Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

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

rameshk28785
Level 5
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
hyderziaee
Correct answer by
Employee
Employee

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

0 Replies
hyderziaee
Correct answer by
Employee
Employee

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

claudialackner
Level 1
Level 1

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

devinw84924321
Level 2
Level 2

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

rameshk28785
Level 5
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.

devinw84924321
Level 2
Level 2

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.

manishk56775265
Level 2
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

devinw84924321
Level 2
Level 2

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.

ashokkumarm
Level 5
Level 5

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

PratheepArunRaj
Moderator
Moderator

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

ashokkumarm
Level 5
Level 5

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

PratheepArunRaj
Moderator
Moderator

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