Visit Number/Frequency over set duration of time

[ClassicKW]

This feels to me like it should be a simple task but cant seem to wrap my brain around the best approach to resolving it. 

The Ask: To have the quantity of New & Repeat Visitors to our website in a given month, with the repeat visitors bucket into the quantity of visits they've made within that month. 

The Problem: I cant seem to tie the Visit number to its respective month, only an ongoing tally since the creation of their VisitorID. The stakeholder doesn't want a visitor who's last visit was from 2019 going into the returning visitor bucket. 

In an ideal state, my freeform table ends up looking something like this, but with the visit number tally restarting at the start of each respective month

	Visits	Visits	Visits	Visits	Visits	Visits
	All Visits	New Visitors	Returning Visitor	Returning Visitor	Returning Visitor	Returning Visitor
	All Visits	New Visitors	Visit Number = 1	Visit Number = 2	Visit Number = 3-5	Visit Number = 6+
Month
6/1/2022	50,000	30,000	0	10,000	5,000	5,000
7/1/2022	60,000	40,000	0	15,000	2,500	2,500

[Pablo_Childe · Accepted solution]

You are going to need to adjust the column and row logic a bit. Might be able to get them closer but this was a quick pull together

You will also need to create segments for visits, New vs Returning(1 each for their options). If you do indeep want all column wise might work making 1 segment for each return freq tier. 

GLTU

[leocwlau]

This is quite an interesting request that you need to reset the visit number for each month, and of course, you are not able to do so.

There was a serious flaw in my original reply which count the 'Visit Number' at the visitor level which will go beyond the scope of reporting, so I updated this reply to remove the incorrect answer. Will try to think if there is any other way and indeed not easy.

My immediate thinking is to get data out using Data Warehouse or Data Feed and perform counting out of Adobe Analytics UI which is absolutely doable but not as the original ask.