This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
crm_attribution [2021/07/08 04:35] windsor_ai |
crm_attribution [2021/07/08 04:36] windsor_ai |
||
---|---|---|---|
Line 24: | Line 24: | ||
Once this is done the data can then be joined in [[https:// | Once this is done the data can then be joined in [[https:// | ||
- | < | + | < |
- | BEGIN; | + | |
TRUNCATE TABLE crm_conversions; | TRUNCATE TABLE crm_conversions; | ||
INSERT INTO crm_conversions (datasource, | INSERT INTO crm_conversions (datasource, | ||
Line 34: | Line 33: | ||
FROM hubspot_data | FROM hubspot_data | ||
ORDER BY transaction_id; | ORDER BY transaction_id; | ||
- | COMMIT; | + | COMMIT;</ |
- | + | ||
- | </ | + |