James Turner (jturner@shield-legal.com)
2024-12-12 16:08:34

I want to build a database table that has all campaigns and colums for how many points it gets at each stage of the process.

I know leads have a ID number that we can build schema off of, in the lr_data extract, where would I find consistent ID number and their associated campaign names so that it won't change even when the name changes on Lawruler?

Dustin Surwill (dsurwill@shield-legal.com)
2024-12-12 16:14:12

the case_type table in the lr-data

James Turner (jturner@shield-legal.com)
2024-12-12 16:16:56

Cool ty