Date range for report | Community
Skip to main content
Level 4
January 12, 2024
Solved

Date range for report

  • January 12, 2024
  • 1 reply
  • 3052 views

Hi everyone,

I am getting confused with date ranges for UV and visit and for seperate subsection segment.

since , I need to create report for daily, monthly  and last 90 days.

->So, Does daily means Today report or just days in dimension for over a month.

->Monthly view should be this month (a custom date range filter) or month in dimension .

->What should be The date range for the panel and will it affect if the custom date range are  different.

Because, I have been doing comparision for visits and UV on the basis of  - this year this month and last year This month.

->I have a doubt on this too can you tell me  should I compare last month and 2 months ago data or This month and last year same month. Which one makes more sense.Same goes to day.

Can anyone please tell me how should I approach or  how normally you deal with date ranges. Any example would be helpful.. Thanks !

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 kayawalton

Hi @aepaa --

I typically would ask the person requesting the report for their date range preference for what the report covers OR if they are not sure, I would look at the data I am analyzing and provide a recommended date range. Because daily and monthly are different date views or breakdown and they did not ask for quarterly but last 90 days, it seems like they might be looking for the last 90 days. (I would double-check.) If they are, make sure you are using the Last Full 90 Days option.

 

As to how to present the daily and monthly views of the data:

To show daily trends of the data, I would drop Day as the rows and the metric as a column. It sounds like you have multiple metrics, so you would have to think about what you're trying to say about those metrics.

If you want to compare trends between UV and visits, I would use UV and visits as different columns and turn that freeform table into a line visualization.

If you want to showcase how a specific metric trends over time, I would keep that table to one metric and right-click to add time-period columns. You can add a column for the 90 days prior to your current date range and/or the same 90 days last year. It really depends on the change from these two time periods to your current data. You will have to update these columns if you change the date range to your panel. There are options to create custom rolling date ranges, but that depends on how often you want to run this report. I would not leave the data as a freeform table, however. It would be easier for you and your stakeholders to digest the data using a line visualization. 

 

For the monthly view, it is the same approach as daily. What are you trying to communicate to your stakeholders? Is it a particular metric over time, or a comparison of both over time? Because you have less rows (if you are using the last 90 days), using a bar graph might be less clunky (I also prefer it to differentiate from the daily view).

 

I think I covered all of your questions. Happy to help if you have any follow-ups.

1 reply

kayawalton
Community Advisor and Adobe Champion
kayawaltonCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
January 12, 2024

Hi @aepaa --

I typically would ask the person requesting the report for their date range preference for what the report covers OR if they are not sure, I would look at the data I am analyzing and provide a recommended date range. Because daily and monthly are different date views or breakdown and they did not ask for quarterly but last 90 days, it seems like they might be looking for the last 90 days. (I would double-check.) If they are, make sure you are using the Last Full 90 Days option.

 

As to how to present the daily and monthly views of the data:

To show daily trends of the data, I would drop Day as the rows and the metric as a column. It sounds like you have multiple metrics, so you would have to think about what you're trying to say about those metrics.

If you want to compare trends between UV and visits, I would use UV and visits as different columns and turn that freeform table into a line visualization.

If you want to showcase how a specific metric trends over time, I would keep that table to one metric and right-click to add time-period columns. You can add a column for the 90 days prior to your current date range and/or the same 90 days last year. It really depends on the change from these two time periods to your current data. You will have to update these columns if you change the date range to your panel. There are options to create custom rolling date ranges, but that depends on how often you want to run this report. I would not leave the data as a freeform table, however. It would be easier for you and your stakeholders to digest the data using a line visualization. 

 

For the monthly view, it is the same approach as daily. What are you trying to communicate to your stakeholders? Is it a particular metric over time, or a comparison of both over time? Because you have less rows (if you are using the last 90 days), using a bar graph might be less clunky (I also prefer it to differentiate from the daily view).

 

I think I covered all of your questions. Happy to help if you have any follow-ups.

Jennifer_Dungan
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
January 12, 2024

I agree with @kayawalton, every person who requests a report may have a different idea about what "monthly" means... so best to confirm by talking to the person... it's better to spend a few minutes chatting to make sure you understand what they want before starting than to spend hours building a report that you may have to go back and spend additional time re-building.

 

 

 

Sometimes I will compare "Yesterday" to "2 Days Ago"... Sometimes I will pull a "Last 7 full days" or a "Last 14 full days trend" or even a "Last 30 full days trend". Sometimes the report will show both...comparisons between the last 2 full days with a larger daily trend to show some history.. I rarely use "Today" since trying to compare a partial day to the previous day.. however, you can get fancy and look at hourly trends, and create a custom date range that can pull data from yesterday up the "hour" we have data today for better comparisons:

 

 



Now, when we speak about Monthly, again, that could be a comparison to the previous month, or to the equivalent month last year... normally if someone says "Monthly" they want recent months... last month to two months ago or a trend of last 3 full months or last 6 full months, etc.. if they want to see a comparison to this month... but sometimes they want a MoM (Month over Month) which generally means they want to see a comparison to the same month last year... but again, I always check because people don't always use the same terms to mean the same thing....

 

 

Both of our suggestions are just that, suggestions... working with the people who will be using these reports is the most important thing... find the date ranges and comparisons that the requester wants... it's safer to ask than to assume.

AEPAAAuthor
Level 4
January 12, 2024

Thanks! @jennifer_dungan , 

Does, DoD means same day last year too.  The report you have shown is Traffic by time of the right.

 

Also, I had asked for one more doubt I have is on  panel creation.

Does panel date and custom date range in report under that panel should be in same ranges. What happens if custom date range in out of scope of panel date range

 

Also, for monthly and 90 days should I need to  create seperate panels?

Because, I need to create panels for subsection also. 

Can you please give me your suggestions and insights on this

Thanks!