Hi Bharani , Can you please let me know why I am not able to get zero impression in my report if I include a segments.Date ? This is a roadblock in our migration from Adwords to Google Ads APi v1.0. In adwords , I am able to get zero impressions along with date when IncludeZeroImpressions is set to true.
Below is the query I am using to get ad performance report. string query = $@"SELECT ad_group_ad.ad.id, campaign.id, segments.date, metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.average_position FROM ad_group_ad WHERE segments.date BETWEEN '2019-04-17' AND '2019-04-28' On Tue, Apr 30, 2019 at 5:41 PM Priya <devipriy...@gmail.com> wrote: > Thank you Bharani for your reply. can you please let me know if I can > include zero impression data along with metrics.Date ? > > The query listed below , returns rows containing non-zero values for > "metrics.impressions" column. However if I remove "segments.date" from the > select statement , all the records , including ones that contain zero > "metrics.impressions" value are returned. > > string query = $@"SELECT ad_group_ad.ad.id, campaign.id, segments.date, > metrics.impressions, metrics.clicks, metrics.cost_micros, > metrics.average_position, FROM ad_group_ad WHERE segments.date BETWEEN > '2019-04-17' AND '2019-04-28' > > I want to retrieve all the "metrics.impressions" rows by "segments.date". > What should I do to modify the query listed above to return zero > "metrics.impressions" rows along with "segments.date" value? > > On Tuesday, April 30, 2019 at 9:32:50 AM UTC-4, Priya wrote: >> >> string query = >> $@"SELECT >> ad_group_ad.ad.id, >> campaign.id, >> segments.date, >> metrics.impressions, >> metrics.clicks, >> metrics.cost_micros, >> metrics.average_position, >> FROM >> ad_group_ad >> WHERE segments.date BETWEEN '2019-04-17' AND '2019-04-28' >> >> >> I get zero impression without segments.date in select field . >> >> How can I get segments.date with zero impression in result when I query >> for a date range in Google Ads API V1.0 ? I am using .net client library. >> >> -- > -- > =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ > 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 adwords-api@googlegroups.com > To unsubscribe from this group, send email to > adwords-api+unsubscr...@googlegroups.com > 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 adwords-api+unsubscr...@googlegroups.com. > 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/32d53bac-e0a1-4281-9c3e-bf69ba1857f8%40googlegroups.com > <https://groups.google.com/d/msgid/adwords-api/32d53bac-e0a1-4281-9c3e-bf69ba1857f8%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com 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 adwords-api+unsubscr...@googlegroups.com. 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/CA%2Bx4VHFcu%3DjX%2BJ0acZT-0bDoQdXn3Ry2EAZKeOr5qx3PX_kY%3DA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
