Hi again Team! I've already seen that I have to use the "location_view" entity to get the data I needed. Now the problem is that I'm trying to collect the "proximity" information but the query does not return the data. This is the query.
SELECT campaign.id,campaign.name,campaign_criterion.placement.url, campaign_criterion.proximity.address.city_name,campaign_criterion.proximity. address.country_code,campaign_criterion.proximity.address.postal_code, campaign_criterion.proximity.address.province_code,campaign_criterion. proximity.address.province_name,campaign_criterion.proximity.address. street_address,campaign_criterion.proximity.geo_point. latitude_in_micro_degrees,campaign_criterion.proximity.geo_point. longitude_in_micro_degrees,campaign_criterion.proximity.radius, campaign_criterion.proximity.radius_units,campaign_criterion.resource_name, metrics.cost_micros,metrics.impressions,metrics.conversions FROM location_view WHERE segments.date DURING YESTERDAY AND campaign.id=xxxxx Is there a related issue? Thanks for your help. El martes, 30 de abril de 2019, 21:13:55 (UTC+2), Miguel Graciá escribió: > > Hi Team! > > I'm trying to replicate the data shown in the screenshot that I attached > but I do not match the data that the api returns. Can you please tell me if > the following query is correct? > > SELECT > campaign.id, > campaign.name, > metrics.impressions, > metrics.clicks, > metrics.cost_micros, > metrics.conversions, > segments.geo_target_city > FROM campaign > WHERE segments.date DURING YESTERDAY AND campaign.id=XXXXXXXX > > On the other hand. Is there a way to return the name of the location in > that same query? > > Thank you very much for your help > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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]. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/44e25d96-6802-48a9-ac54-088c1eabb88e%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
