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

Avatar

Avatar

rameshk28785

Avatar

rameshk28785

rameshk28785

02-02-2017

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

hyderziaee

Employee

Avatar

hyderziaee

Employee

hyderziaee
Employee

17-02-2017

Hi Ramesh,

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

-Hyder

Answers (10)

Answers (10)

Avatar

Avatar

ashokkumarm

Avatar

ashokkumarm

ashokkumarm

26-07-2019

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

Avatar

manishk56775265

Avatar

manishk56775265

manishk56775265

09-01-2019

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

Avatar

PratheepArunRaj

Moderator

Avatar

PratheepArunRaj

Moderator

PratheepArunRaj
Moderator

26-07-2019

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

Avatar

devinw84924321

Avatar

devinw84924321

devinw84924321

04-10-2018

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

Avatar

devinw84924321

Avatar

devinw84924321

devinw84924321

08-10-2018

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

Avatar

PratheepArunRaj

Moderator

Avatar

PratheepArunRaj

Moderator

PratheepArunRaj
Moderator

07-08-2019

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

Avatar

Avatar

ashokkumarm

Avatar

ashokkumarm

ashokkumarm

26-07-2019

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

Avatar

devinw84924321

Avatar

devinw84924321

devinw84924321

25-07-2019

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

Avatar

rameshk28785

Avatar

rameshk28785

rameshk28785

08-10-2018

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

Avatar

claudialackner

Avatar

claudialackner

claudialackner

02-08-2018

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