Connecting ActiveCampaign to our customer database

A one-time import won’t help much when contacts keep entering automations and customers renew throughout the month. You need the first transfer to bring over the existing history, followed by smaller updates that capture new and changed records. You can see how to create an ActiveCampaign MySQL integration here: http://datrise.com/en/integrations/source/activecampaign . Select the contacts, campaigns, automations, and pipeline updates needed for your reports, then send them into separate MySQL tables. Check the first synchronized records against both systems before using them to calculate campaign revenue.

Make sure each ActiveCampaign contact can be matched to the correct customer in MySQL before you build any reports. Email addresses can change, so add the customer ID from your own system to the contact record and use that as the connection between the two sources. Decide which campaign events you actually need as well, because opens, clicks, purchases, and cancellations all answer different questions. That will give you cleaner attribution once the data starts arriving.