Expand my Community achievements bar.

Announcement: Calling all learners and mentors! Applications are now open for the Adobe Analytics 2024 Mentorship Program! Come learn from the best to prepare for an official certification in Adobe Analytics.
SOLVED

Month Over Month not working on First Day of the Month

Avatar

Level 1

I have reports that need to be sent out daily comparing current MTD vs previous MTD. For example, if today is Mar 9, it'll be comparing Mar 1-9 data to Feb 1-9 data. But this breaks on the first day of each month. On Mar 1, Adobe is trying to compare Mar 1-1 vs Feb 1-1, but it returns 0 for the metrics on Mar 1 resulting in any % change or difference to be wrong. I'd like Adobe to use Feb vs Jan data on the day of Mar 1.

 

The solution logic can be a simple if statement, but it's hard to code that directly into Adobe. Does anyone have a workaround for this MTD vs PMTD issue on the first day of each month?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

I don't think this is currently possible in Workspace... you can do something like that using Report Builder and Excel... you can create formulas to calculate the date range based on "today()" and some if statements to dynamically calculate the to and from date ranges for your "current" and "previous" time frames.

 

Then you use those cells to drive the start/end dates in Report Builder, pull in your data and then present the data all in Excel; you can even schedule this to send out automatically every day.

 

 

I did something similar to this with a monthly report that looked at YTD. When the report runs on Jan 1, instead of looking at this year... I look at the full last year and previous year. Then in Feb, it calculates the YTD and Previous YTD (ie. Jan this year vs Jan last year)

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

I don't think this is currently possible in Workspace... you can do something like that using Report Builder and Excel... you can create formulas to calculate the date range based on "today()" and some if statements to dynamically calculate the to and from date ranges for your "current" and "previous" time frames.

 

Then you use those cells to drive the start/end dates in Report Builder, pull in your data and then present the data all in Excel; you can even schedule this to send out automatically every day.

 

 

I did something similar to this with a monthly report that looked at YTD. When the report runs on Jan 1, instead of looking at this year... I look at the full last year and previous year. Then in Feb, it calculates the YTD and Previous YTD (ie. Jan this year vs Jan last year)