How can I set up my table for this? Of users who watched a livestream, how many of those users are revisiting our site after?

[user70977]

I want to know what's the return visit rate of users who watched a livestream. Would it be best to set up a segment? How should I set up my tables to get this data.

[Vinay_Chauhan]

Hi @user70977 

Yes, setting up a segment is a great way to go.

You can start by creating a visitor-level segment that captures anyone who watched the livestream (based on the event or variable you’re using for that). This way, you’re grouping all users who engaged with the livestream at least once.

Then in Workspace, use that segment in a table to track how many of those visitors came back. You can do this by pulling in metrics like visits, unique visitors, or even set up a cohort table to see return behavior over time (e.g., how many came back on Day 1, Day 2, etc.).

If you want a quick return rate, try creating a calculated metric like -

Return Visits / Visitors (for livestream viewers)

This gives you a clean % of how many people came back after watching.

Hope that helps!

[KumarRishii · Accepted solution]

First, create a calculated metric for Return Visit Rate. Then, create two segments:

Segment 1: Users who watched the livestream (based on an event like livestream_view).
Segment 2: Users who visited the site after watching the livestream, within a defined timeframe (e.g., 7 days).

Next, set up two tables:

Livestream Views Table: Track users who watched the livestream.
User Visit Data Table: Track user visits after the livestream.

I hope the above steps helps you to get your required data.

[user70977]

Hi @KumarRishii Can you explain further about how to set up segment 2? Would this be a sequential segment? Also why are we limiting to a defined time frame?

[pradnya_balvir]

Hi @user70977 , Agree with @Vinay_Chauhan ,Yes a segment is the best starting point for this analysis. You want to identify users who watched a livestream, and then measure how many of them returned to your site (i.e., made a subsequent visit). Providing workspace steps.

Create a Segment  “Watched Livestream”

You’ll need to identify the event or variable that tracks livestream views.

Example Segment Definition:

• Visitor-level segment

• Condition:

• Event = livestream_view (or however you're tracking it)

  Make sure it's a "Visitor" container: you want to capture future visits from these users.

  Segment Name: "Users who watched livestream

Create a Calculated Metric: Return Visit Rate

Return Visits / Unique Visitors

Set Up the Table in Workspace

Segment	Unique Visitors	Return Visits	Return Visit Rate
Watched Livestream	(auto)	(auto)	(calc metric)
Site Average (All users)	(auto)	(auto)	(calc metric)

You could break it down further by:

• Livestream Title (if available)

• Date of First Visit

• Days Since Last Visit

Thanks.

Pradnya

[user70977]

Hi @pradnya_balvir  Thank you so much for the detailed explanation. I have a few follow-up questions on the set up.

1) Is there a specific time frame I need to filter my table for? For example, should I only filter for dates after the livestream to ensure we are only getting return visits? Should I only filtre for livestream dates and onwards? Does it matter what time frame I look at?

2) Can you explain how you came up with the formula for return visit rate? I thought return visit rate would be return visits/total visits and return visitor rate is return visitors/total visitors.

3) I originally tried a sequential segment. Would that work as an alternate solution?