Uploading Historical Data

The Historical Data uploader provides an easy way for you to Upload your historical contact, orders, subscriptions data into SegMetrics. 

Uploading Historical Data

You can access the historical data uploader from the integrations page. You can upload your historical contacts data through your CRM or Email Tool integrations, and custom CRM, Payment, and Ad integrations

To upload your historical data:

  1. Head over to the Integrations page in your SegMetrics account
  2. Select the integration to upload your historical data
    1. Contact data can be uploaded via your CRM or email marketing tool integration
    2. Order and Subscription data can be uploaded via your Custom Payments integration
    3. Ads Performance data can be uploaded via the Custom Ads integration
  3. Click the Gear icon on the integration that supports the type of data you’d like to upload
  4. Click Upload Historical Data
  5. Select the type of data to upload
  6. Select the data file to upload (.csv only)
  7. Please Note, there is a 60,000 row limit. We recommend under 40,000 to prevent any slowdown/data delays in the upload
  8. Map the data fields

Now that you have your file prepped and ready to upload, keep reading to learn more about how to map your data to the appropriate fields.

Mapping Your Data File

Once you’ve selected your data file, map the required data fields for the data you’d like to upload. Below you’ll find examples of available data fields as well as all required fields.

Please note, not all fields are required, email is. The fields that aren't required, can be removed.

With some data fields, it’s possible to clarify to SegMetrics how to handle a specific data field, such as the “Is Paid” field in the Orders and Subscriptions imports:

In the examples above, we have a column in our file to indicate whether an order has been paid. We’ve marked paid orders as “Yes” and unpaid orders as “No.” Using those two values from our file, we’ll set the No value to “No” and the Yes value to “Yes.” This tells SegMetrics to mark any order with the “Is Paid” value of Yes to paid, and any value of “No” to unpaid. 

Mapping Contact Data:

  • Contact ID (Required if no email address is included)
  • Email Address (Required if no contact ID is included)
  • Date Created (Required ) date must be in UTC format
  • First Name
  • Last Name
  • Tags (As CSV)
  • Custom Field

Here’s an example of a .csv file with those required fields:

Mapping Order Data:

  • Contact ID
  • Email Address
  • Line Item Amount (Required)
  • Date Created (Required ) date must be in UTC format
  • Line Item ID
  • Shipping Amount
  • Taxes Amount
  • Discount Amount
  • Quantity
  • Product Name (Required)
  • Product ID
  • Order ID (Required)
  • Invoice Total
  • Is Refunded (if is a refund, should be marked as “TRUE”)
  • Is Paid
  • Custom Field

Here’s an example of a .csv file with those required fields:

Mapping Subscription Data:

  • Contact ID (Required)
  • Email
  • Subscription ID (Required)
  • Order ID (Required)
  • Product ID (Required)
  • Product Name (Required)
  • Subscription Amount (Required)
  • Billing Cycle (month, year, etc) (Required)
  • Billing Frequency (1, 2, 3, etc)
  • Status
  • Subscription Start Date (Required)
  • Next Billing Date
  • Last Billing Date
  • Subscription End Date

Here’s an example of a .csv file with those required fields:

Mapping Ads Performance Data:

  • Date (Required)
  • Ad Spend (Required)
  • Impressions
  • Clicks
  • Ad ID (Required)
  • Ad Name (Required)
  • Ad URL 
  • Ad Status
  • Ad Campaign ID (Required)
  • Ad Campaign Name (Required)
  • Ad Set ID (Required)
  • Ad Set Name (Required)

Here’s an example of a .csv file with those required fields:

Review Data For Upload

  • If you see any red cells when you get to the review data for upload screen, you can hover over the cell to see the error message.

  • You can also edit the red cell within the uploader to fix the issue the error message caught.

  • A frequent error message users see for order uploads is "The sum of line item amount must equal the invoice amount". If you see this use the below guide to help:
    • line item total = (Price x qty) + tax + shipping - discount
    • invoice total = Price + tax + shipping - discount.
    • invoice total will be the same in the entire column.
    • In summary, for rows with the same "Invoice ID", the "Invoice Total" of each row must equal the sum of "Line Item Total" of every row, where "Line Item Total" is the result of the equation ( ("Price" * "Quantity") + "Shipping" + "Tax" - "Discount" )

FAQ's/Gotchas

Q: What happens if the data I uploaded causes duplicate data?


A: Uploading historical data isn't always easy. If there was an error or mistake causing any duplicate contacts, reach out to our support help@segmetrics.io. Attach the file you used and an example of a duplicate contact. We can go in and fix it right up for you!


Q: What happens if the data doesn't look correct?


A: Contact our fantastic support team at help@segmetrics.io and be specific about what data looks off and the steps you performed to upload the data. We will fix it on the backend.


Q: Can I delete what I uploaded?


A: As of right now users don't have the ability to delete any of the data they upload. If there was a contact or order uploaded by mistake simply submit a request to our support team along with the data you need deleted.

Still need help? Contact Us Contact Us