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

[esperanzalejano]

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.

[PratheepArunRaj]

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

[Gigazelle · Accepted solution]

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".