SOP: RC Patronage and Social Reach Tracking
Docs and sources
In drive: “RC Patronage & Social Tracking”
https://pools.events - “Memberships” tab
https://patreon.com - “Insights” tab, set to “tiers”
RC Patronage & Social Tracking sheets/tabs
-
p tally - weekly snapshot of patreon tier subscriptions
-
wf tally - weekly snapshot of withfriends tier subscriptions
-
platform 📊 - stacked bar chart showing platform usage split
-
tier tally - sum of platforms by tier, with small constants added for better charting
-
tier tally (📈) - chart of tiers
-
revenue tally - uses tier tally with multipliers (tier cost) to create $ per tier listing
-
revenue % by tier - breaks down tiers by % of total revenue
-
socials - data for a range of social media and outreach platforms
-
socials (📈) - chart of social media and outreach #s
Process
p tally - populated by manually updating counts, date is manually entered
wf tally - populated by manually updating counts
All other subscription tracking sheets are automatically populated via cell formulas
Date on all sheets aside from 'p tally' is populated via array formula referencing 'p tally' sheet