I want to modify these API calls to use a GCP service account instead of my identity.

var report = AdsApp.search(searchQuery);    var table = BigQuery.Tables.insert(table, projectId, dataSetId); BigQuery.Jobs.insert(job, BIGQUERY_PROJECT_ID); 

I read this article but wasn't sure how to find the url for AdsApp and BigQuery.

I searched this post, but still haven't been sure.

Hi,

I want to write an Ads-script to call GoogleAds url nad BQ url using a service account.

I saw this code. Are my urls to the GAds and BQ api correct?

Thanks!

=====================

  // Natural Language API Sentiment URL   var url =       'https://language.googleapis.com/v1beta1/documents:analyzeEntities';   var options = {     method: 'POST',     contentType: 'application/json',     payload: JSON.stringify(body)   };   var response = authUrlFetchApp.fetch(url, options);   var result = JSON.parse(response.getContentText());   Logger.log(result);   if (result.entities) {     // return a list of identified entities     return result.entities;   }   throw Error('No entities response returned'); } 

Hello wonderful person!

I've followed this guide to import google ads campaign info to a BigQuery database.

My goal is to create a simple query that can be stored as a view and accessed from Data Studio to make a report. But some fields like AverageCpm are always set to 0.

I also have a data studio report made using google ads as source for reference and I can access all the campaigns from the google ads platform.

Here is the query I'm working on:

SELECT   c.ExternalCustomerId,   c.CampaignName as name,   c.CampaignStatus,   cs.date as dia,   SUM(cs.Impressions) AS Impressions,   SUM(cs.Interactions) AS Interactions,   AVG(cs.AverageCpm)  AS CPM,   SUM(cs.Cost)  AS Cost FROM   `<DB>.google_ads.Campaign_<ACCOUNT_ID>` c LEFT JOIN   `<DB>.google_ads.CampaignStats_<ACCOUNT_ID>` cs ON   (c.CampaignId = cs.CampaignId    AND cs._DATA_DATE BETWEEN    DATE_ADD(CURRENT_DATE(), INTERVAL -80 DAY) AND DATE_ADD(CURRENT_DATE(), INTERVAL -1 DAY)) WHERE   c._DATA_DATE = c._LATEST_DATE   and c.CampaignName = 'THE_NAME_OF_MY_CAMPAIGN' GROUP BY   1, 2, 3 , 4 ORDER BY   CampaignName, dia 

The field Impressions, returns with a value that is consistent with my reference datastudio report and the info I see in google ads stats, so I feel I'm in the right track.

My problem is that some fields like CampaignStats.AverageCpm , CampaignStats.Cost are always 0.

For example, the query:

Select * from `<DB>.google_ads.p_CampaignStats_<ACCOUNT_ID>` where AverageCpm >0; 

Returns with no results.

I'm thinking permission problems? But I have administrator access to all the company's accounts.

Database is backfilled correctly.

I've tried generating a new dataset: Same problem and I don't see if there is a way to configure how google makes the imports.

What else could it be? What else can I do?

Thank you very very much!

I am trying to set up a data extract in BigQuery to pull data from a Google Ads Account. But I keep getting Auth errors (AuthenticationError.NOT_ADS_USER) when the extract tries starting pulling data.

<ApiError><type>AuthenticationError.NOT_ADS_USER</type><trigge 

What did I do?-

• Set up Big Query and the data extract (as depicted here: https://cloud.google.com/bigquery-transfer/docs/adwords-transfer)

• Invited and added the same email address that big query is using to the Google Ads account with read access level (at first) and then standard access level when the problem persisted.

Is there something that I missed, that I have to enable/accept/configure in order for Big query extract to be able to pull the data from Google Ads?

Thanks,

p.s I have another extract in the same big query account with a different Google Ads account that is working, I recall have followed the same steps.

I just started using GCP and can't create a data transfer from Ads. I did all steps by this documentation but I always get an issue without any explanation.

There was a problem saving this transfer config This transfer config could not be saved. Please try again. iq 

sometimes these two letters change, as far as I remember to 'jk'

I'm using BigQuery to store our Google Ads campaign performance information for our clients. To pull the data, I'm using a very simple query:

select * from yl-adwords.ads.AdBasicStats_[our manager ID] where ExternalCustomerId = [our media client's ID]

This query pulls back to 1/17/21. We took on this new client on 2/16/21, so we're able to get the past 30 days of data. However, the Google Ads account data goes back to 2019.

What's odd is for our other client accounts, when we get access using similar queries, we can pull back historical data with no issue. We're pulling others back to 2018, even though we started working with them ini 2020.

Do I need to schedule a backfill in BQ to get this new data? Or has anyone else experienced this issue?