The New York Sun: subscription sources
Unknown subscription sources cut from over 90% to about 7%.
nysun.comThe New York Sun, opens in a new tabA checkout change hid where new subscribers came from. I rebuilt the SQL report so the finance team could see which sources brought them in.
Tools. Snowflake SQL, Stripe metadata, Equals.
Run the rebuilt report and watch each subscription find its source.Sample
90%+of new subscriptions: source unknown
Why sources went missing
A checkout update saved each subscriber’s source under a new name.
Old report: didn’t look there, so Unknown.
Unknown
Email
Search
Social
Direct
Partner
No AI here. Eight rewrites of the SQL that reads the payment records.
More work.
- SuperBloom: weekly LinkedIn drafts that start from her own answers
- instantAIpage: a page AI search can find and quote accurately
- Chamber chatbot: a chatbot that answers from its own material and hands harder questions to staff
- VAST Cleaning: every request becomes a priced proposal, approved twice
- Client websites: websites their owners keep building