'Calculate the average times each event occurs per session in google data studio
For our web we have set up a number of events we track in Google Analytics. The events are tracked with event category, event action and event label. I have set up a table in Google Data Studio where I show all these events with the total number each event has occurred ("Total Events" value) in the time span selected. Event category, action and label becomes the dimensions of the table and Total events is the metric.
What I want to do now is to calculate the average count of each event per session. So if we have tracked a total of 1000 sessions in the time span and one event has occurred 100 times I want to add a column displaying the value 0.1. However the value for metric "Sessions" will of course be based on the dimensions set up for the table so the value on each row will be the number of sessions where that specific event has occurred meaning the number of sessions is different on each row and not the actual total.
I have been trying for a while to find a way around this and googled for hours but have not been able to find a solution. Perhaps it is not possible but I would like to hear if you know a way it can be done.
Solution 1:[1]
The key is blend data (this link was help) of the same data source and them you can compare de timestamp.
DATETIME_DIFF(event_timestamp (Onb_sin_IngresoCel),event_timestamp (IngresoCelular),SECOND)
With that I could calculate de difference between on event and a group of other making a funnel.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |