Reporting returns nothing if segments.date is included

22 views
Skip to first unread message

V Kuznetsov

unread,
Jul 23, 2020, 3:50:55 PM7/23/20
to AdWords API and Google Ads API Forum
Hello,

The query

SELECT campaign.name, segments.date FROM ad_group WHERE segments.date DURING LAST_30_DAYS

returns no records for me, while

SELECT campaign.name FROM ad_group WHERE segments.date DURING LAST_30_DAYS

returns all the names of campaigns I have in the account. 

I expect the first query to be working because it's very similar to the sample query listed here: https://developers.google.com/google-ads/api/docs/shopping-ads/reporting

Thanks,
Vlad

Google Ads API Forum Advisor Prod

unread,
Jul 24, 2020, 9:19:11 AM7/24/20
to vla...@gmail.com, adwor...@googlegroups.com
Hi Vlad,

Please check and see if you have impressions for the last 30 days. When you include segments such as segments.date, rows with zero impressions will not return.  

Regards,
Anthony
Google Ads API Team

ref:_00D1U1174p._5004Q22Ye82:ref

vla...@gmail.com

unread,
Jul 24, 2020, 2:26:18 PM7/24/20
to AdWords API and Google Ads API Forum
That's very good to know, thank you!
Reply all
Reply to author
Forward
0 new messages