CODEWITHSUNDEEP
google-analyticslooker-studiocalculated-field
Bruno Monteiro
Bruno Monteiro

Reputation: 4519

Google Data Studio: How to count number of specific events

I know similar questions were asked before, but none of the answers that I found (example here, another example) helped me.

What I am trying to do:

Create a report in Google Data Studio that shows me number of Unique Page Views VS Specific Event. For example: how many users visited page X, and how many of those clicked in button Y.

enter image description here (Example of what I am trying to achieve) ☝️

What I already have:

Google Analytics is configured and events are tracked. When I go to Google Analytics I can see the numbers there. Google Data Studio is already connected to my Google Analytics and the numbers are matching.

What I tried so far:

Test 1

Create a chart using Unique Page Views and Unique Events metrics and set a filter with Event Name = "Button clicked", but that filters my Unique Page Views metric and I end up with wrong numbers.

Test 2

Create a Calculated Field using:

SUM(case when REGEXP_MATCH(Event Action, "Button clicked") then 1 else 0 end)

or using:

COUNT(case when REGEXP_MATCH(Event Action, "Button clicked" ) then "Button clicked" else NULL end)

But this only returns 1

Appreciate any other ideas 💡

Upvotes: 16

Views: 25142

Answers (4)

Cade Whitbourn
Cade Whitbourn

Reputation: 1

The post by Cmoz works for me, but after I first created a data extract, and ran the calculated field on that datasource

Upvotes: 0

Cmoz
Cmoz

Reputation: 1

I'm not sure if this is related to Google Analytics 4 data, but that is how I wound up reading this post. I have found a solution. If you would like to pull specific events as a metric, just do the following:

SUM(IF(Event name - GA4="G1_COMPLETION",Event count - GA4,0))

Upvotes: 0

Serhii Yashchuk
Serhii Yashchuk

Reputation: 1

Here is a solution but in my case - I joined not just 2 tables but also it was necessary to join 1 more table just with the date. Where we blend data - we join table 2 with table 1 and table 3 with table 1 also the result of blending data

data blending setup

Join configuration

Upvotes: -1

RaV
RaV

Reputation: 627

Try data blending feature:

  1. Create first plot with Visitors/Users or Unique Page View.
  2. Create second plot with Unique Event filtered as you want.
  3. Select both plots, right-click on one of them, select Blend data.

Example (with addition of unfiltered plot for comparison): Plot comparison

Upvotes: 11

Related Questions