How to make a year in review for your customers
Pick four to six numbers you already have for each customer, put them in a spreadsheet with one row per person, turn each number into a short slide, and send everyone a link to their own. Here is each step, and what to watch for.
What you're making
A year in review is a short story about one person's year with you, told in a handful of full-screen slides they tap through on a phone: a cover with their name, one number per slide, something to be proud of, and a card to share at the end. The big music and fitness apps send their users one every December. The format works for any business that knows what each customer did.
Three things make it a year in review and not a report. It's about one person. It's short: a minute, not a dashboard. And it ends with something worth posting.
Step 1: Pick the period, and who gets one
Decide what the story covers (the calendar year, a season, a school year) and who is on the list. Not every customer has to be: someone who came once in February gets a thin story. A common cut is anyone active in at least three months, or with at least five visits or orders.
Check that you may write to them. If you already email these customers, a year in review from the same address fits what they signed up for. Leave out anyone who has unsubscribed.
Step 2: Choose four to six numbers
Open with the number that says "you showed up". Follow it with one that shows how committed they were. Then something that's a word, not a number: a favorite. Then, for the people who earned it, a rank. End on a note from you.
| Slide | The question it answers | Examples |
|---|---|---|
| The big count | How much did I do? | 86 days at the gym · 47 issues opened · 14 orders |
| The streak or total | How committed was I? | 41 days in a row · 1,180 habits checked off |
| The favorite | What am I like? | Your usual: cardamom bun · Go-to class: yoga |
| The rank | How do I compare? | Top 5% of members, shown only to the top quarter |
| The moment | What will I remember? | Your first pull-up · Swimming across the lake |
| The note | Who is saying this? | One line from the founder, or from their coach |
Every number has to pass one test: would this person be glad to see it? For ideas by kind of business, see year in review ideas.
Step 3: Get one row per customer
Export from wherever the numbers live (your booking system, your shop, your email tool, your database) and shape it into one spreadsheet: a row per customer, a column per number, and a first name. Add an email or a phone column if that's how you'll send it.
Clean it before you design anything. Look at the biggest and the smallest value in each column. Fix the names typed in capitals. And decide what happens when a cell is empty: that slide should be skipped for that person, never shown as a zero.
Step 4: Write each slide in one line
One slide, one number, one short sentence around it. "You showed up on 212 days." "Your usual: cardamom bun." Write it the way you'd say it across the counter.
- Keep the exact number. 212 feels like theirs; "over 200" feels like a mailing.
- Put the unit in the sentence ("212 days"), not in a label above it.
- Say "you", not "our members".
- Use their first name on the cover and once at the end, not on every slide.
- Skip anything that needs explaining. If a number needs a footnote, it's the wrong number.
Step 5: Make it look like you
Full screen, upright like a phone, one idea per slide, your logo and color, a few seconds each, a tap to move on. Numbers that count up feel earned. If you build this yourself it's the expensive step: a designer for the slides, and a developer for the page that fills them in for each person and makes the image people share.
This is the part Highreel does for you. Upload the sheet, pick one of ten designs, add your logo, rewrite any line, and click any customer to watch their story change as you type.
Step 6: Send everyone their own
Each customer needs their own link, and it should come from you. The usual routes: an email from your own address with one button, your newsletter tool with the link as a personal field, WhatsApp for a small list, or one link or QR code where people type their email and get theirs back.
A subject line that works names the person and the thing: "Ana, your 2026 with us is here". There's more in the year-in-review email, and on timing in when to send it.
Step 7: See what happened, and use it
Three numbers tell you whether it worked: how many people opened theirs, how many reached the last slide, and how many saved or shared it. The fourth is your own: what the button on the last slide brought in, whether that's renewals, bookings or referrals.
Note which slide people saved most. That's the first one to keep next year.
Three ways to build it
| Way | Good for | What it takes |
|---|---|---|
| Build it yourself | A product team that wants it inside its own app | A designer, a developer, hosting and a sending setup; weeks of work |
| An email with merge tags | A quick thank-you with two or three numbers | Your email tool. No story to tap through and nothing to share |
| Highreel | Any business with a spreadsheet | No designer or developer; from $99 for the whole campaign |
The longer version, with video platforms, in-app tools and design tools: seven ways to make one, compared.
Questions
Do I need a developer to make a year in review for my customers?
Not if a tool builds the pages for you. With Highreel you upload a spreadsheet and edit the words: there's nothing to code or host.
How many customers do I need for it to be worth doing?
A few dozen is enough. A studio with 80 members gets as much out of it as an app with 80,000, because what matters is that each person's numbers are real. Highreel's smallest size covers up to 1,000 people.
Is it okay to use my customers' data this way?
You're showing each customer their own activity with you, which they already expect you to have. Keep it to what they'd be glad to see, send it the way you already write to them, and let them opt out. A Highreel is a private link that shows a first name and that person's numbers, never an email address or a phone number.
Does it have to cover a calendar year?
No. A summer camp sends it on the last day, a school at the end of term and a club at the end of its season. Anything with a clear end works.