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

2023-05-15 Thread 'Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum
Hi Pablo, Thank you for returning to our team. Regarding your concern, please note that Google Ads API mirrors the Google Ads UI. Meaning the Google Ads API should be able to retrieve or manage the data available in the Google Ads UI. That being said, as requested, so our team can provide accu

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-14 Thread 'Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum
Hi Pablo, Thank you for getting back to us. I hope that you are doing well today. Moving forward to your concerns: does exist ANY way to obtain those rows with null values for city dimension? As mentioned in the documentation about segmentation (https://developers.google.com/google-ads/api/doc

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