Possible to retrieve App Campaign report (breakdown by Ad Group) over Google Ads API or BigQuery Exporter?

[Sia Bee Ting]

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
• Google Ads report 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?

[Google Ads API Forum Advisor Prod]

Hi Sia,

You have received your answer through another support channel and we are responding to you there.

Regards,

Aryeh Baker Google Ads API Team

ref:_00D1U1174p._5004Q2HBgBt:ref