How does Advanced Delivery handle February when a monthly report is scheduled for the 30th? | Community
Skip to main content
esperanzalejano
esperanzalejano
December 5, 2017
Solved

How does Advanced Delivery handle February when a monthly report is scheduled for the 30th?

  • December 5, 2017
  • 2 replies
  • 1330 views

I've scheduled several reports to generate on a monthly frequency on the 30th. What happens in February, when there are only 28 days in the month? These reports compare metrics for the rolling dates of 'This Month' to 'Last Month,' so I am unable to schedule them for the 1st.

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 Gigazelle

You know, that's a really good question, I've never tried scheduling a report for the 30th/31st day of the month to see if it arrives. I want to say it will skip that month, but I've never tried it before.

As an alternative to to trying to scheduling things on the last day of the month, you can change the schedule date to the first of the month, then change the reporting date range to "last month" and "2 months ago". That would achieve essentially the same results as scheduling the report on the last day of the month with a date range of "this month" and "last month".

2 replies

PratheepArunRaj
Community Advisor and Adobe Champion
PratheepArunRajCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
December 5, 2017

Dear esperanzalejano

The option to schedule a Report on the last day of the month is available in Workspace.

Since you didn't mention the source, below is how you can manage if you are using Report Builder.

Schedule the report on 1st day of every month. In Comparison date, rather than selecting the 'Rolling Dates' dates of 'This Month' to 'Last Month', choose 'Date From Cell' & select the cells with

From      : Formula (=EDATE(TODAY(),0)-1)

To           : Fromula (=EDATE(Refer 'From' Cell,-1))

And schedule it on the 1st day of every month rather than 30th.

If you are using any other source like Reports or Dashboards from Adobe Analytics Interface, I dont think we can do it for now.

Thank You!

Arun

Thank You, Pratheep Arun Raj B (Arun) | Xerago | Terryn Winter Analytics
Gigazelle
Adobe Employee
GigazelleAdobe EmployeeAccepted solution
Adobe Employee
December 9, 2017

You know, that's a really good question, I've never tried scheduling a report for the 30th/31st day of the month to see if it arrives. I want to say it will skip that month, but I've never tried it before.

As an alternative to to trying to scheduling things on the last day of the month, you can change the schedule date to the first of the month, then change the reporting date range to "last month" and "2 months ago". That would achieve essentially the same results as scheduling the report on the last day of the month with a date range of "this month" and "last month".

Terms & ConditionsAccessibility statement

Loading footer...