Filter user that trigger one event on some host (subdomain) and then trigger another event

[Cienfu]

I have some landing pages in two subdomains and i have a table filtered to show only that host and some specifics events (time spent, scroll, lead form).

What i want to archieve is have another table that when i click for example in users that spent 30 seconds (t30) on some host, the second table shows me from that users how many also have triggered the lead form.

First table (host 1, event t30, x sessions) > Second table (form that sessions of table 1, evento ContactoGeneral)

[Cienfu]

Any idea?

[JasonCasamina]

Hi Cienfu,

I believe most people would suggest changing the original table you are using. You can build a view with a join that would provide the information you want. Since I do not know what data source you are using, I suggest looking up how to create views and joins in your specific data source.

If you cannot change your original data source, then there is a way to do this in Looker Studio, but it is rather advanced. I will explain it here for you and anyone else looking for a similar solution.

You will need to blend your table with itself. See this article for additional information on how to blend data: https://support.google.com/looker-studio/answer/9061420?hl=en#zippy=%2Cin-this-article

To make this work, we assume your table has the following additional fields:

1. session_id: this should uniquely identify a user. The name itself does not matter. It might be session_identifier, user, or just id. Substitute session_id with the actual name you have. If this field is missing then this solution will not work. How would you know it is the same user who did one event then another event?
2. Sesiones should be a metric. It should Count Distinct session_id. This will guarantee an accurate session count after we make these changes. A regular Count could lead to an incorrect total due to the nature of blending data. If this is not a metric and your table already has counts in it as a dimension then this solution will not work.

This is what your join might look like:

Table 1
Dimensions: Nombre de host, Nombre del evento
Metrics: Sesiones (Count Distinct session_id)

Join configuration
Join operator: Left outer (This is so it selects all users even if they do not do a second action.)
Join condition: session_id (Table 1) links to session_id (Table 2)

Table 2
Dimensions: Nombre de host, Nombre del evento
Metrics: (No metric is needed here)

Save your Blend.

Recreate your first table using this new Blended Table. Use the same dimensions as before, but this time use (Table 1) in your Blended Table. Be very careful when picking dimensions, because the names will be identical except for the ending Table number. Nombre del evento (Table 1) is not the same as Nombre del evento (Table 2).

Then recreate your second table using the Blended Table. Filter for Nombre del evento (Table 2) = contactoGeneral. Display the dimension Nombre del evento (Table 1) and the metric Count Distinct session_id (Table 1).

Enable cross filtering and it should work the way you describe it. I hope that helps!

[Cienfu]

Anyone?