Data Studio
4.4K members online now
4.4K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Data Studio BigQuery events

Explorer ✭ ✭ ☆
# 1
Explorer ✭ ✭ ☆

I'm validating the number of Sessions and Total Events between GA and BigQuery, knowing there is no sampling for a given day.

The sessions count is the same, but I can't manage to get the proper count of Total Events given the following conditions:

  • GA
    • metric: Total Events
    • Filter: Event Label Contains "something" and Event Category = "abc"
  • BQ
    • metric: totals.visits
    • Filter: hits.type = "EVENT", hits.eventinfo.eventLabel = "something", hits.eventinfo.eventCategory = "abc"

The count of events is lower, and when using a data comparison with the previous day, the % difference is very different.

What's your approach to get a count of events through DataStudio with a BigQuery data source?

 

2017-06-16_13-46-43.png