Ryan (ryan@themedialab.agency)
2024-03-29 15:20:11

@Kris Standley @Cameron Rentch

The tracking plan is complete, all numbers tested. Give the TV buyer team those ?s1= from the sheet @Kris Standley so they can put them on the click of the ad to the website. Mark Hines can confirm if the ad click to the website survives the lead test if they test. Just let us know what phone and email they used to submit.

See the green tabs, your S1s for Ad Clicks, and the Yellow tabs are your targeting.

https://docs.google.com/spreadsheets/d/1cWrKqx0XmceVsQsmk01sl84bnm6QLM9dHPNo4GHer8g/edit?usp=sharing

@Cameron Rentch, my portion is 100% done and ready.

Kris Standley (kristopher@shield-legal.com)
2024-04-11 13:14:58

*Thread Reply:* @Ryan Can you please unhide columns C, D and E in the Maryland Tracking tab in the above document (since we’re unable to edit it)? Thanks.

Ryan (ryan@themedialab.agency)
2024-04-11 13:55:32

*Thread Reply:* Sure

Ryan (ryan@themedialab.agency)
2024-04-11 13:55:51

*Thread Reply:* @Kris Standley, done!

Kris Standley (kristopher@shield-legal.com)
2024-04-11 13:58:07

*Thread Reply:* Great - thanks, @Ryan!

Kris Standley (kristopher@shield-legal.com)
2024-04-16 14:33:23

*Thread Reply:* @Ryan Sonobi let me know they used the following when testing today:

Phone:

Email: test@gmail.com

☝️:skin_tone_4: Ryan
Kris Standley (kristopher@shield-legal.com)
2024-03-29 15:43:50

Great - thanks, @Ryan!

Ryan (ryan@themedialab.agency)
2024-04-01 13:20:03

@Kris Standley, when do you expect the campaign to go live and how long will it run?

FYI @Luke Fontaine

Ryan (ryan@themedialab.agency)
2024-04-01 13:20:27

We'll get your new dashboard created so you can follow your leads from front to back @Kris Standley

Kris Standley (kristopher@shield-legal.com)
2024-04-01 13:24:03

@Ryan We’re looking at a Wednesday start this week, depending on when all the spots are approved and finished. This test campaign will run through the end of May. Sounds great re: dashboard!

Kris Standley (kristopher@shield-legal.com)
2024-04-16 12:07:06

@Ryan Here are the pixels Sonobi generated to be placed both on the landing page as well as the post-form submit for each lander:

https://docs.google.com/file/d/1VcF6gWOebtK8NHZpbDA3UVghADJWcv/edit?usp=docslistapi&filetype=msexcel|https://docs.google.com/file/d/1VcF6gWOebtK8NHZpbDA3UVghADJWcv/edit?usp=docslistapi&filetype=msexcel

Please let me know if I need to loop in someone else to handle these. Thanks!

Shield Legal _ Sonobi On Site Pixels.xlsx
Ryan (ryan@themedialab.agency)
2024-04-16 12:08:49

@Kris Standley Ford, this sheet of pixels and the URLs to our kind in the pixel channel

Ryan (ryan@themedialab.agency)
2024-04-16 12:08:55

I’ll make sure he gets it done

Ryan (ryan@themedialab.agency)
2024-04-16 12:09:06

#pixels

Kris Standley (kristopher@shield-legal.com)
2024-04-16 12:12:49

@Ryan Will do, thanks. Meaning the URLs in your tracking document?

Ryan (ryan@themedialab.agency)
2024-04-16 12:13:17

The link to the tracking document, and the website URLs. Mark just makes so many websites every day.

Kris Standley (kristopher@shield-legal.com)
2024-04-16 12:14:04

Got it. 👍:skintone3:

🙏:skin_tone_4: Ryan
Ryan (ryan@themedialab.agency)
2024-04-16 13:24:49

@Kris Standley, check your dashboard. Updated format and a log of your sign ups are on Page 4 now. I also cleaned up your data in the database, it's all TV or Radio.

https://lookerstudio.google.com/reporting/37c549dd-f432-4572-9757-0cd2f7a0a53c/page/p_mxyku40vlc

🙌:skin_tone_3: Kris Standley
Kris Standley (kristopher@shield-legal.com)
2024-04-17 11:10:16

*Thread Reply:* @Ryan Per Steve’s email, are we providing them a dashboard to track performance or are we just keeping that on our side?

Ryan (ryan@themedialab.agency)
2024-04-17 11:16:28

*Thread Reply:* Yes, let me create it

Kris Standley (kristopher@shield-legal.com)
2024-04-17 11:18:52

*Thread Reply:* Great, thanks.

