How-to: Use Attribute Updates to Fix Typos in Your Data
Have you ever added data to Customer.io and only notice after the fact that there was a typo? This happens to the best of us - by using Attribute Updates you can create a campaign that will fix that typo and make sure new data that comes in is clean. Here's how:
Step 1: Create a Segment that Captures the Typo
In this example, let's say you have an attribute called
frist_name that'd you like to fix to
first_name. (While this example is for an attribute name, you could do something similar to clean up attribute values). Create a new segment that captures all profiles with the
Step 2: Create a Campaign Triggered by that Segment
Next, use that segment as the triggering condition in a new campaign. If your data will still be coming in with the incorrect attribute name, be sure to make the campaign re-enterable in order to fix the typo whenever it appear. Since this campaign won't send any messages, you'll want it to "send" to unsubscribed people as well.
Step 3: Add an Attribute Update to Fix the Typo
In the campaign, start with an Attribute Update. You'll want to pass the value from the incorrect attribute to the correct attribute - in this case, from
Step 4: Add an Attribute Update to Remove the Typo
Next, add another Attribute Update - here, you'll set the incorrect attribute name to a null value, effectively removing from the person's profile.
Step 5: Start Your Campaign
Once you've set up your attribute updates, you're ready to start your campaign. On the review page, be sure to select
Current people and future additions - that will correct the typo on all current profiles, and keep it corrected if ever that typo should come up again.