deleted-U04R23BEW3V
2024-11-22 11:07:46

Hey! Cameron hasn't answered my questions about the report he asked me to make. Are you aware of a specific timeframe he's looking for in this report? Additionally, does it need to differ in any way from the All Campaign Finals report that I send on Monday's?

Yan Ashrapov (yashrapov@shield-legal.com)
2024-11-22 11:09:20

Good morning @Maximus What is the current timeframe for the Monday reports?

deleted-U04R23BEW3V
2024-11-22 11:10:05

The report I send on Monday's covers the Monday-Sunday for the week prior

deleted-U04R23BEW3V
2024-11-22 11:11:57

All Campaign Finals 11/11/2024-11/17/2024 This is the most recent version

Yan Ashrapov (yashrapov@shield-legal.com)
2024-11-22 11:14:22

Timeframe should be the same, just applicable to Friday.

deleted-U04R23BEW3V
2024-11-22 11:14:35

No problem. I'll get to work on that now

Yan Ashrapov (yashrapov@shield-legal.com)
2024-11-22 11:14:49

Awesome. Thank you

deleted-U04R23BEW3V
2024-11-22 11:14:59

No problem

Yan Ashrapov (yashrapov@shield-legal.com)
2024-12-02 14:48:50
tiktok lead ids 22.11 - 28.11.xlsx
Yan Ashrapov (yashrapov@shield-legal.com)
2024-12-02 14:49:04
Untitled
Yan Ashrapov (yashrapov@shield-legal.com)
2024-12-02 14:49:52

@deleted-U04R23BEW3V waiting for another media buyer to send his leads. Hope this helps

deleted-U04R23BEW3V
2024-12-02 15:17:37

Thank you!

deleted-U04R23BEW3V
2024-12-02 15:32:43

Chowchilla Lead Created Dates: Terri Ortiz 11/8/2024 Sonia Pitambar 11/21/2024 Becky Cook 11/21/2024 Sonja McDaniel 11/25/2024 Amber Singh 11/27/2024 Roni Hyde 11/27/2024 Rebecca Willis 11/30/2024

Sonja McDaniel, Amber Singh, and Roni Hyde were the only 3 created from 11/22-11/28

🙏:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2024-12-02 15:33:35

Bard PowerPort Lead Created Dates: Sarah Clemonds 11/26/2024 Carlos Diaz 11/25/2024 Carrie Ottinger 11/22/2024 Frank Dillon 11/26/2024 Lois Ballance 11/26/2024 Andrew Davis** 11/25/2024 Aarlah Roland 11/21/2024 Heather Swindle 11/20/2024 Megan Fletcher 11/20/2024

3/9 leads were not created between 11/22/2024-11/28/2024. Andrew Davis was declined in-house and never finalized

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

Hi @deleted-U04R23BEW3V We moved from Discord to operate on slack exclusively. So you can just send Cameron and myself the weekly DQ report for TikTok 🙏:skintone4:

Yan Ashrapov (yashrapov@shield-legal.com)
2024-12-17 02:42:20

Just to clarify - please don’t post any reports on Discord (e-signs or DQs).

deleted-U04R23BEW3V
2024-12-17 09:56:35

Understood! Should I leave that Discord server or is there a possibility that we'll use it again in the future?

Yan Ashrapov (yashrapov@shield-legal.com)
2024-12-17 09:57:16

You can leave it

deleted-U04R23BEW3V
2024-12-17 09:57:44

Music to my ears. I keep getting weird message requests to join scam servers

🎉 Yan Ashrapov
Yan Ashrapov (yashrapov@shield-legal.com)
2024-12-17 09:59:21

Can you by any chance send me last week’s DQ report that was sent to discord?

deleted-U04R23BEW3V
2024-12-17 10:00:11

Of course! Do you want every report from Monday-Friday?

Yan Ashrapov (yashrapov@shield-legal.com)
2024-12-17 10:01:12

Yes please. We can also in the future sync the DQ report and eSign report dates. Is this possible?

deleted-U04R23BEW3V
2024-12-17 10:02:18

I do the DQ reports on a daily basis, the e-Sign Final report had the dates adjusted from Monday-Sunday to Friday-Thursday per Cameron's request.

Yan Ashrapov (yashrapov@shield-legal.com)
2024-12-17 10:04:05

