Open the CSV in Excel, or import it into Google Sheets and choose comma-separated values. Save your working copy in a controlled location. The CSV contains the rows below and space for your notes; it has no macros, formulas or live account connection. The separate Excel workbook contains editable example inputs and formulas that update the forecast.
How to use the template
Collect real quotes first
Ask each agency for its fee model in writing: percentage of spend, retainer and minimum fee, plus what creative is included. For a hire, price the role in your own market and load it with benefits. For an AI tool, use the price at your spend level and any per-ad or usage cost.
Hold the output equal
Enter one number of new ads per month for all three options. If one option also includes strategy, landing pages or reporting that another does not, add that work as a cost to the others or record it in the quote log. Comparing different scopes on price alone is the most common mistake.
Count your own hours honestly
Every option takes some of your time: calls and approvals with an agency, managing a hire, or reviewing an AI tool's proposals. The workbook prices that time at your hourly value so a cheap invoice cannot hide an expensive week.
Stress-test the spend level, then pilot
Use the sensitivity table to see where the cheapest option changes as spend or ad volume grows. Cost is only half the decision. Shortlist on cost, then run a time-boxed pilot with a clear success measure before committing.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Cost line | How it is calculated | Agency (example) |
|---|---|---|
| Monthly ad spend | Paid to the platforms; same for every option | 20000 |
| New ads per month | Same output for every option | 20 |
| Fee | Higher of minimum fee, or retainer + % of spend | 2500 |
| Salary per month | Yearly salary plus benefits / 12 | 0 |
| Tools or subscription | Monthly price at your spend level | 0 |
| Creative | Creative cost per ad x ads per month | 3000 |
| Your time | Your hours x value of one hour (75) | 450 |
| Total monthly cost | Sum of the five lines above; ad spend excluded | 5950 |
| Cost per 100 ads | Total monthly cost / ads per month x 100 | 29750 |
| Cost as a share of ad spend | Total monthly cost / monthly ad spend | 29.8% |
| One-time setup | Onboarding, recruiting or migration cost | 0 |
| First-year cost | 12 x monthly cost + one-time setup | 71400 |
| Days to first live ads | Your estimate from each provider's plan | 14 |
| Who owns the ad account and pixel | Record from the contract or terms |
Worked review example
Illustrative inputs, not market rates: $20,000 monthly spend, 20 ads a month, your time at $75 an hour. An agency at 10% of spend with a $2,500 minimum costs $5,950 a month; a hire at $112,500 a year fully loaded costs $13,525; an AI tool at $500 plus $25 per ad and 20 of your hours costs $2,500.
At about $101,000 of monthly spend the 10% agency fee overtakes the hire's fixed cost in this example. Change the quotes and the crossover moves.
What this template does and does not establish
Cost and your own speed estimate only. The workbook does not estimate which option produces better ads, lower CPA or more revenue, and example values are illustrative rather than market rates. Benefits share and salary examples come from U.S. Bureau of Labor Statistics data; use your local market.
Primary references
- U.S. Bureau of Labor Statistics: Employer Costs for Employee Compensation
- U.S. Bureau of Labor Statistics: market research analysts pay