Kris Standley (kristopher@shield-legal.com)
2024-04-17 12:59:05

*Thread Reply:* Thanks for the quick turnaround on this, @Ryan! 🙏:skintone3:

Kris Standley (kristopher@shield-legal.com)
2024-04-18 14:19:08

*Thread Reply:* @Ryan Steve asked if “Intake Under Review” under Status in the dashboard is pre- or post-consultation. Please confirm - thanks.

Ryan (ryan@themedialab.agency)
2024-04-18 14:22:49

*Thread Reply:* That is pre-sign.

Ryan (ryan@themedialab.agency)
2024-04-18 14:23:09

*Thread Reply:* But promising

Kris Standley (kristopher@shield-legal.com)
2024-04-18 14:28:54

*Thread Reply:* Great, thanks!

Kris Standley (kristopher@shield-legal.com)
2024-04-16 13:28:33

Thank you, @Ryan!

slackbot
2024-04-16 18:21:16

Tort Intake Professionals has joined this channel by invitation from Shield Legal.

deleted-U04HFGHL4RW
2024-04-16 18:21:16

@deleted-U04HFGHL4RW has joined the channel

deleted-U04GU9EUV9A
2024-04-16 18:21:17

@deleted-U04GU9EUV9A has joined the channel

Cameron Rentch (cameron@internetthings.com)
2024-04-16 18:21:20

@deleted-U04HFGHL4RW @deleted-U04GU9EUV9A please note here are TV campaigns that are launching for tomorrow. Please test all numbers today again. Please ensure that all phone numbers are tested and working properly. Also, please ensure that all campaigns are assigned as follows:

I would anticipate

Overall • Flight Dates: 4/17/24-5/31/24 weekdays only (33 total weekdays) • Daily Spend: $4,545.45 Los Angeles County - ACTS - DL/Flatirons • Flight Dates: 4/17/24-5/31/24 weekdays only (33 total weekdays) • Daily Spend: $1,515.15 Maryland - DiCello Levitt - DL/Flatirons • Flight Dates: 4/17/24-5/31/24 weekdays only (33 total weekdays) • Daily Spend: $1,515.15 Maryland - Slater Slater Schulman - Crump/Slater • Flight Dates: 4/17/24-5/31/24 weekdays only (33 total weekdays) • Daily Spend: $1,515.15 [4:20 PM] @Ryan @Kris Standley ^

Ryan (ryan@themedialab.agency)
2024-04-19 11:50:48

*Thread Reply:* @Kris Standley

Please submit your spend each day for the TV flight, we did it for 4/17 to 4/19 already. This video shows us doing the 4/19 submission this morning in prep for tomorrow's run of number. Our deadline is "Following day by 7:00 AM PT".....but since your "fixed daily budget" you can even submit all days from 4/20 to 5/31/24, yeah that is a lot, but do them in bunches as you see to optimize the campaign, etc.

Watch this to learn: https://www.loom.com/share/1c942cadcb5141449df91e1ac32c3648

Form Link:

Cameron Rentch (cameron@internetthings.com)
2024-04-18 14:18:31

@Ryan @Luke Fontaine please remember we are NOT running the BG Maryland campaign yet.

Kris Standley (kristopher@shield-legal.com)
2024-04-19 12:31:02

@Ryan Sounds good - thanks for the refresher video! I’ll start out submitting daily (afternoon/evening the day of so you have it well before the deadline). Since we’re not running on weekends, do I still submit $0 on Saturdays and Sundays?

🙏:skin_tone_4: Ryan
Ryan (ryan@themedialab.agency)
2024-04-25 11:27:53

@Kris Standley, I guess send us the spend by campaign weekly, we'll backfill it to be accurate.

FYI @Luke Fontaine @Cameron Rentch

Kris Standley (kristopher@shield-legal.com)
2024-04-25 11:39:49

@Ryan Sounds good!

Kris Standley (kristopher@shield-legal.com)
2024-04-25 12:17:40

@Ryan It looks like they will be able to send me daily spend amounts for each campaign by Noon PT the following day. Will that work since it’s past the daily deadline?

Ryan (ryan@themedialab.agency)
2024-04-25 12:18:43

Yes, let me send you a sheet for him to complete

Kris Standley (kristopher@shield-legal.com)
2024-04-25 12:33:03

They’ve already set up an Excel sheet that will be updated for me daily. Then I can just submit the spend amounts once their sheet is updated. Or do you need them to use a different sheet?

Ryan (ryan@themedialab.agency)
2024-04-25 14:35:38

@Kris Standley, once we reach 4PM the following day, the submissions won't get into the DB, just send me the sheet that show spend by day by campaign / law firm.

