The Scenario
You are a fundraising manager who just wrapped a registration campaign for a corporate charity run. You offered 25 promo codes to different corporate sponsors — each sponsor's employees got a code for a discounted registration fee.
The campaign just closed and the CFO wants a sponsor performance report by tomorrow: how many times each code was redeemed, the total discount value given, and which sponsors drove the most registrations. You have the promo codes, but the usage data is sitting in Raisely.
The slow version:
- Log into Raisely, navigate to the promo codes section
- Click the first code to see its usage count and discount details
- Write the values into the sheet
- Click the browser back button, find the second code, click in
- Repeat 24 more times
- Realize you also need to calculate total discount value (usage count × discount amount) yourself
- An hour of clicking. The CFO wants the report first thing tomorrow.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI pulls all promo code data from Raisely and builds the usage analysis sheet for you, calculations included.
Open the SheetXAI sidebar and type:
List all promo codes for my Raisely campaign 'corporate-run-2025' and import code, discount type, discount value, and usage count into this sheet. Add a 'Total Discount Given' column that multiplies usage count by discount amount. Sort by total discount descending.
SheetXAI pulls all 25 codes, writes the data, calculates the total discount column, and sorts by highest discount given. The CFO gets a ranked table without you clicking through 25 individual code pages.
What You Get
A complete promo code usage report:
- Code — the promo code string
- Discount type — percentage off, fixed amount, or free registration
- Discount value — the per-redemption discount
- Usage count — how many times each code was used
- Total Discount Given — usage count × discount amount, calculated inline
- Sorted by total descending — highest-impact codes at the top
All 25 codes in one pull. SheetXAI handles the API call so you do not have to click into each code individually.
Want to add a "Sponsor Name" column by matching codes to a sponsor list in another tab? Ask for it in the same prompt.
What If the Data Is Not Quite Ready
Promo code reports often need enrichment before they are ready for a CFO.
When you need to match codes back to sponsor company names
Your codes follow a pattern like "ACME2025," "GLOBALCORP2025," but the CFO wants the full company name, not the code string.
Import all promo codes for 'corporate-run-2025'. For each code, look up the matching company name in the 'Sponsors' tab (column A has code prefix, column B has company name). Add a 'Sponsor' column. Sort by total discount given descending.
When discount types are mixed and need normalization
Some codes are percentage discounts, some are fixed dollar amounts. The CFO wants a single dollar total for each code.
Import all promo codes for 'corporate-run-2025'. For percentage-discount codes, calculate the dollar value per redemption based on the registration fee in cell B1. For fixed-amount codes, use the stated discount value. Write normalized dollar discount per redemption to a new column, then multiply by usage count for total discount. Sort by total descending.
When unused codes should be reported separately
Some sponsors distributed codes that nobody used. The CFO wants to know which sponsors had zero redemptions.
Import all promo codes for 'corporate-run-2025'. Write codes with at least one redemption to rows 2 onward. Write codes with zero redemptions to a separate 'Unused Codes' tab, listing the code and sponsor name.
When you need the full sponsor summary including registration counts
The CFO wants total registrations per sponsor alongside the discount total, not just the promo code count.
Import all promo codes for 'corporate-run-2025'. For each code, look up sponsor name from the Sponsors tab. Sum usage count per sponsor (some sponsors have multiple codes). Calculate total discount given per sponsor. Write one row per sponsor with: sponsor name, total registrations, total discount given. Sort by total registrations descending.
The pattern: pull, enrich with the sponsor mapping, and summarize per sponsor — all in one prompt. The CFO's report is ready the same day.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull your promo code usage data from Raisely into a report sheet. The Raisely integration is included in every plan. See also how to import all donations for board reporting or the Raisely in Google Sheets overview.