I am having a problem with a data transfer from Google Ads. When I schedule the backfill I get the following error for some dates:

Invalid value: Load configuration must specify at least one source URI

When I check the log inside of the details of execution I get the following message:

Failed to start job for table p_ClickStats_5419416216$20201117 with error INVALID_ARGUMENT: Invalid value: Load configuration must specify at least one source URI

The weird part is that this happens for random dates which I had transfered before in a previous transfer. Did anyone have a problem similar to that?

I have created a script in GoogleAds to fetch this report: https://developers.google.com/adwords/api/docs/appendix/reports/product-partition-report from GoogleAds and insert the result as a table in BigQuery using the AdvanceAPI in GoogeAds.

The script I am running is built according to this sample code: https://developers.google.com/adwords/api/docs/appendix/reports/product-partition-report, provided by the Google Ads Script Team and they have also tried to help me in this matter.

The issue I am facing is that the first run of the script runs perfectly and creates a table in BQ and inserts the data as intended. However, when the script runs again (as sheduled 3 PM everyday) to get updated data from GoogleAds I get the following error message: API call to bigquery.tables.insert failed with error: Already Exists

The error message also provides the information that the issue is somewhere in this code:

table.tableReference = BigQuery.newTableReference(); table.tableReference.datasetId = CONFIG.BIGQUERY_DATASET_ID; table.tableReference.projectId = CONFIG.BIGQUERY_PROJECT_ID; table.tableReference.tableId = reportConfig.NAME; table = BigQuery.Tables.insert(table, CONFIG.BIGQUERY_PROJECT_ID,     CONFIG.BIGQUERY_DATASET_ID); 

But all this chunk of code is provided from the Google Ads Script Team so there should not be any problem with this?

So happy if someone could give me any guidance how to solve this!

Thanks in advance.

I am currently in the process of creating an overview of ad spent per landing page/destination url.
We are using several campaign types:

• Shopping
• (Responsive) Search Ads
• Dynamic Search Ads

I am struggling to get a report per landingpage for each campaign type. We have multiple Customer Ids and I would need data for all Customer Ids. When looking at the Google Ads API documentation I think I would need these two reports to get all I need

• Keywordless Query Report (for Dynamic Search Ads landing pages): https://developers.google.com/adwords/api/docs/appendix/reports/keywordless-query-report
• Landing Page Report (for Shopping and (responsive) search ads landing pages): https://developers.google.com/adwords/api/docs/appendix/reports/landing-page-report

Ideally, the data would be uploaded to a BigQuery dataset.

What I have tried:
I have set up a BigQuery Data Transfer (https://cloud.google.com/bigquery-transfer/docs/adwords-transfer). This contains a lot of reports but not the two reports listed above.

I have tried a Google Ads script, but my knowledge of that is too little to write a script that woudl give the same/similar results as the two reports listed above. Next to that I would need help getting this data in my BigQuery project.

Is it possible to link Google Ads BiqQuery data to GA BigQuery Session Data? By this is there a link between the data at all i.e. a key? OR something that is relational?

The idea is to work out spend against revenue generated from the Google Ads data.

Thanks

I've setup a Google BigQuery Transfer to transfer Google Ads (formerly AdWords) data. The transfer job is successful and shows no error.

Summary: succeeded 87 jobs, failed 0 jobs.

However, I went over to the Datasets and saw a lot of views and partitioned tables. But none has any data.

I've read through all the documentation on https://cloud.google.com/bigquery-transfer/docs/adwords-transfer#migrating_google_ads_data_to_mccs, but couldn't figure out where went wrong.

Anyone has similar issue?