[Infusionsoft Hack] Add Infusionsoft Contact ID To 3rd Party Data
How To Add Infusionsoft Contact ID to Excel File
Imagine you have data from somewhere other than Infusionsoft that you want to add to existing Infusionsoft contact records. To do that, you use Infusionsoft’s Data Cleanup function. Then ‘Modify Existing Records’.
The challenge is, to update a record, Infusionsoft requires the Contact Id. And because this is data from somewhere other than Infusionsoft, you don’t have Contact ID. So you need to add it as a column to your third party data file.
How do you do that?
You use two handy Excel functions that solve this problem in a jif. Here are the steps:
-
1. Export your existing contacts from Infusionsoft
Be sure to include contact ID and email address. In fact, when I do it, that is all I export because that is all I care about. We are going to match on email and append the contact ID. Everything else is extraneous.
2. Open the CSV file in Excel, Numbers or Google Spreadhseets
3. Copy and paste the third party data into the spreadsheet.
I prefer to put them side by side, if the data isn’t voluminous. Just makes it easier to see when I am modifying my formula. If there is a lot of data, you can import it as its own tab. Either way.
4. Add a column to the third party data for Contact ID
5. In the first row of ContactID, add this formula:
=INDEX(X:X, MATCH(Z2,Y:Y,0))
where
X:X is the column in the Infusionsoft Export that contains Contact ID
Z2 is the cell in that row of your third party data that contains the email address you are going to match on
Y:Y is the column in the third party data that contains the matching email address
6. Change those three values in the formula, as needed
7. Confirm that it is pulling the correct Contact ID.
8. Fill down the entire column to do the same for all the data.
As my dad would say, “This formula is handy as a pocket on a shirt!” Once you know it, you will find yourself using it over and over.
I have put together a video that walks you through it, just in case you are a visual learner, like me 🙂
Spoiler alert: Bribe coming … You can also opt-in to my email list to [thrive_2step id=’786′]get a copy of the spreadsheet I use in the video[/thrive_2step] to get a jumpstart.
Having software costs you money. Using software skillfully, like this … makes you money.
If you would like to wield Infusionsoft skillfully, as a money-making weapon, grab one or both of my Infusionsoft courses: Learn Infusionsoft Fast and Campaign Builder Mastery. Attendees rave about them and there is a LIFETIME guarantee … so ZERO risk.
If you really need to quit messing around and just get stuff done, I offer small business consulting on a VERY limited basis. You can learn more at https://sync2crm.com/work-with-kim
Finally, if this is helpful to you, you can do me a huge favor. Please Share It on social media. All you have to do is click the Share buttons on the left side of this blog post.
That helps me reach more people with my posts, which allows me to help more people. And for that I would be very, very grateful.
