Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
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