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
On Tuesday, 13 December 2022 at 16:47:51 UTC+8 adsapi wrote:
> 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,
> [image: Google Logo]
> Yasar
> Google Ads API Team
>
>
> ref:_00D1U1174p._5004Q2h2KTv: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
"Google Ads API and AdWords 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/61480cce-cb35-48c9-84d6-f731aeb7c8f4n%40googlegroups.com.
