Cameron Rentch (cameron@internetthings.com)
2024-11-22 10:33:58

@deleted-U04R23BEW3V good morning! I need a new report if possible, every Friday, I need a google sheet report with all of the signed contracts from tik tok, with S1 tag, and by campaign. Can you make sure we get this by 10amPST?

Cameron Rentch (cameron@internetthings.com)
2024-11-22 10:35:02

If you can always simply send to Yan and tag him that would be great! thank you!

deleted-U04R23BEW3V
2024-11-22 10:37:36

@Cameron Rentch absolutely! I’ll get to work on that now! Is there a specific timeframe you’d like this report to reflect?

deleted-U04R23BEW3V
2024-11-22 10:49:02

@Cameron Rentch I do create a Tik Tok S1 Final report every Monday broken down by campaign. Should this one differ in any way?

Cameron Rentch (cameron@internetthings.com)
2024-11-22 11:11:48

This can be the same report. I am looking for it on Friday mornings from the previous seven days perhaps we change and run every Friday.

➕ Yan Ashrapov
deleted-U04R23BEW3V
2024-11-22 11:13:50

All Campaign Finals 11/11/2024-11/17/2024 Understood. This is the most recent version of that report. If there are any changes necessary to the layout, please let me know. I can run a new version to cover 11/15-11/21

Cameron Rentch (cameron@internetthings.com)
2024-11-22 11:21:48

@Yan Ashrapov ^^ thank you @deleted-U04R23BEW3V you are a rock star!!

deleted-U04R23BEW3V
2024-11-22 11:23:43

My pleasure! I'm running a version for 11/15-11/21 now. I'll start running this on Friday's instead of Monday's in the future.

✅ Yan Ashrapov
Cameron Rentch (cameron@internetthings.com)
2024-11-22 11:25:28

perfecto!

deleted-U04R23BEW3V
2024-11-22 12:03:29

Nearing completion. Apologies for the delay. Will be ready within the next 10 minutes

deleted-U04R23BEW3V
2024-11-22 12:09:55

Tik Tok S1 Finals 11/15/2024-11/21/2024 @Cameron Rentch @Yan Ashrapov

✅ Yan Ashrapov
🙌 Cameron Rentch
Yan Ashrapov (yashrapov@shield-legal.com)
2024-11-29 11:46:28

Hey @deleted-U04R23BEW3V just a reminder that we need reports every Friday - google sheet report with all of the signed contracts from TikTok Thank you

deleted-U04R23BEW3V
2024-11-29 11:46:43

Working on it as we speak

💯 Yan Ashrapov
deleted-U04R23BEW3V
2024-11-29 12:22:12

Tik Tok S1 Finals 11/22/2024-11/28/2024

🙏:skin_tone_4: Yan Ashrapov
Yan Ashrapov (yashrapov@shield-legal.com)
2024-12-01 03:26:05

*Thread Reply:* @deleted-U04R23BEW3V Can we please double check this? I'm seeing more contracts signed on those dates for Depo (5), Chowchilla(6) and AFFF (12)

deleted-U04R23BEW3V
2024-12-02 10:43:24

*Thread Reply:* Let me look into this! Please standby

👍:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2024-12-02 12:37:54

*Thread Reply:* I'm seeing 11 in AFFF. The additional sign up occurred over this weekend after I pulled my report. I'm still only seeing 3 finals in Chowchilla and 2 for Depo for these dates. It's possible that leads generated beyond the date range of this report were signed during that time.

deleted-U04R23BEW3V
2024-12-02 12:38:13

*Thread Reply:* The additional AFFF sign up is now reflected on this report

Yan Ashrapov (yashrapov@shield-legal.com)
2024-12-02 12:39:13

*Thread Reply:* @deleted-U04R23BEW3V weird. Media buyers confirmed the numbers I've sent

deleted-U04R23BEW3V
2024-12-02 12:40:03

*Thread Reply:* These numbers are specific to Shield Legal campaigns. Is it possible they're accounting for BLX in their count?

Yan Ashrapov (yashrapov@shield-legal.com)
2024-12-02 12:41:10

*Thread Reply:* Not from what I've gathered. Only Shield's campaigns.

deleted-U04R23BEW3V
2024-12-02 12:42:41

*Thread Reply:* That's interesting. Is there any way I can get a list of the campaigns they're looking at so I can do an additional check against what I'm reporting on?

deleted-U04R23BEW3V
2024-12-02 12:44:02

*Thread Reply:* Better yet, if it's possible for me to get a list of the leads their numbers are reflecting, I can do some digging to find the origin of the discrepancy on my end

✅ Yan Ashrapov
Yan Ashrapov (yashrapov@shield-legal.com)
2024-12-02 14:15:34

*Thread Reply:* @deleted-U04R23BEW3V From what I gathered, I see more contract because the contract are coming from older leads. Perhaps even leads that were generated from before September. Is this possible?

deleted-U04R23BEW3V
2024-12-02 14:19:32

