Migrating AdWords CAMPAIGN_PERFORMANCE_REPORT to new Google Ads API

83 views

Skip to first unread message

Bikram Bhuyan

unread,

Apr 13, 2022, 2:50:00 AM4/13/22

to Google Ads API and AdWords API Forum

Hello,

In the old AdWords api we are using the CAMPAIGN_PERFORMANCE_REPORT to fetch the stats of the campaign based on the date range. Below is the query we were executing.

query = "SELECT CampaignId, Clicks, Impressions, Ctr, AverageCpc, Cost, Conversions, CostPerConversion " +
"FROM CAMPAIGN_PERFORMANCE_REPORT " +
"WHERE Impressions > 0 " +
"DURING " + startDate + ", " + endDate;

I am not able to figure out what is the alternative of "CAMPAIGN_PERFORMANCE_REPORT" in the new api.

Could you please guide me how can I migrate the above report to the new API format. Any related documentation on how to do it will be really helpful.

Thanks,

Bikram.

Google Ads API Forum Advisor

unread,

Apr 13, 2022, 3:17:42 AM4/13/22

to bikram...@gmail.com, adwor...@googlegroups.com

Hi Bikram,

Thank you for raising this concern to the Google Ads API team.

Moving forward to your concern, please see this Resource Mapping document for the Campaign Performance Report. This resource mapping gives you the equivalent of the fields for the said report from AdWords API to Google Ads API. Also, please see this example comparison of the queries.

In addition, you can make use of the query migration tool to convert your AWQL to GAQL.

Regards,

Carmela
Google Ads API Team