-
Google Analytics Advanced Connector - dataset showing multiple rows per Month
I have datasets with Month of Year selected as dimension from Google Analytics Advanced Connector and I noticed that some of my datasets are producing multiple rows per month while some do not. When summing up the values, they do add up to the total except for averaged columns (i.e. Avg. Page Load Time, Avg. Session…
-
Google Analytics Advanced Connector - User count does not match with GA
I'm using the Google Analytics Advanced Connector and I can't seem to get the correct/exact count of Users when comparing to Google Analytics/Data Studio numbers. I'm aware that Google Analytics aggregates the Users differently compared to the Sessions/Pageviews depending on my selected dimensions (i.e. in order for me to…
-
Doing a moving average using window functions in Analyzer
I have this salesforce lead historical dataset (which tracks Lead stage changes) and I want to show a month-on-month moving average of the number of days it takes a lead to convert to the next stage (e.g. 30 days from Stage 1 to Stage 2) with Stage as series/dimension in my card. The dashboard/cards that I'm creating is…
