hey @deleted-U04R23BEW3V! can you please run a report for the signed retainers by case type from the past 7 days? The report should look like this:
Tab for each tort first name date created e-sign date s1 tag
Thank you!
I will want this every week on Monday for the prior week. Lets run from all of last week through this past Sunday, then redo starting next week! Thank you
@Cameron Rentch All Campaign Finals 2/19/2024-2/25/2024 Let me know if there are any adjustments you'd like me to make
@deleted-U04R23BEW3V I need only signed e sign with tik tok S1 (no facebook), can you please redo this?
@Cameron Rentch All Campaign Finals 3/11/2024-3/17/2024 Only TikTok S1's
Hey @Cameron Rentch! I'm trying to run this TikTok S1 report for you but Law Ruler hasn't sent a report back to me in more than 10 minutes. Would you mind if I wrap it up and send it to you tomorrow?
@Cameron Rentch All Campaign Finals 3/18/2024-3/24/2024 Only TikTok S1's
https://docs.google.com/spreadsheets/d/1oUlO_4bQ5rEQZwHoo4tHNiSlVrWXHP0MKI2a2Hwtbs8/edit?usp=sharing
@deleted-U04HFGHL4RW approve the dual rep (looks like signed and declined anyways, not approved the latency as it meets criteria
@deleted-U04HFGHL4RW @deleted-U04R23BEW3V what are you seeing on the Paraquat leads today. Conversion has dropped of the shelf, can you run a DQ report and also an "open report" for leads from today that we have not been able to reach?
Over the last 2 weeks, I've been seeing a good amount of DQ's for Roundup exposure. The restriction from DL Flatirons criteria that mandates PNC's need a Parkinson's diagnosis has been a pretty big hang up as well. I've seen a good number of DQ's where PNC's have symptoms and medication but don't have an official diagnosis yet.
I'll run that report for today's leads for you and give a detailed DQ description for you
Paraquat 12 DQ Report 10/21/2024 Paraquat 12 Open Status 10/21/2024 @Cameron Rentch If there's anything additional I can add to these reports, please let me know!
@deleted-U04R23BEW3V @deleted-U04HFGHL4RW I need to get DQ list and analysis on bard power port since we made some new intake changes. Can you run a report from this week with detailed reasons for DQ? Thank you
@Cameron Rentch Bard PowerPort DQ 10/21/2024-10/25/2024 If youβd like me to check further back, just let me know!
@deleted-U04HFGHL4RW @deleted-U04R23BEW3V have these been rec'd on your end?
@Cameron Rentch Yes all of those are on the Bard PowerPort Replacement Requests sheet. Errolyn Julius is under the name Gloria Vines. Errolyn is the signer, Gloria is the injured party
@deleted-U04R23BEW3V thanks can you notate that ion the sheet somewhere?
Hello @Cameron Rentch! We received communication from Nations stating they have signed cases that they cannot accept. All 3 cases are on the spreadsheet below. They provided detailed reasons for each client. Those reasons are detailed in the "Notes" column on the right. If you need any additional information, please let me know! AFFF Nations Replacement Requests
@deleted-U04R23BEW3V @deleted-U04HFGHL4RW We will review these and list as "pending". Tony - I need to find out if they are reviewing medical records and submitting returns after, as we do not accept returns for medical record reasons. Meantime, please pull the recordings and see if you can find out if these were signed incorrectly. The exposure one seems accurate and should be rejected
@Cameron Rentch should I post the recordings in this message thread or would you like me to email them to you?
606364 Edward Barrett - PNC stated in his initial inquiry that he was diagnosed with stage 4 prostate cancer. On the initial call with the intake agent, the PNC explicitly stated that the cancer had metastasized to his liver (roughly 3 minutes into the call).
600087 John Burditt - Within the first minute of the call, PNC clearly told the intake agent that he was diagnosed with Thyroid Cancer.
great @deleted-U04R23BEW3V. @deleted-U04HFGHL4RW 606364 Edward Barrett should not have been signed. Approved return, please remove from dash and alert Ryan
@deleted-U04R23BEW3V can you run me an open and DQ report from Powerport Lanier Crump? Not seeing any signed contracts want to dig into this. thank you
@Cameron Rentch There are 2 leads that I believe could be moved to Bay Point Simmons. Both intakes were disqualified before discussing possible complications from the unknown devices.
@deleted-U04HFGHL4RW @deleted-U04R23BEW3V need deep dive into Bard Powerport Crump Lanier. Please send me dq with details and open report
@Cameron Rentch all time for the campaign or is there a specific date range youβd like me to target?
weve only been running it since Dec
@Cameron Rentch Bard PowerPort Crump Lanier DQ Deep Dive There are 3 leads highlighted yellow that should have been moved to Bay Point Simmons. I took care of those and added them back to the lead pool.
@deleted-U04R23BEW3V thank you^ can you also add the button battery to DQ and open?
@Cameron Rentch Absolutely! Would you like a deep dive for button battery DQ's as well?
@Cameron Rentch Button Battery DQ Deep Dive Many of the leads generated today and yesterday appear to be a continuation of the issue highlighted yesterday
@deleted-U04HFGHL4RW there are leads here that should have been sent for review. Reminder ANY injury, hospitalization from a button battery at ANY AGE MUST BE SENT FOR REVIEW.
@deleted-U04R23BEW3V good morning can you please give me a DQ and open report for LA wildfires? Also make sure this is added
@Cameron Rentch Yes sir! It's included in today's DQ report. I can run an open status report for the campaign now for you. Should I include the new campaigns that were set up last night or only focus on the Shield Legal campaign?
LA Wildfires Open Status @Cameron Rentch I created 2 open status tabs, one with and one without the new inbound campaigns.
@deleted-U04HFGHL4RW @deleted-U04R23BEW3V I see alot on the open tabs, and many on open that say "disqualified" but have "property damage" and "physically injured". Can we get reasons why these were disqualified?
@Cameron Rentch VGA AWKO Bradley Grombacher Replacement Requests We received an email from AWKO regarding some signed VGA leads. The email says the signers are now refuting that they ever signed retainers and do not wish to pursue the matter any longer. I have listened to all of the calls. There are no indications that any of these clients were under the influence at the time of signing. It appears as though the signers got cold feet. There is a noticeable 5 month gap between the creation of all of these leads (5 in late July and 4 in mid December). It doesn't appear to be a common pattern. All of the leads are detailed in the spreadsheet linked above. If any additional information is necessary to help make decisions, please let me know!
@deleted-U04R23BEW3V I am ok giving them to replacements @deleted-U04HFGHL4RW
@deleted-U04HFGHL4RW @deleted-U04R23BEW3V Can you all please run an all time report , e-sign final for Baypoint/Simmons cooper bard powerport? Note We show a billable number at 308 but he shows 274 open cases on his end. Can we highlight the e-signs that were requested for return and the reason "approve foer return" or "declined"? Thank you!
@Cameron Rentch Law Ruler is showing me 304 signed. According to my communications with Christian Champagne, they've requested a total of 16 replacements all time, however 3 of those requests were files we declined in house and never counted toward the final total. All of that factored in, our number is down to 291 finals. Somehow our numbers are off by 4 finals, and 17 replacement requests. I've checked with Greg Owens to help validate these numbers. His numbers also reflect the discrepancies I just outlined. On the spreadsheet attached, I have highlighted all pending replacement requests in yellow with the email from the firm in the last column. My last communication regarding replacement requests with Christian Champagne was from 1/26/25 regarding Enrico Humphrey's replacement request.
There is a possibility that they are counting some of our test leads in their finals. That would account for 3 of the 4 in the original discrepancy of their 308 vs our 304. I am still searching to find the fourth
@deleted-U04R23BEW3V can you please start a new slack to include the above and add Ryan Vaspra to it with me, you and Tony? @deleted-U04HFGHL4RW you and Ryan need to reconcile the ensure any DQ's have been removed properly. thank you
@deleted-U04R23BEW3V @deleted-U04HFGHL4RW I need deep dive DQ and Open reports on:
AFFF Paraquat MI clergy IL clergy Chowchilla Bladder cancer Bard powerport
@deleted-U04R23BEW3V @deleted-U04HFGHL4RW - Jackson can you also please create a daily report for me for all sign ups for the Meadow campaigns, I would like to see it around 5pm each day for the current day. All I need is:
Lead ID, Campaign, E-sign date, diagnosis, S1
if you can run one from past 7 days that would be great, then add whatever comes by 5pm
@Cameron Rentch Would you like all of the leads on the same sheet or should I separate tabs out by case type?
@Cameron Rentch I ran a test of the Meadow E-Sign report. Please let me know if you'd like me to tweak anything about this report. I did include sexual abuse cases and included the client's story. If you'd like me to omit any case types or story fields, please let me know! Meadow E-Signs 2/10/2025-2/17/2025 Test
@Cameron Rentch The Open Status report is ready. I have linked the Deep Dive report as well, however I am still working through the Paraquat tab. There are 200+ that I am still listening through and auditing. Deep Dive DQ 2/10/2025-2/17/2025 Open Status 2/11/2015-2/17/2025
@deleted-U04R23BEW3V crap I am sorry only need Meadow for AFFF and Paraquat!
@Cameron Rentch Updated that sheet! Let me know if there are any other adjustments you'd like to see
@deleted-U04R23BEW3V sheet looks great, can you possibly have each campaign in order of e-sign date? (most recent at top,to oldest at bottom?)
@Cameron Rentch absolutely! Let me make that adjustment for you. I was just giving it some extra thought. This report only reflects leads generated in the timeframe specified so it will not contain leads generated from 3 weeks ago if they were signed today. Would you like these reports to include older leads or only leads converted on the same day?
oh sorry @deleted-U04R23BEW3V all leads please! just only need the esign dates
@Cameron Rentch Understood! With that in mind, Sobo already has a script that runs a similar report for the Stock Fraud case and is scheduled to send at 8pm every night. With your permission, he is willing run the same kind of script for these Meadow cases with the specifications you've asked for
@deleted-U04R23BEW3V yes thats great re run every night around 8. Also maybe separate into tabs, one for Paraquat and one for AFFF? that way the case types are grouped?
@Cameron Rentch perfect! Sobo and I are running tests to make sure it works correctly. Weβll schedule it for 8pm and group the like campaigns!
@Cameron Rentch We have it setup to deliver in the form of an email. Which email(s) would you like this sent to?
@deleted-U04R23BEW3V please send to me at Cameron@Shield-legal.com
thank you!!! you guys Rock!
@Cameron Rentch No problem! We have it ready to trigger starting tonight. The automation is a little imprecise however it's scheduled to automatically send between 8pm and 9pm
Awesome! I just emailed you the spreadsheet that all of this data comes from. If there are any revisions that need to be made, just let us know!
I will work on back logging all of the e-signs that have already been completed tomorrow
@deleted-U04R23BEW3V
Anthony and I will create an array formula to split the AFFF and Paraquat into separate tabs
Regarding 686411, that was finalized right after I ran my initial custom report and prior to the creation of these automations so it didnβt appear on my initial export. It will be included in tomorrowβs export
@deleted-U04R23BEW3V can you please give me a deep dive on LA wildfires, one each for ACTS, Crump/Andrews, and DL Flatirons please
@Cameron Rentch Working on the LA wildfires Deep Dive. I have roughly 200 more calls to listen to. Will have this to you asap
Thanks @deleted-U04R23BEW3V youβre the best
Hi @Cameron Rentch. I compiled a list of all AFFF leads received since 2/1/2025 that have duplicate leads that exist within the system. Some duplicates were created same day, some as far back as 2022. Of the 2282 AFFF leads created in the timeframe, 912 have at least one duplicate lead in Law Ruler. If you need any additional information or context as to how I created this report, please let me know!
@deleted-U04R23BEW3V can you make sure I have lead Id from LeadsPedia as well as s1
@Cameron Rentch yes! Iβm headed home at the moment. I can get that for you once Iβm home
also @deleted-U04R23BEW3V can you please also sort the leads by "status" . Lastly can you please explain what is meant by "Send to Five9"?
@Cameron Rentch yes! I am working on adding the LeadsPedia IDβs and S1βs now. Iβll have it in order by status. βSend to Five9β is a status we use after a lead has been generated via the API. Leads enter into Law Ruler in the βNew Leadβ status. That triggers an automation to send the contact information directly into the outbound Five9 dialer and changes the status to βSend to Five9β where it remains until acted upon by an agent.
@Cameron Rentch @deleted-U04HFGHL4RW I converted the file into a Google Sheets link. All LeadsPedia IDβs and S1βs are in. The sheet is organized by Status. I ended up catching some test leads so the total is down to 904. I included pivot tables for status and S1 on the second tab. If I can assist in any other way, please let me know! AFFF Files With Duplicates 2.1.25-3.4
amazing @deleted-U04R23BEW3V!
@deleted-U04R23BEW3V @deleted-U04HFGHL4RW I only see 900 leads, and 100 duplicates. Thats only 11% which is about average. Great work on this @deleted-U04R23BEW3V
@deleted-U04R23BEW3V @deleted-U04HFGHL4RW can I get DQ and open report for firefoam leads from today? Attached are raw leads from today. The ones marked "sold" generally appear to be on point based on reading comments. Only seeing 1 sign up so far
@deleted-U04R23BEW3V @deleted-U04HFGHL4RW can you guys explain the status "send to Five9" (just want to understand what that status means)
@Cameron Rentch It means the contact information was sent to the Five9 dialer via an automation. It's now the precursor to a "Contact Attempted" status.
@deleted-U04R23BEW3V can you please send me a DQ report for yesterday on the Los Padrinos Gladiator Fights? Specifically looking to identify cases that were rejected becuase the incident occured before 2023
@deleted-U04R23BEW3V I did not see the automated report today for Meadow? Can you confirm it was sent?
@Cameron Rentch it looks like it just ran a moment ago
@Cameron Rentch @deleted-U04HFGHL4RW Please let me know if you need any additional information for this report! Instant Soup E-Signs All Fields 3/13/2025
@deleted-U04HFGHL4RW @deleted-U04R23BEW3V see this signed up yesterday DL - MDW - 439 - 1710 Judy Sapp - S1:PL-FacebookMB-CPCMP-PQ_F6C
Did this get DQ'ed or is it a valid sign up?
@Cameron Rentch The lead was initially finalized 03/23/2025 09:05:23 AM. Two hours later at 11:17:50 AM, an intake agent changed the status to Disqualified. The lead was moved today at 10:03:49 AM to Signed e-Sign QA to signify that the lead had been finalized but did not need the automations to be retriggered.
Hi @Cameron Rentch! We received a list from Nations of all of their AFFF cases that they wish to have declined. I have categorized and added notations to these files. If you need any additional information to make decisions about these files, please let me know! AFFF Nations Replacement Requests
amazing @deleted-U04R23BEW3V
@deleted-U04R23BEW3V can you please run DQ and Open reports for Mormon abuse? Add to daily process as well. Thank you!
@Cameron Rentch On it! I might have accidentally skipped those in my run this morning. I'll add them to the existing reports. Do you want a separate open/dq as well?
@Cameron Rentch The reports attached below now include Mormon Abuse. My apologies for the oversight DQ Report 4/4/2025-4/6/2025 Open Status 3/31/2025-4/6/2025
@deleted-U04R23BEW3V can you send me a deep dive DQ list for Hair Salon Bladder cancer? (all time please)
@Cameron Rentch Please let me know if you need any additional information! Hair Salon Bladder Cancer DL Flatirons Deep Dive DQ
@deleted-U04HFGHL4RW @deleted-U04R23BEW3V need a quick report - all time TVM AWD/Anapol. All fields. thank you! They are requesting a criteria change and I want to see how it will affect whats been signed already
@Cameron Rentch Please let me know if you need any of the PII fields removed! TVM All Fields All Time
@deleted-U04R23BEW3V @deleted-U04HFGHL4RW we seem to be missing ALOT of data that is required in the intakes>please review ASAP.
Note that we are missing "Date of Implant" on ALOT (Column "AM"). @deleted-U04HFGHL4RW get this corrected right away of we will get hit with a ton of returns. Who is QC'ing these?
@deleted-U04R23BEW3V once @deleted-U04HFGHL4RW gets these updated, can you please re-run me a report. Here is what I need:
Did you have a Y-Mesh or Transvaginal Mesh (TVM) implanted? (AF) Date of implant: (AM) Did you have revision and/or removal surgery, have the revision/removal surgery scheduled, OR has any Medical Professional recommended you have revision/removal surgery? (AO) Date of Revision Surgery: (DL)
@Cameron Rentch The template for the report is ready to be run
@Cameron Rentch Here is the criteria from the firm. The only blanks you should see is where revision surgery is recommended but they have not had it yet. Jackson is going to rerun this report for you know.
@Cameron Rentch I have update the previous report with only the fields you've requested. The finalized clients who have been recommended to have removal/revision surgeries have been highlighted yellow. TVM All Fields All Time
@Cameron Rentch I have update the previous report with only the fields you've requested. The clients who have been recommended to have removal/revision surgeries have been highlighted yellow. TVM All Fields All Time
@Cameron Rentch I have update the previous report with only the fields you've requested. The finalized clients who have been recommended to have removal/revision surgeries have been highlighted yellow. TVM All Fields All Time
hey @deleted-U04R23BEW3V for the ones signed up today (6 of them) can you please add them to the above report (regardless of current status?)
hey @deleted-U04R23BEW3V for the ones signed up today (6 of them) can you please add them to the above report (regardless of current status?)
awesome thanks @deleted-U04R23BEW3V!
@Cameron Rentch we received a spreadsheet regarding some of the Transvaginal Mesh clients we've signed. I've reconciled the majority of the sheet, however there are 3 discrepancies that I've highlighted. The files say "Closed" on the firm's end, however we have them sitting in Signed e-Sign Final. I believe this communication is their manner of submitting replacement requests. In my review of these files, I found that 1/3 clients (Tiajuana Bethea) had the TVM implanted outside of the 10 year SOL, however this client was signed prior to the criteria update to add that SOL. The criteria update to add the 10 year SOL was communicated 4/18/2025. My assessment of Betty Ann Mitchell's file (based on their notation) is that she has previously received a settlement for this matter, however she did not mention previous representation or legal action taken regarding this matter. The final file, Andrea Cobb, states that her injuries were not related to the mesh, however her alleged complications are within the firm's criteria (pelvic pain & urinary dysfunction).
Please let me know if you require any additional information or if there are any actions I should take regarding these files!
@Cameron Rentch we received a spreadsheet regarding some of the Transvaginal Mesh clients we've signed. I've reconciled the majority of the sheet, however there are 3 discrepancies that I've highlighted. The files say "Closed" on the firm's end, however we have them sitting in Signed e-Sign Final. I believe this communication is their manner of submitting replacement requests. In my review of these files, I found that 1/3 clients (Tiajuana Bethea) had the TVM implanted outside of the 10 year SOL, however this client was signed prior to the criteria update to add that SOL. The criteria update to add the 10 year SOL was communicated 4/18/2025. My assessment of Betty Ann Mitchell's file (based on their notation) is that she has previously received a settlement for this matter, however she did not mention previous representation or legal action taken regarding this matter. The final file, Andrea Cobb, states that her injuries were not related to the mesh, however her alleged complications are within the firm's criteria (pelvic pain & urinary dysfunction).
Please let me know if you require any additional information or if there are any actions I should take regarding these files!
@deleted-U04R23BEW3V thank you for this I will review
@deleted-U04R23BEW3V @deleted-U04HFGHL4RW can you please do deep dive on Mormon LDS please? Send me DQ and Open for review.
thank you also @deleted-U04R23BEW3V can you pls send me the deep dive for return requests on TVM?
@Cameron Rentch I can add more details to these files. I'll just need some time to listen to the calls TVM Replacement Requests
thanks @deleted-U04R23BEW3V yes I need notes to show from our perspective if they met criteria or not, also make sure you are applying the criteria based on the date of e-sign (ir we changed criteria about 7-9 days ago), meaning if something "meets criteria at the time" but doesnt after changing then it is billable
@Cameron Rentch Understood! Working on the Mormon deep dive at the moment. Will move onto TVM once I wrap this up
@Cameron Rentch I just finished with the Mormon Deep Dive report. Please let me know if you need any additional information. The leads disqualified only for DOB SOL are non-DL Flatirons leads that do not have Outside SOL criteria. I am going to get to work on the TVM replacement requests now Mormon Deep Dive & Open Status
Ty @deleted-U04R23BEW3V
@Cameron Rentch I have update the TVM replacement request sheet with a synopsis of each file. I made sure to emphasize the reasons for each implant, the complications experienced and the revision/removal dates of each implant. The end of each synopsis has a timeline broken down in terms of how the events transpired in conjunction with the SOL. The 3 files at the bottom of the sheet do meet criteria based on what was communicated to us from the firm at the time of the clients signing. Please let me know if there is any additional information I can provide! TVM Replacement Requests
@deleted-U04R23BEW3V please see attached these are new TVM replacement requests. Please add to your sheet and deep dive ASAP
@Cameron Rentch I have highlighted cells of row 12 yellow because the PNC's story does not line up with known dates of usage for the TVM
@deleted-U04R23BEW3V sorry ALL of the 48 are being requested as replacements ONLY the highlighted ones are NOT
@deleted-U04R23BEW3V please deep dive as you did with others, clearly indicate intakes that DO meet criteria
@Cameron Rentch Understood! In my preliminary review of these clients, I'm noticing clients that were Signed & Declined (never finalized). How should I indicate these files in the sheet?
@Cameron Rentch Understood! In my preliminary review of these clients, I'm noticing clients that were Signed & Declined (never finalized). How should I indicate these files in the sheet?
note them as "signed and declined, NOT billable"
@Cameron Rentch All TVM files that require action have been updated! I am adding to the unbillable leads at the bottom still. Note that line 23 includes a state-by-state SOL that has not been communicated with TIP. That line is highlighted yellow
@deleted-U04R23BEW3V @deleted-U04HFGHL4RW ok I just got clarity, we (this is my fault) have the criteria wrong for TVM. It is supposed to be:
β’ Original implant within the last 10 years β’ Revision/replacement or recommendation within 4 years of the assertion of the claim (IE when the claimant is on the phone). Based on this, can you please go back through the replacement/return requests and update your notes and analysis?
Also, we are going to have a couple of additional (minor) changes to criteria coming.
@Cameron Rentch Many of the files with PNC's who have received recommendations for removal/revision surgeries but have not undergone the procedure cannot recall when they received that recommendation. Should I mark those files as meeting criteria or not meeting criteria?
@Cameron Rentch Columns I and J have been updated in accordance with the criteria update. I have marked the leads described in my above message with "No" for now, however I can update them according to your discretion if need be. Please let me know if there is anything else I can do to assist! TVM Replacement Requests
@deleted-U04R23BEW3V let me review shortly
@deleted-U04R23BEW3V @deleted-U04HFGHL4RW please see the TVM replacement requests. I have updated 28 replacement requests 16 approved 12 meet billable criteria ------ @deleted-U04HFGHL4RW I do not want agents punished, so let's just DQ but give them credit toward numbers. This was my fault
@Cameron Rentch All 16 approved replacement requests have been changed to Signed & Declined
thank you
Hey @Cameron Rentch! I was just reviewing the new Transvaginal Mesh criteria. Anapol Weiss shared a sheet with state-by-state SOL's. The Wrongful Death SOL's are clear, however the Product Liability column is confusing. Are those dates referring to the date of the initial implant or the date of the revision/removal surgery? Both of those possibilities heavily conflict with other the parts of the criteria that state the implant must have occurred within the last 10 years and that the revision/removal surgery must have occurred within 4 years of the assertion of the claim.
@deleted-U04R23BEW3V I will get clarity.
@deleted-U04R23BEW3V @deleted-U04HFGHL4RW on NEC can you run a report since March and let me know how many total sign ups, and of the total sign ups how many claimants have ONLY used Fortifier (no Formula or combination of Formula/Fortifier)
@Cameron Rentch The total count for NEC finals since 3/1/2025 is 216 across all campaigns. In the intake interview, we do not ask for a distinction between which type of Enfamil/Similac product was used (fortifier vs formula), we only ask for which brand was used. We do ask for that information in the PFS interview. I pulled a report for all completed NEC PFS's and narrowed down for clients that answered Yes to using fortifier and No to using formula. Of the clients that met those parameters, none of them signed between March 1, 2025 and today, however those interviews are ongoing. In the report linked below, the first tab is a list of all Finals between the requested dates. The second tab has a list of clients who have completed the PFS and answered Yes to using fortifier and No to using formula. Please let me know if there's any additional information I can provide! NEC Finals 3/1/2025-5/8/2025
@deleted-U04R23BEW3V @deleted-U04HFGHL4RW we need to add a question βwas formula, fortifier or both used (drop down) Formula Fortifier Both
Add to intake below the question of what brand did you use
@deleted-U04R23BEW3V two questions
@Cameron Rentch
@Cameron Rentch The Fortifier/Formula question has been added to the NEC intakes
thank you @deleted-U04R23BEW3V!
Also, here is final update on TVM:
https://docs.google.com/spreadsheets/d/1g0xjiQ9JlqSWZlZCnESJeDwBZbYwHQ5-XdjGn3rEpLs/edit?gid=0#gid=0
In summary,
28 replacement requests 17 approved for replacement 11 meet billable criteria Remaining were never in billable status so are N/A
thank you @deleted-U04R23BEW3V!
Also, here is final update on TVM:
https://docs.google.com/spreadsheets/d/1g0xjiQ9JlqSWZlZCnESJeDwBZbYwHQ5-XdjGn3rEpLs/edit?gid=0#gid=0
In summary,
28 replacement requests 17 approved for replacement 11 meet billable criteria Remaining were never in billable status so are N/A
Dora White is the only one we did not have in correct status.
Dora White, as the spreadsheet indicates that her removal surgery occurred on 4/6/2021 and that her claim was asserted on 4/23/2025, which is 17 days beyond the 4-year threshold. This would bring the total number of credits/replacements to 17.
Hey @Cameron Rentch! We received an email from AWKO requesting 5 replacements for signed clients. 1 of the 5 was Signed & Declined, never in a billable status so I've omitted that client from this sheet. For the remaining 4, their files all show that the clients meet the necessary criteria with the exception of the DOB based on state SOL. These files are all in the OSOL version of the case type. I have found no other pieces of the criteria that these clients do not meet. Please let me know if you'd like to see any additional information for these clients. Mormon Abuse AWKO Replacement Requests
@Cameron Rentch I've just been informed that Andy spoke with AWKO to clarify and they are retracting these replacement requests
@deleted-U04R23BEW3V I think they are saying the the OSOL casses were just signed on the WRING retainer. Please check with Andy
@Cameron Rentch They needed to ensure that the clients were signed in the correct OSOL campaign. Since they all were, it seems there aren't any issues
Hello @Cameron Rentch! Tony request that I compile the TVM DQ's of the last 2 days. If you'd like to see any additional information, please let me know! TVM DQ Report 5/20/2025-5/21/2025
Hello @Cameron Rentch! Tony asked me to provide a TVM DQ report for yesterday's leads. Please let me know if you need anything additional! TVM DQ Report 5/22/2025
thanks @deleted-U04R23BEW3V
Hey @Cameron Rentch! I have an update for TVM DQ's. I've noticed we have thankfully been receiving less inquiries from male parties in recent days. We are still seeing a large number of clients whose inquiries revolve around complications from hernia meshes and IUDs. If you need any additional information regarding these files or data from other days, please don't hesitate to ask! TVM DQ Report 5/28/2025
@deleted-U04R23BEW3V @deleted-U04HFGHL4RW have a few items for you:
Mormon/LDS AWD (1 sheet for each campaign) Deep dive on all rejected/DQ's
DL FL Deep dive on all rejected/DQ's
You did this prior - we are trying to see if there are other cases (non LDS) that we can sign up
PFAS Meadow Deep dive into DQ's
@Cameron Rentch Still working on Mormon and Sextortion Deep Dives! Please let me know if you need anything additional from this report PFAS Meadow Deep Dive DQ
@deleted-U04R23BEW3V any chance you can get me the Mormon LDS/AWD reports fairly soon?
@Cameron Rentch Yes! Wrapping up with those fairly soon. DL Flatirons was fairly large
awesome I know it is quite a heavy lift. Appreciate you sir!
@Cameron Rentch Terribly sorry about the delay! I've noticed that many of these files were DQ'd prior to determining if the abuse experienced qualifies because the alleged abuse did not occur at a church related event. Many of them occurred in the PNCs' homes when Missionaries were invited to make their recruitment pitch. Please let me know if you need any additional information about these files. Mormon Deep Dive DQ
@deleted-U04R23BEW3V can you please separate the AWD and DL/FL, give me one separate sheet for each? Thank you
@deleted-U04R23BEW3V if you can do this quickly for me I would appreciate it. I have a meeting in 8 min π
@Cameron Rentch Mormon AWD Deep Dive DQ Mormon DL Flatirons Deep Dive DQ
The AWD link is the original spreadsheet. I created a fresh separate one for DL
@deleted-U04HFGHL4RW @deleted-U04R23BEW3V great news I have approval to modify AWD criteria as there are many claimants in here that they want to call back and sign up.
@deleted-U04R23BEW3V good morning can you please do a deep dive on the Kanakuk Kamp leads, as well as the Kentucky organ donor leads?
@Cameron Rentch Please let me know if you need any additional information about these files! Kanakuk Kamps Deep Dive DQ KY Organ Donor Deep Dive DQ
@deleted-U04HFGHL4RW @deleted-U04R23BEW3V looking at DL flatirons San Bernardino JDC looks like LAwruler ID 758358 say abuse occured at Los Padrinos, this would be a DQ unless I am missing something. Can you please investigate this asap and let me know?
@Cameron Rentch There's definitely some conflicting information in this file. It says the client was incarcerated at Los Padrinos in 2024 but did not experience sexual abuse at that facility. Similarly, they were incarcerated at a Las Vegas juvenile facility in 2022 but did not experience sexual abuse there either. The alleged sexual abuse stems from their 2024 incarceration in San Bernardino Juvenile Hall. The Las Vegas juvenile hall and Los Padrinos were not mentioned during the original intake.
It's possible the Los Padrinos incarceration date is a typo but this should have been caught before the secondary interview was finished processing.
thank you @deleted-U04R23BEW3V I am going to loop you into a message in a min with Alan, Tony and Edward. We need to get this intake updated to properly reflect the accurate facilty where abuse occured to be San Bernardino
@deleted-U04HFGHL4RW @deleted-U04R23BEW3V for the 12pm call w Abe today, I need all of the CPAP cases that have been declined, both QA signed and declined, and Law Firm signed and declined along with reasons and please be somewhere you can share this. We also need to be able to see the DL daily with rejects etc...see if you can get either Nick M, or Edward to join as well. Thank you
@Cameron Rentch I repurposed the CPAP DQ Report for this meeting to include the Decline reasons for each file. There are a couple at the bottom of the page that I am tracking down the decline reasons for still. The count is 135 declines in total CPAP DL Flatirons Declines
@deleted-U04R23BEW3V good morning can you please get me a deep dive on Depo Provera last 7 days?
@Cameron Rentch The vast majority of the DQ's have been from PNC's reporting other types of cancers, some of which are other varieties of brain cancer. If you need any additional information regarding these files, please let me know! Depo-Provera Deep Dive DQ Report 6/23/20258-6/30/2025
thank you @deleted-U04R23BEW3V!
@Cameron Rentch I've completed my first DQ report for the Northwell Sleep Center campaign. It's a bit of a mixed bag for the DQ's. One person is claiming they've already signed with Slater. Please let me know if you need any additional information about these files! Northwell DQ Report
Thank you @deleted-U04R23BEW3V
Hey @Cameron Rentch! We received some replacement requests from ELG for the PFAS campaigns. All of the files in question have an Ulcerative Colitis diagnosis and meet the minimum latency requirement of 2 years, however 1 file exceeds the maximum of 40 years. If you require any additional information regarding these files, please let me know! AFFF-PFAS ELG Replacement Requests
Hey @Cameron Rentch! We received some replacement requests from ELG for the PFAS campaigns. All of the files in question have an Ulcerative Colitis diagnosis and meet the minimum latency requirement of 2 years, however 1 file exceeds the maximum of 40 years. If you require any additional information regarding these files, please let me know! AFFF-PFAS ELG Replacement Requests
@deleted-U04R23BEW3V can you pls deep dive into Chowchilla? All of a sudden we stopped converting?
@Cameron Rentch Absolutely! I noticed a large number of inquiries from male applicants recently as well as some obvious spam over the last couple of days. I'll detail all of this for you. Would you like me to go back to last week after the DL Flatirons campaign closed?
@Cameron Rentch I took a look at the leads from the last week since DL Flatirons closed. Please let me know if you'd like me to go further back! Chowchilla Deep Dive DQ 7/8/2025-7/14/2025
Also @deleted-U04R23BEW3V can you please run deep dive on Kansas JDC and YRTC campaigns?
@Cameron Rentch The overwhelming majority of the DQ's are from PNC's who experienced physical abuse, not sexual. Even the PNC's manual entries from their inquiries detail physical abuse from guards and other staff and not receiving medical attention after the fact. Please let me know if you need any additional details! KS JDC/YRTC Deep Dive DQ
@deleted-U04R23BEW3V can you send me a deep dive from yesterday only with MI Juv Hall? Conversion really seemed to fall out yesterdya
@Cameron Rentch There were more PNC's who experienced physical abuse than I'm used to seeing in a day's worth of MI Juv Hall DQ's. I couldn't find any salvageable files unfortunately. Please let me know if you need any additional information! MI Juv Hall Deep Dive DQ 7/16/2025
@deleted-U04R23BEW3V can you please give me deep dive on Dublin womens prison from last week?
@deleted-U04R23BEW3V can you please run another deep dive on Dublin, and NV JDC campaigns? thank you
@deleted-U04R23BEW3V can you please run we a report (google sheet): Milestone Tax All leads All fields Have our status listed (ie E-sign final), Rejected etc add a column far right called "disposition at Milestone"
Use these options pre-set so that they can select and we can see dispositions of their leads daily. I need this report to be sent every day and emailed to the following people:
me Yan@shield-legal.com ben@milestonetax.com marc@sunrisessm.com dave@legacycapitalservices.com thom@elitelegalpractice.com
Warm Transfer- Deal Closed Warm Transfer- NQ Low Debt Warm Transfer- NI With Competition Warm Transfer- NI Wants to Handle on Own Warm Transfer- CB Scheduled Warm Transfer- DNC Warm Transfer- Hung Up
Email Lead- Deal Closed Email Lead- NQ Low Debt Email Lead- NI with Competition Email Lead- NI Wants to Handle on Own Email Lead- CB Scheduled Email Lead- DNC Email Lead- No Answer Email Lead- Left VM Email Lead- No Contact Attempted Yet
NQ Not Qualified NI Not Interested CB Call back DNC Do Not Contact VM Voicemail
@Cameron Rentch Here is the Dublin Deep Dive report you asked for! Please let me know if you need any additional information! I am working on the NV report right now. Anthony and I are collaborating to set up the Milestone Report for you. I will send a test to you before distributing to the rest of the recipients. Dublin Deep Dive DQ 8/6/2025-8/12/2025
@Cameron Rentch What time of day would be best to run this report?
how about we send in the am, first thing each day? (each day will show all total activity through the end of the prior day?
@Cameron Rentch Perfect! We'll set it up to trigger during the 6AM hour PST
@Cameron Rentch Here's the NV YRTC Deep Dive DQ Report! Please let me know if you need any additional data! NV YRTC Deep Dive DQ 8/1/2025-8/12/2025
Regarding the Milestone Report, we are still working on creating a test version to send you. Will have that to you shortly!
@Cameron Rentch This is the sheet that will be distributed to the email list you sent. Column X will be used to update the status. Please let me know if any adjustments need to be made! Milestone Lead Tracker
@deleted-U04R23BEW3V this is perfect
@Cameron Rentch Excellent! Please let me know if there's anything else I can do to assist!
@deleted-U04R23BEW3V go ahead and circulate to the email distrobution thank you
The automation triggered this morning at 6:20 AM this morning. I'm seeing that the email for Yan bounced back. The automation is being adjusted to send to yashrapov@shield-legal.com. I'll send him the link through slack for today and he will receive the email automation beginning tomorrow.
@Cameron Rentch I just reviewed the email from Cynthia Tejada regarding Kay Lynn OβQuinn's AFFF-PFAS file. I created a new sheet for return requests from this case type. Please let me know if you require any additional information!
@deleted-U04R23BEW3V great, let's update the description on that specific entry so we do not show the lead "should not have been moved"
let's also get the list above from @deleted-U04HFGHL4RW added into the correct spreadsheet
@Cameron Rentch Updated the notes section! The other spreadsheet has leads that were declined in-house and not sent to the firm for billing, whereas this one is a finalized lead they are requesting a replacement for. I'll create a new tab on this spreadsheet to showcase the in-house declines and their reasons so they're all a part of the same spreadsheet.
got it @deleted-U04R23BEW3V thank you
Hi @Cameron Rentch. I know it's been a busy week. We received some replacement requests from Cooper Masterman regarding the Video Gaming Sextortion campaign. I have categorized the replacement requests on the sheet below. Please let me know if you require any additional information! Video Gaming Sextortion Cooper Masterman AWD Replacement Requests
@deleted-U04R23BEW3V @deleted-U04HFGHL4RW on the non responsive we are required to reconnect the clients to the firm or we have to accept return.
@deleted-U04R23BEW3V can you post me the return requests from TVM?
@Cameron Rentch I've been working on adding to this list. It's currently sorted by cases that are awaiting approval TVM Replacement Requests
@deleted-U04R23BEW3V tomorrow am can you please run deep dive past 10 days for: Santa Clara Juv Mormon LDS
@Cameron Rentch absolutely! It'll be my first priority tomorrow!
@Cameron Rentch I'm working on those deep dive reports for you. Is there a specific Mormon campaign you want me to focus on or would you like a report with all of the campaigns?
please dig into all of them over the past 10 days
Sounds good! I'll separate each tab by campaign for your ease.
@Cameron Rentch I've separated the Mormon report by firm. Among the open campaigns, only AWKO and DL Flatirons received leads that were disqualified in the last 10 days. All leads generated in the WS campaign were signed, however 2 were declined. Please let me know if you require any additional information! Santa Clara Deep Dive DQ 8/12/2025-8/21/2025 Mormon Deep Dive DQ 8/12/2025-8/21/2025
@deleted-U04HFGHL4RW we have a problem. We are supposed to be sending anything that is viable abuse, both in and out of SOL, for review to Abe. Perform Intake and send for review. I will text you and Delk but from what I see on this sheet there appear to be a lot that DL may sign up but we havent sent any reviews. Please ensure I am copied on all of the reviews as well.
@deleted-U04R23BEW3V can you pls share the Milestone sheet with Tony and Delk as well? Add them to the daily email.
@Cameron Rentch Absolutely! I added them to the email automation. They will begin receiving the updates tomorrow. I will send them the link as well so they can access the report immediately