# Excel templates for paid ads

> Free Excel templates for paid ads on Meta, Google, TikTok, Snapchat, LinkedIn, YouTube and X

Source: https://softwiro.com/templates/for-ads
Language: English
Softwiro, softwiro.com

---

Free Excel templates

# Excel templates for paid ads: budget, performance and reports

Ready-made sheets with working formulas for anyone who runs paid ads for their own business or for clients: split the budget across platforms, track CTR, CPA and ROAS every day, test ads in two versions and find out whether the difference is real, work out the break-even point and the highest cost per conversion you can afford, build organised UTM links, and audit an ad account with a checklist. Each sheet also comes with a free summary sheet in Arabic and English with the terms and tips for each platform.

The workbooks are in Arabic (right-to-left); each template's page explains every tab in English.

## The templates

[Ad budget media plan across platforms Split a monthly ad budget across platforms and campaigns, project ROAS, CPA and profit from CPM, CTR and CVR, and compare three scenarios. Workbook in Arabic Details and download](https://softwiro.com/templates/ads-media-plan-budget) [Ad campaign performance tracker Log daily ad spend and results for Meta, Google, TikTok and more. The sheet works out CTR, CPC, CPM, CVR, CPA and ROAS and flags campaigns off target. Workbook in Arabic Details and download](https://softwiro.com/templates/ads-performance-tracker) [Ads A/B test log Log each ad A/B test. The sheet works out CTR and conversion rate for A and B, the lift, a z test at your confidence level and a verdict per test. Workbook in Arabic Details and download](https://softwiro.com/templates/ads-ab-test-log) [Ads break-even and unit economics sheet Enter price, cost, shipping, payment fee and returns. The sheet works out margin per order, break-even ROAS and maximum CPA, then simulates a monthly ad budget. Workbook in Arabic Details and download](https://softwiro.com/templates/ads-breakeven-unit-economics) [Ad agency client management and reports Log each client's ad spend, results and your hours. The sheet works out your fee, ROAS, internal cost and margin, and gives a report card per client. Workbook in Arabic Details and download](https://softwiro.com/templates/ads-agency-client-reports) [UTM link builder and campaign naming Enter the page link, source, medium and campaign and the sheet builds a lowercase UTM link and a structured campaign name, and flags duplicates and gaps. Workbook in Arabic Details and download](https://softwiro.com/templates/ads-utm-naming-builder) [Ad account audit checklist A 42-item ad account audit checklist across seven areas. Answer yes, partly or no and get a score per area, an overall rating and the top 10 fixes. Workbook in Arabic Details and download](https://softwiro.com/templates/ads-account-audit-checklist) [Ads creative production calendar Log each ad design, video or copy with platform, owner, due and launch dates. The sheet flags overdue and ready items and shows a board by status and owner. Workbook in Arabic Details and download](https://softwiro.com/templates/ads-creative-production-calendar) [Ads lead quality tracker Log each lead with its campaign, status and sale value. The sheet works out cost per lead, cost per qualified lead, close rate, CAC and ROI per campaign. Workbook in Arabic Details and download](https://softwiro.com/templates/ads-lead-quality-tracker) [Media buyer rules sheet: ad formulas, scaling rules and testing discipline Media buying rules in Excel: 61 rules with formulas (CPM, CPC, CTR, CPA, ROAS, MER), calculators, a scale/keep/kill helper for 10 ad sets, checklists, a quiz. Workbook in Arabic Details and download](https://softwiro.com/templates/media-buyer-rules)

## Frequently asked questions

### Are the numbers in the sheets official platform benchmarks?

No. The cost per thousand impressions, click-through rate, conversion rate and targets in the examples are assumptions that you change for your business and platform. What varies between industries and countries is not presented as fact.

### Does the sheet connect to my ad account?

No, you type or paste the numbers from the platform's reports. If you want a direct connection and automatic reports, a custom app can be built.

### Are the templates free?

Yes. You download and use them with no sign-up. They work in Excel and Google Sheets, and each one also opens in the browser on a worked example.

### Do the templates follow an official regulation?

No. The templates are calculation tools. Grade boundaries, subjects and weights in them are example values that you type in the settings sheet according to the rules of your school or the body you follow, so check the official source before relying on any result.

### Where is my data kept?

In your file, on your device. The version that opens in the browser keeps its data in your browser and sends nothing to a server, so export it to Excel before you close the page.

[All templates](https://softwiro.com/templates)
