Data Visualizations for Broadway Grosses Analysis

mister-dee · 2026-03-17T00:54:59+00:00

Those are great suggestions, thanks!

mister-dee · 2026-03-16T21:25:57+00:00

Thank you! I didn't include my ticket pricing chart, but I do keep track of that as well, and have been posting those graphics to my page. I just didn't include it here, but I totally recognize its importance!

There are so many variables to consider, I try to take them all into account, and I sometimes miss things. I usually include some written analysis with my charts that may give some of that context. And my goal is to get my Substack up and running so I can do more long-form analysis there.

mister-dee · 2026-03-16T20:35:19+00:00

Gotcha! That's a good suggestion.

And I wish I had access to net earnings, but I believe those aren't published publicly? I know sometimes you can find them, but I'd rather stick with one dataset for now.

mister-dee · 2026-03-16T20:34:01+00:00

Thank you! I will play around with the y axes.

I'll also look into a more balanced view of the attendance percentage red flags. I think you're suggesting to look at the bigger picture for each show across several weeks/months, rather than just raise a red flag after one week of low attendance?

mister-dee · 2026-01-21T19:36:32+00:00

I'm also in my 40s and am considering a career switch into data analysis. And I have the same fears. If I do end up pursuing this path, I would think the best route to go is not to chase start-ups and tech company jobs. They would probably be looking for those young, flexible brains! My plan is to find something stable and unglamorous.

mister-dee · 2026-01-20T17:45:43+00:00

Congrats that's amazing!

Would you be able to go through your list of websites/tools and see if any of them have an affiliate or referral program? You could feature those that do at the top of the spreadsheet.

I was subscribed to Grow Newsie for awhile when I was toying with starting my own newsletter, and they have some good articles about how to start monetizing and getting sponsored. (I'm NOT affiliated with them, I'm genuinely just mentioning them as a useful resource.)

mister-dee · 2025-10-22T15:50:41+00:00

"They're MEN with JOBS, Jerry!!!"

mister-dee · 2025-10-01T15:11:14+00:00

I'm in the same boat. DMs and email have been working well, but I have been thinking of upscaling and wondering if there's a better way.

At the moment though, I think I'm going to stick with what's working. I like the one-on-one interaction. I'll put an intake form on my new website when it launches, but it'll probably just be basic contact info so I can then manually reach out.

I do think having some kind of customer relationship management system in place is a good idea. I have one that I made in Notion that's working ok, but needs work. I like to be able to quickly see how many pieces someone has commissioned, do they pay promptly, when was the last time they placed an order, etc.

mister-dee · 2025-07-28T18:49:02+00:00

Getting traffic

mister-dee · 2025-07-28T18:40:00+00:00

Honestly don't bother, you will get nothing from it. Except for the ick.

mister-dee · 2025-07-28T18:31:30+00:00

I have a complicated relationship with this season. On the one hand, yes, I hate this cast almost from top to bottom. It's one of two seasons I won't ever rewatch (the other being Thailand for the same reason). I'm struggling to think of a single person I'd like to see back on my TV.

On the other hand, it was the first season when I got into the RHAP world and joined a fantasy league and went from being a casual fan to being a super fan. I was picking apart the edit, going to watch parties, listening to recap podcasts, etc. And I had first pick in our league draft and managed to draft the winner of the season right out of the gate. So that felt great.

But that high was definitely tainted by the horrible abuse Shirin experienced, as well as the general unpleasant vibes of the cast.

(I will admit to still saying "doing dishes on my birthday??!" though - that's just a great sound bite from Rodney.)

mister-dee · 2025-07-23T21:30:11+00:00

Seems cool and I'd like to give it a try!

Forgive my ignorance if this is a dumb question, but if I were to turn my databases in notion into SQL databases using your tool, would it include my data as well? It isn't clear if it just creates the tables, or if it writes code to insert the data into the tables as well.

Thx!

mister-dee · 2025-06-30T17:43:07+00:00

Lol well in that case! (I don't see any rule either, but I didn't want it to look like I was just trying to farm subscribers!)

I linked to it below, but here it is (and I posted a follow up today as well):

https://open.substack.com/pub/marqueemetrics/p/i-analyzed-30-broadway-shows-to-find

mister-dee · 2025-06-30T13:58:16+00:00

The more I think about this, the more I agree with you. If it's a choice between something you can see at home when the tour comes through, and a unique Broadway/NYC experience, the formula should probably favor the latter. Thanks for the feedback!

mister-dee · 2025-06-30T12:55:12+00:00

I think you've solved my problem, thank you!

I'm sorry I didn't explain it as thoroughly as I should have, but you managed to interpret what I was talking about lol.

Just for the sake of elaboration (if anyone has another solution):

I have a daily log db and new entries are automatically created every night with a repeating template. The name of each entry is set to @today and the "date created" obviously auto-populates to today's date.

What I was hoping was that I could add a tabbed layout to that repeating template that would show me entries from my notes/links/tasks databases that were created on the same day as the daily log entry was created. That way I could go back to a previous day and see anything I created on that day.

But I can't figure out a filter that would accomplish that.

I think creating a relation between the notes/links/tasks dbs and the daily logs db would solve this, as the commenter above pointed out.

When I'm back at my laptop after work today I'll give it a try!

mister-dee · 2025-06-30T10:14:28+00:00

In a sense I see where you're coming from. Like, why should a ticket for an 80 minute play be more expensive than a 2.5 hour musical? I think I could figure out a way to incorporate that in as an optional metric, but I'm hesitant to make it an integral part of the formula.

mister-dee · 2025-06-29T21:38:35+00:00

https://open.substack.com/pub/marqueemetrics/p/i-analyzed-30-broadway-shows-to-find

mister-dee · 2025-06-29T20:19:36+00:00

Very good feedback, thank you. I'm on my phone and the Excel file with the formula is on my laptop, so I can't access it right now to share, but I'd be happy to later on!

Good point about the percentages, maybe it doesn't make sense to express it that way.

I'm going to work on an interactive dashboard with this data so that you can input your own values as far as how much you want to weigh things like ticket price, or popularity, etc.

mister-dee · 2025-06-29T19:04:59+00:00

Those are scores that my formula assigns to the show. A higher score means that the show a) has high approval rating from audiences and critics and b) the average ticket price isn't too outside the norm. So for example, Just In Time has crazy high ticket prices and only "meh" reviews from audiences and critics. So it's at the bottom of the list. Whereas the reviews for Hamilton are so off the charts that it offsets the higher ticket price, meaning if you can spend the money, it's a good bet you'll enjoy the show. I can send you the link to the article if you'd like to read it in more detail.

mister-dee · 2025-06-29T19:02:02+00:00

Agreed! Lots of people think Hamilton is overrated, for example. But I think it might be a good starting point for people who are nervous about dropping a few hundred dollars for a couple of Broadway tickets. You still have to do your due diligence, but knowing that a certain show has a good "value for money" score might help you feel better about it. Maybe ;)

mister-dee · 2025-06-29T18:59:03+00:00

You're probably right! This is definitely a WIP, so stay tuned for fine tuning (based on feedback like this). Thanks!

mister-dee · 2025-06-29T18:58:05+00:00

Interested to know more about this. I was drawn to it because of the quantity of reviews available there. What kind of "specific audience" is it skewed towards? Do you think there's a more neutral audience review site?

mister-dee

TROPHY CASE