Hello Aryeh, I have follow up question regarding segmentation, could you advice how to to get full data without duplicates from the ad_group_ad report?
1. I want to get all data which is segmented by segments.keyword.info.text 2. I want to get the rest of data which cant be segmented by segments.keyword.info.text Expectation is to get as result data set where total sum(cost) and sum(clicks) will match the UI for the same period For example 1st I do a call like SELECT campaign.id, campaign.name, ad_group_ad.ad.id, ad_group_ad.ad.type, segments.ad_network_type, ad_group_ad.ad.type, metrics.cost_micros, metrics.clicks, segments.keyword.info.text FROM ad_group_ad WHERE segments.date = '2022-04-25' and I get only data where there is keyword in the 2 I want to do SELECT campaign.id, campaign.name, ad_group_ad.ad.id, ad_group_ad.ad.type, segments.ad_network_type, ad_group_ad.ad.type, metrics.cost_micros, metrics.clicks, segments.keyword.info.text FROM ad_group_ad WHERE segments.date = '2022-04-25' AND segments.keyword.info.text IS NULL But second call gives me no data because if segment is added your api engine simply dont return data without keyword So I think question is how to get ONLY data without segments.keyword ? Hope it makes sense, thank you in advance! On Thursday, April 28, 2022 at 9:15:38 PM UTC+3 adsapi wrote: > Hi Marie, > > I reproduced this and it is working as intended. Any ad that doesn't have > keywords will be excluded when adding segments.keyword.info.text to the > report. When adding some segments > <https://developers.google.com/google-ads/api/docs/reporting/segmentation#selectability_between_segments_and_metrics>, > > only metrics rows that fit in to the segment get reported. > > Regards, > > [image: Google Logo] > Aryeh > Google Ads API Team > > > ref:_00D1U1174p._5004Q2aO8ep:ref > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 on the web visit https://groups.google.com/d/msgid/adwords-api/e570e291-4f31-4e9f-9ec9-821be2709747n%40googlegroups.com.
