less data returns when using "segments.date"

[Andrew Nikolaev]

Hello. I'm trying to get campaign data splitted by day, but API showing lesser number of records than in Google Ads UI. This problem appears just when I add "segments.date" to SELECT clause.

My query: 

SELECT
    campaign.id,
    campaign.name,
    metrics.clicks,
    segments.date
FROM campaign
WHERE segments.date BETWEEN '2020-09-01' AND '2020-09-02'

Thanks,

Andrew Nikolaev

[Google Ads API Forum Advisor Prod]

Hi Andrew,

Thank you for reaching out.

Could you further describe or provide details on the fewer number of records you are getting when adding the segments.date in your SELECT clause? Could you provide your customer ID and the complete Google Ads UI screenshot that you are referring to?

Also please note that, if you segment a report by segments.date, metrics will be broken down with one row for each date. Any date that has no impressions will not return in such a report.

That said, you may send the requested information via the Reply privately to author option, so we can continue our discussion privately.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q26Bam0:ref