James Turner (jturner@shield-legal.com)
2025-06-03 11:55:13

Hey good morning! I was wondering where in the shield legal data set do we keep CD or the media buyer in the Leadspedia data that we pull from Leadspedia?

deleted-U05QUSWUJA2
2025-06-03 12:04:19

I would have to look deeper but a quick way is in the Leadspedia data sets is to strip it out of the S1

deleted-U05QUSWUJA2
2025-06-03 12:05:37

Maximus is ML, Caleb is CP, Jack is JA, and John JV

James Turner (jturner@shield-legal.com)
2025-06-03 12:06:22

oh? Is that what comes after MB?

image.png
deleted-U05QUSWUJA2
2025-06-03 12:40:40

Yes

deleted-U05QUSWUJA2
2025-06-03 13:38:32

SELECT SPLIT(SPLIT(allsoldleads.s1, '-')[SAFEOFFSET(1)], '')[SAFEOFFSET(0)] AS mediasource, SPLIT(SPLIT(allsoldleads.s1, '-')[SAFEOFFSET(2)], '')[SAFEOFFSET(0)] AS mbinitials FROM shield-legal-bi.leadspedia.allsoldleads AS allsoldleads;

👍 James Turner
James Turner (jturner@shield-legal.com)
2025-06-03 14:58:04

Thank you!