Hi,
Thanks for your message.
Let me explain it.
Suppose a campaign has 100 clicks
By selecting from geographic_view I would see 30 clicks from users in
Caniformia and 70 clicks in Washington;
and by age_range_view I would see 40 clicks from
20~29 yrs old users and 60 clicks from 30~39 yrs old;
While what I really want is
10 clicks from 20~29 yrs old in Caniformia
20 clicks from 30~39 yrs old in Caniformia
30 clicks from 20~29 yrs old in Washington
40 clicks from 30~39 yrs old in Washington
More specific, I tried this GAQL
SELECT
campaign.id,
segments.geo_target_city,
segments.date,
metrics.clicks
FROM age_range_view WHERE segments.date BETWEEN "2024-10-01" AND
"2024-10-02" AND metrics.impressions > 0
It does not work and results in an error
"select or filter on the following segments:
'segments.geo_target_city'(could not support requested resources:
'AGE_RANGE_VIEW'), since segment is incompatible with the resource in the
FROM clause"
I can hardly figure out why those segments are not compatible. Or should I
try something else ?
On Thursday, February 27, 2025 at 7:20:49 PM UTC+9 Google Ads API Forum
Advisor wrote:
> Hi,
>
> Can you confirm whether you are trying to retrieve the geographic_view
> <https://developers.google.com/google-ads/api/fields/v19/geographic_view_query_builder?hl=en>
>
> and age_range_view
> <https://developers.google.com/google-ads/api/fields/v19/age_range_view_query_builder?hl=en>
>
> data in one single report? If yes, kindly note that both the
> geographic_view and age_range_view reports are different from one another
> and these cannot be fetched in a single report in the Google Ads API. This
> guide
> <https://developers.google.com/google-ads/api/docs/query/cookbook?hl=en>
> provides a set of Google Ads Query Language queries that demonstrate how to
> return the same data as screens in the Google Ads UI. Can you confirm
> whether your requirement is possible to fetch the data from the Google Ads
> UI? If yes, I would request you to provide an uncropped UI screenshot of
> the Google Ads account (with visible customer ID) by highlighting the
> fields and metrics for which you want to fetch the data from the Google Ads
> API.
>
>
> Thanks,
>
> [image: Google Logo] Google Ads API Team
> Feedback
> How was our support today?
>
> [image: rating1]
> <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=1&entry.295079254=5004Q00002Lm1k3QAB>
>
> [image: rating2]
> <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=2&entry.295079254=5004Q00002Lm1k3QAB>
>
> [image: rating3]
> <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=3&entry.295079254=5004Q00002Lm1k3QAB>
>
> [image: rating4]
> <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=4&entry.295079254=5004Q00002Lm1k3QAB>
>
> [image: rating5]
> <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=5&entry.295079254=5004Q00002Lm1k3QAB>
> [2025-02-27 10:20:00Z GMT] This message is in relation to case
> "ref:!00D1U01174p.!5004Q02Lm1k3:ref" (ADR-00075283)
>
>
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/adwords-api/90889315-8a62-4f50-8ae2-60426ce181d5n%40googlegroups.com.
