Year-in-review email: how to send a personalized 'Wrapped'-style recap

What is a year-in-review email?

A year-in-review email is a December message that turns a customer's own data from the past 12 months into a short story: what they bought, used, read, booked or achieved with you, plus a thank-you and one next step. The best-known example is Spotify Wrapped, but any business that records purchases, visits or usage can send a personalized "Wrapped"-style recap with a standard email tool, custom contact fields and a few segments.

This guide shows what the well-known recaps do, which data to use for your type of business, how to build the email with merge fields and segments, how to adapt it for B2B, and when to send it in December 2026.

Key takeaways

• A year-in-review email works because it is about the reader, not about you: lead with one "hero number" from their year, then 2 to 4 supporting stats.
• You don't need an app to do it. Export the data, calculate one row per contact, import it into custom fields and insert those fields into your template.
• Split your list into activity tiers so light or inactive contacts get a different version instead of an awkward "you ordered once".
• B2B companies can send two kinds: an account recap per client and a company recap of milestones and next year's plans.
• Send in the first half of December, ideally between Tuesday 1 and Thursday 10 December 2026, before Christmas promotions take over the inbox.

What do the best year-in-review emails have in common?

The year-in-review emails people remember share three traits: they use data only the brand has, they turn it into a ranking or a single striking number, and they make the result easy to share. Here is how the best-known consumer recaps work, described in our own words so you can borrow the mechanics rather than the look.

What these brands do not do is just as useful: they rarely lead with their own company news, they keep the email short and they ask for one action only. Spotify's recap usually lands around the turn of November and December, which is a useful benchmark for timing too.

Which data should you use in a year-in-review email?

Use 3 to 5 stats the customer will recognise and feel good about, chosen from data you already store. Pick one "hero number" for the top of the email (the biggest or most surprising figure) and support it with a ranking, a "first" or "favourite", and a forward-looking element.

Two rules keep the data honest. First, fix a cut-off date (for example 1 January to 30 November 2026) and say so in small print, so nobody wonders why their mid-December order is missing. Second, only use data the customer would expect you to have. If you lack data on preferences, a short survey in the autumn is the cleanest source; our guide to zero-party data in email marketing explains how to collect it.

How do you build a personalized year-in-review email with merge fields and segments?

You build a personalized recap by calculating each contact's stats outside your email tool, importing them as custom contact fields, and inserting those fields into one template as merge fields. Segments then decide who receives which version. The process takes a few hours, not a development sprint.

1. Export the raw data. Pull orders, bookings or usage logs for the year from your shop, booking system or CRM, with the customer's email address on every row.
2. Calculate one row per contact. In a spreadsheet, use a pivot table (or COUNTIFS, SUMIFS and MAXIFS) to produce totals, a favourite and a "first" for each email address.
3. Create custom fields. In your email tool, add a field per stat, for example orders_2026, top_category, first_order_month, points_2026 and activity_tier. In Mailpro, these are personalized contact fields.
4. Import the file. Import the CSV or XLSX and match it on the email address so the values update existing contacts rather than creating duplicates.
5. Build the segments. Create one segment per activity tier (see the next section) with your tool's email segmentation criteria, such as orders_2026 greater than 2.
6. Design one template. Hero number at the top, three stat tiles, a short thank-you, one call to action. Keep every number in live text, not baked into images, so it shows even when images are blocked.
7. Insert the merge fields. Place each field where the number should appear. If merge tags are new to you, they are placeholders the tool replaces with each contact's value at send time.
8. Test with extreme contacts. Send tests to fake contacts with a very high value, a value of 1, an empty field, a long name and accented characters. Check singular and plural ("1 orders" is the classic bug).

Mailpro is priced by sends, not contacts, so adding custom fields and segmenting your whole list for a December recap does not raise your bill. See Mailpro pricing

Example: the import file for a shop

How do you handle contacts with little or no activity?

Send a different version to each activity tier, because a recap that says "you ordered once" or "0 visits" reminds people of a relationship that barely exists. Three tiers cover most lists.

