All Collections
Channel-specific
Google
Google Sheets
Google Sheets - Why my date range doesn't seem to reflect correct Google Sheets data?
Google Sheets - Why my date range doesn't seem to reflect correct Google Sheets data?
Jan Ufnal avatar
Written by Jan Ufnal
Updated over a week ago

If, when first connected, your sheets don't display any data or not all of it, chances are that there is an issue with the way your data is formatted. Here are a few reasons why.

Reason 1: The date range on the sheets doesn’t match the calendar on the report.

Make sure that whichever date range you have selected on the sheets, these dates are covered by the reporting calendar as well.

Reason 2. The date column has different date formatting across the sheets.

Make sure you settle on a "YYYY-MM-DD" date format. When using different date formats, in the report it might not show the data correctly for the date period that you have chosen.

Wrong example

Correct example

If you have any questions or need additional help, please get in touch with our customer support via live chat or hi@whatagraph.com

Did this answer your question?