Skip to main content

​
Overview

The Creative Importer allows you to upload a CSV file containing creative asset data — such as image URLs, ad copy, metadata, and identifiers — and bulk-import those records into a database source. Like the Data Importer for leads, the Creative Importer includes column mapping, fuzzy matching for near-duplicate creatives, and step-by-step progress tracking.
Creative Importer with matched records, fuzzy matching, and upload button

​
Before You Start

Prepare your CSV file before beginning:
  • File format: .csv (comma-separated values).
  • Encoding: UTF-8.
  • The first row must be a header row with column names.
  • Asset URLs should be fully qualified (e.g., https://cdn.example.com/creative-banner.jpg).
  • Ensure consistent formatting for any date or numeric fields in the file.
Tip: Run a small test batch of 5–10 creatives first to verify your column mapping is correct before importing a full creative library.

​
Step 1: Upload Your CSV File

  1. Navigate to the Creative Importer tab within your database source.
  2. Click Upload CSV File.
  3. Select your file from your local machine or drag and drop it into the upload zone.
  4. The system reads the file and extracts column headers for the mapping step.

​
Step 2: Map CSV Columns to Creative Fields

Align each column in your CSV with the corresponding creative field in Pingtree.
ColumnDescription
CSV ColumnThe header name from your file.
Sample ValuesA preview of values from that column to confirm correct mapping.
Creative FieldThe Pingtree creative field to map this column to.
Standard creative fields available for mapping:
FieldDescription
Creative NameThe display name or identifier for the creative.
Asset URLThe URL of the creative asset (image, video, or document).
Ad CopyThe headline or body text associated with the creative.
Creative TypeThe media type: image, video, or text.
Campaign IDThe campaign this creative is associated with.
StatusInitial status to assign (e.g., new, approved).
TagsComma-separated tag values for categorization.
Custom MetadataAny additional metadata fields defined for your organization.
Mark any columns not needed as Ignore to skip them during import.
Tip: If your CSV column headers match the Pingtree field keys exactly, the system will auto-suggest mappings. Always review these suggestions before proceeding.

​
Step 3: Review and Start Import

Review the mapping summary before starting:
Summary ItemDescription
Total RowsTotal number of creative records in the CSV.
Mapped FieldsAll columns and their assigned creative fields.
Ignored ColumnsColumns that will be skipped.
Click Start Import to begin processing.

​
How Creative Records Are Processed

For each row, the importer:
  1. Validates the row against required fields and format rules.
  2. Checks for exact matches against existing creative records in the source.
  3. Checks for fuzzy matches — creatives similar to existing records.
  4. Creates or updates the record based on the outcome:
OutcomeDescription
New Creative CreatedNo match found — a new creative record is created.
Exact MatchAn identical creative already exists — the record is updated with any new data from the CSV.
Fuzzy MatchA similar creative was found — held for manual review.
Validation FailedThe row has missing or invalid data — logged as a failed row.

​
Fuzzy Matching for Creatives

The fuzzy matching engine compares incoming creative records against existing ones using key identifiers such as the creative name, asset URL, and ad copy. Records that are similar but not identical are flagged as fuzzy matches rather than being merged automatically. To review fuzzy matches:
  1. Go to the Imported Data tab after the import completes.
  2. Open the import file and click Review Fuzzy Matches.
  3. For each pair, compare the incoming creative (left) with the existing record (right).
  4. Choose an action:
ActionDescription
MergeUpdate the existing creative record with data from the CSV row.
Create NewAdd the incoming creative as a separate new record.
RejectDiscard the incoming creative without storing it.
  1. Click Confirm to apply your decisions.
Tip: Fuzzy matches most commonly occur when the same creative has been re-exported and re-uploaded with minor naming changes. Review carefully to avoid creating duplicate assets in your library.

​
Bulk-Approving Imported Creatives

After a successful import, you can bulk-approve all newly imported creatives without reviewing each one individually:
  1. Go to the Creative Library or the imported creatives list.
  2. Select all creatives from the import using the Select All checkbox.
  3. Click Bulk Approve.
  4. Confirm the action.
All selected creatives will move to Approved status and become available for campaign use.
Tip: Use bulk approval only when you have pre-validated the creatives externally (e.g., through an advertiser review process). For new or unverified creatives, review each record individually before approving.

​
Viewing Import File Counts and Status

The Imported Data tab shows a summary for each creative import file:
CountDescription
Total RowsAll rows in the uploaded CSV.
New CreativesRows that created new creative records.
MatchedRows that matched and updated existing records.
Fuzzy MatchesRows held for manual review.
FailedRows with errors that could not be processed.
Import status follows the same lifecycle as lead imports:
StatusDescription
PendingFile uploaded, waiting to be processed.
ProcessingImport is actively running.
CompletedAll rows processed successfully.
Completed with ErrorsProcessing finished but some rows failed.
FailedImport could not complete due to a critical error.

​
Re-Importing Failed Rows

If some rows fail:
  1. Open the import file in Imported Data.
  2. Click Download Failed Rows to get a CSV with only the failed records and their error reasons.
  3. Fix the data issues.
  4. Re-upload the corrected file through the Creative Importer.
Common failure reasons include missing asset URLs, unrecognized creative type values, and malformed metadata fields.