Write a Sponsor Fulfillment Report

Proves every sponsor deliverable was met with numbers and proof, summarizes each sponsor's leads honestly, and drafts the renewal recommendation and email.

Example prompts

Once the skill is added, start a chat with one of these and attach your file if you have one.

  • Write fulfillment reports for our 18 sponsors from this deliverables sheet and lead export.

  • Summarize the 240 leads Northwind scanned into a one-page summary they can show their CMO.

  • Draft the renewal email for Contoso with a recommended package for next year.

What this skill does

This skill turns your sponsor deliverables sheet, lead exports and event metrics into one report per sponsor. Each report has a promised vs delivered table with proof, the sponsor's own results kept apart from event-wide numbers, a clean lead summary and short attendee quotes.

It's honest about misses. Every partial or missed item gets a cause and a make-good, because sponsors notice gaps. It ends with a renewal recommendation tied to the numbers and a draft renewal email you can edit and send yourself.

When to use it

  • Sponsor recap or fulfillment report after your conference
  • A sponsor asks for ROI proof before renewing
  • Summarizing a sponsor's badge scans into something their CMO will read
  • Planning renewal offers for next year's sponsors
  • Checking which sponsor deliverables slipped during show week

How it works

  1. 1Collect inputsAsks once for the deliverables list, proof, lead exports, survey results and renewal context, or reads them from your sheet.
  2. 2Match promise to deliverySets each item to Delivered, Partial, Missed or Make-good, and flags anything marked delivered without proof.
  3. 3Separate the metricsKeeps sponsor-earned numbers apart from event-wide context so nothing is overstated.
  4. 4Summarize leadsDedupes scans into unique people, removes staff, and breaks leads down by source, seniority and company.
  5. 5Recommend and draftSuggests a package for next year based on what performed and drafts the renewal email for your review.

What you'll need

  • Sponsor deliverables sheet or contract list
  • Lead and engagement exports per sponsor
  • Event-wide metrics, proof files list and survey results
  • Next year's dates and package prices (optional)

What you get

One report per sponsor with eight sections: summary, promised vs delivered, sponsor results, event context, lead summary, attendee quotes, misses and make-goods, and a renewal recommendation. You also get a portfolio table across all sponsors, a CSV of the fulfillment table and a draft renewal email for each sponsor.

Tips

  • Collect proof during the event: a shared folder of booth photos, send reports and session check-in counts saves hours afterward.
  • Report checked-in session attendance, not registrations, for sponsored sessions.
  • Ask sponsors for 90-day pipeline from their leads so next year's report can include it.
  • Send reports within two weeks of the event, while the sponsor still remembers the show.

What's in the download

  • sponsor-fulfillment-report/SKILL.md7.9 KB
  • sponsor-fulfillment-report/assets/sample-deliverables.csv1.3 KB
  • sponsor-fulfillment-report/assets/sample-sponsor-leads.csv3.8 KB
  • sponsor-fulfillment-report/references/report-template.md2.9 KB
Read the SKILL.md
---
name: sponsor-fulfillment-report
description: Writes post-event sponsor fulfillment and ROI reports for each sponsor of an owned conference, summit or event series. Builds a promised vs delivered table with proof, separates event-wide from sponsor-specific metrics, summarizes leads and session engagement, adds attendee feedback mentions, notes misses honestly and drafts a renewal recommendation and email. Use for sponsor recaps, sponsor ROI reports, fulfillment reports, sponsor lead summaries or sponsor renewals.
license: MIT
metadata:
  author: eventmarketingsoftware.com
  version: "1.0"
  category: sponsorship
  source: https://eventmarketingsoftware.com/skills/sponsor-fulfillment-report
---

# Sponsor Fulfillment Report

Turns a sponsor deliverables sheet, lead exports and event metrics into one report per sponsor that proves what was delivered, shows what it produced, and sets up the renewal conversation. Sponsors renew on proof. A raw scan file doesn't help a sponsor justify spend to their CMO; a clear report does.

## Intake

If the user has an `event-context.md` file, read it first and don't ask for anything it already answers.

Ask for whatever is missing in ONE message:

1. Event name, dates, format (in-person, hybrid, virtual) and total registered vs attended.
2. The sponsor deliverables list: sponsor, tier, each promised item and quantity (from contracts or the prospectus).
3. What was delivered, with proof where it exists (photo file names, session recording links, email send stats, app impressions).
4. Lead or engagement exports per sponsor (badge scans, session attendees, meeting bookings, booth visits, content downloads).
5. Any attendee survey results that mention sponsors, and the sponsor survey if one ran.
6. Report audience and tone: the sponsor's event lead, or something they can forward to their CMO.
7. Renewal context: next year's dates, whether pricing changes, any early-renewal offer.

Work with partial data. Mark anything missing as "Not provided" instead of guessing.

## Data sources (connectors optional)

- If a Google Sheets connector is available, read the deliverables sheet and exports from it and offer to write the fulfillment table back to a new tab.
- If a Slack connector is available, you may draft an internal summary for the sponsorship channel.
- Otherwise, work from pasted tables, uploaded CSV or XLSX files, or plain text, and return Markdown plus a downloadable CSV of the fulfillment table.
- Never require a paid service. Never fetch URLs.

Sample inputs: [assets/sample-deliverables.csv](assets/sample-deliverables.csv) and [assets/sample-sponsor-leads.csv](assets/sample-sponsor-leads.csv).

## Method

