James Turner (jturner@shield-legal.com)
2025-06-17 14:31:34

If I did this right..

James Turner (jturner@shield-legal.com)
2025-06-17 14:37:03

First pulled all the campaigns names from Excel

Then pulled all the Campaign Ids from the names via the database,

Pulled ALL of the leadIds assocated with the campaigns..

For every single LeadID generated thus far, I Grabbed the date of the latest time a status changed to any status containing "Signed e-Sign" and made that into it's own column..

Then for each leadid, I grabbed the entirety of the activity log, and made each one it's own row..

SO theres a row for every time a update to the activity log happens, for each leadid..

and then I cut it up so it is ONLY the ones with a status that contains that "Signed e-Sign" Somewhere in the status history..

James Turner (jturner@shield-legal.com)
2025-06-17 14:37:31
la_county_leads_activity_log.csv
deleted-U08FJ290LUX
2025-06-17 14:39:38

CA Juvenile Hall Abuse DOCS - ACTS - ACTS - ACTS CA Juvenile Hall Abuse VSS - ACTS - ACTS - ACTS ACTS Fact Sheet