Malissa (malissa@shield-legal.com)
2025-07-10 10:36:19

hi @Ryan and @Zekarias Haile

Here are those IDs:

31683515 - Hair Relaxer Uterine Cancer - DL/FI 32756643 - LA County Foster Care Abuse - Oakwood 33916800 - Firefighting Foam - ELG/Ghozland 34817004 - NEC Baby Formula - LegaFi 2 34832212 - PFAS - Levinson/ELG TC/B 34832244 - PFAS - Levinson TC/SA

Note those PFAS campaigns were made at the same time. There's a third but it is not duplicating the $$

Malissa (malissa@shield-legal.com)
2025-07-10 10:38:26

There is ANOTHER problem where LP IDs do not seem to be connecting to reports. I know these campaigns are affected with that:

32756643 - LA County Foster Care Abuse - Oakwood* both were connected at some point 32607120 - NEC DL/Flatirons 34385131 - Kanukuk Kamps Abuse - DL/Flatirons (TIP) - Contract 34156210 - Trinity Private School Abuse - Dicello/Flatirons (TIP) - Contract * this one seems to have disconnected

Ryan (ryan@themedialab.agency)
2025-07-10 10:39:18

@Malissa, so the first set above has double payments when there is 2 LP IDs in the field?

Malissa (malissa@shield-legal.com)
2025-07-10 10:40:05

Double payments and double budget. like the double mint gum twins

Malissa (malissa@shield-legal.com)
2025-07-10 10:40:35

But obviously not every campaign with more than 2 is getting duplicated

Ryan (ryan@themedialab.agency)
2025-07-10 10:41:22

That's what is weird to me, SQL doesn't have "options for dataset returned" like this so I bet a million dollars it's a naming convention issue in LP or something. I hope this doesn't take me 5 hours to learn it's a setup issue.

Malissa (malissa@shield-legal.com)
2025-07-10 10:41:56

Mark was wondering if it was naming but he did like 3 at the same time the same way and only 2 are messed up. let me add him

slackbot
2025-07-10 10:42:11

@Mark Maniora has been added to the conversation by Malissa Phillips.

Malissa (malissa@shield-legal.com)
2025-07-10 10:42:30

@Mark Maniora we are discussing that weirdness with payments and budgets duplicating

Mark Maniora (markmaniora@shield-legal.com)
2025-07-10 10:45:28

@Ryan I have been looking at the names, but don't see anything off compared to previous PFAS names that work fine

Mark Maniora (markmaniora@shield-legal.com)
2025-07-10 10:46:48

PFAS Water Contamination - ELG/Levinson (TC) (Military Base Exposure) (TIP) - Contract <--- OLD CONTRACT

PFAS Water Contamination - Levinson/ELG (TC/SA) (Military Base Exposure) (TIP) - Contract <--- NEW PFAS Water Contamination - Levinson/ELG (TC/B) (Military Base Exposure) (TIP) - Contract <--- NEW

Mark Maniora (markmaniora@shield-legal.com)
2025-07-10 10:48:08

Unless it's the second slash mark in "TC/SA"

Ryan (ryan@themedialab.agency)
2025-07-10 10:48:34

Did these get named, media start, then renamed at all?

Ryan (ryan@themedialab.agency)
2025-07-10 10:48:50

We look for TC/, (TC) and /TC

Mark Maniora (markmaniora@shield-legal.com)
2025-07-10 10:48:56

no, I have not changed the name

Ryan (ryan@themedialab.agency)
2025-07-10 10:49:18

ok

Ryan (ryan@themedialab.agency)
2025-07-10 10:49:56

I'm going to investigate soon, but have something more pressing right now, and Marc is needing PCTID completed, his Page 0 Looker Dashboard is not showing these in the e-sign log @Malissa

👍 Malissa
Malissa (malissa@shield-legal.com)
2025-07-10 10:51:16

gotta do what you gotta do @Ryan

Malissa (malissa@shield-legal.com)
2025-07-10 10:51:37

The work around for PvS is i download it and give rose a corrected spreadsheet for Marc

Ryan (ryan@themedialab.agency)
2025-07-10 11:28:31

Filter on Levinson Legal Group, make sure all PFAS are correct, then check your others

Malissa (malissa@shield-legal.com)
2025-07-10 11:30:14

Looks like the PFAS ones are fixed. NEC LegaFi 2 is wrong. Hair Relaxer is wrong. AFFF Ghozland is wrong. And Oakwood is wrong

Malissa (malissa@shield-legal.com)
2025-07-10 11:30:56

@Ryan

Ryan (ryan@themedialab.agency)
2025-07-10 11:32:25

What is wrong about each?

Ryan (ryan@themedialab.agency)
2025-07-10 11:33:09

@Malissa, same issue?

Malissa (malissa@shield-legal.com)
2025-07-10 11:35:27

Same issue. $$ paid and Budget doubling

Ryan (ryan@themedialab.agency)
2025-07-10 11:50:19

@Malissa, check these 4 now:

31683515 - Hair Relaxer Uterine Cancer - DL/FI 32756643 - LA County Foster Care Abuse - Oakwood 33916800 - Firefighting Foam - ELG/Ghozland 34817004 - NEC Baby Formula - LegaFi 2

Malissa (malissa@shield-legal.com)
2025-07-10 11:52:44

NEC Fixed. The others are still incorrect @Ryan

Ryan (ryan@themedialab.agency)
2025-07-10 11:53:48

Yeah, I think I know the issue.

👀 Malissa
Malissa (malissa@shield-legal.com)
2025-07-10 12:00:57

you gotta share so we know what NOT to do lol @Ryan

Ryan (ryan@themedialab.agency)
2025-07-10 12:04:29

@Malissa, all the first set is working? You can put all OppIDs into the new first page, named with (M Version) so it matches what Marc sees exactly. Please double check.

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

@Mark Maniora, compare what you have in Leadspedia to what you have in mediarawv2.customer and campaign names, make sure they match exactly @Zekarias Haile in the table, this issue happens when a customer name or vertical name changes after Cameron went live. Let me and @Malissa know what you find, in detail please. Please do this ASAP.

Ryan (ryan@themedialab.agency)
2025-07-10 12:05:55

There is ANOTHER problem where LP IDs do not seem to be connecting to reports. I know these campaigns are affected with that:

32756643 - LA County Foster Care Abuse - Oakwood* both were connected at some point 32607120 - NEC DL/Flatirons 34385131 - Kanukuk Kamps Abuse - DL/Flatirons (TIP) - Contract 34156210 - Trinity Private School Abuse - Dicello/Flatirons (TIP) - Contract * this one seems to have disconnected

Malissa (malissa@shield-legal.com)
2025-07-10 12:05:57

The PFAS campaigns are good NEC is good

The others not so much

Ryan (ryan@themedialab.agency)
2025-07-10 12:06:08

I checked them

Ryan (ryan@themedialab.agency)
2025-07-10 12:06:12

@Malissa, hop on call