[FIXED] How to retrieve Performance MAX campaigns Google Ads into Google Big Query

Issue

I am using a third-party tool that use the Adwords Reporting https://developers.google.com/adwords/api/docs/appendix/reports/all-reports to retrieve data.

At the moment all the "Performance Max" campaigns are lost from the Adwords Reporting and I need to retrieve them to include their costs. With the migration from Adwords to Ads, also, I need to find a solution before April 2022.

I only need to move that data into my Google BigQuery project.

At the moment the solution using the BigQuery Data Transfer is NOT OK because use the same v201809 reporting of Adwords ( https://cloud.google.com/bigquery-transfer/docs/adwords-transfer?hl=en-GB ) .

Also the Google Ads Script don't support Google Ads but only report name of Adwords v201809 ( https://developers.google.com/google-ads/scripts/docs/solutions/bigquery-exporter )

Do you have a suggestion to help me? Thanks

Solution

Remember: Do not select an AdGroup when querying Performance Max campaigns, as no campaigns will be returned. https://developers.google.com/google-ads/api/docs/performance-max/reporting

Solution --> I use two different GAQL :

• one FROM ad_group for the details needed with the ad_groups resource
• another FROM campaign without any ad_group in the SELECT

Answered By - gip

Answer Checked By - Marilyn (PHPFixing Volunteer)