Difference between numbers in Google Sheet and Looker

Hi community - i'm having issues with showing correct numbers in Google Looker with data from Google Sheet. 

In Google Sheet I have events as high as, for example, 5058 but in Google Looker, the highest event count I get is 9. 

- The date range is the same 
- the count of the metrics are in [sum] 

what is going wrong here? I'm getting desperate... thank you! 

Screenshot 2024-09-09 at 17.35.27.png



Solved Solved
0 3 261
1 ACCEPTED SOLUTION

I found a solution, it seemed something was missing in the export from Matomo to Google Sheets. 

[&convertToUnicode=0] must been added to the export url from Matomo to Google Sheets. 

Cheers!

View solution in original post