Correct. Can you please send us Friday-Thursday weekly report for DQs as well please?

deleted-U04R23BEW3V
2024-12-17 10:05:20

Do you no longer need DQ's on a daily basis or would you like a cumulative report for DQ's on Friday's as well?

Yan Ashrapov (yashrapov@shield-legal.com)
2024-12-17 10:05:50

The cumulative report as well

deleted-U04R23BEW3V
2024-12-17 10:06:26

Understood! I'll have that on my calendar for Friday's in the future

Yan Ashrapov (yashrapov@shield-legal.com)
2024-12-17 10:06:39

Awesome. Appreciate it

deleted-U04R23BEW3V
2024-12-17 10:06:46

No problem

🙏:skin_tone_4: Yan Ashrapov
Yan Ashrapov (yashrapov@shield-legal.com)
2024-12-17 10:10:59

Next week can we compile it to a single sheet?

deleted-U04R23BEW3V
2024-12-17 10:11:44

Yes. I can separate the tabs by campaigns or dates. Which would be easiest for your purposes?

Yan Ashrapov (yashrapov@shield-legal.com)
2024-12-17 10:12:14

Campaigns would be great

deleted-U04R23BEW3V
2024-12-17 10:12:27

Consider it done

🙏:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2024-12-17 10:14:04

Should I still use the Friday-Thursday date range? If so, I can start this week's by backfilling from the previous week's reports

Yan Ashrapov (yashrapov@shield-legal.com)
2024-12-17 10:15:10

Friday-Thursday is the way to go for both reports

Yan Ashrapov (yashrapov@shield-legal.com)
2024-12-17 10:15:55

Backfilling is fine in this case

deleted-U04R23BEW3V
2024-12-17 10:16:08

Gotcha. I'll create one for 12/13-12/19 and send the link so you can check its progress throughout the week. If you notice anything you'd like to adjust, just let me know

🔥 Yan Ashrapov
deleted-U04R23BEW3V
2024-12-17 10:37:39

Tik Tok DQ Report 12/13/2024-12/19/2024 I'll be updating this sheet throughout this week

deleted-U04R23BEW3V
2024-12-20 14:26:47

The Tik Tok DQ Report for this week has received its final update

✅ Yan Ashrapov
deleted-U04R23BEW3V
2024-12-23 12:49:03

Tik Tok DQ Report 12/20/2024-12/26/2024 This week's Tik Tok DQ Report. Only 3 campaigns had leads generated with Tik Tok S1's this weekend

deleted-U04R23BEW3V
2024-12-27 12:31:21

This week's Tik Tok DQ Report is complete

🙏:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2024-12-30 13:52:30

Tik Tok DQ Report 12/27/2024-1/2/2025

🙏:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-01-03 12:51:33

This week's Tik Tok DQ Report is complete

👍:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-01-10 12:22:05

This week's Tik Tok DQ Report is complete

👍:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-01-13 13:27:21

Tik Tok DQ Report 1/10/2025-1/16/2025

🙏:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-01-17 12:12:57

This week's Tik Tok DQ Report is complete

🙏:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-01-20 12:18:07

DQ Report 1/17/2025-1/23/2025

👍:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-01-24 12:25:07

This week's Tik Tok DQ Report is complete

👍:skin_tone_4: Yan Ashrapov
Yan Ashrapov (yashrapov@shield-legal.com)
2025-01-27 09:37:32

Good morning @deleted-U04R23BEW3V Hope you’ve been well! A quick question: would it be possible, data wise, to compile all DQs and eSigns (per tort) for this last quarter (Q4 2024) to a google sheet?

deleted-U04R23BEW3V
2025-01-27 10:01:10

Good morning! Would you like them separated by status or all together on one sheet?

Yan Ashrapov (yashrapov@shield-legal.com)
2025-01-27 10:18:16

@deleted-U04R23BEW3V can we do 2 separate docs? One with the DQs and one with the eSigns. Similar to our weekly report format

deleted-U04R23BEW3V
2025-01-27 10:19:48

Understood. Are you only interested in files with Tik Tok S1's?

Yan Ashrapov (yashrapov@shield-legal.com)
2025-01-27 10:24:50

