Ryan (ryan@themedialab.agency)
2024-09-16 18:06:26

@Cameron Rentch, page cleaned up and updated ☝️:skintone4:

Ryan (ryan@themedialab.agency)
2024-11-11 14:53:37

@Dustin Surwill

Dustin Surwill (dsurwill@shield-legal.com)
2024-11-11 14:53:39

@Dustin Surwill has joined the channel

Ryan (ryan@themedialab.agency)
2024-12-02 15:45:53

@Nicholas McFadden @James Turner @Dustin Surwill @Zekarias Haile

James Turner (jturner@shield-legal.com)
2024-12-02 15:46:02

@James Turner has joined the channel

Zekarias Haile (zhaile@shield-legal.com)
2024-12-02 15:46:02

@Zekarias Haile has joined the channel

Ryan (ryan@themedialab.agency)
2024-12-02 15:46:32

Shield Financials Calculations ```:::::::::: :Measures: ::::::::::

Gross Spend = dailyspend + cccost + agency_fee

Gross Revenue = daily_revenue

Gross Spend = dailyspend + cccost + agency_fee

COGS = dailyspend
+ cccost
+ agencyfee
+ mbcommission
+ sales_commission

Total Expense = dailyspend -- COGS & gross spend + cccost -- COGS & gross spend + agencyfee -- COGS + mbcommission -- COGS + salescommission -- COGS + operationexpense

Gross Profit = dailyrevenue - dailyspend - cccost - agencyfee

Gross Profit COGS = dailyrevenue - dailyspend
- cccost
- agencyfee
- mbcommission
- salescommission

Flatirons Overhead ** = VSS fees + CSP + MRT = Total Flatirons Post Retainer Services / by mediarawv2 row count where customer LIKE '%Flatirons%' per month. Update Looker shield_legal model file.

** Is added to External Total Expense, Combined Total Expense and subtracted from External Net Profit, Combined Net Profit, Combined Cash Flow

Net Profit = dailyrevenue - dailyspend
- cccost
- agencyfee
- mbcommission
- salescommission - op_expense

Cash Flow = enetprofit (Shield) - itotalexpense (TC)

:::::::: :Ratios: ::::::::

Conversion Rate = Signed Contracts / Sold Leads

Gross Cost Per Lead = Gross Spend / Daily Leads

Gross Cost Per Contract = Gross Spend / Signed Contracts

Gross Profit Margin = Gross Profit / Gross Spend

Net Profit Margin = Net Profit / Gross Revenue

Total Cost Per Lead = Total Expense / Sold Leads

Total Cost Per Contract = Total Expense / Signed Contracts

Revenue Per Lead = Daily Revenue / Daily Leads

Revenue or Price Per Contract = Daily Revenue / Signed Contracts```

Ryan (ryan@themedialab.agency)
2024-12-03 16:01:48

*Thread Reply:* @Cameron Rentch, master copy here in #adminshieldlibrary and above. Added your Ratios abobe.

Andy Rogers (andy@shield-legal.com)
2025-07-15 12:01:31

@Andy Rogers has left the channel

Ryan (ryan@themedialab.agency)
2025-08-21 14:48:27

@CC Kitanovski

CC Kitanovski (ckitanovski@shield-legal.com)
2025-08-21 14:48:30

@CC Kitanovski has joined the channel

Ryan (ryan@themedialab.agency)
2025-08-21 15:27:35

@Nicholas McFadden @James Scott

James Scott (jamesscott@shield-legal.com)
2025-08-21 15:27:37

@James Scott has joined the channel