How to create a calculated month-to-date (MTD) metric? | Adobe Higher Education
Skip to main content
Level 2
October 16, 2015
Répondu

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!

Ce sujet a été fermé aux réponses.
Meilleure réponse par sanmeetw1519854

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

2 commentaires

sanmeetw1519854
Level 3
October 16, 2015

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

Gigazelle
Adobe Employee
Adobe Employee
October 16, 2015

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