Forum Discussion
identical Google Analytics created at different time returned different values
- 9 years ago
Hi Anonymous,
Power BI Desktop rely on the Google Analytics Core Reporting API to get data from the Google Analytics service, though Power BI desktop attempts to update corresponding to the API changes, we can't guarantee the results when use this connector. See: Google Analytics connector for Power BI Desktop.
According to the document, I would suggest you post a thread in Stack Overflow google-analytics-api forum to get help from Google Analytics.
Best Regards,
Qiuyun Yu - Anonymous9 years ago
It seems Google Analystics return different values if you select Metrics from different FOLDERS. Google analytics has basically 3 kind of information 1) Folder 2) Dimension 3) Metrics... In each folder (eg Ecommerce) you have Dimension (product category) AND metrics (Revenue $).. If in PBI Get data, I select more than one Metric from 2 different folders (eg Revenue $ from 'Ecommerce folder' AND Session Duration from 'Session folder'), I return a different Revenue $.
My solution (which is cumbersome).. to create 2 queries.
Query 1:
Time = Month of Year
Ecommerce = Revenue $ metric
Query 2:
Time = Month of year
Session = Session Duration
I like to hear from Google Anaytics experts - as my approach is cumbersome
Hi Anonymous,
Power BI Desktop rely on the Google Analytics Core Reporting API to get data from the Google Analytics service, though Power BI desktop attempts to update corresponding to the API changes, we can't guarantee the results when use this connector. See: Google Analytics connector for Power BI Desktop.
According to the document, I would suggest you post a thread in Stack Overflow google-analytics-api forum to get help from Google Analytics.
Best Regards,
Qiuyun Yu
It seems Google Analystics return different values if you select Metrics from different FOLDERS. Google analytics has basically 3 kind of information 1) Folder 2) Dimension 3) Metrics... In each folder (eg Ecommerce) you have Dimension (product category) AND metrics (Revenue $).. If in PBI Get data, I select more than one Metric from 2 different folders (eg Revenue $ from 'Ecommerce folder' AND Session Duration from 'Session folder'), I return a different Revenue $.
My solution (which is cumbersome).. to create 2 queries.
Query 1:
Time = Month of Year
Ecommerce = Revenue $ metric
Query 2:
Time = Month of year
Session = Session Duration
I like to hear from Google Anaytics experts - as my approach is cumbersome