Cost Reporting incorrect for Campaigns with Experiments

[Etleap Dev]

Hello,

Our tool downloads Ad Performance Reports (v201809) on behalf of a customer and the customer noticed that when adding the cost for all the ads in the campaigns, there are some discrepancies for campaigns that have an Experiment attached to it. I've seen the documentation here https://developers.google.com/adwords/api/docs/guides/campaign-drafts-experiments#reporting and attempt to compensate by also adding all the ad costs where the baseCampaignId also equals the relevant campaign, but there is still a large discrepancy. 

Are there any known issues where some ads for a Campaign Experiment might not be returned in the Adwords API but still be used in cost calculations in the Adwords UI? I imagine you will need specific campaign Ids which I will be happy to supply in a private response.

Jordan

[googleadsapi...@google.com]

Hi Jordan,

So I can further investigate, could you provide to me the clientCustomerId, the complete report definition used to generate the reports in the AdWords API and the screenshot of the Google Ads UI where the discrepancies can be identified? You may reply via Reply privately to author option.

Thanks and regards,

Peter

Google Ads API Team

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@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+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/4c8ca814-98d8-4350-aabe-d8a711552b67%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Etleap Dev]

For posterity, the issue turned out to be that we had mistakenly assumed that an Ad ID has a one-to-many relation to AdGroupId, but in fact the relationship is many-to-many when Campaign Experiments are involved, which caused us to incorrectly update the destination database. https://developers.google.com/adwords/api/docs/guides/objects-methods#object_id_uniqueness