Skip to main content
nottebohm
Level 2
Oct 16, 2015 2:26 AM UTC
Solved

How to create a calculated month-to-date (MTD) metric?

Hello, how would you create a month-to-date (MTD) metric? For instance, if I count 20 conversions on the 15th of the month, my Conversions MTD metric is 40 (assuming the number of days in the current month is 30).

Thanks!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
sanmeetw1519854
sanmeetw1519854Accepted solution
Level 3
Oct 16, 2015 2:26 AM UTC

Hey Raphael,

MTD is period between start of the month and current date or date under consideration. In this case your MTD will not be 40, it will be 20 only if the date under consideration is 15th.

In case 5 conversions happen on 16th, and the date for MTD is 16th, your MTD will be 25.

Hope this helps.

Regards,

Sanmeet

View in thread

2 replies

Gigazelle
Adobe Employee
GigazelleAdobe Employee
Adobe Employee
Oct 16, 2015 2:26 AM UTC

I'm having trouble understanding where you're getting the 40 from. Can you elaborate on the calculations you use to get that number?

Translate
sanmeetw1519854
sanmeetw1519854Accepted solution
Level 3
Oct 16, 2015 2:26 AM UTC

Hey Raphael,

MTD is period between start of the month and current date or date under consideration. In this case your MTD will not be 40, it will be 20 only if the date under consideration is 15th.

In case 5 conversions happen on 16th, and the date for MTD is 16th, your MTD will be 25.

Hope this helps.

Regards,

Sanmeet

Translate
Terms & ConditionsAccessibility statement

Loading footer...