We all know how effective data repositories are in housing local data collections and providing access to them through various means. In the same vein, the Zeta Marketing Platform has its own Asset library that enables you to securely store and share marketing-related files (attribution files, seed files, model files) in ZMP.

Importing a File

1. From the menu on the left, navigate to Data > Files. Click on Import File.

2. Drop the desired file here or click on Browse the file.

Note: The maximum file size allowed is 10MB.

3. Once uploaded, the file will be listed in the assets library:

Columns

Description

Name

Name of the imported file

Type

Type of the file being imported with possible values as - User, Event, Coupon, Resource, Seed, Model, Attribution, Suppression, Other

Format

Whitelisted formats of file being imported are TSV, RTF, HTML, PHP, PGP, PDF, MP4, JPG, JPEG, PNG, TXT, JSON, GZIP, GZ, ZIP, XLSX, JSONL, CSV

Source

Source of file with possible values as UI, FTP, SFTP, AWS S3

Tags

Tags associated with the asset

Date

Date of import 

Status

Status of import. This status should change to 'Pending' as soon as you initiate the import - then to 'In-progress' - The status will finally result in either 'Successful' or 'Failed'.

Rows Processed

Number of rows processed from the source file

Exporting a File

Any file hosted in the platform can be exported to a customer’s designated FTP, AWS S3 locations, or can be delivered via email as a link to a location hosted at Zeta.

Email

Files can be shared via email using an auto-generated link to Zeta's internal hosted location.

1. Locate the row with the file you want to export. Click on the three dots on the right > Export.

2. Provide a list of email addresses in the Email Recipient field and click on Export File.

FTP/SFTP

1. Locate the row with the file you want to export. Click on the three dots on the right > Export.

2. Select FTP/SFTP from the Export via dropdown.

Either:

  • Select from a list of pre-defined external FTP locations.

  • or Click on Add & manage locations to enter a new FTP location.

3. Click on Export File.

Amazon S3

1. Locate the row with the file you want to export. Click on the three dots on the right > Export.

2. Select Amazon S3 from the Export via dropdown.

Either:

  • Select from a list of pre-defined external S3 buckets.

  • or Click on Add & manage locations to enter a new S3 bucket.

3. Click on Export File.

Searching for/Filtering Files

You can search for imports/exports in the following ways:

1. For a quick search for imports, you can click on the magnifying glass and add text from the filename you are looking for.

2. For a more focused search, you can click on the funnel icon and enter the criteria specific to what you are looking for.

  • The Filter menu will be prompted and you can select from the following:

Column

Criteria

Date

  • Today

  • This Week

  • This Month

  • This Year

  • A Specific Date

  • Within a Date Range

Type - CheckBox

  • Seed

  • Attribution

  • Suppressions

  • Other

Status - CheckBox

  • In Progress

  • Successful

  • Failed

  • Pending

  • Completed with Errors

  • Ready to Activate (Programmatic Export only)

Format - CheckBox

  • CSV

  • G2

  • TXT

  • OTHERS

  • DAT

  • PGP

  • ZIP

Tags

  • Enter in the Tags that you added during import

Source - CheckBox

  • S3

  • UI

  • FTP

Organizing Files

A best practice for organizing files would be to add tags to the import/export.

1. To add a tag, click on the row of the desired file, and select the Tag icon. Click on + Add Tag.

2. You can later filter for these tags as detailed above.

Checking the Status of Import/Export

Once the files are imported/exported, you can see their status in the assets library.

The following statuses are available:

Status

Definition

In Progress

File is in progress of being imported/exported

Successful

File was either Imported or Exported successfully

Failed

File that was either Imported or Exported has failed

Pending

Ready to Activate

File that has been successfully been exported and audience matching has been completed. Currently only supported for Programmatic channel exports.

Completed with Errors

File that was imported or exported completed but there are errors with the file

For successful exports to Google Ads, you can find the Customer Match match rate in the export details. Google only supports match rates for audiences with more than 100 unique matches.

Google’s current benchmarks for Customer Match match rate are:

0-29%

Low

29-62%

Average

62-100%

High

Feel free to reach out to Support for additional help.

People Import Correction Process

  • Email correction will remove spaces and special characters will replace commas with periods

  • Email addresses and phone numbers that don’t match the correct pattern will be rejected

  • Phone correction will remove non-numeric characters

  • Phone correction will add country code if + is missing (default to the country in the account set up)

  • Send a notification email on file import with import breakdown

Best Practices

Follow a Naming convention for files names this way it is easy to search and filter

Follow a convention for a newer version of a file