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.

Amazon Data Studio | Mixshift

$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

Data statements | Mixshift
Good amazon data | Mixshift
Sam Hager | Mixshift
 Mixshift logo

Sam Hager President, MixShift

“We’ve been in your shoes…… and we’re building the solutions we wish existed. Across our team we’ve seen the inner workings of Amazon, built brands, agencies, and managed multimillion dollar ad accounts. That experience guides our roadmap and is built into the DNA of our products.”

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.

Amazon Report Center Data | Mixshift

Become a master Amazon analyzer with our data analytics tool, no previous experience required

Data Master Tables | Mixshift

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.

Advertising Center Controls | Mixshift

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.

Updated data | Mixshift

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 Amazon APIs | Mixshift

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 | Mixshift

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 | Mixshift

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 data in one place | Mixshift

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 | Mixshift

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

Mixshift Services | Mixshift

Ready to unlock your Amazon data?

Check out MixShift Data Studio.

Automated Amazon Data flow offering scalable reporting, democratized data access, & enhanced Advertising management – unlock new insights and bring scale to your organization.
amazon business process management | Mixshift

Report Center

Out-of-the-box Reporting for Amazon

amazon business development | Mixshift

Data Master

Custom Advertising & Operational Data at your fingertips
amazon business analyst | Mixshift

Advertising Center

Streamlined Advertising Management for Amazon

FAQs

Get answers to common questions about our solutions.

Blog

Our wide-ranging commentary on amazon & eCommerce.

Media

See our media content ranging from podcasts, articles, and press.

Partner Program

Join our partner program and earn a discount on referrals.

About Us & Careers

Learn more about us & current opportunities to join our team.

Contact Us

Still have questions? We’re here to help.