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 one date formatting, rather than having different formats for different time periods.
Wrong example
Correct example
Reason 3. The 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!