Free editable template

Agency vs in-house vs AI cost comparison

Put real quotes side by side and see the total monthly cost, cost per 100 ads, cost as a share of ad spend, first-year cost and your own estimate of time to first live ads. The same formula runs every column, so the comparison is not tilted toward any option.

By GaaS editorial · Sources checked · 14 worksheet rows

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 lineHow it is calculatedAgency (example)
Monthly ad spendPaid to the platforms; same for every option20000
New ads per monthSame output for every option20
FeeHigher of minimum fee, or retainer + % of spend2500
Salary per monthYearly salary plus benefits / 120
Tools or subscriptionMonthly price at your spend level0
CreativeCreative cost per ad x ads per month3000
Your timeYour hours x value of one hour (75)450
Total monthly costSum of the five lines above; ad spend excluded5950
Cost per 100 adsTotal monthly cost / ads per month x 10029750
Cost as a share of ad spendTotal monthly cost / monthly ad spend29.8%
One-time setupOnboarding, recruiting or migration cost0
First-year cost12 x monthly cost + one-time setup71400
Days to first live adsYour estimate from each provider's plan14
Who owns the ad account and pixelRecord 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

Continue the work