The Scenario
You're a paid media director managing six brand clients. Every month you run a portfolio health check across all their Snapchat campaigns — status, budget, flight dates — to catch anything that's lapsed, overspent, or scheduled past the campaign end date. You've been doing this by logging into six different Ads Manager accounts and copying the data into a master spreadsheet. It's the third Monday of the month and this is your least favorite part of the job.
The bad version:
- Log into client 1's Ads Manager. Navigate to Campaigns. Export the campaigns list — or manually copy the names, statuses, budgets, and start/end dates if the export doesn't include all the columns you need.
- Paste into the master sheet. Log into client 2. Repeat.
- Six accounts, six logins, six exports or copy sessions. If any of the ad accounts have more than one page of campaigns, you have to click to the next page and copy again.
Three hours later you have a master sheet that's stale by the time anyone looks at it because the flight dates for two campaigns ended yesterday and you'll catch that next month.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your sheet and connects to the Snapchat Marketing API. You can pull campaigns from multiple ad accounts in one ask.
List all campaigns for Snapchat ad account abc123 and write campaign name, status, daily budget, start date, and end date into columns A through E of the Portfolio Health tab, formatting dates as YYYY-MM-DD
What You Get
- One row per campaign, all pages fetched
- Campaign name, status, daily budget, start and end dates in consistent formatting
- Covers the full account — no pagination gaps
What If the Data Is Not Quite Ready
You need campaigns from two ad accounts combined into one table
Fetch all campaigns from Snapchat ad accounts abc123 and xyz456, add an Account column as column A, and write campaign name, status, daily budget, start date, and end date into columns B through F — format all dates as YYYY-MM-DD
You want to flag campaigns that have already ended
Pull all campaigns for Snapchat ad account abc123 — campaign name in A, status in B, daily budget in C, start date in D, end date in E — then write Lapsed in column F for any campaign where the end date is before today and status is still Active
You want campaign objective included for budget allocation context
List all campaigns from Snapchat ad account abc123 — campaign name in A, objective in B, status in C, daily budget in D, start date in E, end date in F — formatted dates as YYYY-MM-DD
Full monthly health check: all campaigns, lapse flags, budget flags, and summary totals
Fetch all campaigns across Snapchat ad accounts abc123 and xyz456 — account in A, campaign name in B, status in C, daily budget in D, start date in E, end date in F — flag Lapsed in column G for any campaign past its end date, flag High Spend in column H for any campaign with daily budget above $1,000, and add a TOTALS row at the bottom summing column D
The health check sheet is built and annotated in one prompt instead of a three-hour manual pull.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where your monthly Snapchat portfolio review lives, then ask it to pull campaigns from your ad accounts. Related: pulling ad squad performance, and the hub overview for all Snapchat workflows.