How to report an event in Adobe analytics based on its occurrences for selected periods.

[Kshg7030]

How can we track and report an event based on its history in adobe analytics.

I have an event for login which I want to filter based on - Users that have logged in and did not return in 1M, 3M

[bjoern__koth]

Hi @Kshg7030 

not sure I get your question right, but typically, you would want to start with a freeform table and drop your event in as metric.

This will automatically add "Day" as dimension (rows) in the table. If you are then interested in extending the lookback window, use the calendar and adapt it accordingly to e.g., "Last 90 days". In this case, daily data may be too granular to keep, so maybe choose "Week" instead to still keep enough data points.

From there on, maybe drag & drop a line visualization on top which should automatically pick up and visualize the data in the table.

[Kshg7030]

Hi @bjoern__koth,

Sorry for any unclear points here. What my objective is to see how many users have logged in once and then not returned for 1 month, 3months and other time periods.

I have a "login" event already in place and I am also collecting user IDs and Unique Visitors.

So end goal would be to see how many unique visitors or unique user IDs are there that have login event and within a 1 month time period but not returned or no visits after that.

I hope I am clear now.

Thanks

[Vinay_Chauhan · Accepted solution]

Hi @Kshg7030 

You are essentially describing a “did event, then did not return within X days” use case, which is more of a retention/churn problem than a straight event count. OOTB Workspace can’t directly calculate “users who did something once, but not again in 1M/3M,” but you can approximate it in two ways -

1. Cohort Table - Use the Cohort Analysis panel in Workspace with “Login” as the inclusion metric and no additional metric for return. This lets you see users who logged in during a given period and whether (or not) they came back in subsequent periods (1M, 3M, etc.).
   
   

2. Segments for churned users, you can build segments like -

   • Visit where Login event exists within Date Range A

   • AND Visitor does not have any Login event after Date Range A (exclude next 30/90 days).
     This will isolate users who logged in during that window but didn’t return.
     
     

According to me, the Cohort panel is usually the most straightforward way to visualize this over time.

Let me know if that works.

[Kshg7030]

Hi @Vinay_Chauhan this worked. Thanks for the help

[Jennifer_Dungan]

I agree with using a Cohort Table set up to look at Churn... 

This will include users that Logged In Successfully, then look for those users to have additional visits at a monthly granularity.

Retention will show the users who do return, Churn will calculate the users who didn't return.

[Kshg7030]

Hi @Jennifer_Dungan , thankyou for the detailed explanation.