Cameron Rentch (cameron@internetthings.com)
2024-12-02 13:03:08

@Marc Barmazel I talked with Ryan this am, and he put together this updated "cheat sheet" for all Shield calculations. Also, he updated the "gross profit" in dash to our original calculations we have always used of "media spend+agency fee+call center cost". The "net profit" will factor in the COGS + overhead.

Ryan Vaspra (https://themedialaboratory.slack.com/team/UJF2W0EB1)
<p>On the call, here is the latest cheat sheet on SL financials, I just updated it.</p> <p><strong>Shield Financials Calculations</strong> ```Gross Spend = daily<em>spend + cc</em>cost + agency_fee</p> <p>Gross Revenue = daily_revenue</p> <p>Gross Spend = daily<em>spend + cc</em>cost + agency_fee</p> <p>COGS = daily<em>spend<br /> + cc</em>cost<br /> + agency<em>fee<br /> + mb</em>commission<br /> + sales_commission</p> <p>Total Expense = daily<em>spend -- COGS &amp; gross spend + cc</em>cost -- COGS &amp; gross spend + agency<em>fee -- COGS + mb</em>commission -- COGS + sales<em>commission -- COGS + operation</em>expense </p> <p>Gross Profit = daily<em>revenue - daily</em>spend - cc<em>cost - agency</em>fee</p> <p>Gross Profit COGS = daily<em>revenue - daily</em>spend<br /> - cc<em>cost<br /> - agency</em>fee<br /> - mb<em>commission<br /> - sales</em>commission</p> <p>Flatirons Overhead ** = VSS fees + CSP + MRT = Total Flatirons Post Retainer Services / by media<em>raw</em>v2 row count where customer LIKE '%Flatirons%' per month. Update Looker shield_legal model file. </p> <p>** Is added to External Total Expense, Combined Total Expense and subtracted from External Net Profit, Combined Net Profit, Combined Cash Flow</p> <p>Net Profit = daily<em>revenue - daily</em>spend<br /> - cc<em>cost<br /> - agency</em>fee<br /> - mb<em>commission<br /> - sales</em>commission - op_expense</p> <p>Cash Flow = e<em>net</em>profit (Shield) - i<em>total</em>expense (TC)```</p>
Slack Conversation
Cameron Rentch (cameron@internetthings.com)
2025-06-27 11:27:19

@Ryan please share this with Marc asap thank you

https://docs.google.com/spreadsheets/d/1LqK6JikJHIDPZT_SaQDguvSaZfNSQnRBmhQMvX37e9E/edit?gid=1938462615#gid=1938462615

Ryan (ryan@themedialab.agency)
2025-06-27 11:38:35

Sent to ML email

Cameron Rentch (cameron@internetthings.com)
2025-08-27 10:53:36

@Ryan we need to go back into financials and remove media spend for days listed below on Tik tok. We used ad credits on these days from Tik tok so should be zero media spend

Cameron Rentch (cameron@internetthings.com)
2025-08-27 10:54:37

Bard Powerport

• July 24: $5,178.54 • July 25: $7,082.72 • July 26: $7,160.52 • July 27: $6,014.47 • July 28: $5,178.87

For NEC August 13 to August 21, amounting to $135,000 USD:

August 13: $14,651.56 August 14: $15,046.26 August 15: $15,255.47 August 16: $17,670.81 August 17: $15,507.57 August 18: $16,627.52 August 19: $19,396.28 August 20: $16,996.55

August 21: $3,847.98

Ryan (ryan@themedialab.agency)
2025-08-27 11:10:44

@Cameron Rentch, got it. Doing now.

Ryan (ryan@themedialab.agency)
2025-08-27 12:15:32

@Cameron Rentch, They are done.

Cameron Rentch (cameron@internetthings.com)
2025-08-28 12:14:49

@Ryan @Marc Barmazel and I need a variation of the "page zero". We are looking for sign ups by campaign for ONLY lead created on the same day

☝️:skin_tone_4: Ryan
Ryan (ryan@themedialab.agency)
2025-08-28 13:24:24

Let me investigate.