How to account for your unique customer/lead properties
All you need to do is create a table with them
| customer_id | name | industry | number of employees | totally_custom_property | budget | target_date |
| cus111 | InfiniDim Enterprises | intergalactic information | 170000 | aliens | 42000000 | 2026-01-01 |
This data will then be pivoted into a generalized format.
Final Table Structure: Customer_properties
| customer_id | property_name | numeric_value | timestamp_value | string_value |
| cus111 | name | NULL | NULL | InfiniDim Enterprises |
| cus111 | industry | NULL | NULL | intergalactic information |
| cus111 | number_of_employees | 170000.00 | NULL | NULL |
| cus111 | totally_custom_property | NULL | NULL | aliens |
| cus111 | budget | 42000000.00 | NULL | NULL |
| cus111 | target_date | NULL | 2026-01-01 00:00:00 |
Same format can be used for Leads
| lead_id | property_name | numeric_value | timestamp_value | string_value |
| lead111 | name | NULL | NULL | InfiniDim Enterprises |
| lead111 | industry | NULL | NULL | intergalactic information |
| lead111 | number_of_employees | 170000.00 | NULL | NULL |
| lead111 | totally_custom_property | NULL | NULL | aliens |
| lead111 | budget | 42000000.00 | NULL | NULL |
| lead111 | target_date | NULL | 2026-01-01 00:00:00 |