Zero cost omitted from results

[Oliver]

Hi,

I have a fairly simple python script that runs a query to get the cost_micros, day, date for a given campaign.

It works fine but I've noticed that any days where no cost was accrued are not included in the results - e.g. it will go from Jan 1st to Jan 3rd if there was no spend on Jan 2nd. This gives an incomplete picture of the data, which is difficult to amend after retrieving.

Is there a way to force zero results to be included? I haven't been able to find anything in the docs for this.

Here is the query:

SELECT
    metrics.cost_micros,
    segments.day_of_week,
    segments.date,
    customer.currency_code
FROM campaign
WHERE campaign.status = 'ENABLED'
AND segments.date >= '2020-01-01' AND segments.date <= '2021-01-01'
ORDER BY segments.date, campaign.name

Thanks in advance if anyone has any ideas!

[Google Ads API Forum Advisor]

Hi Oliver,

Thank you for reaching out to us.

Please note that it is currently not possible to force return a row if all selected metrics fields are zero. However, if there's one or more selected metrics fields having a value that is not zero, the row should be returned. You can refer to this documentation for more details.

Best regards,

Heidi Google Ads API Team

ref:_00D1U1174p._5004Q2YsMjS:ref

[Mat]

Hey Google, you have screwed it up. Bring the zero metrics back to the reports. Give us the option at least!

[Google Ads API Forum Advisor]

Hi Mat,

Thank you for your feedback. I have created a feature request on your behalf, subject to internal review. Any relevant updates will be posted in the release notes.

I see that you have posted on multiple threads created by other users. If you have any follow-up remarks or questions related to zero metric reporting, please limit correspondence to this thread.

Regards,
Matt
Google Ads API Team

Matt Google Ads API Team

 

ref:_00D1U1174p._5004Q2YsMjS:ref

[MATTHEW Dworkin]

Hello,

Not sure if you're taking a tally, but if it helps the internal review: it would be very helpful to have the option to return rows with zero metric reporting. 

Anyone else need this? Let them know!

Thanks,

Matt

[Google Ads API Forum Advisor]

Hi Matt,

I raised with my team your comments. This request is subject to review. You may monitor our blog for an update

Regards,

Aryeh Google Ads API Team

ref:_00D1U1174p._5004Q2YsMjS:ref

[Trevor]

Yes! I needed it before, still need it now. The documentation says "There's no need to implicitly include zero impression rows, so we've removed {includeZeroImpressions : true}. Also, you can't get zero metric rows for segments.

The only alternative seems to be pulling and comparing structural reports to segmented metric reports so you can figure out what's 'missing'

[Google Ads API Forum Advisor]

Hi,

Thank you for getting back to us.

Kindly note that when any metrics like impressions, clicks and conversions are zero that data won't be returned by the Google Ads API. For more information refer to the zero metrics.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02YsMjS:ref"

Thanks,
 

Google Ads API Team