*Thread Reply:* Yes. We often find that older leads convert outside of the expected conversion window, especially around the end of the year when we enter our slow season. Revisiting older leads is a commonly used strategy for our dialer during those times.

deleted-U04R23BEW3V
2024-12-06 13:01:07

Tik Tok S1 Finals 11/29/2024-12/5/2024

🙌 Cameron Rentch
🙌:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2024-12-13 11:41:26

Tik Tok S1 Finals 12/6/2024-12/12/2024

🙌:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2024-12-20 14:24:49

Tik Tok S1 Finals 12/13/2024-12/19/2024 @Yan Ashrapov yesterday we experienced an issue with our API and lead generation. The leads generated around 9:20AM came in without S1's. If the counts are off, that would be the explanation as to why. As we work towards a fix, I will continue to monitor the potentially affected leads and provide updates to the report as necessary.

🙏:skin_tone_4: Yan Ashrapov
Yan Ashrapov (yashrapov@shield-legal.com)
2024-12-20 14:30:57

@deleted-U04R23BEW3V appreciate the update on this

deleted-U04R23BEW3V
2024-12-20 14:32:45

Of course!

deleted-U04R23BEW3V
2024-12-27 12:53:16

Tik Tok S1 Finals 12/20/2024-12/26/2024

🙏:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-01-10 13:58:42

Tik Tok S1 Finals 1/3/2025-1/9/2025

🙏:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-01-17 13:22:15

Tik Tok S1 Finals 1/10/2025-1/16/2025

🙏:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-01-24 14:12:08

Tik Tok S1 Finals 1/17/2025-1/23/2025

🙏:skin_tone_4: Yan Ashrapov
Cameron Rentch (cameron@internetthings.com)
2025-01-29 11:44:47

@deleted-U04R23BEW3V can you please locate the S1 tags on these e-signs and populate?

https://docs.google.com/spreadsheets/d/1br_NdIqhb3D-smAY1CafOS9hUu8cli2R2zUTbrO1eSQ/edit?usp=sharing

BCL Shield Wildfire
deleted-U04R23BEW3V
2025-01-29 11:45:22

@Cameron Rentch on it!

deleted-U04R23BEW3V
2025-01-29 11:49:13

@Cameron Rentch 667218 is the parent file of 673604, 673593, 673830, and 673835. The original inquiry of 667218 does not have an S1, and the other 4 were manual creation from client referrals. Is there a way you would like me to outline this scenario on the spreadsheet?

image.png
deleted-U04R23BEW3V
2025-01-29 11:51:45

@Cameron Rentch This situation is applicable to 665238 (parent file), 673724, 673649, 673718, 673707, 673733, and 673696 as well

Cameron Rentch (cameron@internetthings.com)
2025-01-29 16:25:36

@deleted-U04R23BEW3V sorry, we should associate all "referrals" with the originating s1

deleted-U04R23BEW3V
2025-01-29 16:27:25

@Cameron Rentch Understood! Unfortunately, the original leads for all of these referrals came in without S1's.

Yan Ashrapov (yashrapov@shield-legal.com)
2025-02-28 13:36:49

Hey @deleted-U04R23BEW3V is there a chance that we missed a few finals with Depo provera?

deleted-U04R23BEW3V
2025-02-28 13:38:40

@Yan Ashrapov I just reran the report to double check. In leads created between 2/21 and 2/27, I'm seeing 2 finals from all Depo campaigns, 1 facebook, 1 tik tok

Yan Ashrapov (yashrapov@shield-legal.com)
2025-02-28 13:46:03

@deleted-U04R23BEW3V OK. double checked with the media buyer and we see a large disparity (12 from TikTok and 2 from FB). Is there a chance that in this case the leads we're submitted a while ago ?

deleted-U04R23BEW3V
2025-02-28 13:47:12

Yes. Those additional leads were likely generated in weeks prior but not reached by our intake floor until this week

✅ Yan Ashrapov
deleted-U04R23BEW3V
2025-03-07 13:15:46

Tik Tok S1 Finals 2/28/2025-3/6/2025

🙏:skin_tone_4: Yan Ashrapov
Yan Ashrapov (yashrapov@shield-legal.com)
2025-04-04 11:20:58

Hey @deleted-U04R23BEW3V hope you've been well! Can we please start the same setup that we have with TikTok for Google as well? Same exact cadence?

deleted-U04R23BEW3V
2025-04-04 11:23:54

Hello! Hope all is well with you! Yes, we absolutely can. I'll use the same procedure for Google as I do for Tik Tok

🙌:skin_tone_4: Yan Ashrapov
Yan Ashrapov (yashrapov@shield-legal.com)
2025-04-04 11:24:24

@deleted-U04R23BEW3V fantastic! thank you!

Yan Ashrapov (yashrapov@shield-legal.com)
2025-04-08 13:33:06

Hey @deleted-U04R23BEW3V please add Los Padrinos tort to the DQ list. Also, let's please update the tort list on a weekly basis 🙏:skintone4:

