01/ 07

The prompt

Give it to Claude, ChatGPT or Cursor along with your key. It reads the docs, follows the recipe, and asks you before spending anything.

Recipe 1.1

Read https://data.magpieiq.com/llms.txt and the docs at https://data.magpieiq.com/docs.
Then fetch https://data.magpieiq.com/skill/SKILL.md and follow recipe 1.1.
My Magpie API key is: <paste your key>

Rules: always call the catalogue first to see what exists; always run a dry-run estimate and show me the row count before spending anything; ask me before spending any credits.

What I want: rank every brand in Indonesian sunscreen by GMV for the last six months, show me how share moved, and flag anyone who gained or lost more than a third.

02/ 07

What it tracks

01

Monthly GMV and units per brand, at the category grain you ask for

02

Market share per brand, and how it moved across the window

03

Realised price per unit — GMV divided by units — indexed against the category average at 100

04

Row counts per month, so a collection artefact is visible rather than read as a market move

03/ 07

How it works

1
Call GET /v1/exports/catalog?country=ID and confirm the category and market exist, and for which months.
2
POST /v1/exports with "estimate": true to see exactly how many rows the scope returns. The estimate charges nothing.
3
Submit the same body without "estimate", then poll the job until the files are ready.
4
Download the signed links, one file per category and month, and compute share and the price index.

04/ 07

What a real response looks like

Real export rows · ID · Shopee · Facial Serum · 2 of the top rows, selected columns

            POST /v1/exports → export file rows
            captured 2026-08
          
[
  {
    "month": "2026-05",
    "country": "ID",
    "ecommerce_platform": "Shopee",
    "category_3": "Facial Serum",
    "sku_name": "SKIN1004 Madagascar Centella Tone Brightening Capsule Ampoule 100ml",
    "brand": "Skin1004",
    "merchant_name": "SKIN1004 Indonesia Official",
    "merchant_badge": "Shopee Mall",
    "price_usd": 13.22,
    "discount": 0.7,
    "sold_monthly": 9039,
    "gmv_monthly_usd": 119540.78,
    "rating": 4.9,
    "review_monthly": 6260
  },
  {
    "month": "2026-05",
    "country": "ID",
    "ecommerce_platform": "Shopee",
    "category_3": "Facial Serum",
    "sku_name": "d'Alba White Truffle First Spray Serum 100ml",
    "brand": "D'Alba",
    "merchant_name": "d'Alba Indonesia Official Shop",
    "merchant_badge": "Shopee Mall",
    "price_usd": 16.82,
    "discount": 0.35,
    "sold_monthly": 5633,
    "gmv_monthly_usd": 94740.02,
    "rating": 5.0,
    "review_monthly": 4609
  }
]

05/ 07

Tips from our own runs

Always pass a category_3. Leave it out and you'll export every category in the market, which is almost never what you meant.

Copy category names straight from the catalogue response. It's a quick step, and it stops a small typo from turning into an error.

If one month's row count looks way off next to its neighbours, that's usually a collection hiccup rather than a real market move. Flag it and move on.

06/ 07

When not to use this

Use this when

Category share tracker

You want brand rankings, share movement and price position across months.

Use instead →

Competitor price monitor

This reads the maintained monthly panel, so it cannot tell you what a product costs today. For a live price on a page right now, use the Competitor price monitor instead.

07/ 07

Other tools

Get a key, then paste the prompt.

New accounts start with free trial credits. You generate your own key from the dashboard.

Get an API key Read the recipe in the docs

See who is winning a category, and how share is moving.