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

Why Daily, Weekly & Monthly Unique Visitor Metrics not showing up in the Workspace?

Avatar

Level 5

Hi,

Do you have any idea why Daily, Weekly & Monthly Unique Visitor Metrics not showing up in the Workspace? When i am trying to add Daily Unique visitor Metric its not available in Workspace. Only Unique Visitor metric is available

Any suggestions would be helpful.

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Hi Ramesh,

These metrics are from an earlier version of Sitecat, and are not supported by Ad Hoc and Analysis Workspace.

-Hyder

View solution in original post

11 Replies

Avatar

Correct answer by
Employee Advisor

Hi Ramesh,

These metrics are from an earlier version of Sitecat, and are not supported by Ad Hoc and Analysis Workspace.

-Hyder

Avatar

Level 1

Hi Hyder, is there a way to calculate Daily Unique Visitors based on the supported metric Unique Visitors? Thanks

Avatar

Level 3

I second claudialackner​ question above. It's a real disappointment that we can't use daily unique visitors in Workspace. It's a much better indication of traffic compared to visits. hyderziaee

Avatar

Level 5

Hi Devin,

Create a calculated metric in the workspace (ex: sum of all "UV's" for each day of a month). It gives the same result as Adobe Analytics DUV's data.

Avatar

Level 3

rameshk28785​ Can you provide an example of the calculated metric so we know how to build it? The goal here is too DUV by month or week in the workspace without having to break UVs down by day.

Avatar

Level 2

Hello Fellow Adobe Analytics Users,

I tried to create the following Calculated Metric and It works:

  1. Drag the metric - 'Unique Visitors' in the canvas and Divide it by Step no 2 below
  2. Drag the function 'Approximate Distinct Count' and drag the dimension 'Day' in it as shown in the screen grab below. It works when use Week, Day, Month or Year.

Daily Unique Visitors.png

Avatar

Level 3

Thanks for adding this but it still doesn't get you to actual daily unique visitors. If you split unique visitors by the day dimension and manually sum, it won't equal the custom metric.

Avatar

Level 6

Hi Ramesh,

If you need Daily Unique Visitors in Workspace try this below method to get that detail.

If you need Daily Unique Visitors then insert Day as Line Item and then add metric "Unique Visitors"

After that Right Click on Metric header, then click "Create metric from Selection > Column Sum", you will get the Daily Unique Visitors number.

1800105_pastedImage_0.png

Same has applicable for Monthly and Weekly

Regards

Ashok

Avatar

Community Advisor

Dear Ashok,

If i do the above, i see same Unique Visitor Number for the entire month. Guess that was not correct.

Thank you!

Arun

Avatar

Level 6

Hi Arun,

Yes.. its display entire month same number and i have changed display rows number as "1" to view single rows.

Requirement is to view Daily Unique Visitors number in Workspace. So i give suggestion to display Daily Unique Visitor number in Workspace.

Regards

Ashok

Avatar

Community Advisor

Dear All,

Thought of reverting the discussion a long back, but somehow was packed and unable to reply.

As said by Ashok Kumar, it is a very good idea to Sum the Column to have Daily Unique Visitor but will work only on aggregations.

Explanation goes below:

Assume, you want to understand daily Unique Visitors for May - Jul 2019. You can go to Reports & Analytics interface and just drag the Unique Visitors to it : Below the Screen Grab.

1808606_pastedImage_0.png

In Work Space, you cannot do it by month, rather you can aggregate the numbers by each month.

I.e. If you take Day Dimension and Unique Visitor as a metrics to Sum the column, you will only get 8,315 as the answer which is Daily Unique Visitor for all 3 months combined : Below the Screen Grab.

1808607_pastedImage_1.png

So if you want to understand Daily Unique Visitor by month, either you need to create 3 Free Form Tables with different Time Period to Sum the column or compare it with time periods to Sum the column like below in a Single Free Form Table.

1808608_pastedImage_2.png

Now you can see that Daily Unique Visitors Number matching the column aggregations.

Hope this is clear!

Thank You!

Arun