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:

Head over to the Integrations page in your SegMetrics account
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
Click the Gear icon on the integration that supports the type of data you’d like to upload
Click Upload Historical Data
Select the type of data to upload
Select the data file to upload (.csv only)
Please Note, there is a 60,000 row limit. We recommend under 40,000 to prevent any slowdown/data delays in the upload
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
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.