SOP: RC Patronage and Social Reach Tracking

In drive: “RC Patronage & Social Tracking”

https://pools.events - “Memberships” tab

https://patreon.com - “Insights” tab, set to “tiers”

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

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

socials - manually updated by checking IG / bluesky / signal chats / logging into tally.so - socials are linked in column header for ease