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_codeFROM campaignWHERE 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! -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/9120b723-cf08-4909-8f2c-c6f014722ca4n%40googlegroups.com.