Ad Performance Report missed data when CriterionId is included

[Dmitry Kozyrev]

Hi,

Our customer uses automated report fetching similar to following:

curl --http1.1 \
    --header "Authorization : Bearer {AuthorizationToken}" \
    --header "developerToken : {DeveloperToken}" \
    --header "includeZeroImpressions: false" \
    --header "clientCustomerId : {CustomerId}" \
    --data "__rdquery=SELECT AdNetworkType1, AdNetworkType2, BaseCampaignId, AccountTimeZone, CampaignName, ViewThroughConversions, Cost, ActiveViewImpressions, CampaignId, ImageCreativeName, UniversalAppAdYouTubeVideos, ConversionValue, ActiveViewMeasurableImpressions, InteractionTypes, Impressions, ActiveViewMeasurableCost, Device, ActiveViewViewability, AdGroupName, Date, ExternalCustomerId, IsNegative, MultiAssetResponsiveDisplayAdYouTubeVideos, AccountDescriptiveName, AccountCurrencyCode, Conversions, Slot, Id, Interactions, AdGroupId, Clicks, BaseAdGroupId, ActiveViewMeasurability, CriterionId, CriterionType FROM AD_PERFORMANCE_REPORT DURING 20200501,20200531&__fmt=CSV" \
    https://adwords.google.com/api/adwords/reportdownload/v201809

He notices that the sum of Cost for specific customer is lower than it should be (than the one he can see in the UI in another report).

We found that if we remove CriterionId, CriterionType, and IsNegative columns from the report queried from the API the total Cost will match the correct value.

So the question is why adding the fields related to Criterion leads to less Cost data returned?

Dmitry

[Google Ads API Forum Advisor Prod]

Hi Dmitry,

Thank you for reaching out. Can you please share your client customer ID,  both downloaded reports, and a screenshot of the data in the UI via Reply privately to author so I can further investigate the issue?

Regards,
Mitchell
Google Ads API Team

ref:_00D1U1174p._5004Q20VVw3:ref

[Dmitry Kozyrev]

Hi Mitchell,

Sorry for the late reply. Unfortunately I did not receive the permission to share that data.

But recently we ran into a similar issue (for another customer):

curl --http1.1 \
    --header "Authorization : Bearer {AuthorizationToken}" \
    --header "developerToken : {DeveloperToken}" \
    --header "includeZeroImpressions: false" \
    --header "clientCustomerId : {CustomerId}" \

    --data "__rdquery=SELECT Date, Conversions, CriterionId FROM AD_PERFORMANCE_REPORT WHERE CampaignId='{CampaignId}' DURING 20200812,20200818&__fmt=CSV" \
    https://adwords.google.com/api/adwords/reportdownload/v201809

This query returns total Conversions = 19. But when I remove CriterionId from the fields, total Conversions become 268 (and this value matches the UI).

(I also asked the customer for the permission to share the reports if you need it.)

Best regards,

Dmitry

[Google Ads API Forum Advisor Prod]

Hi Dmitry,

We will need your CID and report results that Mitchell mentioned to further look into this. Please do so using reply privately to author.

Thanks,
Anthony
Google Ads API Team

Anthony Google Ads API Team

ref:_00D1U1174p._5004Q20VVw3:ref

[don....@gmail.com]

Helllo Anthonly, I have similar issue, if CriterionId is included into query we do not get full cost for certain campaigns



Example

1. Call without CriterionId

curl --location --request POST 'https://adwords.google.com/api/adwords/reportdownload/v201809?__rdquery=SELECT%20%20CampaignId,%20CampaignName,%20Cost,%20Clicks,%20Impressions,%20Id,%20AdType,%20AdNetworkType1,%20AdNetworkType2%20FROM%20AD_PERFORMANCE_REPORT%20%20WHERE%20CampaignId%20IN%20[9935647141]%20DURING%2020200901,20200924&__fmt=CSV' \

--header 'Authorization: Bearer <screened>' \

--header 'developerToken: <screened>' \

--header 'clientCustomerId: 3100659627' \

--header 'skipReportHeader: true' \

--header 'skipColumnHeader: false' \

--header 'skipReportSummary: false' \

--header 'useRawEnumValues: false'

response:

