# SOP: RC Patronage and Social Reach Tracking

### <span class="heading-content">Docs and sources</span>

In drive: “RC Patronage &amp; Social Tracking”

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

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

### <span class="heading-content">RC Patronage &amp; Social Tracking sheets/tabs</span>

- 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

### <span class="heading-content">Process</span>

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