E-commerce Data Validator

Are your e-commerce statistics accurate? Are you making your most important decisions based on inaccurate data? This tool helps you check the accuracy of your e-commerce transactions data quickly, easily and in-depth. To use this tool, you need to sign in to Analytics-Toolkit.com. Sign In or Free Trial.

Validate Your E-commerce Tracking

It uses uploaded transactions data from your e-commerce backend and matches it with e-commerce transactions data from your Google Analytics account. It then reports any discrepancies it finds in an easy to understand way. Simply upload a CSV file with data about the transactions from your online shopping solution and let the tool do its job. We support OSCommerce, BigCommerce, Shopify, Magento, PrestaShop and custom systems.

Google Analytics E-commerce Data Validator - Video Transcript

In this video we present the Google Analytics Ecommerce Data Validator in Analytics-Toolkit.com.

E-commerce data, when applicable, is often the single most important factor internet marketers and web analysts base their decisions and recommendations on. It’s a crucial piece of information and thus its accuracy is of utmost importance for any e-commerce oriented business.

If you can export a CSV file with daily summary data or individual transactions data, we can help you check your e-commerce data accuracy quickly and easily. Our tool does checks on multiple levels and the output is helpful for debugging and fixing any issues.

Let’s see the tool in action. Select the view you want to check the data against then select the CSV file from your machine. We have prepared a sample CSV file with data for individual transactions from the backend. Specify what type of file you are uploading and click “Upload”.

The next step is to match the columns from your CSV file to Google Analytics dimensions. We automatically recognize and map correctly CSV exports from OSCommerce, BigCommerce, PrestaShop, Shopify and Magento. The system will also attempt to automatically map export files from other systems, but some manual mapping might be required.

To map manually, simply select the appropriate CSV column name for the Google Analytics dimension to the left. After you are done, press “Begin Validation”.

First, the tool outputs overall results, segmented by dimension – product revenue accuracy, item quantity accuracy and so on. Then you have a report for accuracy by date.

If the file you uploaded contained data for individual transactions, you will also see a report for accuracy of data by transaction. In it you will see transactions that have different parameters in your CSV file, compared to Google Analytics data. You will also see if there are any transactions that are in the backend-generated CSV but not in Google Analytics and vice versa.

We hope our tool helps make sure your data-driven decisions are based on accurate data.

Tool Characteristics

AutomationPartial / Full

Time-Saving1000X+

Unique ToolYes / No

API OnlyYes / No

Expertise LevelNovice / Experienced / Expert

What should my CSV file contain?

The CSV file you upload must be properly formatted and can be one of two types: summary file by day or a file with individual transactions. In the first case it must contain at least the following columns: date, daily revenue without tax, number of items sold in that day. In the second case: transaction ID, revenue without tax, number of items in the transaction. Other fields that we'll use, if present: date of transaction (highly recommended), shipping cost (incl. tax), tax for the products. The more data you provide, the better the validation. Any other columns will simply be discarded.

The maximum file size is %s MB. If the file you generated is larger than that, you can reduce the number of transactions in it, for example by reducing the date range.