I want to use the metric "Monthly Unique Visitors" in the new Report Builder.

[yukoyuko_k]

Hello,

I would like to request the development of the "Monthly Unique Visitors" metric, which was available in the previous Reports & Analytics and ReportBuilder, for use in the new Report Builder.

(Ideally, it would also be great if it could be used in the Workspace. Similarly, it would be beneficial if Daily, Weekly, Quarterly, and Yearly Unique Visitors metrics could also be available.)

The reason we need this is that it is very useful for forecasting monthly unique visitors. By comparing the "Monthly Unique Visitors" for the same month of the previous year or the previous month with the daily "unique visitors," we can leverage user visit frequency trends (daily number of duplicate visitors within the same month) to create highly accurate forecasts.

I understand that it might be possible to extract UUs for periods like May 1st to May 2nd, May 1st to May 3rd, ..., May 1st to May 31st, etc., using similar logic. However, I am concerned that this would require a large number of data blocks. We operate a large number of web and app services, and many employees rely on this metric to monitor KPIs.

Please consider this request.

[MandyGeorge]

Hi @yukoyuko_k , if you want to use monthly unique visitors but there isn't a default metric for it, you could do it a couple of other ways. First, since the report builder lets you use custom metrics, you could build your own metric. You would do that by using unique visitors divided by distinct count of months. Distinct count is a function that you can drag into your metric and it will count how many months there are and divide the total unique visitors by that, giving you a monthly average. Or, you could simply create a data block that is unique visitors broken out by month, and then in excel create an average.

Also, if you want to suggest this as an idea to the product team, the best place to put it is in the ideas section. That area is where people share ideas and we can upvote each others ideas so the product team knows what the users want to see. Adobe Analytics Ideas - Adobe Experience League Community

[Jennifer_Dungan]

Sadly, I don't think that Monthly Unique Visitors, Daily Unique Visitors, Quarterly Unique Visitors, etc will ever be brought back... those are all legacy metrics that existed before the "date flexible" Unique Visitors metric was created. Then the old metrics were dropped from the UI... The old report builder was still able to tap into those metrics, but for the most part they were technically no longer supported. But I hear you, those old metrics still have some applicable applications today... it's sad that even though the data exists, it's not available to us... so it's worth a try....

However, if you want to compare your daily uniques to your monthly uniques, you can do so with a complex calculated metric...

Basically, you will have to create a series of nested IF statements, to check for each month of the year, if true, then you can return "Total Unique Visitors" for that specific matching month...

I just did a small sample looking for April:

To get the "Total Unique Visitors", pull in the Unique visitors metric, click on the gear, and choose "Grand Total"

You can see that my Days for Feb show 0, for both UVs filtered to April, as well as my calculated:

But, when I scroll down to April, the middle column (just the month filtered UVs) is the same daily value... but the calculated column (since it's now April) is showing the Monthly UVs

If you need to compare to the previous year's month, the display gets a little wonky... (in this case to last year being a leap year), but if I add a compare time period to last year on my calculations, I can see last year's Monthly UVs:

This would probably work better at a quarterly granularity.