An eCommerce Analytics Challenge: Combining Amazon Data and Shopify Data


As you’ve scaled on Shopify and started to sell on Amazon, you’ve probably noticed that reporting on Amazon is a different animal from Shopify. How Amazon reports on and stores your brand’s data has many different nuances that are necessary to understand. 

To help you get to a place where you can effectively report on both sales channels together and the nuances you need to know to properly report on Amazon, we're going to cover:

  1. What you need to know about Amazon data and data reporting compared to Shopify data reporting
  2. The difficulties you’re likely to encounter when you’re trying to combine your Amazon and Shopify data 

Amazon Data Reporting vs. Shopify Data Reporting

Reviewing your Amazon data

There are three major ways to access and review your Amazon data:

  1. Using Amazon’s dashboards (which Amazon calls "reports")
  2. Downloading data reports
  3. Through Amazon’s SP-API

Amazon's Dashboards

You will most likely want to focus on some standard data categories to track your brand’s performance on Amazon. These probably include Orders and Sales, Inventory, Product Performance, Fulfillment, and Returns. 

Dashboards in the Amazon Seller Central UI provide high-level performance views. For instance:

View of sales dashboard in Amazon Seller Central UI, accessible via Side Menu -> Reports -> Business Reports

These dashboards provide simple visualizations (the user cannot drill into the data, only highlight each date dimension: "Today so far," "Yesterday," and "Same day last week"), as Amazon reserves more detailed data for spreadsheets and via the API.

Downloading Amazon Data Reports

Via each Amazon dashboard, you can download each report as a CSV. The spreadsheets provide a ton more data, though can be quite large and require a fair amount of manipulation in order to normalize the data—and much more manipulation to analyze the data.

Exported report from the Seller Central Sales Dashboard

Programmatically retrieving data through the SP-API

In order to get access to the SP-API, a developer on your team will have to submit a developer application through your Seller Central account. They will also need an AWS account and set up AWS IAM (Identity and Access Management). Beginning to end, this process can be quite time-consuming and take weeks to months to set up, depending on corrections or changes requested by Amazon.

Reviewing Your Shopify Data

Similar to Amazon, you can access and review Shopify data in the same three ways:

  1. Using your Shopify dashboards
  2. Exporting data from the "Reports" section
  3. Via Shopify's API

Shopify's Dashboards

The analytics section of Shopify's UI provides visualizations with more data than Amazon's, though it is still limited, and users cannot drill into the data.

Downloading Shopify data reports

Through the "Reports" section of the Shopify dashboard, brands can retrieve a few dozen reports that stretch beyond what Shopify's visualizations provide.

Programmatically retrieving data through the Shopify API

You can programmatically extract data via Shopify's REST API or its GraphQL API (dev pages here). This is by far the best way to get your hands on Shopify data, as Shopify exposes hundreds of data points, and with the right data transformation, extremely robust analytics is possible.

Why Amazon Data + Shopify Data + eCommerce data analytics is a challenge

The eCommerce data model and how Amazon changes it

In eCommerce, there are four fundamental data components: Customers, Products, Orders, and Fulfillments. The majority of your eCommerce data and analytics efforts fall under these categories.

When using Shopify, your data is fairly complete, and you have instant access to all four components of the data model. You have customer data (email, phone number, address, etc.), product data (SKUs, Units, Costs), order data (who is buying what and how much), and fulfillment data (operations data galore: suppliers, shipping, delivery).

However, Amazon makes Products and Orders data available to you (and third party reporting tools). Internally, of course, Amazon has immense amounts of data Customer and Fulfillment data, but they restrict what merchants have access to. 

A big reason for the lack of customer data is that customers who purchase your products on Amazon are not your customers. They are Amazon’s customers. 

For example, you have probably noticed that Amazon hashes (anonymizes) customer emails. Or, that Amazon makes you delete customer PII (Personally Identifiable Information) after 30 days. By taking steps like these, Amazon eliminates the idea of a customer (from an analytics perspective) so that merchants can’t whisk people away and sell to them directly.

Basically, Amazon gives you exactly enough data to maintain its business model and nothing more. 

