Results of Adgroup_Performance_Report display different campaigns than campaignIDs requested in query

19 views

Skip to first unread message

Christoph Lindemann

unread,

Feb 7, 2020, 10:08:57 AM2/7/20

to AdWords API and Google Ads API Forum

For the following python query:

    report_query = (adwords.ReportQueryBuilder()
                      .Select('Date','CampaignName','AdGroupName','Impressions','InteractionRate','TargetCpa','Cost','TrackingUrlTemplate')
                      .From('ADGROUP_PERFORMANCE_REPORT')
                      .Where('CampaignId').In('68060187', '124390347')
                      .Where('AdGroupStatus').In('ENABLED','PAUSED','REMOVED')
                      .During(end_date+ ','+start_date) 
                      .Build())

I receive a report for campaignID 68060187 as expected but in addition for ID 1674059168 instead of 124390347.

In the account I can see that traffic was definitely present in 124390347 during the requested period.

Any help is really appreciated.

Kind regards

Christoph

Google Ads API Forum Advisor Prod

unread,

Feb 7, 2020, 4:08:49 PM2/7/20

to c.lin...@academics.de, adwor...@googlegroups.com

Hello Christoph,

Thank you for reaching out. I tried generating the report against your account with the shared report query and was successfully able to generate the results for the two shared campaign ids. Please find below the code snippet of the report query. If you are still having issues, could you please share the complete request and response logs along with the report file generated on your end for me to assist you better?

.fields("CampaignName", "AdGroupName", "AdGroupStatus", "Date", "Impressions", "InteractionRate", "TargetCpa", "Cost", "TrackingUrlTemplate")
                               .from(ReportDefinitionReportType.ADGROUP_PERFORMANCE_REPORT)
                               .where("CampaignId").in ("68060187", "124390347")
                               .where("AdGroupStatus").in("ENABLED","PAUSED","REMOVED")
                               //where("CampaignId").in("68060187")
                               .during(new LocalDate("2009-12-11"),new LocalDate("2020-02-07"))

P.S. Please use Reply privately to author option while sharing the details for investigation.

Regards,
Nikisha Patel, Google Ads API Team