How to use this Digital Media Plan Generator?
Step 1: Input the Ad channels data, including Channel Name, CPC/CPM, CTR, Conversion Rate, Sale per conversion and Bid Type
For example, I will run 2 campaigns:
- Adword campaign: The bid type is CPC with expecting CTR is 10%, cost per click is 2$, the conversion rate is 2% with 50$ gain per sale.
- Facebook campaign: The bid type is CPM with expecting CTR is 5%, cost per 1000 impression is 15$, the conversion rate is 3% with 35$ gain per sale.
Insert the first table like this
Step 2: insert campaign detail
My budget is 10,000$, and the leads equal qualified leads (converted to sale), so the “% Taken” is 100%.
Insert the second table like this
Explain the % taken: If you only track the number of people who fill the form (leads), the % taken is 100%, but if you want to track how many people who filled the form actually buy the product, you might want to use the % taken.
For example, 1000 people filled the form, and 100 of them actually buy the product, so the % taken is 100/1000 = 10%. Remember this is not the conversion rate
Step 3: Insert budget for each channel
I allocate 70% budget for Adword and 30% budget to Facebook. the table will look like this.
Move to Output Media Plan tab, this will be the result
Comment below if you have any question or suggestion
Also check out Budget Pacing Calculator tool