How to Track Every Concert You Go To (Without Forgetting Half of Them)
I went to 23 concerts last year. I know this because I counted them in January while trying to remember the name of that opener who was surprisingly good at a Tuesday night show in October. I couldn't remember the opener. I couldn't remember the venue either. I just knew it happened.
That's when I started logging concerts. Not because I'm organized, but because I got tired of losing the details.
Concert memories fade fast
You'd think a live show would be hard to forget. But after a few months, the details blur together. Which venue was it? How much did you pay? Who opened? Who did you go with?
I tried scrolling through old ticket confirmation emails. Some were in my spam folder. Some had been auto-deleted. A few were from resale sites that only showed the order number, not the artist.
Social media posts helped a little, but I didn't post about every show. And the ones I did post about were usually just a blurry photo with no useful information attached.
What I actually track
I keep it simple. After every show, I log a row with:
- Event name and headliner – sometimes these are different (festival vs. single artist)
- Venue and city – I travel for shows sometimes and forget which city had which venue
- Date and ticket price – including fees, because those are real money
- Genre and type – concert, festival, club show, arena, etc.
- Who I went with – this one surprises people but it's my favorite column to look back on
- Rating – gut feeling, 1 to 5 stars, logged the same night
The whole thing takes about 90 seconds. I usually do it on the drive home or while waiting for the parking lot to clear out.
The spending part is eye-opening
I had no idea how much I was spending on concerts until I added it up. Tickets, sure. But also parking, drinks, merch. Even if you only track ticket prices, the total is usually bigger than you'd guess.
Last year I spent over $1,400 on tickets alone. That's not counting the two festivals. Seeing that number didn't make me stop going to concerts – but it did make me think twice about the $85 nosebleed seats I was impulse-buying on a Tuesday afternoon.
I set a concert budget for the first time this year. Not to limit myself, but to make the spending intentional instead of invisible.
Patterns you don't expect
After tracking for a year, the data starts telling you things. Some of mine:
- I go to way more shows in September and October than any other months. Summer is actually my slowest season.
- My average rating for arena shows is 3.1 stars. For small venues, it's 4.4. I keep buying arena tickets anyway.
- I've been to the same venue 9 times – more than any other. I had no idea until I looked at the chart.
- One friend shows up in my "companions" column 14 times. Another friend I thought I went to lots of shows with? Twice.
None of that is useful in a life-changing way. But it's interesting. And the spending data is genuinely useful for budgeting.
Festivals are their own thing
Multi-day festivals are tricky. You could log every set you saw as a separate row, but that gets messy fast. I log the festival as one entry with the headliner I was most excited about, the total ticket cost and notes about the standout sets.
Some people prefer one row per day. Either works – just pick one approach and stick with it so your counts stay meaningful.
Why a spreadsheet and not an app
There are concert tracking apps. I've tried a few. The problem is they're either social networks pretending to be trackers (you don't need followers for your concert log) or they're built around setlists, which is a different hobby.
A spreadsheet gives you the columns you want, charts that update automatically and no one else's data mixed in. Your concert history is yours – it sits in your Google Drive, not on someone else's server that might shut down in two years.
Tips for getting started
Start from now, not from memory
Don't try to reconstruct 10 years of concerts from memory. You'll get frustrated and quit. Start with the next show you go to. Add old ones later if you feel like it – ticket email searches can help fill in gaps.
Log it the same night
The rating is the most time-sensitive part. Your gut reaction to a show changes after a few days. The venue, date and price you can look up later. The "was it actually good?" feeling fades fast.
Track the opener
This is optional but it's saved me a few times. "Who was that opener who played the song with the weird synth intro?" is a question I can now answer by scrolling through my notes column.
Start logging your concert history
ConcertFlux is a Google Sheets tracker with spending analytics, venue stats, genre breakdown and monthly charts. 20 sample concerts included so you can see everything before adding your own.
More articles
- How I Track Everything I Watch, Read, and Play in Google Sheets
- Google Sheets vs Notion for Tracking Hobbies
- Why I Stopped Using Vivino and Started Tracking Wine in a Spreadsheet
- The Board Gamer's Guide to Tracking Cost Per Play
- How to Build a Year-in-Review Dashboard for Your Hobbies
- How to Track Every Concert You Go To
- How I Track My Online Courses in Google Sheets
- Why I Track Every Album I Listen To
- How I Finally Got My Gaming Backlog Under Control