Re: how to avoid empty result when dimension is not set on data

2023-05-15 Thread Pablo Fernandez
Thank you, but let me reformulate the question. I'm running a Google Ads Scripts (GoogleAds->Tools and Settings->Bulk Actions->Scripts). The query being run is *SELECT segments.date,customer.id,customer.resource_name, customer.descriptive_name,segments.geo_target

Re: how to avoid empty result when dimension is not set on data

2023-05-12 Thread Pablo Fernandez
Thank you As stated in the documentation you provided me, *When adding some segments, the metrics in the summary row may decrease* *When segments.keyword.info.match_type is added to a query with FROM ad_group_ad, that segment is telling the query to only get the rows of data that have keywords

how to avoid empty result when dimension is not set on data

2023-05-10 Thread Pablo Fernandez
Hi. with the following query I'm able to collect costs with country and city as columns. SELECT segments.date, geographic_view.country_criterion_id, segments.geo_target_region, metrics.clicks, metrics.impressions, metrics.cost_micros, customer.id, customer.resource_name, geographic_view.r