@deleted-U04R23BEW3V correct. TikTok is the first priority. Second distant is to create a full S1 (Meta included). This can be done for later this week if time bandwidth allows

deleted-U04R23BEW3V
2025-01-27 10:26:00

Understood. I'll make this task my first priority once I complete my Monday reporting for Cameron

🙏:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-01-31 12:14:36

This week's Tik Tok DQ Report is complete

deleted-U04R23BEW3V
2025-02-07 13:15:08

This week's Tik Tok DQ Report is complete

🙏:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-02-14 12:48:24

This week's Tik Tok DQ Report is complete

🙏:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-02-21 12:24:39

This week's Tik Tok DQ Report is complete

👍:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-02-28 13:11:42

This week's Tik Tok DQ Report is complete

👍:skin_tone_4: Yan Ashrapov
Yan Ashrapov (yashrapov@shield-legal.com)
2025-03-04 10:19:07

Good morning @deleted-U04R23BEW3V Can you please compile all DQs and eSigns (per tort) for January and February to a google sheet (TikTok)?

deleted-U04R23BEW3V
2025-03-04 10:20:44

Definitely! Do you want separate reports for January and February or would you like them all in the same report?

Yan Ashrapov (yashrapov@shield-legal.com)
2025-03-04 10:21:12

Same report. But we can add the dates so we can pivot it if need be

deleted-U04R23BEW3V
2025-03-04 10:21:23

Sounds good

🙏:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-03-07 12:58:21

This week's Tik Tok DQ Report is complete

👍:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-03-14 15:21:36

This week's Tik Tok DQ Report is complete

🙏:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-03-21 12:50:20

This week's Tik Tok DQ Report is complete

deleted-U04R23BEW3V
2025-03-28 14:49:12

This week's Tik Tok DQ Report is complete

👍:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-04-04 13:21:10

This week's Tik Tok DQ Report is complete

deleted-U04R23BEW3V
2025-04-09 11:58:30

Hey @Yan Ashrapov! Just wanted to give you a quick update regarding the Google S1's. I haven't observed any come in at this point, disqualified or otherwise. I have seen some Paraquat leads without an S1 on the file. Is it possible that those leads are the Google S1 leads?

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

@deleted-U04R23BEW3V don't think so. Mark Maniora probably will reach out regarding this today

deleted-U04R23BEW3V
2025-04-11 11:11:50

Sounds good! Thank you! I'm seeing snapchat S1's as well. Should I be making a dedicated report for those leads as well?

Yan Ashrapov (yashrapov@shield-legal.com)
2025-04-11 11:12:04

@deleted-U04R23BEW3V please do!

deleted-U04R23BEW3V
2025-04-11 11:12:11

On it!

🙏:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-04-11 13:30:20

This week's Tik Tok DQ Report is complete Snapchat DQ Report 4/4/2025-4/10/2025

👍:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-04-18 13:48:58

This week's Tik Tok and Snapchat DQ Reports are complete

👍:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-04-25 17:58:16

This week's Tik Tok and Google DQ Reports are complete

deleted-U04R23BEW3V
2025-04-30 13:38:28

Tik Tok DQ Report 4/25/2025-5/1/2025 Google DQ Report 4/25/2025-5/1/2025 Sorry for the late delivery on these. I just returned to the office

deleted-U04R23BEW3V
2025-05-02 12:30:06

This week's Tik Tok and Google DQ Reports are complete

deleted-U04R23BEW3V
2025-05-09 12:44:23

This week's Tik Tok and Google DQ Reports are complete

deleted-U04R23BEW3V
2025-05-16 13:56:37

This week's Tik Tok and Google DQ Reports are complete

deleted-U04R23BEW3V
2025-05-23 16:21:41

This week's Tik Tok and Google DQ Reports are complete

deleted-U04R23BEW3V
2025-05-30 17:16:00

This week's Tik Tok and Google DQ Reports are complete

deleted-U04R23BEW3V
2025-06-06 16:13:00

This week's Tik Tok and Google DQ Reports are complete

deleted-U04R23BEW3V
2025-06-20 14:18:47

This week's Tik Tok and Google DQ Reports are complete

deleted-U04R23BEW3V
2025-06-27 15:58:21

This week's Tik Tok and Google DQ Reports are complete

Yan Ashrapov (yashrapov@shield-legal.com)
2025-07-05 12:54:15

