Before sending Ometria data to Attentive, you'll want to make sure that your contact data in Ometria and Attentive is as closely aligned as possible.
This article explains how to update your contacts' SMS marketing preferences:
- In Ometria, using Attentive data as the source of truth, or;
- in Attentive, using Ometria data as the source of truth.
Speak to your Customer Success Representative about which method is right for you.
Export your contacts from Attentive
Get in touch with your Attentive CSM and request an export of your entire database with the following fields:
- Email - this is a mandatory field in Ometria; contacts without email addresses won't be ingested.
- Phone number
- SMS marketing opt-in (true/false)
- SMS marketing opt-in timestamp
- First name (if available)
Format your CSV file using this template.
Use the following formula to quickly re-format your dates:
Next, log into Ometria and go to Settings > Contact upload.
Select your formatted CSV file and complete the rest of the fields:
|Add contacts to static segment?
|Select Only overwrite fields where a non-empty cell is provided to make sure your existing data isn't overwritten.
|Email and SMS Subscription mode
|Select Unchanged to make sure that the email subscription statuses of the contacts in your CSV file stay the same.
Finally, select the two data protection boxes before clicking Upload.
Once you've uploaded the file, let your Customer Success Representative know so that they can give you access to the Attentive audience sync connection.
CSV upload template
The CSV file is a template you can use to guide your formatting.
We've also included an XLXS file with tabs and a VLOOKUP function in column A to help you consolidate your data.
Export your contacts from Ometria
In Ometria, go to the Segment explorer and select the following columns:
- Phone number
- Accepts SMS marketing
- Subscription updated (SMS)
See also: How to export segments
Once the file has been generated, download it and send it to your Attentive CSM.
The Attentive CSM can upload the CSV to Attentive for you.
No additional formatting is required.