Kris Standley (kristopher@shield-legal.com)
2024-04-25 14:39:14

@Ryan Got it. When the sheet is updated, I’ll post the link here for you. It should have all spend amounts for 4/17-4/24. Then it should be updated for each subsequent day by Noon PT the following day.

Ryan (ryan@themedialab.agency)
2024-04-25 15:09:51

@Kris Standley, any chance Craig can get that earlier, like 8AM? 🙂 Then you could submit, if not, then that sheet will work

Ryan (ryan@themedialab.agency)
2024-04-25 15:09:55

FYI @Luke Fontaine

Kris Standley (kristopher@shield-legal.com)
2024-04-25 15:17:07

@Ryan I reminded them about the morning deadline, but they said they can post the daily spend by Noon PT after they compile the numbers. I’ll remind them again that the earlier they can post the spend, the better.

🙏:skin_tone_4: Ryan
Kris Standley (kristopher@shield-legal.com)
2024-04-25 17:26:26

@Ryan Here is the link to the spend document. The daily individual campaign spend amounts are in rows 5, 10 and 15. Thanks!

https://docs.google.com/spreadsheets/d/1a6mlNhv8YX-9UO40wCdO67woNiEMoDT3c5draFCZHfw/edit

☝️:skin_tone_4: Ryan
Ryan (ryan@themedialab.agency)
2024-04-26 12:39:12

@Kris Standley @Cameron Rentch, TV spend is updated in Dashboard.

🙏:skin_tone_3: Kris Standley
Ryan (ryan@themedialab.agency)
2024-05-09 11:15:22

@Kris Standley @Cameron Rentch, TV spend is updated in Dashboard.

🙏:skin_tone_3: Kris Standley
Cameron Rentch (cameron@internetthings.com)
2024-05-09 13:23:12

@Ryan please make the revenue equal to the daily gross spend for each specific campaign. These are test campaigns so they have to be at least break even.

Ryan (ryan@themedialab.agency)
2024-05-09 13:27:58

@Cameron Rentch, so sum up the campaign spend for all days per campaign, and make the single day revenue match that for "TOTALS" row break even correct?

Ryan (ryan@themedialab.agency)
2024-05-09 13:28:17

Just making sure I understand your request.

Cameron Rentch (cameron@internetthings.com)
2024-05-09 13:28:33

Gross spend equal to gross rev

Ryan (ryan@themedialab.agency)
2024-05-09 13:29:53

Gross spend for all days per campaign will equal the gross revenue on the day we got the revenue

Cameron Rentch (cameron@internetthings.com)
2024-05-09 22:33:07

@Ryan no, spread it out each day , spend = rev

Ryan (ryan@themedialab.agency)
2024-05-10 07:10:54

I did

Ryan (ryan@themedialab.agency)
2024-06-03 11:46:55

@Kris Standley @Cameron Rentch all spend is updated from Sonobi sheet through 5/30/24.

🙏:skin_tone_3: Kris Standley
Cameron Rentch (cameron@internetthings.com)
2024-06-03 11:56:54

@Kris Standley can you please follow up with David on the IL Juv Abuse spots ASAP. I believe everything is approved. Please get spots to him asap for all three firms.

Kris Standley (kristopher@shield-legal.com)
2024-06-03 12:04:15

@Cameron Rentch Sounds good. Now that spots are approved, I’ll give them a final check and then have David finish the other versions so I can send those to Sonobi.

Kris Standley (kristopher@shield-legal.com)
2024-06-03 13:02:27

@Cameron Rentch Just to confirm, we’re still starting with just Crump/Slater in IL for now, correct?

Cameron Rentch (cameron@internetthings.com)
2024-06-03 13:26:25

yes @Kris Standley ^

Cameron Rentch (cameron@internetthings.com)
2024-06-03 13:26:47

let's start with this one, then once we get targeting right then we can layer in additional campaigns

👍:skin_tone_3: Kris Standley
Kris Standley (kristopher@shield-legal.com)
2024-06-03 13:28:38

@Cameron Rentch Sounds good, thanks.

Ryan (ryan@themedialab.agency)
2024-08-13 11:23:19

@Kris Standley @Cameron Rentch, I'll have all TV spend for Juve Abuse into the SL financials and KS dash by end of tomorrow. I'm having to insert the IL campaign manually since the Leadspedia contracts were not on as designed to count and report the lead rows. I'll confirm when done.

🙏:skin_tone_3: Kris Standley
Kris Standley (kristopher@shield-legal.com)
2024-08-13 11:27:01

Sounds great - thanks, @Ryan!

🙏:skin_tone_4: Ryan