Mappings
Last updated
Was this helpful?
Last updated
Was this helpful?
The solutions offers a powerful "Mapping Tool" feature that provides you with complete control over mapping rules, allowing you to effectively utilise the data available in your CSV files. With this feature, you can configure specific Klaviyo attributes using the data from your source CSV files, giving you the flexibility to tailor the syncing process to your exact needs.
View and Adjust Mappings for Customers, Orders and Rewards
Data Utilisation: By leveraging the "Mappings" feature, you can make the most of the data contained within your CSV files. You have the ability to extract and map specific information to relevant Klaviyo attributes, ensuring that your customer and order data is accurately synchronized.
Customisation: The feature allows you to create custom mapping rules, enabling you to match the columns in your CSV files with the corresponding Klaviyo attributes. This level of customisation ensures that the data is accurately transferred and seamlessly integrated into your Klaviyo account.
Flexibility: With the "Mappings" feature, you can configure how the data from your CSV files is transformed and aligned with Klaviyo attributes. This flexibility allows you to accommodate variations in data formats or naming conventions, ensuring that the syncing process adapts to your specific data requirements.
"Mappings" are templates and rules linked to specific Klaviyo attributes. DotDev will set up these mappings for you based on your preferences and CSV samples, but you can also update them yourself.
To access the mappings, go to Customers > Mappings or Orders > Mappings. Here, you'll see a list of Klaviyo attributes and their associated mappings.
Clicking on a mapping, will reveal the details, including any rules and templates applied to that particular field, and the ability to change them.
You will need to enter the description, scope, target field, rules and template for each mapping.
Description: A brief description of the mapping, such as extracting the first name from the "FIRST_NAME" column.
Scope: The type of object to which the mapping should be applied.
Target Field: A list of pre-defined Klaviyo attributes that are available through the Klaviyo API. It is important to keep in mind that you will need to provide a key name for any properties.
Rules: Each mapping contains one or more “rules”. When the DotCustomerHub app is calculating the value of a particular Klaviyo attribute, it will first find any mappings attached to that field, and then for each mapping, loop over the rules until one evaluates to true.
For example, you can map the MOBLIE column from CSV to the phone_number attribute in Klaviyo, as shown in the screenshot.
The Target field is selected to phone_number
The rules and templates dictate that if the MOBILE column is filled, the phone_number attribute in Klaviyo should be aligned with the MOBILE data from the CSV.
Template: When a rule evaluates as true, the template attached to that rule will be used to calculate the attribute in Klaviyo. The templates are , and are a powerful way of composing the value you need in Klaviyo, without writing any code.
