AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
2.5K members online now
2.5K 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