Solved

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

Forum|Forum|8 months ago
May 7, 2025
5 replies
1233 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by 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

MandyGeorge

Accepted solution

Community Advisor and Adobe Champion

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

Community Advisor and Adobe Champion

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.

Sukrity_Wadhwa

Community Manager

Hi @yukoyuko_k,

Were you able to resolve this query with the help of the provided solutions, or do you still need further assistance? Please let us know. If any of the answers were helpful in moving you closer to a resolution, even partially, we encourage you to mark the one that helped the most as the 'Correct Reply.'

Thank you!

Sukrity Wadhwa

Y

yukoyuko_kAuthor

Thank you all for your ideas.
Since it seems that legacy metrics are unlikely to be reinstated, we are considering adjusting our operational workflow if that is confirmed.

However, our biggest concern is that we operate over 50 Report Suites.
May we assume that there is absolutely no possibility of these metrics being brought back?
Also, could you share the reason why they were discontinued?
Was it due to high processing load on APIs or SQL? (I suspected this might be the case, as I imagine we would face similar issues if we tried to recreate the same logic using SQL.)

For reference, I’ve attached a simple file showing how we forecast monthly unique visitors.
(Apologies if the conversion from Japanese isn’t perfect.)

The red boxes represent data blocks in Report Builder. Our workflow involves updating only the current month’s data on a daily basis, then copying and pasting the relevant Excel formulas.

This is just one example, but we have many websites and app services, and this kind of standardized logic helps us efficiently generate outputs across different teams.
It would be very disappointing if this capability is fully discontinued.

sample.xlsx

Jennifer_Dungan

Community Advisor and Adobe Champion

Your English translation is good, no need to apologize.

While I don't work for Adobe, I can only guess that is was discontinued because in most respects the "Unique Visitors" metric was "better"... since it auto-adjusts to the time frame.. and when being used in a table, it would show the unique visitors in the month (or day, or week, etc. based on the breakdown) as well as the proper de-duplicated total for the entire time span.

It really shouldn't have anything to do with processing.. There is actually a flag for each granularity in the Raw Data.

Looking at your report, your "Estimated Unique Visitors" for each month is highly inflated because it isn't removing the users that returned across multiple days.

However, I do see how you are using the "Monthly Unique Visitors" to identify duplicate visitors from the month against the day... this is the biggest use case honestly...

Now, trying to replicate this in Report Builder is probably going to be painful, something like setting up a request for each line of the month....

However, the Monthly Unique Visitors metric is still available via the API... I just did a quick check looking at available metrics:

So, maybe you might have to look into using the API to pull a similar report if this is really important?

gautham_madala

Level 5

you're absolutely right that the "Monthly Unique Visitors" metric was a key part of analysis and forecasting in the previous Reports & Analytics and ReportBuilder environments.

Being able to compare monthly unique visitor counts year-over-year or against prior months is fundamental for understanding user frequency trends, projecting growth, and evaluating campaign impact. Rebuilding this logic manually through cumulative date ranges (e.g., May 1–2, May 1–3, etc.) is not scalable, especially for organizations managing multiple web and app properties and with many stakeholders relying on consistent KPI tracking.

I’d like to support this request not only for the reintroduction of Monthly Unique Visitors in the new Report Builder, but also for expanding the offering to include Daily, Weekly, Quarterly, and Yearly Unique Visitors—ideally in both Workspace and Report Builder. These metrics are foundational and help align teams around consistent measurement periods.

Adobe, if there's any roadmap update or potential workaround that minimizes block usage while still achieving a similar result, many of us would appreciate the guidance.

Thanks again for highlighting this—hoping to see this functionality restored in a scalable and native way soon.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded