Hi,
We run a company that sells advertising campaigns. The campaigns often stretch across multiple months, and we would like to figure out how much we are earning each month from that campaign based off of daily revenue.
Example A:
Advertiser A has a contract for the month of Feb. (28 days) for $2800 ($100/day). In this example, all $2800 is being spent in Feb. so the sum would be $2800 earned in Feb.
Example B:
Advertiser B has a contract from October 15th to November 4rd (20 days total). The contracts value is $2000. The daily revenue from this contract would be $100.
According to this information, $1600 would be coming in October (Calculated by pulling [# of days the contract is running in October] * [daily revenue]) and $400 in November.
The revenue then should be recorded as:
OCT17 => $1600
NOV17 => $400
... and not all $2000 coming in Oct. with zero in Nov.
In our CRM we already collect the following information on our Deals Page:
Start Date, End Date, Term (in Days), Daily Revenue, Net Revenue
How can we generate this report with out manually doing these calculations? Do we need any additional variables on the deals page? Thank you!