Skip to main content
All CollectionsChannel-specificGoogleGoogle Sheets
Google Sheets - Why I cannot see my data displayed correctly when using Google Sheets?
Google Sheets - Why I cannot see my data displayed correctly when using Google Sheets?

Do you see incorrect numbers or errors when your sheets are connected? Here are some steps to re-check before proceeding further.

Jan Ufnal avatar
Written by Jan Ufnal
Updated over 4 months ago

Here are a few steps to keep in mind if you are not seeing the data being displayed correctly in the reports.
​

Step 1: Has your date column been selected to be the first column in the sheets?

The date range column should always be the first column and not in the middle of the sheets, especially when there is another column next to it that resembles numbers as well.

Wrong example :

Correct example:

Note: please make sure that you are using the "YYYY-MM-DD" date format.

Step 2: Are your metrics segmented into separate columns?

Make sure your sheets have each metric separated into different columns on the horizontal side, not the vertical, otherwise, the report will treat dimensions and metrics incorrectly.

Wrong example

Correct example

Did this answer your question?