1. **Normalize the deliverables.** One row per sponsor per promised item. Standardize item names (e.g. "logo on lanyard", "Lanyard logo" become "Lanyard branding"). Keep the contract wording in a notes column if it differs.
2. **Match delivery to promise.** For each row set status:
   - `Delivered` (met or exceeded, proof exists)
   - `Delivered, no proof` (team says yes, nothing to show; ask for proof before sending)
   - `Partial` (delivered less than promised, e.g. 2 of 3 social posts)
   - `Missed` (not delivered)
   - `Make-good` (missed but replaced with something agreed)
   Never mark `Delivered` without a quantity or proof reference.
3. **Split metrics into two groups.** Event-wide metrics (total attendees, sessions, app users, total email reach) are context. Sponsor-specific metrics (their scans, their session attendance, their meetings, clicks on their links, their logo impressions if tracked) are the proof. Never present an event-wide number as if the sponsor earned it.
4. **Summarize leads.** From the sponsor's lead export: total unique leads (dedupe on email, then name plus company), split by source (booth scan, session scan, meeting, content download), top companies, seniority mix (C-level, VP, Director, Manager, Individual contributor, Unknown) and job function, and how many match the sponsor's stated target if they gave one. Don't score or tier leads for the sponsor unless they asked; that's their job. Exclude your own staff and other sponsors' staff and say how many you removed.
5. **Pull feedback mentions.** Quote short attendee comments that mention the sponsor, their session or their activation (max 3, anonymized). Include sponsor survey scores if available.
6. **Be honest about misses.** List every `Partial` or `Missed` item with a one-line cause and the make-good offered or proposed. A report that hides a miss loses the renewal when the sponsor notices.
7. **Recommend the renewal.** Based on what performed: keep, upgrade, swap items, or downgrade. Tie each recommendation to a number in the report. Suggest one specific package and why. Don't invent next year's prices; use the user's prices or leave a placeholder.
8. **Draft the renewal email** (draft only) that links the report, names the two strongest results, acknowledges any miss, and proposes a call.

Domain rules that matter:
- Lead counts are unique people, not raw scans. Report raw scans separately if the sponsor cares about traffic.
- Session attendance for a sponsored session should be checked-in attendees, not registrations. Say which one you have.
- Don't share attendee personal data with a sponsor unless the attendee consented to sharing (typically a checkbox at registration or the act of scanning a badge at their booth, depending on your privacy notice). If consent status is missing, give aggregates only and flag it.
- Pipeline and revenue belong to the sponsor's CRM. You can report leads and meetings; you can't claim sourced or influenced pipeline for them. Offer a follow-up field: "Ask the sponsor for 90-day pipeline from these leads."

## Output templates

Full headings and a worked example: [references/report-template.md](references/report-template.md).

Per sponsor report headings:
1. Summary (3 bullets: biggest result, delivery rate, renewal suggestion)
2. Deliverables: promised vs delivered
3. Your results (sponsor-specific metrics)
4. Event context (event-wide metrics, labeled as such)
5. Lead summary
6. What attendees said
7. What we missed and how we made it right
8. Recommendation for next year

Deliverables table columns:

| Deliverable | Promised | Delivered | Status | Proof | Notes |
|---|---|---|---|---|---|

Lead summary table columns:

| Source | Raw scans | Unique leads | Director and above | Matches your target | Top companies |
|---|---|---|---|---|---|

Portfolio view (when there are several sponsors):

| Sponsor | Tier | Items promised | Delivered | Partial | Missed | Unique leads | Renewal suggestion | Proof gaps |
|---|---|---|---|---|---|---|---|---|

## Validation checklist

Copy and run before you hand over the reports:

- [ ] Every promised item from the input appears in exactly one row; count of items in equals items out.
- [ ] No `Delivered` status without a quantity or proof reference.
- [ ] Event-wide and sponsor-specific metrics are in separate sections.
- [ ] Lead counts are unique people; staff and other sponsors removed, with counts stated.
- [ ] Every miss has a cause and a make-good line.
- [ ] No personal data in the report unless consent to share is confirmed.
- [ ] Renewal suggestion cites at least one number from the report.
- [ ] House style: plain words, no hype, no superlatives you can't prove.

## Approval gates

- Show each report and the renewal email as drafts. Never send email, post to Slack or write to a sheet or CRM without showing a preview and getting a clear yes.
- If any row is `Delivered, no proof`, list those rows first and ask the user to confirm or supply proof before finalizing.

## Privacy

- Keep lead files inside the user's own tools. Give sponsors only the fields your privacy notice allows.
- Flag EU and UK attendees in lead files. Under GDPR and the UK GDPR, sharing them with a sponsor needs a lawful basis your notice covers. If unsure, share aggregates and let the sponsor follow up through the opt-in route.
- Anonymize survey quotes.

FAQ

What should a sponsor fulfillment report include?
A promised vs delivered table with proof for every item, the sponsor's own results such as scans, session check-ins and meetings, event-wide context kept separate, a lead summary by source and seniority, a few attendee quotes, an honest list of misses with make-goods, and a renewal recommendation tied to the numbers.
Can I share attendee contact details with sponsors?
Only when your privacy notice and the attendee's consent allow it, for example a badge scan at the sponsor's booth or an opt-in checkbox at registration. If consent status is missing, the skill gives the sponsor aggregates only and flags the rows. EU and UK attendees are flagged so you can check your lawful basis first.
Should I include misses in a sponsor report?
Yes. Sponsors usually notice a missing social post or a cancelled dinner, and hiding it costs trust at renewal time. The skill lists each partial or missed item with a short cause and the make-good you offered, which shows you're accountable and makes the renewal conversation easier.
Can this skill calculate pipeline for my sponsors?
No. Pipeline lives in the sponsor's CRM, so the report sticks to leads, meetings and engagement you can verify. It adds a line asking the sponsor to share 90-day pipeline from the leads, so you can measure results together next year.