migration ADGROUP_PERFORMANCE_REPORT

[Василий Рогачев]

Good evening!

How to go from a request

SELECT Date, CampaignId, CampaignName, AdGroupId, AdGroupName, Impressions, Clicks, Cost

        

         FROM ADGROUP_PERFORMANCE_REPORT

        

         WHERE AdGroupStatus IN [ENABLED, PAUSED] DURING LAST_7_DAYS

to the new version of the Google Ads API?

[Google Ads API Forum Advisor]

Hello,

Thanks for reaching out. You can use the Query Migration Tool to convert AdWords API queries to the Ads API. For your query, the tool provides the Ads API equivalent below:
 

SELECT segments.date, campaign.id, campaign.name, ad_group.id, ad_group.name, metrics.impressions, metrics.clicks, metrics.cost_micros FROM ad_group WHERE ad_group.status IN ("ENABLED","PAUSED") AND segments.date DURING LAST_7_DAYS

Regards,
Matt
Google Ads API Team

Matt Google Ads API Team

ref:_00D1U1174p._5004Q2PL1eJ:ref

[Василий Рогачев]

And what url should be called? Previously it was https://adwords.google.com/api/adwords/reportdownload/v201809

среда, 20 октября 2021 г. в 17:33:01 UTC+3, adsapi:

[Google Ads API Forum Advisor]

Hi,

This is Yasar and I work with Matt. Let me assist you with this.

You may use the ad_group report in Google Ads API which is equivalent to ADGROUP_PERFORMANCE_REPORT in the AdWords API. The Google Ads API can be called either using gRPC or REST, and we recommend using Google's official client libraries.

That said, you may create queries using either of the Search or SearchStream methods to get an ad_group report. Note that both Search and SearchStream use the same base URL below.

    https://googleads.googleapis.com/v8/customers/CUSTOMER_ID/googleAds

For more information, you may refer to this guide.

Let us know if you have any further questions.

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2PL1eJ:ref

[Василий Рогачев]

https://googleads.googleapis.com/v8/customers/CUSTOMER_ID/googleAds

__fmt=TSV&__rdquery=SELECT segments.date, campaign.id, campaign.name, ad_group.id, ad_group.name, metrics.impressions, metrics.clicks, metrics.cost_micros FROM ad_group WHERE ad_group.status IN ("ENABLED","PAUSED") AND segments.date DURING LAST_7_DAYS

Everything works in the old way, but nothing is given in the new way. Although only the query and url have been replaced

четверг, 21 октября 2021 г. в 13:55:26 UTC+3, adsapi:

[Василий Рогачев]

I call this report, as before, through curl. This should work, right? This is exactly how the old report works for me.

четверг, 21 октября 2021 г. в 20:59:22 UTC+3, Василий Рогачев:

[Google Ads API Forum Advisor]

Hi,

Could you please confirm if your CURL request has been successful?  We would request that you provide the complete request and response logs, with the request-id, generated when you tried to get the ad_group report, for our team to further investigate.

For REST interface requests, you can enable logging for the curl command by using the -i flag. This will cause the tool to include the HTTP response headers in the output.

You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Regards,