The result pulled back by the api is inconsistent with that on the google panel

[William Zhou]

For this campaign (Google-JP-AND-221104-UAC1.0-YZL-newinstall-JP), the data on the Google panel is attached. The data we pull back through the api are

20221104      23199.736

220221105    38997.7229

20221106      62731.7378

The difference between them is more than 30.000

[Google Ads API Forum Advisor]

Hi William,

Thanks for reaching out to the Google Ads API Forum.

I’ve tried to get the cost data for the campaign (Google-JP-AND-221104-UAC1.0-YZL-newinstall-JP), and it is exactly same in the API what Ads UI is showing. You may refer to below GAQL I’ve used:

 

 

SELECT

  metrics.cost_micros,

  campaign.advertising_channel_sub_type,

  campaign.advertising_channel_type,

  campaign.id,

  campaign.name

FROM campaign

WHERE

  campaign.name IN ('Google-JP-AND-221104-UAC1.0-YZL-newinstall-JP')

  AND segments.date = '20221104'

 

Here’s the below screenshot where UI’s cost, and API’s summaryRow metrics data showing same value:

 

 

In your below provided details, I can see that dates seems to be not correct. 

 

20221104      23199.736

220221105    38997.7229

20221106      62731.7378

 

Once you try with above provided GAQL with said dates, then you should be able to get same cost what you are seeing in the UI.

Let me know if it works for you.

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2h2KTv:ref

[William Zhou]

thank you for your answer, i use the table ad_group_ad_asset_view not campaign, this may be caused by the inconsistency between the two tables