*I'm tried with `**geographic_view**`
[**geographic_view**](https://developers.google.com/google-ads/api/fields/v3/geographic_view)
to get acustomer's cost group by country.*
*As below query showed:*
query = """
SELECT
customer.descriptive_name,
customer.id,
metrics.cost_micros,
geographic_view.country_criterion_id,
segments.geo_target_state
FROM
geographic_view
WHERE
segments.date BETWEEN '{}' AND '{}'
""".format("2020-06-01","2020-06-17")
Then I got multiple results with different `geoTargetConstants` which
belonged to same country. After I group those by same country. I found
there are some country costed not appeared with GAQL as I could find at my
google manage backend.Also the sum cost with all these country didn't meet
the cost I request singlely
query_cost_only = """
SELECT
customer.descriptive_name,
customer.id,
metrics.cost_micros
FROM
customer
WHERE
segments.date BETWEEN '{}' AND '{}'
""".format("2020-06-01","2020-06-17")
Can you give me some advice about these?
Thanks.
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/31109e84-7dd8-4ec8-b5f3-d5b5400fe34do%40googlegroups.com.
