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
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
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
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
What it does not do
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