Hi, Thanks for the clarification, I need to use segments.activity_country however, I can't include segments.activity_country to my select stament when campaign is in my FROM clause. How can I retrieve this data?
Here is my query: SELECT campaign.id, campaign.name, campaign.status, segments.date, segments.activity_country, metrics.all_conversions_value, metrics.clicks, metrics.conversions, metrics.cost_micros, metrics.impressions, customer.id FROM campaign WHERE segments.date BETWEEN "2024-10-01" AND "2024-10-31" Error: Fix your query to address the errors below and re-submit. - 'segments.activity_country' is not a valid field in the SELECT clause when 'campaign' is the resource in the FROM clause. Fields in the SELECT must be 'Selectable'. On Thursday, November 7, 2024 at 9:09:58 PM UTC+1 Google Ads API Forum Advisor wrote: > Hi, > > Thank you for reaching out to the Google Ads API support team. > > Regarding your question about segments.geo_target_country and > segments.activity_country, here’s a breakdown of the two fields: > > - segments.geo_target_country: This represents the country where your > campaign was targeted. It refers to the geographic location you selected > when setting up the campaign, i.e., where you intended to show your ads. > - segments.activity_country: This refers to the country where actual > user activity occurred, such as where clicks, conversions, or revenue were > generated. In other words, it represents the location of the user > interacting with the ad. > > Based on these documentations of *segments.geo_target_country* > <https://developers.google.com/google-ads/api/fields/v18/segments#segments.geo_target_country>, > > *segments.activity_country* > <https://developers.google.com/google-ads/api/fields/v18/segments#segments.activity_country>, > > you can use the appropriate field based on whether you're interested in the > targeted country or the actual activity country. > > I hope this helps. > > This message is in relation to case > "ref:!00D1U01174p.!5004Q02vGiha:ref" (ADR-00274739) > > Thanks, > > [image: Google Logo] Google Ads API Team > > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/28b0d974-455f-41de-88c4-1ee747bf9a40n%40googlegroups.com.