Amazon data reports, part 1: ASINs, Seller SKUs, and FN SKUs

The bulk of Amazon data that you can get your hands on comes from the reports that we discussed earlier. You can download about 30 different Amazon data reports that provide you with a lot of information about Products and Orders. You’ll be able to dive into information about how long inventory has been stored, associated inventory fees, fast-selling SKUs, and much more. 

Unfortunately, these data reports get complicated. Here’s why.

A key piece of Amazon’s ecosystem is that it has invented its own organizational information (because, Amazon). These are the big three:

  1. ASIN (Amazon Seller ID Number): A unique code for every item in the Amazon space that Amazon gives you.
  2. Seller SKU: You request SKUs from Amazon. Sometimes, they give you the SKUs that you request, sometimes they don’t. 
  3. FN SKU (Fulfillment Network SKU): A separate SKU that the Amazon Fulfillment Network gives to a product (yup, each product has two SKUs and an ASIN)

If you want to make sense of these data reports on your own, you’ll have to develop your own system to track all of the Amazon-added variables.

Amazon data reports, part 2: the settlement report

In addition to the Product and Order reports, Amazon has a special (and incredibly detailed) report called the settlement report. The settlement report is designed to give the full breakdown of the fees (ranging from customer service to inventory) associated with your account. 

In principle, the settlement report allows you to calculate the profitability of different products and get an understanding about where your greatest costs are. 

In practice, you may be able to learn more about your CS and inventory costs through Amazon, but you’re likely going to have a tremendously difficult time trying to understand your products’ profitability. 

Some brands use BI and visualization tools built specifically for making the Amazon data reporting headaches less headache-y, but if you’re selling on Shopify and Amazon, a third-party tool built specifically for Amazon will only help you so much. More on that now.

The hard(er) part: combining Amazon data and Shopify data

You have probably realized at this point that not only do Amazon data and data reporting have more elements than Shopify data, but that the data is quite different. Shopify data and data reporting is understandable for anyone in eCommerce, but working with Amazon is another ballgame. 

In order for eCommerce brands to combine Amazon data and Shopify data on their own, they face two options:

  1. Simplify Shopify data
  2. Massage Amazon data to fit Shopify data

Although neither option sounds great, option 2 is a better choice because nobody wants to simplify their Shopify data and lose the granularity and actionability it brings. That said, you’re now left with some heavy data lifting to do. 

Even if you do pay for an Amazon-specialized BI/visualization tool, you might have nice-looking Amazon data, but you’re still left with two data silos that don’t overlap.The fundamental problem of Amazon data + Shopify data remains.

[To read about how Reshoevn8r, a Daasity customer, successfully combined their Amazon, Shopify, and multi-channel ad data, click here.]

In order to combine the two data sources, you have to create the two parts of the eCommerce data model that Amazon is missing (Customer and Fulfillment) out of your order data. 

Then, you need to map out the constructed Amazon data onto the Shopify data using a number of the Amazon data reports using logic you create (which gets even more complicated, because not every report has all of the information you need, so you have to combine the data from different reports, which you have to download every time you want refreshed information) and combine those with your Shopify data in separate spreadsheets. 

We haven’t even touched on trying to build consistent and reliable metrics and eCommerce data analytics for your brand based on the hacked-together data situation. That's a whole other ballgame.

But, what if I don’t want to do all this myself?

Example high-level overview dashboard showing Amazon revenue, subscription revenue, and transactional revenue from the Daasity app.

We’ll toot our own horn a little bit here: if you don’t want to face this long and laborious process of dealing with Amazon data reporting, Shopify data reporting, and combining the two (plus the manual data analytics nightmare on top of it), Daasity can help you out. 

We’ve spent years building the right extraction and transformation process to get the data a fast-growing brand needs from Amazon and combine it with Shopify data for a holistic understanding of their business. We do all of this for you, automatically, in super-easy-to-read dashboards that allow you to look at all your Amazon data and Shopify data in the same charts.

Having a single source of truth with your data is the key to making sound decisions in a fast-growing eCommerce business, and it is challenging to create a single source of truth when you have to do all of it by yourself. Check us out here and learn more.

May interest you