Number of times visited per week for N consecutive weeks

[jaredhislop]

I'm trying to figure out the best way to build an audience for users that have visited the site (a certain page) 2x per week, each week for 8 consecutive weeks. This is different than average visits per week. 

I've thought about am eight week timeline, but there is not way to chunk that up to count individual weeks within that timeline.

Or a one week timeline and have 8 seperate Numbers (metrics) that count the values in that timeline and have logic that only allows the next number to be populated if the previous one already has a value. There are issues with creating a rolling count with this instead of just clearing all the numbers at the same time.

Ideas are appreciated. 

[mark_reddin]

Hey @jaredhislop !

A clarification on your question

Do weeks have to run from say Sun-Sat, i.e. are they calendar weeks you are after here, or are they just 7 day weeks working backwards from the current date?

Because I think I can give you a recipe for the latter using pure UDH, but the former is more complex and will require some Tealium iQ help.

I will also wait until Monday to give some of our Tealium Experts a chance to give their answers, but the clarification will help them too.

[jaredhislop]

Hey @mark_reddin! Good to hear from you. 

The latter is what we are after. Essentially a rolling previous 56 days from current date.

I'd love to hear what you have in mind so I can try to knock it out this weekend if I have time. 

Thanks

[mark_reddin · Accepted solution]

OK, well maybe @kathleen_jo will forgive me this one time, because you are yourself an expert when it comes to Tealium

So, the idea is that you create a 56 day visitor timeline (or longer if you wish to be more flexible), where you record an event each time the target event occurs.  You don't record anything in the event.

Then, you have a number that is the number of events in the timeline over the past 7 days (you can do that dynamically on the number, you don't need a new timeline for this).

You repeat with another number for the number of events over past 14 days, past 21 days, and so on.

To get the previous 7 days to the last 7 days, you subtract your 7d from 14d numbers.

To get the previous 7 days to that, you subtract your 14d from 21d numbers

And so on.

You basically now have your answer.

In case you haven't seen it, this may help (and I like to plug it whenever possible) https://community.tealiumiq.com/t5/Universal-Data-Hub/AudienceStream-Visit-and-Visitor-Attributes-an...

[jaredhislop]

Interesting. It always takes a couple ways of looking at things. I had looked at that enrichment, but didn't think about using it like this. Thank you for your answer. I'll play around. The worst part about this is having to wait so long to make sure it is set up correctly....

PS. That chart is awesome and would make a cool poster on the wall :)