Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Single average frequency number

Avatar

Level 4

I am well aware of the Return Frequency dimension in Workspace.  However I need to get an average Return Frequency that isn't bucketed.  It would be a single number like "1.1 visits per month."  Is it possible to get that single number in Workspace, or even Reports & Analytics?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

I would first create a return visit segment like below

1806572_pastedImage_4.png

Than use this segment to create "Avg. Return Frequency" calculated metric.

1806570_pastedImage_1.png

Report should look something like -

1806573_pastedImage_5.png

Note: however i would recommend to create calculated metric for each return frequency rather than creating a single one.

Thanks,

Asheesh

View solution in original post

2 Replies

Avatar

Level 1

Hi,

For this scenario, we can take Unique Visitors and Visits to calculate Avg. Visits.

Calculation : Visits / Unique Visitors

1799431_pastedImage_4.png

Regards,

Adil

Avatar

Correct answer by
Community Advisor

I would first create a return visit segment like below

1806572_pastedImage_4.png

Than use this segment to create "Avg. Return Frequency" calculated metric.

1806570_pastedImage_1.png

Report should look something like -

1806573_pastedImage_5.png

Note: however i would recommend to create calculated metric for each return frequency rather than creating a single one.

Thanks,

Asheesh