1
0 Comments

Created sponsorship sheet, sold out in 2 hours.

Today I created a Sponsorship Sheet for Alternative Assets.

The problem I'm trying to solve is that the newsletter is increasingly valuable each week. So assigning fixed sponsorship rates doesn't make sense right now.

My sheet pulls in real-time pricing, based on an audience & CPM formula I created. I also tried to give it a nice look & feel - I think a little can go a long way with something like this.

https://docs.google.com/spreadsheets/d/1yaxGNoMq4sHuS26lMJHPqT1j1tWduVjmpa-pL3Ezp54/edit?usp=sharing

Sponsorship Sheet

----
Pricing Formula

  • First I took the subscribers and multiplied by $0.03 cents per subscriber. This is standard, perhaps on the low end for smaller newsletters.

  • Second, I took the number of opens, and multiplied it by $0.067 per open. Opens are fundamentally more valuable than subscribers, and since my open rate is on the higher side.

  • Third, I took the number of impressions, and multiplied it by $0.10 cents. Because of my website, impressions are higher than inbox views.

  • To predict the future of subscribers (in light gray) I calculated my weekly growth rate at just under 10% per week. I used my average open rates over the past 6 weeks as the benchmark.

  • Predicting the impressions was trickier. I created a metric called the impressions to subscribers ratio, which I calculated at 2.1.

  • Finally, to calculate my rack rates, I simply took the average of the three prices.

Sponsorship Calculation

2 hours after posting, a sponsor I had been previously speaking with went ahead and bought up all of my remaining inventory for slot #1

Interested in booking a slot? Let me know!

Trending on Indie Hackers
I was a lawyer, taught myself to code, bootstrapped Wavve to $150,000 MRR, and we just sold it. AMA! 39 comments Work from home jobs: How to find remote work while building your business in 2021 17 comments The Notion API will go live as a public beta on May 13th 12 comments Two Founders, Honest Talk | Bootstrap vs VC Funding 8 comments What do you think of my landing page 5 comments Getting over my fear by launching a Covid-19 vaccination tracker 4 comments