Webinar: Adobe Customer Journey Analytics Product Innovations: A Quarterly Overview. Come learn for the Adobe Analytics Product team who will be covering AJO reporting, Graph-based Stitching, guided analysis for CJA, and more!
SOLVED
Unique vistors filtered by last day (24h), last 7 days and last 30 days
Hii everybody!
One of our product owners wants to see his product´s unique visitors by the last day, last 7 days, and last 30 days. However, changing the panel calendar will always show me the numbers based on today. Eg. if I chose the date range for February 25, I see the results for that specific 24h (day), the last 7 days from the 25th, and the last 30 days from it. However, in reality, if I choose a different day, it will always give me a value considering today as starting point. Is there a way for me to create that?
also, how can I create a last 24h (day) dimension since this is not a default one?
additionally, he would like to see in the right column also by day (even if for each case - "filter" - we need a different table).
Something like this dummy illustration:
thank you in advance
1 Accepted Solution
Correct answer by
Hi, the first part of the question
One of our product owners wants to see his product´s unique visitors by the last day, last 7 days, and last 30 days. However, changing the panel calendar will always show me the numbers based on today. Eg. if I chose the date range for February 25, I see the results for that specific 24h (day), the last 7 days from the 25th, and the last 30 days from it. However, in reality, if I choose a different day, it will always give me a value considering today as starting point. Is there a way for me to create that?
is actually easy, Adobe released a new feature this year that will make the tables relative to the panel calendar, it can be found under "show advanced settings" then checking the box to enable it:
With the default setting, your panels look like this (and are always relative to "Today"
But when you enable this setting, the date ranges change to dynamically show the date range relative to the selected panel date (currently selected to "Today"):
But if I were to change to Feb 25th, they become:
Unfortunately, the second part of your question
also, how can I create a last 24h (day) dimension since this is not a default one?
Adobe is not designed for this type of date selection...
While technically you can bind a date selection by a start time (which applies to the start data) and an end time (which applies to the end date) which technically allows you to pull something like:
July 6th, 5:00pm - July 7th, 4:59pm (which would be a 24 hour segment)... there is no way to make this dynamic...
And the relative date range doesn't take the selected time into account, you can see this just becomes July 5th, and the time starts at midnight
On top of that, once you allow people to change the panel data to "Feb 25" or whatever date they want, the current time becomes irrelevant... the selected date would be Feb 25th as a whole and the report would just return Feb 24th....
If they want an interactive report where people can choose a day and get relative data back, the "last 24 hours" makes no sense... better to just build three tables for "Last 30 Full Days", "Last 7 Full Days" and "Yesterday"
Correct answer by
Hi, the first part of the question
One of our product owners wants to see his product´s unique visitors by the last day, last 7 days, and last 30 days. However, changing the panel calendar will always show me the numbers based on today. Eg. if I chose the date range for February 25, I see the results for that specific 24h (day), the last 7 days from the 25th, and the last 30 days from it. However, in reality, if I choose a different day, it will always give me a value considering today as starting point. Is there a way for me to create that?
is actually easy, Adobe released a new feature this year that will make the tables relative to the panel calendar, it can be found under "show advanced settings" then checking the box to enable it:
With the default setting, your panels look like this (and are always relative to "Today"
But when you enable this setting, the date ranges change to dynamically show the date range relative to the selected panel date (currently selected to "Today"):
But if I were to change to Feb 25th, they become:
Unfortunately, the second part of your question
also, how can I create a last 24h (day) dimension since this is not a default one?
Adobe is not designed for this type of date selection...
While technically you can bind a date selection by a start time (which applies to the start data) and an end time (which applies to the end date) which technically allows you to pull something like:
July 6th, 5:00pm - July 7th, 4:59pm (which would be a 24 hour segment)... there is no way to make this dynamic...
And the relative date range doesn't take the selected time into account, you can see this just becomes July 5th, and the time starts at midnight
On top of that, once you allow people to change the panel data to "Feb 25" or whatever date they want, the current time becomes irrelevant... the selected date would be Feb 25th as a whole and the report would just return Feb 24th....
If they want an interactive report where people can choose a day and get relative data back, the "last 24 hours" makes no sense... better to just build three tables for "Last 30 Full Days", "Last 7 Full Days" and "Yesterday"
Related Conversations
