Order history data for prospecting campaigns

To optimize prospecting campaigns (which acquire new customers), Axon highly recommends that you provide Axon with order history data. This allows Axon to build an accurate model of your existing customers so it can find new, high-value users.

If you are a Shopify user who installed the Shopify Axon app and connected it to your Axon Ads Manager account, you’re ready!

Otherwise, follow the requirements below to upload this data in CSV form.

File upload requirements

• File format: CSV only.
• File size: Maximum file size of 200 MB per file.
• Upload method: You can upload files directly, or via secure transfer methods (e.g. SFTP).
• Multiple files: You can upload multiple files. The data from each new file are added to your existing backfilled data.
• Deduplication: Axon automatically deduplicates orders based on the transaction_id. Axon ignores any data row with a transaction_id that already exists in its system. If rows with duplicate transaction_ids exist in a single file, Axon keeps the one with the earliest event_timestamp and discards the rest.

Field specifications

Your CSV file must include all the required headers listed below, though certain fields are optional to populate.

The column order does not matter, but the header names must match exactly.

Event window: Axon processes only those events that occurred in the past two years. Axon excludes events that are older than two years.

Key validation rules

• Headers: The file must contain all the required headers listed above.
• Identifier requirement: Each row must contain a user_id and email. Axon rejects rows that are missing values for those columns.
• Event name: The event_name column must exist and its value must be purchase.
• Transaction value: The value column must contain a non-negative number (≥0).
• Country code: Axon does not accept order history data relating to customers in the following countries/regions:
  • AX — Åland Islands
  • AD — Andorra
  • AT — Austria
  • BE — Belgium
  • DK — Denmark
  • FO — Faroe Islands
  • FI — Finland
  • FR — France
  • DE — Germany
  • GI — Gibraltar
  • GR — Greece
  • GG — Guernsey
  • IS — Iceland
  • IE — Ireland
  • IM — Isle of Man
  • IT — Italy
  • JE — Jersey
  • LI — Liechtenstein
  • LU — Luxembourg
  • MT — Malta
  • MC — Monaco
  • NL — Netherlands
  • NO — Norway
  • PT — Portugal
  • SM — San Marino
  • ES — Spain
  • SJ — Svalbard & Jan Mayen
  • SE — Sweden
  • CH — Switzerland
  • GB — United Kingdom

Example CSV file

Here is an example of a valid CSV file:

Providing customer data to Axon is subject to your own privacy compliance requirements, including any necessary notices and consents.

Axon hashes plaintext email addresses and phone numbers that you provide.

If you would prefer to perform your own hashing, do so by carefully following these guidelines:

email : Remove any leading or trailing whitespace. Convert any uppercase characters to lowercase. Then hash via SHA256.

phone : Remove any leading or trailing whitespace. Also remove any leading zeros. Remove any dashes, plus-signs, or other symbols. Convert any letters to their numerical counterparts. Always include the country code (for example, 1 for United States phone numbers). Then hash via SHA256.

For example (for email addresses):