deleted-U04R23BEW3V
2025-04-08 13:37:48

@Yan Ashrapov Los Padrinos has been on the list since the campaign began receiving leads 3/5/25. There were no disqualified leads to report on from over the weekend so a sheet was not made on yesterday's DQ report

✅ Yan Ashrapov
deleted-U04R23BEW3V
2025-04-08 13:37:56

@Yan Ashrapov Los Padrinos has been on the list since the campaign began receiving leads 3/5/25. There were no disqualified leads to report on from over the weekend so a sheet was not made on yesterday's DQ report

Yan Ashrapov (yashrapov@shield-legal.com)
2025-04-08 13:38:21

@deleted-U04R23BEW3V thank you!

deleted-U04R23BEW3V
2025-04-08 13:38:27

No problem!

Yan Ashrapov (yashrapov@shield-legal.com)
2025-04-08 13:41:02

@deleted-U04R23BEW3V can you please do a deep-dive on Los Padrinos DQ for the last 7 days?. We want to understand why we are not converting..

deleted-U04R23BEW3V
2025-04-08 13:41:15

Absolutely!

deleted-U04R23BEW3V
2025-04-08 15:54:36

@Cameron Rentch @Yan Ashrapov Los Padrinos Deep Dive DQ 4/1/2025-4/7/2025

Yan Ashrapov (yashrapov@shield-legal.com)
2025-04-10 10:26:20

Good morning @deleted-U04R23BEW3V Can you please send all TikTok NEC leads since Feb 11 to March 31? with the current setup of: Lead ID First Name Lead Created Date E-Sign Signed Date Case Description S1

deleted-U04R23BEW3V
2025-04-10 10:26:51

Absolutely!

🙏:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-04-10 10:33:16

NEC Tik Tok S1 2/11/2025-3/31/2025 I included a pivot table for the S1's on the second tab. Let me know if you need anything else!

🙏:skin_tone_4: Yan Ashrapov
Yan Ashrapov (yashrapov@shield-legal.com)
2025-04-11 14:07:01

*Thread Reply:* @deleted-U04R23BEW3V confirming that these are the finals AKA signed contract for NEC?

deleted-U04R23BEW3V
2025-04-11 14:07:47

*Thread Reply:* Yes! Signed and QA approved to be sent to the firm

🙌:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-04-11 14:00:09

Tik Tok S1 Finals 4/4/2025-4/10/2025 No Snapchat or Google S1 Finals from 4/4/2025-4/10/2025

👍:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-04-18 14:06:28

No Snapchat or Google S1 Finals from 4/11/2025-4/17/2025

Cameron Rentch (cameron@internetthings.com)
2025-04-18 14:12:25

@deleted-U04R23BEW3V I am seeing 3 Depo Provera signed via google

deleted-U04R23BEW3V
2025-04-18 14:15:10

@Cameron Rentch When I pulled the report, I did find 3 files that did not have S1's. Am I correct in assuming the 3 blanks in this report should be Google leads?

image.png
Cameron Rentch (cameron@internetthings.com)
2025-04-18 14:48:25

Yes correct @deleted-U04R23BEW3V

deleted-U04R23BEW3V
2025-04-18 14:48:46

Gotcha. Would Mark have those S1's?

Cameron Rentch (cameron@internetthings.com)
2025-04-18 15:04:19

@deleted-U04R23BEW3V yes also Edward may be able to get them as well

deleted-U04R23BEW3V
2025-04-18 15:05:00

Understood! I’ll get you an update soon!

🙌 Cameron Rentch
deleted-U04R23BEW3V
2025-04-18 15:24:27
Untitled
deleted-U04R23BEW3V
2025-04-18 15:31:06

@Cameron Rentch Google S1 Finals 4/11/2025-4/17/2025

🙌 Cameron Rentch
Yan Ashrapov (yashrapov@shield-legal.com)
2025-07-05 12:53:18

Hey @deleted-U04R23BEW3V hope your’e having a great holiday weekend! Can you please send the finals as soon as possible on Monday? Thanks in advance

Yan Ashrapov (yashrapov@shield-legal.com)
2025-08-29 14:41:10

Hey @deleted-U04R23BEW3V could you please do a deep dive into the Chowchilla Google DQs from August 5 to today? We are trying to find a conclusive reason of having signed contracts DQd..

deleted-U04R23BEW3V
2025-08-29 14:50:03

Hi @Yan Ashrapov. I'm a bit confused by the request. Do you want a deep dive on files disqualified or files with signed retainers that are declined in-house and not billed?

Yan Ashrapov (yashrapov@shield-legal.com)
2025-08-29 14:57:04

First option please

deleted-U04R23BEW3V
2025-08-29 14:57:45

Got it! I'll get to work on that

deleted-U04R23BEW3V
2025-08-29 16:49:35

@Cameron Rentch @Yan Ashrapov Please let me know if you require any additional details from this report! Chowchilla Google S1 Deep Dive DQ 8/5/2025-8/29/2025