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
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
22022110538997.7229
20221106 62731.7378
The difference between them is more than 30.000
[image: Google-JP-AND-2
When I calculate the cost through the campaign table and the
ad_group_ad_asset_view table, the data is inconsistent
SELECT
sum(metrics.cost_micros)
FROM
{table}
WHERE
segments.date >= '{start_date}'
and segments.date <= '{end_date}'
Th