Hey @deleted-U04R23BEW3V please send the DQs as soon as you can on Monday. Thank you 🙏:skintone4:

deleted-U04R23BEW3V
2025-07-07 17:36:01

Last week's Tik Tok and Google DQ Reports are complete

deleted-U04R23BEW3V
2025-07-11 16:58:05

Google DQ Report 7/4/2025-7/10/2025 Tik Tok DQ Report 7/4/2025-7/10/2025 This week's Tik Tok and Google DQ Reports are complete

deleted-U04R23BEW3V
2025-07-18 16:36:25

This week's Tik Tok and Google DQ Reports are complete

🙏:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-07-25 15:58:25

This week's Tik Tok and Google DQ Reports are complete

deleted-U04R23BEW3V
2025-08-01 14:01:22

This week's Tik Tok and Google DQ Reports are complete

deleted-U04R23BEW3V
2025-08-05 17:31:49

Google DQ Report 8/1/2025-8/7/2025 No Tik Tok DQ's this week to report on

deleted-U04R23BEW3V
2025-08-08 15:55:37

This week's Tik Tok and Google DQ Reports are complete

Yan Ashrapov (yashrapov@shield-legal.com)
2025-08-11 10:51:15

Hey @deleted-U04R23BEW3V can I please get the Meta DQs as well? for last week?

deleted-U04R23BEW3V
2025-08-11 10:51:37

Meta as in Facebook?

Yan Ashrapov (yashrapov@shield-legal.com)
2025-08-11 11:24:32

@deleted-U04R23BEW3V yes please

deleted-U04R23BEW3V
2025-08-11 11:43:50

Can do

deleted-U04R23BEW3V
2025-08-11 12:14:21

Facebook DQ Report 8/1/2025-8/7/2025

🙏:skin_tone_4: Yan Ashrapov
deleted-U04R23BEW3V
2025-08-14 11:48:43

@Yan Ashrapov Hello, is yashrapov@shield-legal.com the correct email to reach you at?

Yan Ashrapov (yashrapov@shield-legal.com)
2025-08-14 11:49:05

@deleted-U04R23BEW3V correct!

deleted-U04R23BEW3V
2025-08-14 11:50:39

Perfect! I set up an automation to deliver this spreadsheet to you on a daily basis however I was provided an incorrect email address. The link to the spreadsheet is below and your correct email has been added to the automation so you will be notified each day after it is updated. Milestone Lead Tracker

✅ Yan Ashrapov
Yan Ashrapov (yashrapov@shield-legal.com)
2025-08-14 11:52:48

Is this sorted by date or can be perhaps?

deleted-U04R23BEW3V
2025-08-14 11:53:49

It's already sorted by lead created date! The Lead ID in column A ticks up sequentially as leads are created so the most recent leads will always populate in order at the bottom

Yan Ashrapov (yashrapov@shield-legal.com)
2025-08-14 12:08:36

great! is this CC'd to other people as well?

deleted-U04R23BEW3V
2025-08-14 12:09:25

Yes it is! Cameron sent me these emails: ben@milestonetax.com marc@sunrisessm.com dave@legacycapitalservices.com thom@elitelegalpractice.com Please let me know if there are any others that should be on there

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

OK. Was the first email sent and I've missed it or it should be sent from tomorrow?

deleted-U04R23BEW3V
2025-08-14 12:11:04

It was directed at an email address that didn't exist. You will get them beginning tomorrow. The rest of the list received the first email this morning

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

Got it. Thank you

deleted-U04R23BEW3V
2025-08-14 12:14:16

No problem

Yan Ashrapov (yashrapov@shield-legal.com)
2025-08-15 12:42:27

Hey @deleted-U04R23BEW3V can you please add jack@shield-legal.com to the milestone lead tracker?

deleted-U04R23BEW3V
2025-08-15 12:43:10

Absolutely!

deleted-U04R23BEW3V
2025-08-15 15:13:34

This week's Tik Tok and Google DQ Reports are complete

deleted-U04R23BEW3V
2025-08-22 13:33:26

This week's Tik Tok and Google DQ Reports are complete

deleted-U04R23BEW3V
2025-08-29 16:50:36

This week's Tik Tok and Google DQ Reports are complete