"Spotify Wrapped"...but for community members

Kara

Yesterday my intern and I were brainstorming some end-of-the-year engagement ideas. One was to send out a Spotify Wrapped-style summary of a member's activity from the year. (# of discussions, comments, questions answered, badges earned, likes received, etc) in a fun, infograph-type format.

We love this idea, but imagine it would be entirely too much of a manual lift to gather this info and create a fun summary for each of our almost 4,000 members. Has anyone else done this, thought of doing this, or knows an amazing trick for how we might accomplish this?

Cheers,

Kara

Shauna

Hey @Kara I wonder if you have tech resources that could write a script and pull things in over the API? Like have a generic email template that pulls in user specific details?

My other thought here would instead of doing it per user, doing it for the community itself, like maybe spotify wrapped style shoutouts? Maybe spend some time playing with analytics and seeing if folks 'win' certain categories?

Maybe a post calling out 'Picard' wins the 'prolific author award' for most posts with 89 posts this year! 'Riker' is this year's resident expert with 56 answers -- you really liked 'DrCrusher' who got the most reactions etc etc

You could maybe do some fun tiered stuff and % of overall community and make it look pretty with a tool like Canva?

Curious to hear what the rest of the community thinks! 🤓