I'm working at an agency and I would like to get the Spend data for all of our accounts to be imported into BigQuery to make a budget overview dashboard.

I've set up a Data Transfer and I managed to join some tables in the SQL editor from doing some research and learning SQL along the way. The data I get seems to be good.

However, I can't seem to find "Account Name" anywhere in the tables/views, I only find "ExternalCustomerId" which matches the AccountId, but the Account Name would of course be much better.

I've found that in the "Account Performance Report" or "Campaign Criteria", the name should be available, but I don't have these reports in my Data Transfer, I get different tables (see screenshots).

https://developers.google.com/adwords/api/docs/appendix/reports/account-performance-report

https://developers.google.com/adwords/api/docs/appendix/reports/campaign-criteria-report

screenshot: available campaign reports

Can anyone point me in the right direction?

Thanks a lot!

I have set up a google ads transfer into bigquery with a refresh window set at 30 days. I am aware that conversion-type statistics are continually updated within the lookback window, so I am not concerned about discord between the data pull and the UI for data within the last 30 days; however, there seems to be a difference between the UI and the data transfer for up to 10 days after the 30 day attribution window has ended. (ex. I schedule a backfill for 2020-04-29 on 2020-06-02. When comparing the UI and the bq data, on 2020-06-10, the bq data no longer matches the UI) Note: Backfill data that is older than 40 days, does not seem to have this issue.

Has anyone else experienced this issue? Any potential solutions?

This same question has been posted within the GCP slack community.

We have connected AdWords to our Google Analytics views and it works: AdWords campaigns are shown in Google Analytics. For deeper analysis we would like to analyze the data also in BigQuery.

We have setup the import from Google Analytics to BigQuery using a data view which is linked to AdWords. The import itself works, but if we search in BigQuery for TrafficCampaigns with TrafficMedium = cpc (AdWords-Campaigns), the campaigns are missing (null).

We are also importing all AdWords data directly to BigQuery, but we could not find how to relate this data to the Google Analytics data.

Does anybody know how this works? What do we have to do to link the AdWords campaigns with the Google Analytics data in BigQuery?

Thanks for your help! Kind regards, Al

Screenshot of GA-Export in BQ

I'm trying to find the corresponding label for the column CountryCriteriaId, the column is coming from p_GeoStats_*.

The schema description says that I can find the label in LocationCriterionService but as far I understand that's a Google Adwords API function rather a table in Big Query.

Do you know where can I find the labels inside the Adwords schema?

This is a question addressed to users of Google Ads data in BigQuery.

My goal is to create a dashboard displaying all ad extensions (Sitelinks, callouts ...) and their results.

In BigQuery, we have this dataset called "rawdata" imported from Google Ads. I noticed that ad extensions have specific tables and are not in generic tables like "p_Ad" or "p_AdStats". Instead we can find them in p_ExtensionsCallouts, p_ExtensionsSitelinks.

But in p_ExtensionsSitelinks we only find ad texts, no figures, no results. So I need to link to another table containing results. CreativeId in p_AdStats seemed to be the key between my results and the id in my sitelinks table.

I tried to join p_AdStats to p_ExtensionsSitelinks, on p_AdStats.CreativeId = p_ExtensionsSitelinks.Id, but no success. Id in p_ExtensionsSitelinks seems to be a very specific id, not found in p_Ad.

Screenshot of p_ExtensionsSitelinks Schema

Does anyone have already encountered this problem please?

Thank you very much.

Cheers, Julien