Malissa (malissa@shield-legal.com)
2025-07-09 13:08:15

@Cameron Rentch @Ryan @Zekarias Haile

redid this so it's easier to read.

:rotatinglightred: HOUSTON, We have a problem

There is an issue on the PvS report where payments and budgets are being doubled. There are new campaigns and two older campaigns that have this issue. I'm not sure why or where it's happening. I'm not sure what else it's effecting.

Marc made a comment to Rose that the paid revenue on the Paid vs Spent report seems very high. That's exactly what's off by about $3.7m because of duplicates.

These are the affected campaigns:

image.png
Malissa (malissa@shield-legal.com)
2025-07-09 13:09:26

I'm going to try a quick fix of rebuilding the newer campaigns. If that works, great, but I'm worried it's something happening even when campaigns have been in the system for a while (like Oakwood).

Ryan (ryan@themedialab.agency)
2025-07-09 13:47:44

@Malissa , delete one of the trouble campaigns and it’s payments, and re-add it back and see if that fixes that one, including adding the payments back

Ryan (ryan@themedialab.agency)
2025-07-09 13:47:52

Let me know when done, I’ll do a historical re-sync

Malissa (malissa@shield-legal.com)
2025-07-09 13:54:17

@Ryan I tried that without deleting the original. If i only put in one LP id, it didn't duplicate. If I put in both, it duplicated. I'll try deleting one and rebuilding to see if that helps.

Malissa (malissa@shield-legal.com)
2025-07-09 13:57:49

@Ryan i just built a new one and deleted an old one. You can try that resync

Malissa (malissa@shield-legal.com)
2025-07-09 14:47:09

FYI, the one i deleted didn't delete which, even pre-resync, is very odd.

Malissa (malissa@shield-legal.com)
2025-07-09 15:28:56

@Ryan just checking on that resync

Ryan (ryan@themedialab.agency)
2025-07-09 16:12:16

@Malissa, doing re-sync now.

❤️ Malissa
Ryan (ryan@themedialab.agency)
2025-07-09 16:13:20
image.png
Malissa (malissa@shield-legal.com)
2025-07-09 17:19:07

@Ryan sadly that experiment did not work. It's still doubling the budget and amount paid. I did a different experiment and discovered that if i remove 1 LP ID, it doesn't double the information. I also found that in the Shield Orders Pipeline report these campaigns are showing up twice. Example:

image.png
Ryan (ryan@themedialab.agency)
2025-07-09 18:34:24

Ok, send me lead ids of these, I will have to get to it in a few days. I’ve been given a few hotter items. @Zekarias Haile , I’ll setup time for me to reach you this part and help me get it debugged and fixed.

👍 Malissa
Malissa (malissa@shield-legal.com)
2025-07-10 10:34:18

@Ryan I'll send you and Zeke the IDs in another chat so we don't clog up Cam's slack

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

ok