The Scenario
You are a marketing analyst at a real estate brokerage. The director wants a campaign performance report covering the last 30 days: opens, clicks, and unsubscribes per campaign, with open rate and click-through rate calculated. The data lives in Follow Up Boss as email marketing events.
The report is due Monday morning at 9 AM.
The slow version:
- You log into Follow Up Boss, navigate to Email Marketing, open each campaign one by one
- You screenshot or manually copy the open and click counts for each
- You open Google Sheets and type them in
- You calculate open rate by hand using DIVIDE formulas
- You realize you forgot unsubscribes and have to go back to Follow Up Boss
- Monday 8:45 AM: you have seven of twelve campaigns entered and your formulas have a circular reference
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI pulls the Follow Up Boss email marketing events directly into the sheet and can calculate rates in the same prompt.
Open the SheetXAI sidebar and type:
Fetch all Follow Up Boss email marketing events from the last 30 days. Write event type, campaign name, contact email, and timestamp into this sheet starting at row 2. After writing all rows, add a summary table below the data showing total sends, opens, clicks, and unsubscribes per campaign, and calculate open rate and CTR for each campaign.
SheetXAI queries Follow Up Boss, writes the event rows, and builds the summary table with rates calculated. Your report is done before you finish your morning coffee.
What You Get
A full email engagement export with performance summary:
- All events from the last 30 days — event type, campaign name, contact email, timestamp
- Summary table per campaign — sends, opens, clicks, unsubscribes, open rate, CTR
The rates are calculated from the actual event counts, not from a formula template you maintain. If you re-run the prompt next month, the new data and new rates replace the old ones automatically.
What If the Data Is Not Quite Ready
Thirty days of email events from a high-volume team is a lot of data, and not all of it belongs in the same report. SheetXAI can filter and condition the export inline.
When you only want events from specific campaigns
The director only cares about the four buyer drip campaigns, not the full campaign catalog.
Fetch Follow Up Boss email marketing events from the last 30 days for campaigns whose names contain "Buyer". Write event type, campaign name, contact email, and timestamp into this sheet. Add a summary table showing sends, opens, clicks, and unsubscribes per matching campaign with open rate and CTR.
When you need to exclude internal test sends
Your team sends test emails to internal addresses before launching a campaign. Those should not count toward the open or click rates.
Fetch all Follow Up Boss email marketing events from the last 30 days. Exclude any row where the contact email ends in your company domain (@yourdomain.com). Write the filtered events into this sheet. Add a summary table with sends, opens, clicks, unsubscribes, open rate, and CTR per campaign.
When the director wants events grouped by week instead of total
She wants to see whether open rates improved or dropped week over week.
Fetch all Follow Up Boss email marketing events from the last 30 days. Group the data by campaign and by week. For each campaign-week combination, count opens, clicks, and unsubscribes. Write the weekly breakdown into this sheet and add a column for week-over-week open rate change.
When you need event-level data plus contact details for follow-up
The sales team wants a list of everyone who clicked but did not reply, with their name and phone number, so they can do outbound follow-up.
Fetch all Follow Up Boss email marketing click events from the last 30 days. For each contact who clicked, look up their first name, last name, and phone number from their Follow Up Boss person record. Write event type, campaign name, contact email, first name, last name, and phone into this sheet. Exclude contacts who have had any subsequent inbound activity in the last 30 days.
The pattern: fetch, filter, and summarize in one prompt instead of pulling data from multiple Follow Up Boss screens and manually calculating rates in a separate step.
Try It
Get the 7-day free trial of SheetXAI and open any sheet, then ask it to pull your Follow Up Boss email event data. The Follow Up Boss integration is included in every SheetXAI plan. For related workflows, see how to create email campaigns from a sheet or the Follow Up Boss in Google Sheets overview.