Re: Ad Performance Report missed data when CriterionId is included
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 -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/zyri-0QHFUFO00fjhv5H3_ToOUPiI8nxZp0g%40sfdc.net.
Re: Ad Performance Report missed data when CriterionId is included
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 ' \ --header 'developerToken: ' \ --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,44401,2276,32591,448044171280,,Cross-network,Cross-network 9935647141,[Discovery] Remarketing,958642,2,134,458105442385,,Cross-network,Cross-network 9935647141,[Discovery] Remarketing,2757,155,2372,448044171283,,Cross-network,Cross-network 9935647141,[Discovery] Remarketing,2664,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,27660,1411,19653,445715044232,,Cross-network,Cross-network 9935647141,[Discovery] Remarketing,497741,2,43,458105442400,,Cross-network,Cross-network 9935647141,[Discovery] Remarketing,389693,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 ' \ --header 'developerToken: ' \ --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,304 9935647141,[Discovery] Remarketing,431059,1,114,458105442394,,Cross-network,Cross-network,300 9935647141,[Discovery] Remarketing,10088,0,4,448044171289,,Cross-network,Cross-network,300 9935647141,[Discovery] Remarketing,1150624,6,116,458105442394,,Cross-network,Cross-network,304 9935647141,[Discovery] Remarketing,0,0,2,448044171292,,Cross-network,Cross-network,304 9935647141,[Discovery] Remarketing,5602034,13,943,458105442397,,Cross-network,Cross-network,304 9935647141,[Discovery] Remarketing,453652,1,26,458105442400,,Cross-network,Cross-network,304 9935647141,[Discovery] Remarketing,10009,0,2,458105442403,,Cross-network,Cross-network,304 9935647141,[Discovery] Remarketing,0,0,1,458105442394,,Cross-network,Cross-network,100 9935647141,[Discovery] Remarketing,0,0,1,448044171280,,Cross-network,Cross-network,300 9935647141,[Discovery] Remarketing,360548,1,46,458105442385,,Cross-network,Cross-network,300 9935647141,[Discovery] Remarketing,0,0,1,448044171286,,Cross-network,Cross-network,300 9935647141,[Discovery] Remarketing,341233,1,82,458105442391,,Cross-network,Cross-network,300 9935647141,[Discovery] Remarketing,10131,0,8,448044171292,,Cross-network,Cross-network,300 9935647141,[Discovery] Remarketing,10682801,36,2186,458105442397,,Cross-network,Cross-network,300 9935647141,[Discovery] Remarketing,44089,1,17,458105442400,,Cross-network,Cross-network,300 9935647141,[Discovery] Remarketing,1495837,10,263,458105442391,,Cross-network,Cross-network,304 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
Re: Ad Performance Report missed data when CriterionId is included
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 -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/WUi-40QGCO5B004HTKd7F0RhuQ6vH6q8E7hg%40sfdc.net.
Re: Ad Performance Report missed data when CriterionId is included
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
On Tuesday, June 2, 2020 at 10:35:51 PM UTC+3 adsapiforumadvisor wrote:
> 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
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/4652475f-db11-42c3-931a-ee1f36fa4209n%40googlegroups.com.
RE: Ad Performance Report missed data when CriterionId is included
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 -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/RItkr0QBBD3900aN_kfOfUSCOtDm5SivdbTA%40sfdc.net.
Ad Performance Report missed data when CriterionId is included
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
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/b81a11cb-65f0-4a73-a736-6df62ba21cb4%40googlegroups.com.
