Ryan (ryan@themedialab.agency)
2024-01-16 12:09:52

@Tony, Cameron asked originally for this to be on a TV.

@Cameron Rentch, Tony said he did not want it on a TV.

Can you guys confirm and let me know so we can wrap up this request?

Ryan Vaspra (https://themedialaboratory.slack.com/team/UJF2W0EB1)
<p>@Cameron Rentch @Tony @deleted-U04GU9EUV9A @deleted-U05EFH3S2TA</p> <p>@Cameron Rentch, on January 5th, you requested a "TIP Leads Dashboard" that you envisoned on a television in the call center area. That TV dashboard is ready to be setup and used. This dashboard will update at 4:00AM, 8:15PM, 12:15PM and 3:15PM Pacific Times.</p> <p>The full-screen, present mode that has to be simply setup once on a TV screen in a browser are the last steps once the hardware is ready. @Cameron Rentch, who do we lean on in Las Vegas to deliver this?</p> <p>And if you want different visualizations, feedback appreciated.</p> <p><strong><a href="https://lookerstudio.google.com/reporting/e6291642-d160-4f97-a866-83b9a91d90a2">TIP NEW LEADS DASHBOARD</a></strong></p> <p>FYI @Mike @Luke Fontaine</p>
Thread in Slack Conversation
Tony (tony@shield-legal.com)
2024-01-16 12:12:30

If this is real time and shows conversion percentages I can put it up on the tv.

Ryan (ryan@themedialab.agency)
2024-01-16 12:13:37

The original request from @Cameron Rentch was to have it update just once a day, we have it updating 4 times per day as leads flow into LawRuler. 4:00AM, 8:15AM, 12:15PM and 3:15PM Pacific Times. We did these 4 times per day to support this and the Agent Payroll Report for Allan too.

Ryan (ryan@themedialab.agency)
2024-01-16 12:26:36

@Tony, let me know if 4x is good enough. If not, we'll have to have LawRuler send the reports hourly during work hours, and have developer update lambda to run 8 times per day. I need to know quick cause tonight the developer is going to update the data import schedule.

Cameron Rentch (cameron@internetthings.com)
2024-01-16 12:31:14

@Tony I believe you originally asked for only “raw leads” being populated/sent into lawrulwr via LeadsPedia

Ryan (ryan@themedialab.agency)
2024-01-16 12:33:07

The data in this report looks at leads created today where Lead Status or Previous Lead Status equals "New Lead" @Tony. I can remove the status check and make the dash show all "Leads Created Today" instead, let me know which way you want it.

Tony (tony@shield-legal.com)
2024-01-16 12:34:58

Please make it lead created today.

🙏:skin_tone_4: Ryan
Ryan (ryan@themedialab.agency)
2024-01-16 12:52:37

@Tony, do you want me to exclude Form 95s?

Ryan (ryan@themedialab.agency)
2024-01-16 12:52:50

They get "created" when cloned in LawRuler

Ryan (ryan@themedialab.agency)
2024-01-16 12:55:52

@Tony, I've excluded them for now, the dash is ready. I'll get Brittany to work on-site to get it setup on TV.

Tony (tony@shield-legal.com)
2024-01-16 13:03:07

Yes, please exclude

Ryan (ryan@themedialab.agency)
2024-01-16 13:03:36

Got it, doing now

Ryan (ryan@themedialab.agency)
2024-01-16 13:04:05

Done

Tony (tony@shield-legal.com)
2024-02-26 12:30:48

@Ryan I talked to Cameron on Friday about the ACTS inbound campaign. He said that the pricing for this campaign should be $122 per qualifying transfer.

Ryan (ryan@themedialab.agency)
2024-02-26 12:35:55

Got it, then will change back @Debbie

Tony (tony@shield-legal.com)
2024-06-02 21:34:11

@Cameron Rentch Please share with Ryan the revised Director commissions for payroll, if you have not already done so.

☝️:skin_tone_4: Ryan
Cameron Rentch (cameron@internetthings.com)
2024-06-03 10:48:38

@deleted-U04HFGHL4RW make sure this is sharded and reviewed with Brian in accounting as well. @Ryan here you go...

tip 5-15-24 override schedule revised proposed 5_15_24.xlsx
Ryan (ryan@themedialab.agency)
2024-06-03 11:04:33

@Tony and @Cameron Rentch, use the "blue section" titled Current for May 2024? Confirming, thanks.

Cameron Rentch (cameron@internetthings.com)
2024-06-03 11:31:07

no @Ryan this one..."Proposed"

Proposed
Monthly Sign up Range Commission/Override Pot Marc Quarterly Qualifications Sign Up Range Commission Pot

1000+ $22,125.00 $21,093.75 3000 $10,000.00 1350 $25,875.00 $22,968.75 4000 $11,000.00 1650 $28,125.00 $27,656.25 5000 $13,000.00 2000 $31,125.00 $32,343.75 6000 $15,000.00 2000+ $35,000.00 $45,000.00 7000 $17,000.00 2500+ $40,000.00 $50,000.00 8000 $19,000.00 3000+ $45,000.00 $55,000.00 9000 $21,000.00 3500+ $50,000.00 $60,000.00 10000 $23,000.00 4000+ $55,000.00 $65,000.00 11000 $25,000.00 **Minimum of 60% of files must be Tier 3 and above

Cameron Rentch (cameron@internetthings.com)
2024-06-03 11:31:20

the green one

Ryan (ryan@themedialab.agency)
2024-06-03 11:32:29

Got it, making sure, thanks for confirming @Cameron Rentch

Ryan (ryan@themedialab.agency)
2024-06-03 11:33:19

@Cameron Rentch, do I ignore the Marc column or use that Marc column versus column F "Commission/Override Pot"?

Cameron Rentch (cameron@internetthings.com)
2024-06-03 11:52:59

@Ryan I dont know what you are asking me

Cameron Rentch (cameron@internetthings.com)
2024-06-03 11:53:17

I dont see or have a "Marc column"

Tony (tony@shield-legal.com)
2024-06-03 14:55:40

The column on the right is the column marked Mark that he approved. The column on the left was my original proposal

Ryan (ryan@themedialab.agency)
2024-06-03 15:00:43

@Tony, got it! I'll use Marc column.