Amazon has a couple different APIs and is a bit confusing to navigate. First, there’s the product API which passes product specific dimensions and metrics like product name, quantity sold, fulfillment channel, etc. This API allows you to create nice tables to see best sellers, search sales by product, etc. Second, there’s the API which passes more order related data such as daily orders, revenue, etc. this part of the API is great for tracking your daily sales and trending over time. Fortunately, there are a few different good options for connectors on this page.
- Data Points: First, what are interested in reporting on? Give each connector a test-run to ensure that you have the right data angle in terms of pulling the combinations of dimensions and metrics which you need.
- Roll-Up Amazon Reporting: Do you have one Seller Central account or many to report on? Some connectors will just allow for 1 connection while others will make it easy to roll-up data and filter by account as needed.
- Direct Connection vs Data Warehousing: With some connectors, you connect directly to the Amazon APIs in real time. This means that you’ll pull data from Amazon each time your report loads. However, it’s sometimes good to warehouse the data (as Power My Analytics does) so that you can trend data faster.
For Amazon, we like Power My Analytics hands-down. It’s fast, data is all there, and we can produce an extremely useful view of our clients’ Amazon efforts.