Data Mappings

ZMP’s import mapping feature enables you to:

Bypass the ETL framework when your data does not require transformation or cleaning.
Create a unified framework for all inbound data dropped as files into Zeta's SFTP users folder.
Remap inbound column headers to corresponding fields (user properties) in ZMP, including both implicit and explicit properties.
Map columns to 'standard attributes,' providing them with enhanced insights from their data.

Supported files include txt and csv, and supported delimiters include tab, comma, and pipe.

Note that this feature only supports the mapping of people or user data for now.

Reach out to the Support team if you cannot see Data Mappings and want it enabled for your instance.

Create Data Mappings

1. To create a new mapping, navigate to Data > Data Mappings, and click on the New Mapping button at the top-right.

Within the screen that appears, click on Start Mapping.

2. Fill in the desired mapping settings on the left-hand panel and upload the mappings on the right.

Field	Description
Mapping Name	This is the name of your mapping
Mapping Description OPTIONAL	Add a description to your mapping to make it easier to see what this mapping does at a glance
Company Name	The company name will indicate where the data is sourced from, it will also map into the `Connectivity` sub-menu under `Data`
Company Logo	For existing company names, this will be populated automatically, for new companies click the box and you will be able to indicate a company domain to pull a logo from
FTP location	Currently only available for People imports (i.e. the `/user` folder on the SFTP location for this account). In the future, you will be able to map Campaigns, Events, and Lists.
Prefix (“Include any file that begins with”)	The prefix of the inbound file, be sure to use a distinct name as all files that match will be imported using this mapping. Note that prefixes must be at least 3 characters long. Zeta’s recommendation is to use a distinct word or identifier and an underscore (e.g. `test_` or `zeta_`). Please be aware that files dropped into the users' folder which do NOT match the specified prefix will still be ingested by ZMP, but mapping will not be applied.

On the right-side panel, drop a sample file (with a handful of records) by clicking on Browse for file or selecting one from your computer to expose the actual mappings.

At the top of the page, you’ll see the name of your sample file and the delimiter, which can be changed - note that currently we support tab, pipe, and comma

Currently, mappings are manual, meaning you must select a property to assign or leave empty to import as-is.

Points to Remember:

a user_id or email is mandatory for all user imports - you can leave a correctly named field unmapped or can assign to uid in the drop down. However, if you do not want to import with user_id or email then make sure to have the site setting enabled for “Track anonymous people”.
email_md5_id can be remapped by first importing a file using this as your key - the file can simply contain a single column named correctly and one row with a valid email md5 hash see here for steps
dates: note that ZMP prefers a date in the format yyyy-mm-dd or if timestamps are needed, yyyy-mm-ddThh:mm:ss±hh:mm e.g. 2023-01-01T17:16:15+5:00
existing properties will be present in the list
new properties can be created directly from this menu and will be tagged as new
fields which are not needed in import can be ignored by enabling the toggle
standard properties can be referenced here
Note that you can also view your sample data by pressing View Full Screen

3. Once filled up, you can make any necessary edit to the mapping.

4. Once finalized, you will have two options to:

Save	A saved mapping will NOT be used to map inbound files
Activate	An active mapping will take files that match the naming convention prefix and re-map fields as needed - you may load a file via the `/users` folder on the corresponding FTP to utilize your mapping

TXT files are now supported (without a corresponding mapping) for pipe, tab, and comma-delimited files which are dropped to the users or segments folders on the corresponding account ftp

Monitoring Mappings

Once the file has been imported into the ZMP from the Users folder, you will be able to monitor the progress and status in a couple of different places from the ZMP.

1. You can confirm that the connection between the source and the destination is healthy by reviewing Data > Connectivity.

2. You can review the status of the file import from Data > Files. If there are any errors, you can download a list of the errored rows.