Campaign ID,Campaign,Cost,Clicks,Impressions,Ad ID,Ad type,Network,Network (with search partners)
9935647141,[Discovery] Remarketing,444010000,2276,32591,448044171280,,Cross-network,Cross-network
9935647141,[Discovery] Remarketing,958642,2,134,458105442385,,Cross-network,Cross-network
9935647141,[Discovery] Remarketing,27570000,155,2372,448044171283,,Cross-network,Cross-network
9935647141,[Discovery] Remarketing,26640000,121,1485,448044171286,,Cross-network,Cross-network
9935647141,[Discovery] Remarketing,1837070,11,346,458105442391,,Cross-network,Cross-network
9935647141,[Discovery] Remarketing,108390088,538,8629,448044171289,,Cross-network,Cross-network
9935647141,[Discovery] Remarketing,1581683,7,231,458105442394,,Cross-network,Cross-network
9935647141,[Discovery] Remarketing,366950131,1738,26839,448044171292,,Cross-network,Cross-network
9935647141,[Discovery] Remarketing,16284835,49,3129,458105442397,,Cross-network,Cross-network
9935647141,[Discovery] Remarketing,276600000,1411,19653,445715044232,,Cross-network,Cross-network
9935647141,[Discovery] Remarketing,497741,2,43,458105442400,,Cross-network,Cross-network
9935647141,[Discovery] Remarketing,3896930000,21855,421988,448044171295,,Cross-network,Cross-network
9935647141,[Discovery] Remarketing,10009,0,2,458105442403,,Cross-network,Cross-network
Total, --,5168260199,28165,517442, --, --, --, --


2. Call with CriterionId

curl --location --request POST 'https://adwords.google.com/api/adwords/reportdownload/v201809?__rdquery=SELECT%20%20CampaignId,%20CampaignName,%20Cost,%20Clicks,%20Impressions,%20Id,%20AdType,%20AdNetworkType1,%20AdNetworkType2,%20CriterionId%20FROM%20AD_PERFORMANCE_REPORT%20%20WHERE%20CampaignId%20IN%20[9935647141]%20DURING%2020200901,20200924&__fmt=CSV' \

--header 'Authorization: Bearer <screened>' \

--header 'developerToken: <screened>' \

--header 'clientCustomerId: 3100659627' \

--header 'skipReportHeader: true' \

--header 'skipColumnHeader: false' \

--header 'skipReportSummary: false' \

--header 'useRawEnumValues: false'

reponse:

Campaign ID,Campaign,Cost,Clicks,Impressions,Ad ID,Ad type,Network,Network (with search partners),Keyword ID
9935647141,[Discovery] Remarketing,598094,1,88,458105442385,,Cross-network,Cross-network,3000004
9935647141,[Discovery] Remarketing,431059,1,114,458105442394,,Cross-network,Cross-network,3000000
9935647141,[Discovery] Remarketing,10088,0,4,448044171289,,Cross-network,Cross-network,3000000
9935647141,[Discovery] Remarketing,1150624,6,116,458105442394,,Cross-network,Cross-network,3000004
9935647141,[Discovery] Remarketing,0,0,2,448044171292,,Cross-network,Cross-network,3000004
9935647141,[Discovery] Remarketing,5602034,13,943,458105442397,,Cross-network,Cross-network,3000004
9935647141,[Discovery] Remarketing,453652,1,26,458105442400,,Cross-network,Cross-network,3000004
9935647141,[Discovery] Remarketing,10009,0,2,458105442403,,Cross-network,Cross-network,3000004
9935647141,[Discovery] Remarketing,0,0,1,458105442394,,Cross-network,Cross-network,100
9935647141,[Discovery] Remarketing,0,0,1,448044171280,,Cross-network,Cross-network,3000000
9935647141,[Discovery] Remarketing,360548,1,46,458105442385,,Cross-network,Cross-network,3000000
9935647141,[Discovery] Remarketing,0,0,1,448044171286,,Cross-network,Cross-network,3000000
9935647141,[Discovery] Remarketing,341233,1,82,458105442391,,Cross-network,Cross-network,3000000
9935647141,[Discovery] Remarketing,10131,0,8,448044171292,,Cross-network,Cross-network,3000000
9935647141,[Discovery] Remarketing,10682801,36,2186,458105442397,,Cross-network,Cross-network,3000000
9935647141,[Discovery] Remarketing,44089,1,17,458105442400,,Cross-network,Cross-network,3000000
9935647141,[Discovery] Remarketing,1495837,10,263,458105442391,,Cross-network,Cross-network,3000004
9935647141,[Discovery] Remarketing,0,0,1,458105442391,,Cross-network,Cross-network,100
9935647141,[Discovery] Remarketing,0,0,2,445715044232,,Cross-network,Cross-network,100
Total, --,21190199,71,3903, --, --, --, --, --

We are loosing $5k+ in cost over a month, and this is just one example,  please advice how to address this?

Having CriterionId breakdown is crucial for our work as well as correct cost reporting

[Google Ads API Forum Advisor Prod]

Hi Dmitry,

From what I could find out, we cannot expose criterionId for Discovery campaigns in AdWords API without adding full support for this campaign type in AdWords API. However, we recently announced general availability for Google Ads API , which is the next version of AdWords API. As a result, we won't be adding new features to AdWords API.

Could you consider using the Google Ads API to see if you can retrieve the relevant data using it?

Cheers
Anash

ref:_00D1U1174p._5004Q20VVw3:ref