What MixShift data does Rig sync?

Accounts, ads rollups (account summary, campaign performance, search terms, ASIN performance), retail sales and traffic, Brand Analytics search query performance, and daily campaign, ad group, keyword and product ad history.

How far back does the history go?

The daily history streams reach past Amazon's own 60 and 95 day lookback, as far as MixShift holds data. The rollup streams cover a trailing window you set, from 1 to 366 days.

What credential does Rig need?

A client ID and client secret that a MixShift tenant admin creates with the Create with raw secret option. The secret is shown once, and the credential is read only unless an admin adds a write scope.

Can I query MixShift data in Claude or ChatGPT?

Yes. Once MixShift is synced to your warehouse, Rig serves it to Claude, ChatGPT, Cursor and other AI tools over MCP.

Advertising Supported

MixShift integration for Rig

The easiest way to connect MixShift to Claude and other AI tools

MixShift is an Amazon Ads and retail data platform that keeps advertising and sales history well beyond the 60 and 95 day lookback of Amazon's own APIs.

Try Rig Book a demo

What Rig syncs from MixShift

Once connected, Rig models these objects so questions resolve to the right tables and joins:

Accounts
Ads account summary
Campaign performance
Search terms
ASIN performance
Retail sales
Retail traffic
Brand Analytics search query performance
Daily campaign, ad group, keyword and product ad history

How MixShift connects to Rig

Rig Ingest syncs MixShift into your warehouse on a schedule, using a client ID and secret that a MixShift admin creates. Rollup streams run every sync, and the daily history is loaded one month at a time.

Read the step-by-step MixShift setup guide

Analyse Amazon Ads performance beyond Amazon's lookback

Amazon's own reporting APIs reach back 60 to 95 days for Sponsored Products, Brands and Display. MixShift holds the longer record, and Rig reads it as daily campaign, ad group, keyword and product ad tables, so year-on-year comparisons are possible.

Ask Rig

How did ad spend and sales by campaign compare with the same month last year?
Which ad groups have had the lowest return over the last 18 months?
Show daily spend for one campaign across its full history

Find the search terms and keywords that earn their spend

Search terms are the shopper queries that triggered your ads, and keywords are the targets you bid on. Rig reads both from MixShift, so you can see which terms drive sales and which only drive clicks.

Ask Rig

Which search terms spent the most without a sale this quarter?
What are the top keywords by sales in each campaign?
Show search term performance for my best selling ASIN

Compare ads and retail performance by product

ASIN performance joins the ads view with product level retail sales and traffic. Rig puts these in one warehouse, so you can see how advertising lines up with sessions and sales for a single product.

Ask Rig

Which ASINs have rising ad spend but flat retail sales?
How do retail sales and traffic trend for my top 10 ASINs?
Show ads spend next to retail sales by ASIN for last month

Track brand search demand

Brand Analytics search query performance shows how shoppers search on Amazon. Rig syncs it alongside your ads data, so you can read demand next to what you spent on those terms.

Ask Rig

Which search queries bring the most traffic to my brand?
How did search query performance change over the last 8 weeks?
Which high volume queries am I not advertising on?

Ask your MixShift data in Claude, ChatGPT or Cursor

Rig serves your MixShift data to AI assistants over MCP. Once MixShift is synced into your warehouse, you can ask questions in plain English from the tool you already use, and every answer is backed by validated, governed SQL.

Frequently asked questions

What MixShift data does Rig sync?: Accounts, ads rollups (account summary, campaign performance, search terms, ASIN performance), retail sales and traffic, Brand Analytics search query performance, and daily campaign, ad group, keyword and product ad history.
How far back does the history go?: The daily history streams reach past Amazon's own 60 and 95 day lookback, as far as MixShift holds data. The rollup streams cover a trailing window you set, from 1 to 366 days.
What credential does Rig need?: A client ID and client secret that a MixShift tenant admin creates with the Create with raw secret option. The secret is shown once, and the credential is read only unless an admin adds a write scope.
Can I query MixShift data in Claude or ChatGPT?: Yes. Once MixShift is synced to your warehouse, Rig serves it to Claude, ChatGPT, Cursor and other AI tools over MCP.