Data Studio
Unlock the power of your Amazon data
MixShift pulls, transforms, stores, and presents your Amazon data from the Amazon Advertising API and Amazon Selling Partner API (SP-API). It’s the engine that powers our solutions while making your Amazon API data accessible and usable.
$50,000+
$$ Saved in building your own
48+
# of API connections done for you
≻20%
Efficiency gained across your team
Getting and using your Amazon data shouldn’t be so dang hard. Your time is better spent elsewhere.
Amazon data can wear you out
And you might be spending hours maintaining a house of cards
A fundamental challenge for you and all Amazon account managers is the sheer volume of data available while being tedious and time consuming to pull and maintain. The data is messy, ever-changing, and scattered across many locations within Amazon Seller Central or Vendor Central, making it nearly impossible to keep up with manual data pulling processes every month.
If your company relies on manual data processes, failure is a near inevitability, which is scary.
Incorrect data due to restatements
New reports releasing with changes to stay on top of
Different data in different reports (confusing)
Broken reports as structure evolves
Reports scattered across Amazon
Excel is not a database! Repeat to self if necessary
Sam Hager President, MixShift
Help has arrived
Smart decision-making starts with good Amazon data
Exponentially reduce the amount of time you spend gathering, maintaining, and preparing Amazon data for use, which are hidden costs you know are happening. You feel the pain but it’s hard to measure the impact. You no longer have to work with broken, mismatched, or out-of-date data, and can eliminate outright the possibility of human error in data reporting for Amazon.
MixShift solves the data problem for you, and then goes further by delivering solutions you need to stay on top of multiple Amazon accounts. You don’t need to hire an expensive developer or data scientist, we’ve got you covered with our pre-made solutions that can be customized for your unique needs and tricky clients or executives.
Data updated daily and automatically restated
Data directly from the Amazon Advertising API & SP-API
New API data integrated continuously ahead of the Console
Pre-built database, no developer required
Intentional design and transformations that just make sense
Smart tagging for personalized Amazon reporting and custom analytics
The MixShift solutions built on top of Data Studio:
Report Center, Data Master, & Advertising Center
Unlock new insights with our library of ready-to-go smart reports
Report Center
Polished, presentation-ready reports updated automatically every day for Amazon account managers
Having all the data is great, but it doesn’t do an ounce of good unless you can use it. One of the biggest hurdles Amazon account managers face is building reporting that scales as your agency, brand, or aggregator grows. As you and your clients become more sophisticated, it can be a challenge to deliver results and continuously communicate your value to clients.
In collaboration with our early partners, the Mixshift team built hundreds of reports in BI tools like Google Data Studio but continued to run into issues of scale. Enter Report Center, an out-of-the-box reporting solution with a deep library of templates and dashboards pre-built and automatically connected to your data. Translation, you don’t have to build a thing, all your reporting is done for you including unique insights into your Amazon business you can’t get anywhere else.
Become a master Amazon analyzer with our data analytics tool, no previous experience required
Data Master
Analyze your data on-the-fly, finally freed from spinning excel files and cumbersome pivot tables
What drove my ACoS down last month? Was it due to higher CPCs, lower conversion rates, a ‘mix shift’ to lower priced products? What was my top-selling non-brand search term during Prime Day last year? No matter the question, you can find the answer with Data Master.
MixShift stores all of your historical data so you can confidently compare performance over time. We’ve built analytics tools for Amazon sellers that simplify the common analyses, turning hours of work into mere moments. Among many useful features, we help you ditch pivot tables forever, providing pivoted data across ads, ops, and a blend of the two. We also have a secret weapon in our Bridge Engine, a powerful feature that shows you exactly what is driving performance changes in ACOS and other metrics, all the way down to the search term level.
Save time and ad budgets with our advertising tools for Amazon agencies
Advertising Center
You’re the Amazon expert, you just need the right levers to pull
Amazon advertising management can be overwhelming. Throw in multiple accounts with big budgets and the burden to manage can become a very tall task. While some may resort to black-box algorithms to automate their work, we don’t believe that’s the way. Our focus is empowering Amazon experts like you to make bulk changes using finely tuned performance filters for a perfect balance of efficiency and attention to detail an account requires.
We make core advertising optimization tasks like bidding, budgeting, negations, and more straightforward and swift. You apply your personal performance criteria to find opportunities and waste, and then apply live changes account-wide with a single push of a button.
Your go-to solution for Amazon Data, Reporting, Analytics, and Advertising Management.
With your data concerns behind you, you’ll be able to focus on things you really want to do, like growing your clients’ Amazon accounts and advertising budgets.
Daily Updated & Restated Data
Amazon data is refreshed every day across all data sets and is published to your database by 8:00 am local time. We also ensure your data is restated for any changes that have occurred so you don’t mistakenly report outdated and incorrect data to your clients or executives.
Direct from the Amazon APIs
You’re getting the best data Amazon has available (often ahead of the Amazon Console), automatically. It would be hard to overstate the time savings you’ll rack up when you don’t have to pull manual reports anymore.
Smart Linking Across Ads & Ops
The full picture of business performance requires looking across operations and advertising data (think TACOS, but better). We do this integration and preparation for you, while providing editable labels and tagging fields to fully customize your reporting and analytics for Amazon.
Protected from Structural Changes
Amazon adds new data sets to the Amazon APIs before they are made available in the Amazon Console reports. We have dedicated resources focused on integrating new data sets into our system so you have the latest and greatest.
All your Data in One Place
With Amazon’s multitude of scattered reports, maintaining a manual store of the data will be the Achilles’ heel of your operations. MixShift eliminates that weakness by capturing your data programmatically and making it useful in a single space for all of your managers and employees.
Intentional Design & Transformation
We know the potential that lies within Amazon data, but the raw data is hardly structured to support easy use. With your needs in mind, we’ve taken care to wrangle, scrub, structure, and transform the data to make important analyses possible without the heavy data prep lift.
What data does MixShift have available for reporting and analytics?
From the Amazon Advertising API data:
Campaign
Data included: All sponsored ads data for Sponsored Products, Sponsored Brands, and Sponsored Display ad types at the campaign level.
Where it comes from: This data ties to the Ad Console interface, as well as the ‘Campaign’ exportable report in the Ad Console for each of the respective ad types.
Endpoint(s) used: https://advertising-api.amazon.com/reporting/reports
Historical data available: 60 days prior to activation date and forward
Campaign Tracking
Data included: This is a MixShift unique table that tracks campaign-level attributes on a daily basis such as budget, creative, missed sales, budget utilization, and more.
Where it comes from: This is a MixShift unique table that aggregates campaign data from mutliple sources.
Historical data available: Activation date forward
Ad Group
Data included: All sponsored ads data for Sponsored Products, Sponsored Brands, and Sponsored Display ad types at the ad group level.
Where it comes from: This data ties to the Ad Console interface, but does not have an exportable report twin in the Ad Console.
Endpoint(s) used: https://advertising-api.amazon.com/reporting/reports
Historical data available: 60 days prior to activation date and forward
Keywords & Targets
Data included: All sponsored ads data for Sponsored Products, Sponsored Brands, and Sponsored Display ad types at the keyword and target expression level.
Where it comes from: This data ties to the Ad Console interface, as well as the ‘Search Term’ exportable report in the Ad Console for each of the respective ad types. Note that for Sponsored Display, Search Term is not yet reported so the data in this table ties to the ‘Targeting’ report at the target expression level for SD campaigns.
Endpoint(s) used: https://advertising-api.amazon.com/reporting/reports
Historical data available: 60 days prior to activation date and forward
Product Ad (Advertised ASIN)
Data included: All sponsored ads data for Sponsored Products and Sponsored Display ad types at the product ad (ASIN) level. Note, this data source excludes Sponsored Brands data as cost data is not reported on the product ad level for SB ads.
Where it comes from: This data ties to the Ad Console interface, as well as the ‘Advertised product’ exportable report in the Ad Console for each of the respective ad types excluding Sponsored Brands.
Endpoint(s) used: https://advertising-api.amazon.com/reporting/reports
Historical data available: 60 days prior to activation date and forward
Monthly Metrics
Data included: This is a MixShift unique table that rolls up hisotrical advertising performance data by Ad type by Month. This includes Sponsored Products, Sponsored Brands, Sponsored Display, and DSP ad data for each unique advertising Profile (merchant or DSP seat)
Where it comes from: This is a MixShift unique table that aggregates campaign data from multiple sources for the purposes of monthly report.
Endpoint(s) used: https://advertising-api.amazon.com/reporting/reports
Historical data available: This table is automatically populated with available data from the campaignmetric table, but is able to be updated with additional historical data via a custom uploader file.
DSP Audience
Data included: All DSP audience-level reporting data at the segment and targeting method level.
Where it comes from: DSP reports in the Ad Console currently require custom configuration to match the API data reported. The data matches across the respective data sources for Console-configured reports that include the lowest level of segmentation reported in a given table.
Endpoint(s) used: /accounts/{accountId}/dsp/reports
Historical data available: 90 days prior to activation date and forward
DSP Campaigns
Data included: All DSP audience-level reporting data at the line item and creative level.
Where it comes from: DSP reports in the Ad Console currently require custom configuration to match the API data reported. The data matches across the respective data sources for Console-configured reports that include the lowest level of segmentation reported in a given table.
Endpoint(s) used: /accounts/{accountId}/dsp/reports
Historical data available: 90 days prior to activation date and forward
DSP Geography
Data included: All DSP audience-level reporting data at the city level.
Where it comes from: DSP reports in the Ad Console currently require custom configuration to match the API data reported. The data matches across the respective data sources for Console-configured reports that include the lowest level of segmentation reported in a given table.
Endpoint(s) used: /accounts/{accountId}/dsp/reports
Historical data available: 90 days prior to activation date and forward
DSP Inventory
Data included: All DSP audience-level reporting data at the supply source and site name level.
Where it comes from: DSP reports in the Ad Console currently require custom configuration to match the API data reported. The data matches across the respective data sources for Console-configured reports that include the lowest level of segmentation reported in a given table.
Endpoint(s) used: /accounts/{accountId}/dsp/reports
Historical data available: 90 days prior to activation date and forward
DSP Products
Data included: All DSP audience-level reporting data at the product name and product subcategory level.
Where it comes from: DSP reports in the Ad Console currently require custom configuration to match the API data reported. The data matches across the respective data sources for Console-configured reports that include the lowest level of segmentation reported in a given table.
Endpoint(s) used: /accounts/{accountId}/dsp/reports
Historical data available: 90 days prior to activation date and forward
DSP Technology
Data included: All DSP audience-level reporting data at the browser and device level.
Where it comes from: DSP reports in the Ad Console currently require custom configuration to match the API data reported. The data matches across the respective data sources for Console-configured reports that include the lowest level of segmentation reported in a given table.
Endpoint(s) used: /accounts/{accountId}/dsp/reports
Historical data available: 90 days prior to activation date and forward
From the Amazon Selling Partner API (SP-API) Retail data:
*Note that SP-API data is NOW AVAILABLE for both Sellers and Vendors. We have released our Vendor Retail Analytics including sales, inventory, traffic, demand, items, and net ppm. Brand Analytics data will follow, which will be available for both Sellers and Vendors.
Orders (Sellers)
Data included: All orders data at the order level (no item details)
Where it comes from: This data ties to the ‘All Orders’ report in Seller Central found under Reports > Fulfillment > Sales > All Orders
Historical data available: Last 25 months + Month to Date (up to activation date) and forward
Orders by Item (Sellers)
Data included: All orders data at the ASIN and SKU level.
Where it comes from: This data ties to the ‘All Orders’ report in Seller Central found under Reports > Fulfillment > Sales > All Orders
Historical data available: Last 25 months + Month to Date (up to activation date) and forward
Business Reports by SKU (Sellers)
Data included: The Detail Page Sales and Traffic report data at the daily date and SKU level.
Where it comes from: This data ties to the ‘Detail Page Sales and Traffic’ By ASIN report in Seller Central found under Reports > Business Reports > By ASIN > Detail Page Sales and Traffic.
Historical data available: Last 13 months + Month to Date (up to activation date) and forward
Business Reports by Date (Sellers)
Data included: The Detail Page Sales and Traffic report data at the daily date level.
Where it comes from: This data ties to the ‘Detail Page Sales and Traffic’ By Date report in Seller Central found under Reports > Business Reports > By Date > Detail Page Sales and Traffic.
Historical data available: Last 23 months + Month to Date (up to activation date) and forward
Catalog - All Items (Sellers)
Data included: This is a MixShift unique table including all current and historical catalog data at the ASIN and SKU level. This is the list of current ASINs and SKUs, as well as archived or closed listings over time.
Where it comes from: This is a MixShift unique table but for In Catalog items, ties to the ‘All Listings’ report in Seller Central found under Reports > Inventory Reports > All Listings.
Historical data available: Data is populated from Activation date forward, showing all items in the catalog over time as a record table (no dates)
Returns (Sellers)
Data included: All returns at the ASIN and SKU level.
Where it comes from: This data ties to the ‘FBA customer returns’ report in Seller Central found under Reports > Fulfillment > Customer Concessions > FBA customer returns
Historical data available: Last 25 months + Month to Date (up to activation date) and forward
Inventory History (Sellers)
Data included: All inventory data for both FBA and FBM seller SKUs, noting that this report takes a snapshot of the inventory quantities once per day. Includes FBA inventory statuses such as fulfillable, reserved, inbound, researching, and more for a true picture of Available inventory. The enhancements we’ve made to the data that you can’t get from Amazon are: identifying out of stock instances, including merchant fulfilled inventory, and inclusion of stranded inventory not available in the active catalog.
Where it comes from: This data largely ties to the Manage FBA Inventory Report with some MixShift modifications described above. The FBA Inventory report can be found in Seller Central found under Reports > Fulfillment > Inventory > Manage FBA Inventory, noting that the data ties at the time of the snapshot as inventory quantities are continuously changing.
Historical data available: From activation date and forward
Inventory Health (Sellers)
Data included: The most current Inventory Health data at the ASIN and SKU level, noting that this is data takes a snapshot of the data once per day and does not track historical inventory health states.
Where it comes from: This data ties to the ‘FBA Inventory’ report in Seller Central found under Reports > Fulfillment > Inventory > FBA Inventory
Historical data available: This is a snapshot table and shows only the previous day’s data at all times
FBA Estimated Fees (Sellers)
Data included: The most current FBA Estimated Fees data at the ASIN and SKU level, noting that this is data takes a snapshot of the data once per day and does not track historical FBA fee values.
Where it comes from: This data ties to the ‘Fee Preview’ report in Seller Central found under Reports > Fulfillment > Payments > Fee Preview.
Historical data available: This is a snapshot table and shows only the previous day’s data at all times
Sales (Vendors)
Data included: All sourcing and manufacturing sales data at the ASIN level
Where it comes from: This data ties to the Retail Analytics reports in Vendor Central found under Reports > Retail Analytics > Sales
Historical data available: Last 25 months + Month to Date (up to activation date) and forward
Traffic (Vendors)
Data included: All traffic data at the ASIN level
Where it comes from: This data ties to the Retail Analytics reports in Vendor Central found under Reports > Retail Analytics > Traffic
Historical data available: Last 25 months + Month to Date (up to activation date) and forward
Demand Forecast (Vendors)
Data included: All demand forecast data at the ASIN level
Where it comes from: This data ties to the Retail Analytics reports in Vendor Central found under Reports > Retail Analytics > Forecasting
Historical data available: From the point of activation, we store the first available forecast and then continuously add new forecasts for each ASIN + Week as they are released from Amazon, giving you a historical record of forecasts and changes made to a given ASIN’s forecast over time.
Inventory (Vendors)
Data included: All inventory data at the ASIN level
Where it comes from: This data ties to the Retail Analytics reports in Vendor Central found under Reports > Retail Analytics > Inventory
Historical data available: Last 13 months + Month to Date (up to activation date) and forward
Net Pure Product Margin (Vendors)
Data included: All net pure product margin data at the ASIN level
Where it comes from: This data ties to the Retail Analytics reports in Vendor Central found under Reports > Retail Analytics > Net PPM
Historical data available: Last 13 months + Month to Date (up to activation date) and forward
Catalog Items (Vendors)
Data included: All vendor catalog items identified in the various metric reports
Where it comes from: This is a MixShift special as Amazon does not publish vendor catalogs directly in the API. Instead, we identify all ASINs available in the various metric reports and build the catalog based on those ASINs present.
Historical data available: All vendor items in initially pulled historical sales data and forward.
It’s embarrassing how much we think about Amazon data
Translating data into insights and insights into action since 2010
We have spent years in the Amazon space, successfully building Amazon agencies and supporting hundreds of e-commerce businesses navigating this industry. Along our journey, we have encountered issues of management and efficiency firsthand. With an objective of solving these problems, we’ve built tools for Amazon that will hopefully make your life a whole lot easier…and we use them everyday to ensure they continue to do so.
Need Help?
Amazon can be overwhelming… and sometimes you may need a helping hand.
Tap our team of Amazon experts, well-versed in all things Amazon. From custom reporting and one-off deep dives, to training and strategic consulting, if you’re struggling, reach out to us for help. We have the tools and talents for Amazon to help you with the following:
Advertising Deep-Dives
Amazon Training
Acquisition Analytics
Account Audits
Custom Reports
Strategic Consulting
Ready to unlock your Amazon data?
Check out MixShift Data Studio.