For long-term customers, the recap pairs naturally with anniversary messages. If you already send loyalty milestones during the year, our article on milestone emailing for loyal customers covers that side; the year-in-review email is the one annual summary on top of it.

What should a B2B or company year-in-review email include?

A B2B year-in-review email should show each client the value they got from working with you, or, for a company-wide recap, the milestones that matter to clients, not to your internal team. B2B companies can send two different emails.

1. The account recap (personalized per client)

Accountants, agencies, IT providers, logistics firms and software vendors all hold per-client data: projects delivered, tickets resolved and average response time, documents processed, shipments sent, hours saved. Built with the same field-and-import method, the account recap is a soft renewal argument sent before budgets are set for next year. Address it to the contact who owns the relationship and keep the tone factual.

2. The company recap (one version for everyone)

A company year in review works when it is short and client-centred. A reliable structure:

• One sentence of thanks, signed by a named person (the founder or managing director).
• Three to five milestones, each tied to a client benefit: "We opened a support line in Spanish, so answers now come in your language."
• One number about clients rather than revenue: projects delivered, clients served, satisfaction score with its source.
• What's coming next year, in two or three lines.
• One call to action: book the annual review meeting, read the full report, or answer a two-question survey.

The company recap is also a good moment to share your own plan for the year ahead. If you are still writing it, our quarter-by-quarter email marketing plan is a template you can roll forward to 2027.

When should you send a year-in-review email?

Send your year-in-review email in the first half of December: late enough that the year feels complete, early enough to arrive before Christmas promotions and the holiday break. For 2026, the sweet spot is Tuesday 1 to Thursday 10 December.

Keep the recap separate from your heaviest promotional send by at least a day or two. The recap builds goodwill; a hard sales push on the same day undermines it.

What subject lines work for a year-in-review email?

Subject lines that name the reader and promise their own numbers work best, because the curiosity is personal. Some patterns to adapt:

• "Laura, your 2026 in numbers"
• "Your year with [brand]: 7 orders and one clear favourite"
• "We added it up. Here's your 2026"
• "2026, wrapped up: thank you for being part of it"
• B2B: "Your account in 2026: 42 projects delivered"
• Company recap: "Our year in review, and what's changing for you in 2027"

Use the preheader for the hero number or the reward ("plus 340 points waiting for you"). Avoid putting sensitive figures, such as amounts spent or balances, in the subject line, as it appears on lock screens. More personalization ideas are in our email personalization tips.

What mistakes should you avoid?

• Stats in images only. Many email clients block images by default; the hero number must be live text.
• Wrong or empty values. Test empty fields and singular/plural, and set a default value for each field.
• Creepy or sensitive data. Health, money and family details stay out. Under the GDPR, only use data collected for a purpose the customer would expect.
• Company bragging. Revenue growth and internal awards interest you, not your customers.
• Too many calls to action. One main button, at most one secondary link.
• Forgetting the data trail. Delete your exported spreadsheets after the import and keep personal data on a GDPR-compliant platform; Mailpro is hosted in Switzerland and never sells or rents your data.

Frequently asked questions

Can I send a Spotify Wrapped-style email without a developer?

Yes. A year-in-review email only needs a spreadsheet to calculate each contact's stats, custom contact fields to store them, and merge fields in a standard drag-and-drop template. Animated, app-style stories need developers; a personalized email does not.

How many stats should a year-in-review email include?

Three to five. One hero number at the top, two to four supporting stats, then a thank-you and one call to action. More than that turns a story into a report.

What if I don't have personal data for every contact?

Send a brand-level recap to contacts without data: your community's year in numbers, best-sellers and favourite content. Use segments so only contacts with real activity receive the personalized version.

Is it too late to send a year-in-review email in January?

Not entirely. A recap sent in the first full week of January still works if you frame it as "your year, and what's next", but it competes with resolutions and sales. December gets more attention.

Is a year-in-review email a newsletter or a campaign?

It is a one-off campaign, sent once a year, usually to the whole list split into segments. It replaces your regular December newsletter rather than adding to it.