Historical Data

Rockerbox can distinguish new-to-file from repeat customers. These capabilities allow you to determine how your marketing differs between these types of users.

To access these capabilities, we'll need a one-time log of all historical orders.

📘

Shopify

If you are using the Shopify Implementation, then Rockerbox automatically pulls in your historical orders, and you do not need to separately send us a file.

The dataset we require includes the following:

Field

Description

order_id

Match the format from the Purchase event (i.e. don't send us Shopify Order IDs from your Purchase event, and CRM Order IDs for the historical file).

user_id

Match the format from the Purchase event.

email_address

Optional. We can use this value to match users in cases where user_id formats change over time (ex: you switched from one order system to another).

timestamp

Full timestamp of order including date, time, timezone offset—ideally in UTC.

revenue

This should match the revenue value we get on the Purchase event. If you send us net revenue, the historical file should also be net revenue. if you send us gross, it should be gross.

  • File Format. The file will be in a spreadsheet format, such as .csv, .xlsx, or gsheet. If the file is too large to send over email, Rockerbox will setup a shared folder for the customer to drop the file.
  • Date Range. The date range of the historical order file should start at the beginning of the customer's order history all the way to when the Purchase event was completely setup in Rockerbox.
  • Processing Time. It will take Rockerbox approximately 3 business days to process the file, assuming we do not encounter any issues in the dataset.
  • User Identifiers. Rockerbox only requires one of user_id or email_address to process the historical order file but recommends including both fields in the file.

New Capabilities

After successfully ingesting the historical file, you will have access to two additional capabilities within the platform:

  • "New Customer only" flag on screens like Reports and Converters. This toggle will filter out New Customers based on whether or not we've already seen that user make a purchase in the past.
  • The LTV Cohorts screen that shows you cohorts that make repeat purchases. Note the cohorts timeframe will only include orders that we're capturing via pixels, so you'll need to pick date ranges starting from when the Purchase pixel starting firing in May.

Did this page help you?