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.2

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.2.
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: map the price bands in Indonesian facial serum for the most recent full month. Show me how many brands sit in each decile and what share of category GMV each band holds, and tell me whether there is a band with real demand and few competitors.

02/ 07

What it tracks

01

Realised price per unit per brand — GMV divided by units, not list price

02

Which decile each brand sits in, measured against the category average

03

How many brands occupy each decile, and what share of category GMV they hold together

04

Bands holding meaningful demand with few competing brands

03/ 07

How it works

1
Call the catalogue and confirm the category, market and the most recent full month.
2
Estimate an export of that month at "top": 500, and review the row count before submitting.
3
Submit, poll, and download the files.
4
Compute GMV divided by units per brand, bucket into deciles against the category average, and total GMV share per decile.

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

Work out realised price as GMV divided by units rather than using the listed price. Discounts move it more than you'd expect.

Remember that "top": 500 gives you the biggest sellers, not the whole category, so mention that when you quote shares.

It's fine to find no gap. A clear "there's no easy opening here" is just as useful as a band worth going after.

06/ 07

When not to use this

Use this when

Price-band map

You are pricing an entry and want to see where demand sits against competition.

Use instead →

Competitor price monitor

This describes the shape of a category in a finished month. It will not tell you what a competitor is charging right now — for that, use the Competitor price monitor.

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

Find the price band with demand and few rivals.