Query returns 'null' with 'segments.date' in SELECT but works fine without it

[Rohith Balaji]

Hey,

I am using the Python SDK for Google Ads API V1  to query the metrics of a campaign like 

query = ('SELECT campaign.id, campaign.name, campaign.status, campaign_budget.amount_micros, '

             'metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.ctr, metrics.average_cpc, '

             'metrics.average_cpe, metrics.average_cpv, metrics.average_cpm, metrics.bounce_rate, metrics.conversions '

             'FROM campaign WHERE segments.date DURING %s AND campaign.id = %s '

             'ORDER BY metrics.impressions DESC ' % (time_range, campaign_id))

response = ga_service.search(customer_id, query, page_size=page_size)

It works fine.

But, When I query with segments.date in SELECT, it returns null

This returns null. I am not sure Why.

query = ('SELECT campaign.id, campaign.name, campaign.status, campaign_budget.amount_micros, segments.date, '

             'metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.ctr, metrics.average_cpc, '

             'metrics.average_cpe, metrics.average_cpv, metrics.average_cpm, metrics.bounce_rate, metrics.conversions '

             'FROM campaign WHERE segments.date DURING %s AND campaign.id = %s '

             'ORDER BY metrics.impressions DESC ' % (time_range, campaign_id))

response = ga_service.search(customer_id, query, page_size=page_size)

Thanks.

[Google Ads API Forum Advisor Prod]

Hi Rohith,

Thank you for reaching out. So I can further investigate the issue as to why your account is getting null values, could you provide to me your clientCustomerId and also the time range you specified when you generated the report?

You may reply privately using the Reply privately to author.

Thanks and regards,
Peter
Google Ads API Team

ref:_00D1U1174p._5001UAqixg:ref

[Max Khlystov]

Did you mange to find solution ?

понедельник, 27 мая 2019 г., 9:25:44 UTC+3 пользователь Rohith Balaji написал:

[Google Ads API Forum Advisor Prod]

Hi Max,

Are you facing the same issue? If so, please reply privately to author with your report requests and their results.

Regards,
Anthony
Google Ads API Team

ref:_00D1U1174p._5001USx4Wa:ref