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
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 :
FROM ad_group for the details needed with the ad_groups resourceFROM campaign without any ad_group in the SELECT