Understanding your sales data is one of the main applications of Source Medium. This document will walk through the fundamentals, some key use-cases, and then briefly explain some limitations of Amazon data.
Connecting Source Medium to Amazon Data
To access Amazon data in the first place, you’ll need to allow source medium to connect and ingest your data. More information about connecting Source Medium and Amazon can be found here.
Where can I find Amazon Sales Data in Source Medium?
Once Source Medium and Amazon are fully connected, you’ll see Amazon as an option in the “Channel” dropdown at the top of the pages in your dashboard.
Sales data shows up all over the Source Medium dashboard, but the main pages to be aware of are the Executive Summary, Year over Year Performance, LTV & Retention, Orders Deep Dive, and Product Performance.
How do I analyze Amazon Sales Data in Source Medium?
As always, make sure to check your channel and date filter to make sure you are looking at Amazon data from your desired period. On this page you find a collection of core metrics about your sales and customers.
The first chart will show net and gross revenue by day. You can change this to by week, month, quarter, or year using the drill-up and drill-down buttons on the top right of the chart.
Other key charts are net revenue by orders and net revenue by spend:
There’s lots more here for you to explore on your own time, but let’s move on!
Analyze trends over time to identify seasonal patterns. The Year over Year page is an excellent place to understand these sales trends. Some key charts:
Checking in on KPIs like Net Revenue or ARPC is the simplest way to get a sense of the health of your business and the efficiency of your operations. You may want to identify sales KPIs for Amazon and have us create scorecards, or synchronize your team through automated weekly emails, for example.
Our LTV & Retention dashboard is an immensely powerful way to understand the lifecycle of your customers, from their first purchase on. This can help you optimize your customer experience by seeing where customers become dedicated fans or drop off. To use this view with your Amazon data, just select Amazon as a channel:
Orders Deep Dive is the place to go for understanding order latency. Coupling the order-level filters on this page with this chart can give insights into how different segments experience different order latency curves:
Additionally leveraging the order latency filter on the top of the page can tailor every chart on Orders Deep Dive to illustrate order information across different order latencies, which can be very powerful!
Often when looking at high-level summaries, we’ll start to think about the underlying business dynamics and functions. In Source Medium, it’s easy to hop from high-level Executive or YoY summaries into the deep-dives and granular analytics to understand why your business is performing the it is. This is something that gets easier with familiarity, but a good way to learn is to ask us analytical questions in Slack!
Amazon Data Limitations
Amazon does not share all of their data, so as you navigate you’re likely to see a few tables or graphs which are not populated. This is expected! We do our best with the limitations of Amazon’s data availability.
- Data History
- Geographic Limitations
- Subscription Data
- PII or Customer Data
- Acquisition Data
Amazon offers limited historic data, with different limitations for different domains. The shortest history is amazon ads, only offering a 60 day history from the time of your ingestion. Most amazon data has 12-18 month history. Going forward from ingestion, Source Medium will begin to store your historic data, allowing your data history to expand.
We can only report on orders shipped to US customers.
Amazon currently offers no subscription-level data, so any information we do have about subscriptions or subscribers is very limited.
Amazon offers no PII (Personally Identifying Information) such as customer email addresses, Customer IDs, or anything that could be used to identify individual customers. Amazon also don’t share any discount codes used by customers.
Amazon doesn’t offer any source/medium information or acquisition campaign information. This means you won’t have CAC (Customer Acquisition Cost), although you will see CPA (as spend / new customers)
For a full list of amazon data availability, consult this airtable.