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
Fill the ad set inventory
One row per live ad set: type, daily budget, purchases in the last 7 days, ads in it, and whether it has a real business reason to stay apart (country, currency, margin or a legal rule). Each row gets Merge or Keep separate.
Read the summary
Budget, ads and weekly purchases moving into the merged Advantage+ ad set, whether it reaches about 50 a week, and an ads check against Meta's 20-ad suggestion and 50-ad cap.
Go down the switch checklist
Eleven lines with a dropdown each. The three levers should be On, the four controls set, and the four off-switches all No. The bottom line reads Ready to publish only when nothing is red.
Pick the migration path
For an old Advantage+ shopping campaign, answer three questions (existing-customer budget cap, more than 50 ads in an ad set, managed through the API) to get the route: duplicate, migrate in place, copy and migrate, or the Ads Manager upgrade prompt.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Group | Setting | What to do |
|---|---|---|
| Meta runs it | Advantage+ campaign budget | One budget on the campaign |
| Meta runs it | Advantage+ audience | On; interests, lookalikes and lists become suggestions |
| Meta runs it | Advantage+ placements | On, all placements |
| Still yours | Locations | Only where you ship or sell |
| Still yours | Minimum age | Raise only if you must (up to 25 in this setup) |
| Still yours | Custom audience exclusions | Past buyers, staff, existing lists |
| Still yours | Bid strategy or cost cap | Set on the campaign if needed |
| Turns it off | Ad set budgets on 2+ ad sets | Use one campaign budget |
| Turns it off | Hard targeting, suggestions off | Don't restrict the audience to your inputs |
| Turns it off | Placement edits (e.g. removing Threads) | Don't remove placements |
| Turns it off | Device rules (e.g. Android on Wi-Fi only) | Don't add device or connection rules |
Worked review example
Fictional activewear store: 14 manual ad sets at $40/day ($560/day) with 42 ads and 140 purchases a week ($28 cost per purchase). Every ad set got 7 to 14 purchases, far below Meta's ~50 a week. None had a separate country, currency or legal rule, so all 14 merge into one Advantage+ sales ad set with about 140 purchases a week and 42 ads, under the 50-ad cap.
What this template does and does not establish
The controls and off-switches come from Jon Loomer's June 2025 guide to Meta's Advantage+ setup; Meta changes these settings, so check each one in Ads Manager. Meta's 20% lower cost per result is its own footnoted average. The merged maths assumes cost per purchase holds after merging. The legacy ASC freeze applies to the Marketing API; in Ads Manager most campaigns have been moved to the new setup.
Primary references
- Meta: Marketing API v25.0 changelog
- Meta for Developers: ASC and AAC migration options
- Meta: Advantage+ sales campaigns
- Jon Loomer: Advantage+ campaign creation guide
- Meta: About learning limited
