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

Reason 1. Date range on the sheets don’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 report calendar as well.

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

Make sure you settle on one date formatting, rather than having different formats for different time periods.

Wrong example

Correct example

Reason 3. Report takes metric columns and treats them as dimensions

When you have every data set up in a column but still see your metric data appearing in the dimension, make sure that metric names don’t include time/date period in them. For example (Last Year, This Month etc.)

Wrong (Will be treated as dimensions instead of metrics)

Correct

If this does not take care of the issue, please get in touch with us via live chat and we can get to the root of the problem!

Did this answer your question?