@Cameron Rentch great! I can add another pivot table to sort by unique S1 if it’s helpful
@deleted-U04R23BEW3V sure that would be great. If you can name it "(case type) open status" , run for all torts for last week, then drop into the #CKWD7ASJU channel. Great job appreciate it
Hey @Cameron Rentch! I apologize for the delay on the DQ reports for today. I know you were made aware of the issue with AFFF leads generating in wrong campaigns yesterday. One of them was DQ'd and made it onto my Paraquat DQ report. Would you like me to remove that one before posting it in internaltraffic?
All good @deleted-U04R23BEW3V thank you!
@deleted-U04R23BEW3V can you please run and post all of the case reports "open status" from all of last week today so that the team can see last weeks leads? Then start on Monday for pirior weekes leads. Thank you!
@Cameron Rentch Do you want a date range included in the report title?
@deleted-U04R23BEW3V whatever the range is from last weeks leads. Ie Monday-Sunday
@Cameron Rentch Gotcha. They'll be named "(case type) Open Status 1/22/2024-1/28/2024"
@deleted-U04R23BEW3V can you please add Hair Relaxer, Ozempic, and Human Trafficking to the daily declines and weekly status reports
@Cameron Rentch Yes sir! I made a report for NJ Juv Hall Abuse as well. Should I keep up with that one as well?
Yes sir @deleted-U04R23BEW3V ! Thank you
Hair Relaxer Revisit These 4 hair relaxers were dq'd based on diagnosis SOL from the last 4 reports I've run. I can back track further to find more. Is there a date range you'd like me to target? I can go back through all of them we've ever done as well.
I also built a PFAS DQ report that I'll be running beginning tomorrow. There were none to build a report with for today
awesome @deleted-U04R23BEW3V thank you!
Hey @Cameron Rentch! We have been receiving replacement requests for the Ozempic Nigh Goldenberg case over the last 2 days. I have been tracking them on a sheet similar to the AFFF ELG replacement requests. In total, they have requested 6 replacements, 3 of them do not meet criteria (non-qualifying diagnoses), but the other 3 do meet the agreed upon criteria. Our criteria does not mention an SOL with regards to when Ozempic was made available, it also does not detail the dosage and frequency of usage that the firm deems acceptable. The sheet has 4 tabs for the reasons the firm requested the replacements.
@deleted-U04R23BEW3V thank you let me review
@deleted-U04R23BEW3V do you have a single folder link that contains all of these DQ reports(so I can send one link rather than each link individually?) AFFF DQ Report 2/26/2024 Asbestos DQ Report 2/26/2024 CA Juv Hall Abuse DQ Report 2/26/2024 CL DQ Report 2/26/2024 CPAP DQ Report 2/26/2024 IL Juv Hall Abuse DQ Report 2/26/2024 MD Juv Hall Abuse DQ Report 2/26/2024 MI Juv Hall Abuse DQ Report 2/26/2024 NJ Juv Hall Abuse DQ Report 2/26/2024 Ozempic DQ Report 2/26/2024 Paraquat DQ Report 2/26/2024 PFAS DQ Report 2/26/2024
@Cameron Rentch I can make a Google Drive with each individual file or I can combine all of them to be in separate tabs
oh I like the combined with tabs! please and thank you!
Would you like me to combine all DQ's into one file with separate tabs in the future?
yes please I think it is easier to review and manage, do you agree?
@Cameron Rentch DQ Report 2/26/2024 All DQ reports will look like this moving forward
@deleted-U04R23BEW3V great! last thing lets remove the "last name" from the reports please
Hey @Cameron Rentch! I'm working on the report with all Finals from the last 7 days and I just noticed there aren't S1's in Firefighting Foam - BG - Meirowitz Wasserberg
I'm seeing conflicting information in the Firefighting Foam - Bailey Glasser - Shield Legal campaign as well
@deleted-U04R23BEW3V I need a list of e signed that do not have S1. Please ensure the LEADId from LeadsPedia is contained within the report. I also don’t understand what you mean by “conflicting info”?
The field highlighted in yellow (Case Type) has a different campaign name from what's listed at the top. They're both Bailey Glasser but the one below indicates that it's supposed to belong in the BG Bowersox case type
@Cameron Rentch AFFF Missing S1 Here's the sheet for the missing S1's. Anthony Soboleski helped me get to the bottom of why they're missing. All of the leads originated in other campaigns that have since closed. When the leads were moved to new campaigns, the S1's did not transfer because LawRuler does not recognize our S1's as a standardized field, they are considered custom fields, so any time a leads is moved from one campaign to another, the S1 remains in the original inquiry notes but does not transfer to the new S1 field. I apologize for any confusion I may have caused.
Hey @Cameron Rentch! We have a few Human Trafficking Van HRSC cases that haven't been finalized yet but will be soon. Should I upload them as they come in or wait until tomorrow's 9:30_10:00AM window?
@deleted-U04R23BEW3V sorry just saw this...you can upload them as they come in
@deleted-U04R23BEW3V can you add these campaigns to daily reports, dq weekly, signed weekly, and open? Tepezza NJ Juv Hall Seventh Day Adventist Polinsky
@Cameron Rentch Absolutely! I've been running NJ and Seventh Day Adventist. NJ has DQ's from time to time but not too often. Haven't seen any for Seventh Day Adventist. I'll build Tepezza and Polinsky reports now
@Cameron Rentch I had considered the possibility of a fake Enrique Iglesias but didn't want to discount the possibility of the existence of another🤣
I fully agree. I'll do some digging to make sure this person isn't a fake claim
@Cameron Rentch Turns out Enrique Iglesias was indeed at Camp Lejeune. Perhaps it served as inspiration for his successful singing career lol
wow @deleted-U04R23BEW3V lt everyone know! lol crazy
@deleted-U04R23BEW3V what is your email address? Going to add you to a discord chat so I can have you add the tik tok reports to the tik tok team directly
work: jackson@tortintakeprofessionals.com personal: jacksonnakagawa@gmail.com
sent to your gmail account
.teriyakipapi but I should just appear as Jackson Nakagawa in the server
@Cameron Rentch hey! Jake just asked me if I could add which ad account each offer is in for the next report. I’d be more than happy to, I’m just not entirely sure what he means
@Cameron Rentch hey Cameron! I was near completion in my DQ report for yesterday but I have been pulled into a Law Ruler meeting without an end in sight. I sincerely apologize for the delay. I owe you a double report for tomorrow
Hey @Cameron Rentch! While I was doing my DQ report, I found this lead that was generated yesterday in Paraquat 1 DLG. No S1 on the file. Just wanted to make you aware. If there's anything you need me to do with it, please let me know
Hey @Cameron Rentch! I went to post the link to All Campaign Finals 4/1/2024-4/7/2024 in the discord and for some reason I no longer have access to the channel to post in
all good @deleted-U04R23BEW3V thank you
@deleted-U04R23BEW3V can you please add Round up to your daily diso reports?
Hey @Cameron Rentch! I just wanted to point out a change I've noticed in the Camp Lejeune leads we've been receiving since Tuesday. I've noticed a huge influx of primarily Spanish speaking PNC's with little to no knowledge of what Camp Lejeune is. There are 2 S1's that I've noticed this pattern with. I'll attach them below. PL-FacebookMB-CPF23 PL-FacebookMB-CPF24
thank you @deleted-U04R23BEW3V good eyes here!
@Cameron Rentch Happy to help! Today's DQ report will reflect this as well. I can highlight the affected rows if it would be helpful
Hey @Cameron Rentch! Should I only include Tik Tok S1's in the DQ reports I post in the Discord or can I post the full version there?
yes @deleted-U04R23BEW3V please and thank you!
Hey @Cameron Rentch! We are still receiving lots Camp Lejeune leads with PNC's that speak Spanish only and have never been to Camp Lejeune. I spoke with an agent who speaks Spanish and it appears that all of the PNC's are under the belief that the form they filled out is a job application. I'm not certain if the inquiry they're responding to is in Spanish or if it originally was in English and their phones translated the inquiry into Spanish. Just wanted to let you know that it's still happening and we now know what the PNC thinks they're signing up for. The S1's the leads are coming from are: PL-FacebookMB-CPF23 PL-FacebookMB-CPF24
thanks @deleted-U04R23BEW3V let me dig further into this...
@Cameron Rentch no problem! If there's any way I can help, I'd be more than happy to
thanks you sir!
@deleted-U04R23BEW3V hello sir! can you please add cumberland and paraquat to your daily DQ and Open reports?
Hey @Cameron Rentch! Just wanted to give you an update on the health of those Camp Lejeune S1's. The inquiries as of late have been mostly the correct audience. The amount of inquiries from Spanish speakers who think they're inquiring about a job have been much fewer and further between over this last week.
Hey @Cameron Rentch! I just received an email from Epic Games (owner of Fortnite and many other games). The email states that they have updated the terms of service for their games. I clicked on the Fortnite link and I believe subsection 3 might be of interest to our company. I’ll include screenshots as well as the direct link to the website for you.
Hey @Cameron Rentch! Hope you had a great 4th! We have been receiving replacement requests from ELG for both PFAS and AFFF lately. I'm working on revamping the AFFF tracker. I should have it done before the end of the day. Here is the link for the PFAS Replacement Requests
Hey @Cameron Rentch! The ELG AFFF Replacement Requests sheet is updated as well. If there are any additions to this sheet or the PFAS Replacement Requests, please let me know!
Hey @Cameron Rentch! We received a replacement request from Walsh for an Ozempic case. The one we received today is on the Non-qualifying Diagnosis tab. The email we received was very vague and did not provide any insight as to why they will not be accepting the case. Based on previous replacement requests, my belief is that it has to do with the injury being related to the gallbladder. We have received previous replacement requests due to the injuries being gallbladder related, however we have never received guidance from the firm to update criteria to reflect that they aren't accepting gallbladder related injuries. I will leave the link to the sheet below
Thank you @deleted-U04R23BEW3V illl look into it
Hey @Cameron Rentch! I've made some updates to the ELG PFAS Replacement Requests sheet to reflect the replacement requests that we've received over the last 2 days. There are 2 new tabs for Insufficient Latency and Exposure.
I also just finished adding to ELG AFFF Replacement Requests
Hey @Cameron Rentch! Hope all is well! These are all of the ELG PFAS Replacement Requests that have been sent to us as of this morning. The 3rd to last column from the right designates whether or not each case meets criteria, and the final column is an explanation. If there are any additional details needed, please let me know.
Hey @Cameron Rentch! We received multiple leads from this S1 yesterday (PL-FacebookMB-MLMDJUVEFORM1) from PNC's attempting to sign up for a CA Juv Hall case but the S1 is directing the inquires to MD Juv Hall BG Meirowitz Wasserberg campaign. Just wanted to give you a heads up about it. It accounts for 3/5 MD Juv Hall DQ's from yesterday
@deleted-U04R23BEW3V who is the contact at ELG that is sending the requests for replacements
@Cameron Rentch All of the replacement requests have been coming from Julius Toleco. I apologize. I'll add that column to the PFAS sheet
all is good @deleted-U04R23BEW3V aside from the dual reps ELG will be taking all of the PFAS. thanks again
@Cameron Rentch excellent! It was my pleasure! I’ll make the appropriate adjustments to the sheet
@deleted-U04R23BEW3V can you send me repalcment requests for ELG Ibrahim campaign?
@Cameron Rentch Absolutely! Would you like me to add it to the existing ELG replacement request sheet or make a fresh one just for this campaign?
I think adding to the existing sheet for continuity sake is probably the right idea
I agree, howver can you please run a separte sheet for me as well for this campaign? thank you
Of course! Give me about 5 minutes and I'll send it your way
Ibrahim ELG Replacement Requests ELG AFFF Replacement Requests There are 2 Ibrahim replacement requests. Both sent by our friend Julius Toleco
Hey @Cameron Rentch! We got a few peculiar Ozempic replacements requests from Walsh. All of them qualify under the criteria we have. One of them (568027) was an error on our end where a box was clicked mistakenly that should not have been but qualifies otherwise. They are all on Ozempic Replacement Requests in the "Non-Qualifying Diagnosis" tab.
@deleted-U04R23BEW3V can you please add Dacthal to DQ send me to me for review asap? We have a call with the firm shortly thank you!
Absolutely! Give me just a few minutes and I'll have that over to you!
I'll be adding all DQ's for Dacthal to this report and running it on a daily basis with the rest of the DQ's from here forward
@deleted-U04R23BEW3V can you pls post here?
I can separate it into it's own report as well if that would work better for your meeting
this is great thanks @deleted-U04R23BEW3V
@deleted-U04R23BEW3V my man! doing a great job can you pls add the other new campaigns to the DQ daily if you have not yet? NH Abuse, Liquid destroyed embryos, video game sextortion
@Cameron Rentch yes sir! Thank you! Added sextortion this morning. I'll build the NH and Liquid Embryos right now and add them to today's report!
@Cameron Rentch Report is updated! No leads from Liquid Embryo. 2 NH Juv Hall DQ's
Hey @Cameron Rentch! I'm not sure if you're the right person to bring this up with but CA Juv Hall Miller Nielsen doesn't have a Form Fields tab, so S1's generate in the initial posting of the lead but without the Form Fields tab, all S1's need to be added manually into the reports. Just wanted to bring that up. If it's not a big deal for your purposes, I totally understand. I have no problem adding it manually, but others who utilize the reporting functions and are less familiar with the system might have trouble finding it.
Hey @Cameron Rentch! I got these requests in the Tik Tok discord this morning. Just wanted to check with you to make sure with you I’m authorized to send a report like this to them
@Cameron Rentch I created these in accordance with their requests. Let me know if there are any edits I need to make prior to sending or if I shouldn't send them at all. Tik Tok DQ's 1/1/2024-9/30/2024 Tik Tok Finals 1/1/2024-9/30/2024
Hey @Cameron Rentch! I'm not sure who this person is (or why the child in the photo is holding an AK) but I wanted to check with you before I send anything
Hey @deleted-U04R23BEW3V it’s ok lol this is Maximus he is one of our media buyers.
I think he is trying to match up to ensure the leads are coming in properly. We are having some glitch issues with a zapier integration
Gotcha! I just got thrown off because he was asking for the phone numbers and emails of the clients. Didn't want to breach any privacy regulations without checking first lol
@deleted-U04R23BEW3V Maximus got everything from Brian Hirst just fyi.
Excellent! Thank you for getting back to me! I know you've been super busy this week @Cameron Rentch
@deleted-U04R23BEW3V can you run a DQ report from PA juv abuse from this date range? 10/7-10/23 we started to scale ads but have not seen as much conversions as we would like
@Cameron Rentch PA Juv Hall DQ 10/7/2024-10/23/2024 Sorry it took so long. Had a minor wrist surgery this morning lol let me know if there’s anything else this report needs!
Hey @Cameron Rentch! In light of those changes to the Depo-Provera criteria, I'll be going back though my dq reports to designate files that we need to revisit to qualify. I can send you the full list of all files I take action on if you'd like. If not, no worries!
@deleted-U04R23BEW3V looks like 618964 would qualify now, had 3 injections and diagnosis
Caught that one. All of the files on that sheet are being changed to revisit lead. I'll have a supervisor direct agents to give these leads the highest priority to call back
@Cameron Rentch All files are now appropriately updated. I have high hopes for quite a few of these
Hey @Cameron Rentch. I'm noticing while I do my DQ report that NEC Baby Formula - LegaFi does not have an S1 field in the Form Fields tab. The S1 populates in the notes generated from the initial inquiry.
On an unrelated side note, I was informed you're a fan of the DC football team (they're still the Redskins as far as I'm concerned). Congratulations on acquiring Marshon Lattimore. Great things are on the horizon for that franchise
and YES for getting Lattimore! Big win for us!
@Cameron Rentch I'm a huge Jayden Daniels fan! Loving what I'm seeing from him! Any team that beats the Cowboys twice in a year is worth rooting for in my book
Hey @Cameron Rentch. I compiled a list of the Bard PowerPort leads that were sent back from Bay Point today. If you require any additional details to help make a decision, please let me know! Bard PowerPort Replacement Requests
@Cameron Rentch Mortgage Race All Time DQ If there is anything missing from this or any files you'd like me to mark for agents to revisit, please let me know!
Hey @Cameron Rentch! We just received more replacement requests from Bay Point for Bard PowerPort. If you require any additional information about these, please let me know! Bard PowerPort Replacement Requests
thanks @deleted-U04R23BEW3V I will review
@deleted-U04R23BEW3V I am trying to see why these "dont meet criteria" what sheet are the referencing on the comments? Can you help me understand more
@Cameron Rentch Unfortunately that was all of the information they gave us. I reviewed each case carefully. From what I can tell, all of those cases meet criteria (before and after the changes) except for the bottom 3 but we never finalized the bottom 3
Hey @Cameron Rentch. Looks like the Form Fields tab is missing from the AFFF BG Bowersox ELG campaign. The data is still being captured in the notes section!
Hey @Cameron Rentch! Tony informed me that you're in need of an all time report for Oxbryta. If any additional detail is required, please let me know! Oxbryta All Time
@deleted-U04R23BEW3V
need to know why declined
621515 11/1/2024 Stubby Disqualified PL-FacebookMB-MLtest1
628610 11/12/2024 Link Disqualified Death after taking Oxbryta PL-FacebookMB-MLtest2
621513 11/1/2024 Saleh Disqualified PL-FacebookMB-MLtest1
626603 11/11/2024 Humberto Disqualified PL-FacebookMB-MLtest2
627252 11/12/2024 Deborah Disqualified PL-FacebookMB-MLtest_2
The 3rd tab at the bottom has the DQ report
3/4 No exposure leads say they did not submit their inquiries 621515 Stubby 621513 Saleh 626603 Humberto
The 4th (627252 Deborah) stated she never used Oxbryta
628610 Link is a PNC who passed away in Georgia in 2021 which is outside the SOL @Cameron Rentch
@deleted-U04R23BEW3V for the Bard powerpoint return requestes, can you please run a report of requested returns, review most recent criteria and provide me with a detailed reason on why we show the lead DOES qualify if it appears it should? Need ASAP. thank you!
@Cameron Rentch I added a new tab to the bottom of the Bard PowerPort Replacement Requests report.
I found 3 cases that are possibly questionable while the rest check out:
Line 4 (596755 Karen Wyatt) seems like a weak case despite meeting qualifying criteria. She stated she removed the ports herself and also stated she required surgical intervention. I'm under the impression she had an IV in her arm but the location of the port system was not detailed in the file or on the call. The thought of removing a PowerPort on your own sounds excruciating and gives me visions of Tony Stark installing that power core in his chest.
Line 7 (593263 Luvasia Greene) appears to toe a fine line. The port's "migration" was the port sinking into the PNC's hand due to a nurse exerting too much pressure while giving the PNC a medication dose. I'm not sure if that would fall within the definition of "migration."
Line 9 (581374 William Cook) may not have had a qualifying device. He stated he received it following a severe car accident and needed surgery to repair his ruptured spleen. He's positive it was a PowerPort model but this is not in alignment with any uses I've ever encountered for this device.
Hey @Cameron Rentch. I believe there's an issue with this S1: PL-FacebookMB-MLMDJUVEFORM1 It's attached to MD Juv Hall campaigns but 2/4 DQ's from yesterday are PNC's who were incarcerated at Chowchilla and were under the impression that their inquiries were for the Chowchilla case.
@deleted-U04R23BEW3V thanks I will take a look
@deleted-U04R23BEW3V can you send me the claimants information on these?
639465 - Trinity Burright - Case ID: 6FBP1KTD -
639474 - Altanea Brown - Case ID: LRTB9GFQ -
Hey @Cameron Rentch! When I ran my DQ report for Paraquat this morning, I noticed an issue with this S1: PL-FacebookMB-JACMP-ParaquatForm05 All of the phone numbers are from the Dominican Republic. I created a separate report with all of this information. Please let me know if there is anything additional you'd like to see in this report. Paraquat DQ Report 12/5/2024
@deleted-U04R23BEW3V I need the phone numbers please
sorry that was meant for someone else lol
Hi @Cameron Rentch! Hope all is well. I'm completing the Open Status Report for last week. I noticed in the Chowchilla ACTS DL/Flatirons campaign, some leads have multiple Case Descriptions. From my understanding, that's the Leadspedia identifier. I've made a spreadsheet with the leads and the Case Descriptions. None of the signed leads from last week had this issue. All of the notes sections of these leads in Law Ruler look like the screenshot I've attached below. If I see this in any other case types, I will notify you. Chowchilla ACTS DL Flatirons 2 Case Descriptions
Thanks @deleted-U04R23BEW3V let me take a look
@Cameron Rentch Open Status report is now complete. No other instances of this to report on🫡
Hey @Cameron Rentch! As I'm doing my DQ reporting, I'm noticing that we received a large influx of leads yesterday at or around 9:20 AM and the automation that populates the form fields seems to have encountered an error of some sort. The leads are coming in without the S1 or any information from the inquiries. Thus far, I've observed this in AFFF DL Flatirons and Bard PowerPort Bay Point Simmons. Is this something you'd like me to create a report detailing?
@Cameron Rentch Will have that to you shortly! This issue will likely result in the numbers of my Friday Tik Tok S1 reporting being incorrect. Should I preface Yan with that when I send that report?
@Cameron Rentch Please let me know if any additional information is necessary in this report! No S1 Leads 12/19/2024
@deleted-U04R23BEW3V can you please update the daily open and DQ for Prvate boarding school abuse, Il foster, and any other torts not added? thank you!
@Cameron Rentch yes absolutely! IL Foster has been on the DQ reports this week, haven’t seen any leads come in for NY school abuse. I’ll double check to make sure I didn’t miss any others!
Hey @Cameron Rentch! No problems to report on today. Just wanted to pass along congratulations on the success of Washington Commanders! Considering my Packers early postseason exit, I’ll be a full time Commanders fan until further notice. Excited to see what the future has in store for them!
Let’s goo!!! Sorry to hear about your Packers. I was cheering for them.! @deleted-U04R23BEW3V
It was a tough game against a tough opponent. Looking forward to next season. Until then, go Commanders! @Cameron Rentch
@deleted-U04R23BEW3V can you pls send the the latest DQ report on Button Batteries
On it! We last got leads 1/16/25. Would you like only leads from that day or all DQ's for the campaign?
@Cameron Rentch I've added a filter to the columns. If you'd only like to see leads generated on specific dates, the filter will be able to parse those out. Please let me know if there's anything else I can do to help! Button Battery DQ Report
Hey @Cameron Rentch! Just wanted to give you an update. All LA Wildfire leads from yesterday came in with S1's, however none of the MI Pollution leads from yesterday had S1's. I'll notify you if I observe any changes in the future
Hey @Cameron Rentch! We've received 2 replacement requests from VAM about AFFF leads whose diagnoses exceed the latencies outlined in the criteria. One of them appears to have been handled already. I have a spreadsheet with these files outlined. If there's any additional information required, please let me know! AFFF VAM ELG/ML Replacement Requests
@Cameron Rentch Tony asked me to create a report for LA Wildfires DQ's dating back to 1/25. There are some odd circumstances that kept a few clients from meeting criteria (homeless clients, clients living in treatment facilities, etc.). From what I've gathered, these clients would not qualify as of today. If you require any additional information, please let me know!
Thanks @deleted-U04R23BEW3V I will review
@deleted-U04R23BEW3V on the LA wildfires can you please ad the S1 tags AND/or referring URL(if you can see it?)
@Cameron Rentch S1's are in. Created a pivot table on the second tab for the S1's. If there's anything else I can do to help, please let me know
Hey @Cameron Rentch. Tony wanted me to revisit this Nations AFFF replacement request report. I narrowed the list down to the 7 that haven't been declined already. The results of my review are notated in column Z. As always, if any additional information is needed, please just let me know!
@deleted-U04R23BEW3V I will review
Hey @Cameron Rentch! During my reporting, I've noticed a couple of situations that seem related that I wanted to share with you. They all revolve around 1 Chowchilla (Chowchilla Womens Prison Abuse - DL - Flatirons) campaign and a couple of Paraquat campaigns. We're seeing instances in Chowchilla where a PNC will fill out an inquiry through Facebook, then the algorithm will recommend other inquiries to the PNC, which the PNC also fills out. When the additional inquiries are submitted, the original lead created from the first inquiry is updated with the information from the additional inquiries, resulting in 1 lead having multiple S1's and Leadspedia ID's. Here are some example files where I've observed this: 679600, 681066, 678476, 680356. I believe this to be the result of Law Ruler matching the contact information of the PNC with the existing contact card, prompting an update to the original leads, rather than creating separate files for each inquiry. It is most likely due to multiple S1's being designated for a single campaign. Conversely with Paraquat, we're seeing the same PNC create multiple files off of inquiries where S1's point at different Paraquat campaigns (ex. 681640 in Paraquat 12 - DL - Flatirons and 681638 in Paraquat - AWD - Wagstaff).
@deleted-U04R23BEW3V lets review this tomorrow on a call
@Cameron Rentch yessir! Any time that works for you is fine by me. If you’d prefer a phone call to a Slack huddle, my phone number is
@deleted-U04R23BEW3V I will let you know
Hi @Cameron Rentch! Tony asked me to create a report based on an email we received from ACTS. This is regarding LA Wildfire files we've sent them. The majority of the files in question seem to have clients who are not responding to ACTS's attempts to reach them. I went back to review all of the calls. All of the clients seemed highly motivated at the time of the intake to complete the process. I did find 2 instances that might not meet criteria (those files are highlighted yellow). I'll include a screenshot of the email ACTS sent regarding these clients. Please let me know if any additional information is needed. LA Wildfires ACTS Replacement Requests
Great work @deleted-U04R23BEW3V I will review.
Hey @Cameron Rentch! It's been brought to my attention from the intake floor that there's a specific S1 in Paraquat - AWD - Wagstaff (PL-FacebookMB-JACMP-ParaquatForm010) that is generating a high number of leads with non-qualified PNC's. The vast majority of these PNC's are Spanish speakers who believe they are applying for a job. If I'm not mistaken, we had a similar issue with a Camp Lejeune S1 late in 2023. I've compiled the last week's worth of leads in a spreadsheet and a pivot table to highlight the S1 that is behaving abnormally. Please let me know if you need any additional information. Paraquat AWD Wagstaff S1 Check
Oh I see. My report is showing something entirely different. Let me troubleshoot and get back to you
just download the file I sent you via email and open
My date field looks like it's formatted correctly. I'm not sure why it wouldn't be a direct reflection on your end. Anthony and I will do some more testing.
that is when I download the excel file
@Cameron Rentch gotcha. Are you using the Microsoft version of Excel or are you using the Mac equivalent?
@deleted-U04R23BEW3V see if you can send as a google doc, so that is populates daily and I can leave up in by broser
I see. Since you’re on a Mac, it’s probably just converting those date fields incorrectly when the file opens because Microsoft and Apple aren’t the best at communicating with each other.
And yes we can definitely do that! I’ll have the automation send the link to the Google sheet in the email, that way the email acts more as a reminder and verification that the update successfully ran.
ok thanks @deleted-U04R23BEW3V is there a way to have the automation run at 12, 4, and 8 or is that too much "pull"
I need to really watch these campaigns closely
Absolutely! I can set the intervals for as often as you'd like. We could even run it on an hourly basis
No problem! I'll let you know when it's up and running. I am getting started with backfilling the previous e-signs from those campaigns.
@Cameron Rentch No problem! I have the update automations setup for 12, 4, and 8. The automation that triggers the email is separate from the update automation. Would you like an email about the updates at the same intervals?
@deleted-U04R23BEW3V yes please send me a link to the google sheet and I will refresh it
@Cameron Rentch Perfect! I'll set the automation to also trigger the email when the updates occur. Here is the link to the google sheet https://docs.google.com/spreadsheets/d/1cKHtUmpDD9sYMUoQ8XnzjDTIqiy08BuxBC30EPFsGRo/edit?usp=sharing
@deleted-U04R23BEW3V is there are reason that column E on paraquat is not "yes" for all intakes?
also Tony mentioned that we have two e-signs today for AFFF , but I dont see them on the sheet here?
Double checking on the paraquat files. The automation that's scheduled to run in this hour hasn't triggered yet. Anthony says his Stock Fraud automation that's scheduled for 8-9pm usually kicks in closer to the 8:30 mark.
Looks like I missed the diagnosis field when I pulled the backlog information. Filling those fields in now
Regarding AFFF, I'm only seeing 1 finalized AFFF for today. The second signed ML AFFF is still in PD and will reflect on the 8pm update if finalized
@deleted-U04R23BEW3V report is perfect BTW. Appreciate it! Can you please add "Andy@shield-legal.com" and "marc@sunrisessm.com" to this daily email alert and permissions?
@Cameron Rentch Excellent! It was my pleasure! I'll add those emails to the distribution right away
@deleted-U04R23BEW3V good morning can you please add jbecker@meadowlawfirm.com to the permissions and daily emails for the Meadow AFFF/Paraquat google sheet? thank you!
@deleted-U04R23BEW3V can you please share the AFFF/Paraquat sheet with Caleb and Jack (media buyers) caleb@shield-legal.com jack@shield-legal.com
add persmissions and I will drop them the link...
just let me know when permissions are updated
Hey @Cameron Rentch! We've been receiving replacement requests from Bailey Glasser for various IL Juv Hall campaigns. 5/6 requests are due to the PNC already being represented by Bailey Glasser. None of these clients were previously signed through TIP so no duplicates exist in Law Ruler. The 6th request is because the PNC is deceased. The inquiry was submitted by the PNC's mother. The file should have been flagged and declined according to our process. I have compiled these requests into a google sheet. If you need any additional information about these files, please let me know! Bailey Glasser IL Juv Hall Replacement Requests
@deleted-U04R23BEW3V these should all be returned. Please let Tony and Ryan know to remove from systems and dashboards etc. Ty!
@deleted-U04R23BEW3V can you please send me a deep dive DQ and Open list for firefoam for this week (Starting on Monday through yesterday)?
thanks @deleted-U04R23BEW3V let me know
@Cameron Rentch I have about 150 calls to listen to. I should have this ready for you by mid-afternoon
thank you @deleted-U04R23BEW3V greatly appreciated!
@Cameron Rentch AFFF Deep Dive is ready! I've highlighted the leads that appear to be spam inquiries. The criteria I used for identifying possible spam are leads with: multiple inquiries in short succession, and PNC's who stated they did not submit an inquiry. Please let me know if there's any additional information you need! AFFF Deep Dive DQ 2/24/2025-2/27/2025
Amazing thank you @deleted-U04R23BEW3V will go through this tonight!
@deleted-U04R23BEW3V do you have the following:
total Firefoam leads ingested into lawruler 2/24-2/27 total signed total open
@Cameron Rentch Total Ingested: 343 Total Signed: 14 Total Open: 329
ok So, can we confirm this is accurate:
Total ingested = 343 Total signed = 14 Total open = 329 Where are the 216 in the deep dive, are they on top of the total? Sorry tying to get accurate counts
No worries! The 216 from the deep dive are included in the 329 open. The discrepancy of 113 are files that have not yet been contacted.
ok so then:
Total ingested = 343 Total signed = 14 Total "closed" = 167 (rejected, opt out etc) *does not include "cant contact" Total open = 162 open *includes "cant contact"
Total 4% e-sign conversion rate Total 48% DQ rate Total open (unable to reach yet) = 47%
Yes sir! My apologies. In my mind, Already Represented and Disqualified for no diagnosis could still potentially qualify later down the line if they decide to change representation or receive unfortunate medical news. Should I not include these disqualified statuses in my Open Status reports?
Note conversion rate for Firefoam has declined steadily since November, where criteria has been the same (with exception of a small window of time where no firms accepted thyroid disease)
October = 14% November = 12% December = 11% January = 9% February = 9%
The good news is that last 7 days conversion rate has jumped to 10%. For this campaign to be successful we need a minimum 17% conversion rate
My large concern is the inability for us to reach people (large number of "open" leads still.
Agreed. The contact rate has been significantly down compared to what we're accustomed to seeing. I'm not certain of the exact timeframes, but I do know there is a dedicated portion of the day where AFFF is the primary focus of our outbound dials, however, the frequency of receiving spam inquiries has made the numbers in the last 3 weeks much messier.
hey @deleted-U04R23BEW3V I think you are missing some e-signs - I am showing 44 AFFF signed 2/24-2/27
are you counting the e-signs we move manually to Nations/Levinson campaign?
@Cameron Rentch I missed that campaign in my pull. Let me rerun those numbers
Total ingested = 375 Total signed = 38 Total open = 197 Total closed = 170
Total signed discrepancy is 6. Does the dashboard you're looking at account for only leads created on those dates?
could be ones that were not removed from system yet?
I ran an additional report on all leads whose status changed to Final from 2/24-2/27. The report is showing 47 finals during that timeframe.
My initial report only included leads created within 2/24-2/27
Ok then here are numbers:
Total ingested = 343 Total signed = 47 (14 ELG/Meadow, 33 Nations/Levinson) Total "closed" = 167 (rejected, opt out etc) *does not include "cant contact" Total open = 162 open *includes "cant contact"
Total 13% e-sign conversion rate Total 48% DQ rate Total open (unable to reach yet) = 47% • Note highlighted yellow leads of 32 accounts for "spam" related leads (accounts for 9% of leads, which is slightly high but still within our standard deviation. Note that we can account for 5% of the spam leads from a specific batch of traffic that has been clipped/removed so we should see less next week) • Note the "total" numbers don't exactly add up because some of the leads were ingested prior to 2/24 Conversion rate Note conversion rate for Firefoam has declined steadily since November, where criteria has been the same (with exception of a small window of time where no firms accepted thyroid disease)
October = 14% November = 12% December = 11% January = 9% February = 9%
The good news is that last 7 days conversion rate has jumped up from 9 to 13%. For this campaign to be successful we need a minimum 17% conversion rate.
@Cameron Rentch confirmed! That is good news about the rise in conversion percentage but we still aren’t where we need to be. I will keep the 5% in mind when accounting for spam leads. As we move forward, if I notice a change in the spam leads trend as well as contact percentage, I’ll be sure to let you know.
Hey @Cameron Rentch! In light of the new Los Padrinos case, would I be allowed to go back through some of my old CA Juvenile Hall DQ reports to find PNC’s that were DQ’d for only experiencing physical abuse and have them revisited by our agents?
@deleted-U04R23BEW3V good idea but let's not do this yet
actually @deleted-U04R23BEW3V lets do this but ONLY for DL/Flatirons leads to start
@Cameron Rentch Would you like me to go back through all of the DQ's all time or only back to a specific time period to start?
@deleted-U04R23BEW3V look at the "year the incident occured", we are looking for 2023 or after
@Cameron Rentch I've identified 44 potential leads that might qualify for the new case. I've compiled them on the spreadsheet below. All of these are in the CA Juv Hall Abuse - ACTS - DL Flatirons case type. Los Padrinos Abuse DL Flatirons Revisit
Once the new case is active, it will be very easy to move these to the new case type
Great @deleted-U04R23BEW3V let’s do it!
@deleted-U04R23BEW3V good morning - can you please run me a report, for DL Flatirons NH Abuse, I am looking for the different facilities where the abuse occurred and the total counts
@Cameron Rentch The first tab has all of the raw data and the second tab has a pivot table of the facilities. I included all statuses (signed e-signs and disqualified). If you'd like me to filter out any unnecessary statuses, please let me know! NH Juv Hall DL Flatirons Facility Count
awesome @deleted-U04R23BEW3V!
@deleted-U04R23BEW3V
Can you tell me the diagnosis of each sign from today in #firefoam channel?
@Cameron Rentch 700729 - Alexander Washington - Liver Cancer 700282 - Lois Tryon - Hypothyroidism (Not yet finalized) 700648 - Opal French - Hyperthyroidism (Not yet finalized)
This is great. Can you create another sheet for me even if something isn’t finalized I want to be able to get the diagnosis as soon as it is populated into the channel.
Absolutely! Let me work with Sobo and we'll have a report for you ASAP
@deleted-U04R23BEW3V just need Intake number, diagnosis, s1
@Cameron Rentch AFFF e-Sign Diagnosis All AFFF e-Signs will now post to this google sheet
@deleted-U04R23BEW3V apologies can you add last name? Also how often can we have this populate?
@Cameron Rentch Absolutely I can add the last name! They populate within 3 minutes of the e-sign being signed
@Cameron Rentch Follow up question: we just had someone who needed an additional e-sign to amend their first. Do you want duplicates to populate or would you like those to be parsed out?
Hey @Cameron Rentch! I'm making a sheet for the Dublin replacement requests I was CC'd on. A few of the clients do not have any specifications about which piece of criteria that aren't met. Would you like me to reply in the email thread asking for additional clarification?
Hey @Cameron Rentch! I've identified 50+ previously disqualified leads in AWKO VGA that are worth revisiting due to the updated age SOL. The only difficulty with some of these is that most of the inquiries were originally submitted by the PNC's parents who do not have legal capacity to sign for the PNC as the PNC's are now over 18. Are these leads worth revisiting?
@deleted-U04R23BEW3V let me get with AWKO
Hey @Cameron Rentch! Just wanted to give you a quick head's up. I'll be out of the office from Friday 4/25/2025 - Tuesday 4/29/25. The regularly scheduled reports will be handled by Nyla Gaston in my absence, however I will be able to double check and distribute the reports as normal while I'm gone.
@Cameron Rentch I have the hypotheticals for the Transvaginal Mesh case below. Please let me know if there's anything I should change about these.
Ronika Love of Wisconsin had TVM implanted to treat POP in June 2019. In May 2022, she began experiencing pelvic inflammation and urinary dysfunction. At an appointment in August 2022, her doctor recommended the TVM be removed. The removal surgery occurred November 2022. This claim would qualify.
Heather Neel of Louisiana had TVM implanted to treat SUI in December 2020. In April 2021, she began experiencing pain during intercourse, pelvic pain, pelvic inflammation, and pressure on the nerves. At an appointment in May 2021, it was revealed that the mesh had eroded into her colon and the TVM was subsequently removed in June 2021. This claim would not qualify.
Justine Herbert of Oregon had TVM implanted to treat POP in May 2020. In July 2023, she began experiencing urinary dysfunction and pain during intercourse. At an appointment in October 2023, her doctor recommended the TVM be removed. The removal surgery occurred in December 2023. This claim would qualify.
Great job @deleted-U04R23BEW3V ! If you would like to email these to me I can forward and copy you and Tony.
@Cameron Rentch Here is the spreadsheet we are using to track NEC clients with their response to the Formula or Fortifier question. Please let me know if there are any additional fields you'd like to have on this sheet NEC - Formula or Fortifier
@deleted-U04R23BEW3V great if you can add claimant "last name" and the S1 tag that would be helpful
@Cameron Rentch added those fields and backfilled the information for the existing files
great thanks @deleted-U04R23BEW3V I cant say it enough THANK YOU! You are a rockstar my man!
@Cameron Rentch always happy to help! You have afforded me many opportunities to make an impact for a cause I believe in. Thank you!
good morning @deleted-U04R23BEW3V can you run me a deep dive of Soup Burn leads from yesterday? We had a big push on tik tok and only saw one sign up. My guess is that the traffic was not good. If you can dig in and send a report I would appreciate it!
@Cameron Rentch Absolutely! I have been seeing a large number of DQ's from that campaign lately. Most of the DQ's I've notice have been due to the PNC presently being over 19.5 years old and not having sought medical attention at the time of the incident. I'll detail further in the report.
@Cameron Rentch Please let me know if you'd like any additional information about these files! Instant Soup DQ Report 6/3/2025
Hey @Cameron Rentch! Sorry to be sending this to you so late on a Friday. We've received more replacement requests from Anapol Weiss for the TVM case. The number they've rejected is 15. Of those 15, I've identified 13 that either meet current criteria or met criteria to our understanding at the time of the e-sign. For context, the most recent update to criteria was agreed upon 5/6/2025. These files will be found on rows 50-64. The rows with yellow highlighted boxes detail the files and where they meet criteria. If you need any additional information about these files, please let me know! Have a great weekend! TVM Replacement Requests
thank you @deleted-U04R23BEW3V I will review
@deleted-U04R23BEW3V can you do a deep dive on bard powerport for this week? DQ and Open please! Thank you
@Cameron Rentch These leads are mostly DQ'd due to the PNC having an IV or a picc line. I did highlight the S1 of one file. The PNC did state that the ad they saw showed an IV so that could explain the prevalence of these types of files. Please let me know if you need any additional information! Bard PowerPort Deep Dive DQ 6/12/2025-6/18/2025
@Cameron Rentch I apologize for the delay of the deliver of those Mormon reports. I have 2 more that I'm still working with. I am on a time crunch today. My wife underwent surgery this morning and I need to be home to help her out. I'll finish those 2 remaining reports first thing tomorrow. I'm sincerely sorry about the inconvenience.
@deleted-U04R23BEW3V no need to apoligize, I was unaware of your wife surgery. Please take care of her and dont worry about any of this - family always first my man. You are a rockstar please let me know if you need anything from me!
@Cameron Rentch I heavily appreciate your kindness and understanding. She's recovering well and getting the rest she needs
Hey @Cameron Rentch! I've made some updates to the Replacement Requests sheet for Nations. Please let me know if you need any additional information to make decisions about these files! AFFF Nations Replacement Requests
There are 5 new additions to the Already Represented tab and 3 in the Client Opt Out tab
@deleted-U04R23BEW3V thanks I have updated entries please make sure you circulate to tony and team to process these!
@deleted-U04R23BEW3V can you pls forward me the TVM return requests from Anapol?
@Cameron Rentch Lines 50-64 are the newest additions. After reviewing the files, there were 2 that did not meet criteria at the time of signing and do not meet criteria now. The remaining files all met criteria at the time of signing and are highlighted in column I. Please let me know if you need any additional info! TVM Replacement Requests
@deleted-U04R23BEW3V can you please mark those 2 as "approved for return"?
Hey @Cameron Rentch! Hope your weekend went well! I'm auditing Chowchilla leads created between Friday and Sunday and noticed a couple of different issues. Some of these leads are PNC's that we've previously signed for different Chowchilla campaigns that the marketing for SGGH-Meadow reached again. Those 3 are at the top of this sheet highlighted in yellow in Column D. Additionally, I noticed a good number of these leads don't have S1's but were created through the API. I've included those leads in this sheet with yellow highlights in Column F. If you need any additional information, please don't hesitate to ask! Chowchilla Meadow SGGH 7/18/2025-7/20/2025
Hey @Cameron Rentch! I ran a DQ report for the new NEC AWKO campaign. I did notice that a handful of the files were created by the father of the PNC and many of them haven't been able to give definitive answers regarding the PNC's diagnosis. Those files could possibly convert if the father is able to find the appropriate information or if the PNC's mother calls in to provide a positive diagnosis. Please let me know if you need any additional information! NEC AWKO 2 DQ Report 8/7/2025
Hi @Cameron Rentch! Malissa just informed me that we received communication from the firm regarding the Northwell Sleep Center campaign. Their email seemed to intimate that we are sending them files with non-qualifying facilities still. This is not the case. The files they cited were Darlene Allen and Celestine Colombo, who were signed 7/31 and 8/1 respectively. Their clarification regarding the qualifying facilities was communicated to us 8/2. They appear to be requesting replacements for these files. I will create a spreadsheet and share it with you.
@Cameron Rentch please let me know if you require any additional information. Northwell Sleep Center LCA Slater Replacement Requests
@Cameron Rentch please let me know if you require any additional information. Northwell Sleep Center LCA Slater Replacement Requests