How to export all days from analytics?

Question

excel

When uploading data from google analytics to google exсel, if there were no sessions on some day, then this day is skipped.
And you need to make it so that on days where there were no sessions, zeros were displayed.

Answer 1

You can't go directly to GA from Excel. You are using some kind of software.
As for figuring out how the GA API gives days - you can pick it up here:
https://ga-dev-tools.appspot.com/query-explorer/
If there really are no zeros, then you need to manually add them on the client side after processing the data . For example, stretch all the days separately on a separate sheet, pull up the data from the previous one there, where there will be an error - put 0 there.