The Scenario
Your CMO asked for a campaign performance overview — every email and SMS campaign Remarkety has sent, the type, the status, and when it went out — and they want it in an Excel workbook so they can sort and filter it themselves. You have 40 campaigns in the account. Remarkety's UI lets you see them one at a time.
You've been in this meeting before. You know what happens when you show up with a screenshot instead of a spreadsheet.
The bad version:
- Open the Remarkety campaigns list. Click into the first campaign. Note the name, type, status, and date. Go back. Click into the next one.
- After 20 campaigns, realize you missed the creation date format on the first ten and have to go back through them.
- Get to campaign 35 and discover Remarkety's list view is paginated and you have to load the next page manually.
You have a quarterly review in 90 minutes and you're hand-copying data from a web UI.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the workbook, pulls from Remarkety, and writes structured data wherever you point it — no manual clicking through a list view.
Fetch all Remarkety campaigns and write campaign name, type, status, and creation date into columns A through D. Use YYYY-MM-DD format for dates. Put headers on row 1.
What You Get
- Every campaign in the account written into the workbook with headers — all pages, not just the first 20.
- Campaign name, type (email, SMS, social), status (active, paused, draft), and creation date in columns A through D.
- Dates in YYYY-MM-DD format so filtering by date range works without formula gymnastics.
- Headers on row 1 so the CMO can sort and filter immediately.
What If the Data Is Not Quite Ready
You only want active campaigns, not drafts or paused ones
Fetch all Remarkety campaigns where status is "active". Write campaign name, type, and creation date into columns A through C. Sort by creation date descending so the newest campaigns appear first.
You need the campaign ID included for a lookup the analytics team is building
Fetch all Remarkety campaigns and write campaign ID, name, type, status, and creation date into columns A through E. Sort by campaign ID ascending.
The workbook already has campaign names from last quarter and you need to add the new ones only
The workbook has campaign names in column A from a previous export. Fetch all current Remarkety campaigns and add any campaigns not already in column A to the bottom of the list. Write name, type, and status for new rows in columns A through C.
Full performance summary with status counts
Fetch all Remarkety campaigns. Write every campaign — name, type, status, creation date — into columns A through D. Then in a summary block starting at column F, show a count of how many campaigns are active, how many are paused, and how many are drafts.
One prompt pulls the raw data and builds the summary the CMO actually wants to see.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook, then ask it to pull your full Remarkety campaign list into a format your team can work with. Also see: Export Remarkety Customer Data for RFM Analysis and the Remarkety overview.