Data import

Bring your sales history with you when you switch

Upload an export from your old tool or a spreadsheet. Your past customers and sales show up in your reports on the dates they happened, credited to the channels, campaigns and ads they came from

Growth and Unlimited Included in the free trial

No credit card required. Set up in about 5 minutes

TrueMetriks was installed on Oct 8. One import fills in January to October 7, on the dates the sales happened

Any layout, matched for you

Upload a CSV, Excel (XLSX) or JSON file as it is. For a sheet, AI proposes what each column holds from the header and the first 20 rows, and you can change every match before anything is saved

Your columnSample valuesMatched to
Customer Email[email protected], [email protected]EmailAuto
Order #10482, 10483Order IDAuto
Created At07/10/2026 16:41Purchase date and timeDates are written as Month/Day/YearAuto
Total497.00, 97.00Order totalAuto
utm_campaignugc-hooks, retarget-30dUTM campaignAuto
First Click Sourcefacebook, googleFirst sourceAuto
Notesgift wrapIgnoreNot used

AI matches carry an Auto badge. When AI is unavailable, or has already made 50 AI matches for your organization in the last 24 hours, a built-in matcher reads the column names and its matches say Matched

Check everything before it saves

Before you click Import you see what the file will add: customers, orders, revenue, and every skipped row with its reason

Refunds are taken off their order, and a fully refunded order is skipped. A sale in another currency is converted into your website's currency at that day's rate

A sale with no source in the file lands under its own Imported channel, never under Direct, so your Direct numbers only hold real direct visits

First and last source per sale

When your file has each buyer's visits, the first source is their earliest visit before the sale and the last source their latest. Visits after the sale never count

Old sales can land on their ads

A sale lands on its campaign, ad set and ad when the file names them by ID or by an exact name that only one of your ads has

When the file goes back further than the ad data from your connected Facebook, Google Ads or TikTok account, TrueMetriks fetches the older ad data first: up to about 37 months for Facebook, 12 months for Google Ads and TikTok. So spend and ROAS for the imported period are real

Sales already in TrueMetriks are skipped

A sale in your file counts as already tracked when TrueMetriks recorded a sale with the same email, an amount within 1% and a time within 30 minutes. It is skipped, not counted twice

Sales from after TrueMetriks started tracking that match no tracked sale are skipped too, unless you choose to import them

Upload the same file again and every order already imported is skipped. Any import that is Done or Failed can be undone from Past imports

Nothing goes to your ad platforms

Imported sales are never sent to Facebook, Google Ads, TikTok or GA4. They do not reach your webhooks and do not trigger an email. They only change what you see in TrueMetriks

Imported buyers count as existing customers, so their next purchase shows as returning. Your new-customer numbers are honest from your first day

  • FacebookNot sent
  • Google AdsNot sent
  • TikTokNot sent
  • GA4Not sent
  • WebhooksNot sent
  • EmailsNot sent
  • Your reportsRevenue, Acquisition and ConversionsUpdated

Exports that work

Export your sales from your old tool and drop the file in Settings, Account, Import data. Any layout works as long as it has an email column

  • Hyros (file export)
  • Roaspy (JSON or CSV)
  • Shopify orders export
  • Stripe
  • Northbeam touchpoint exports
  • Your own spreadsheet

Import data

Bring your history from another tool or a spreadsheet: customers, what they bought and where they came from. Imported sales show up in your reports, so nothing is lost when you switch

Import into demo-brand.example
Upload a fileCSV, XLSX, JSON

Any layout works. We read your columns and match email, order ID, product, SKU, amount, date and UTMs for you. You check the match before anything is saved

Drop a file here or click to browse Exports from Hyros, Roaspy, Shopify, Stripe or your own sheet. CSV, XLSX or JSON. Up to 10,000 sales

Past imports

Your import runs in the background. You can leave this page. The sales show up in your reports when it says Done

Source New customers Orders Revenue Status Date
sales_export.csv 4,812 6,930 1,284,300 Done41 already tracked by TrueMetriks Oct 13, 2026 Undo

What it does not do

  • One file per import, with a size limit. Up to 10,000 rows for a CSV or Excel file, 10,000 sales for a JSON file, and 50 MB. A bigger history goes in several imports
  • One import at a time per website. Upload the next file once the first is finished
  • No live sync with your old tool. Each import is a file you upload. Nothing is pulled in on a schedule
  • Customers and their sales only. Leads, booked calls and ad spend are not imported as events, and a row with only an email is imported as an existing customer, so do not upload a lead list. Each sale gets a simulated visit for each source it has, not the buyer's real browsing
  • No .xls files. Save an old .xls as .xlsx or .csv first
  • Click logs without emails and reports of totals cannot be imported. Each sale needs a buyer email, and the file needs the sales themselves, not totals
  • Not every old sale finds its ad. It needs the ad ID or an exact, unique ad name in the file, and ad data from that period: about 37 months back for Facebook, 12 months for Google Ads and TikTok
  • One Shopify case can be imported twice. An order the Shopify Custom Pixel saved under its checkout token does not match the export's order ID

Questions

Can I connect my Hyros account?

No. Export your sales from Hyros as a CSV, Excel or JSON file and upload it under Upload a file. Then check how its columns were matched, as for any other file

Will imported sales be sent to Facebook?

No. Imported sales are never sent to Facebook, Google Ads, TikTok or GA4, never reach your webhooks and never trigger an email. They only show in your TrueMetriks reports

What if I have more than 10,000 sales?

Import them in parts. A JSON file asks for a From and To date, so you import up to 10,000 sales at a time, and you split a CSV or Excel file yourself into files of up to 10,000 rows, keeping every row of one order in the same file. An order already imported is skipped, so parts that touch never double a sale

What does the AI see?

For a CSV or Excel file, only the header row and the first 20 rows, with each cell cut short. For a JSON file, a summary of its layout with a few short samples. When AI is unavailable or has made 50 AI matches for your organization in the last 24 hours, a built-in matcher reads the column names instead

Can I undo an import?

Yes. In Past imports, click Undo next to an import that is Done or Failed. The undo runs in the background and removes that import's orders and the customers it added from your reports

Related features

Switch without losing your history

Upload your old tool's export and see your past sales next to the ones TrueMetriks tracks from now on

No credit card required. Set up in about 5 minutes