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

Tag:google-ads-api, google-bigquery, google-cloud-platform

Add a new comment.