Hi Team,
Here is the query I use to fetch report:
SELECT
metrics.clicks,
metrics.conversions,
metrics.cost_micros,
metrics.ctr,
metrics.impressions,
metrics.cost_per_conversion,
customer.id,
customer.descriptive_name,
segments.date
FROM customer
WHERE segments.date DURING LAST_7_DAYS
And I print it as python dataframe : (Already mask customer client id and
name)
[2019-08-06 06:52:51 - INFO] Request made: ClientCustomerId: 199xxxxxxxx,
Host: googleads.googleapis.com:443, Method:
/google.ads.googleads.v2.services.GoogleAdsService/Search, *RequestId*:
*I6D0HLQ3iN7gLA6870SSZg*, IsFault: False, FaultMessage: None
customer_client_id customer_name clicks conversions cost
ctr impressions cost_per_conversion date
0 199xxxxxxxx ABCD1234567890 1399 312.0 582.31786
0.011297 123843 186640.339744 2019-07-29 00:00:00
1 199xxxxxxxx ABCD1234567890 1176 313.0 577.93887
0.011129 105666 184645.006390 2019-07-30 00:00:00
2 199xxxxxxxx ABCD1234567890 710 171.0 328.94199
0.010422 68126 192363.736842 2019-07-31 00:00:00
3 199xxxxxxxx ABCD1234567890 1220 269.0 612.36120
0.010993 110975 227643.568773 2019-08-01 00:00:00
4 199xxxxxxxx ABCD1234567890 1152 258.0 497.61677
0.009795 117617 192874.717054 2019-08-02 00:00:00
5 199xxxxxxxx ABCD1234567890 1432 317.0 709.85821
0.010074 142143 223930.034700 2019-08-03 00:00:00
6 199xxxxxxxx ABCD1234567890 1323 266.0 603.64787
0.010326 128127 226935.289474 2019-08-04 00:00:00
Compare with UI Dashboard numbers:
[image: google-ads-cost.png]
Please notice that:
clicks / impressions are all matched.
But COST is not right.
By the way, we use adwords api to fetch campaign daily report, which
sum(cost) could match with UI number.
Please help with this!
Thanks a lot!
Wenjun
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 [email protected]
To unsubscribe from this group, send email to
[email protected]
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/10cb320c-2334-4a7a-91ce-2066695bf9f3%40googlegroups.com.
