Hi Team, We have been using BigQuery Exporter to extract Google Ads into BigQuery for further analysis with a query model. However, notice all the App Campaign reports extracted from BigQuery.
Here are the links I am referred to: - Google Ads transfers <https://cloud.google.com/bigquery-transfer/docs/adwords-transfer> - Google Ads report transformation <https://cloud.google.com/bigquery-transfer/docs/adwords-transformation> I am using this query to retrieve the list of app campaign that created under our account: SELECT * FROM {dataset_id}.Campaign_{customer_id} WHERE AdvertisingChannelType = 'MULTI_CHANNEL' Then I am trying to find the corresponding adgroup from the app campaign returned above with this query, but no results. (it is works for display and search campaign) SELECT * FROM {dataset_id}.Campaign_{customer_id} AS campaign INNER JOIN {dataset_id}.AdGroup_{customer_id} AS adgroup ON campaign.CampaignId = adgroup.CampaignId WHERE AdvertisingChannelType = 'MULTI_CHANNEL' Understand the BigQuery Exporter is built on top of Adwords / Google Ads API. Wonder if you can assist me in this case? -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/491e33ee-cbb0-41a4-83c8-e5cf01656cf6n%40googlegroups.com.
