gilby
gilby

Reputation: 232

GA4 - Count users that have fired two specific events

I'm trying to create a scorecard that displays the number of users that have taken two specific actions over the configured time period. However, I can't figure out how to properly filter by these two specific events. I know I can't use an AND condition in an "Include event name" filter because this will always yield a count of 0, since each row in my GA4 dataset is tied to a specific event. I thought maybe I could leverage the "Blend Data" feature, but I have no idea how to properly join the two tables, each filtered by a single event name. Any ideas on how I can accomplish this?

For additional context, here's a screenshot of a report I started with the Google Merchandise Store GA4 Sample Data:

GA4 Sample Data Report

In this example, what I'd like to calculate is "Users who viewed promotion AND added to cart." I expect this number to be smaller than "Users who added to cart."

Upvotes: 0

Views: 1551

Answers (2)

ali izadi
ali izadi

Reputation: 539

You can blend two Ga4 data sources, filter dataset1 to event 1, and dataset2 to event 2. Then use cross joins to count the number of users who have either event 1 or event 2. You can also use an active user or a new user as a metric.

cross join 2 datasets

Upvotes: 1

A_Patterson
A_Patterson

Reputation: 555

If you have two event names where you want to count the users, it would be best to leverage RegEx (regular expression) to capture both. I would use the match regex (ignore case) and build an expression like this:

(event_name_1|event_name_2)

() in regEx creates a capture group.

| separates each thing you want to match. You can have as many alternatives in the capture group; they just need to be separated by the pipe.

There are other, more complex ways of matching if there are numbers or if part of the names match but this should at least get you what you need.

Upvotes: 0

Related Questions