--- name: app-store-connect-daily-downloads-and-proceeds description: "Every day at noon: yesterday's first-time App Store downloads and proceeds, by app and country, set against the same weekday last week. Use when the user asks for this, or when it runs on a schedule." --- # App Store Connect daily downloads and proceeds Every day at noon: yesterday's first-time App Store downloads and proceeds, by app and country, set against the same weekday last week. For indie developers and small app teams who open Sales and Trends every morning to see how yesterday went. The daily sales report mixes first downloads, updates, redownloads and in-app purchases in one file, and proceeds come per unit in each storefront's payout currency, so the number you want takes a spreadsheet to find. The agent downloads yesterday's summary report, keeps first-time downloads apart from updates, multiplies proceeds out, and compares the day with the same weekday last week. A feature in one country or a pricing mistake shows up the next day instead of at month end. ## Two ways to get the data Use the API or MCP route when you have an MCP server, a CLI or an API token for the app. Otherwise, if you can drive a browser the user is signed in to (Claude in Chrome, a Playwright or Chrome DevTools MCP server), use the browser route. Say which one you used. ## Route A: API or MCP server ### What you need - An App Store Connect Team API key (Users and Access > Integrations) with the Sales, Finance or Admin role: its Issuer ID, Key ID and `.p8` file. Sales reports refuse Individual keys. - Your vendor number, shown on Payments and Financial Reports, and a way to sign the JWT: a short script with a JWT library, or an App Store Connect CLI or MCP server you already trust. If something is missing, say what and stop; do not invent numbers. ### Steps 1. **Download yesterday's summary report** (App Store Connect): Call `GET https://api.appstoreconnect.apple.com/v1/salesReports` with `filter[reportType]=SALES`, `filter[reportSubType]=SUMMARY`, `filter[frequency]=DAILY`, `filter[reportDate]=` and your `filter[vendorNumber]`, with an ES256 JWT signed by your API key. The response is a gzip file of tab-separated rows. If the API answers that a newer report version exists, pass the `filter[version]` it names. 2. **Sort the rows by product type**: Count `Units` as first-time downloads only where `Product Type Identifier` is `1`, `1F`, `1T`, `F1` or a bundle or custom app code (`1-B`, `F1-B`, `1E`, `1EP`, `1EU`). Leave out updates (`7`, `7F`, `7T`, `F7`) and redownloads (`3`, `3F`), and count in-app purchases and subscriptions (`IA1`, `IA9`, `IAY` and their Mac codes) on their own line. Negative units are refunds. 3. **Work out proceeds**: `Developer Proceeds` is per unit, so each row is worth `Units` times `Developer Proceeds` in its `Currency of Proceeds`. Convert the currencies to one with that day's exchange rate and name the rate source on the card; free downloads add nothing. 4. **Compare and post**: Save each day's totals to a small JSON file so the tile has 14 days of history, and compare with the same weekday last week, since app downloads swing by day of week. Name the app and the country behind the biggest change. ## Route B: the browser ### What you need - Signed in to App Store Connect with an account that has the Admin, Finance, or Sales role, or Access to Reports, on the team. - The Sales and Trends view set to the currency you want the card in; the person sets it once. If something is missing, say what and stop; do not invent numbers. ### Steps Start at https://appstoreconnect.apple.com/trends. The user is signed in already; never type passwords or codes, and ask if a sign-in page appears. 1. **Open Sales and Trends for yesterday**: In App Store Connect open **Sales and Trends**, then the **Sales** tab. Set the date picker to yesterday (a single day) and the measure to **Units**. If you manage more than one team, pick the team first from the account menu in the top right. 2. **Keep only first-time downloads**: Open **Filters** and set **Transaction Type** to `First Time Download`, with **Product Type** left on apps. Group the table by **App** and note each app's units, then switch the grouping to **Territory** for the top five countries. Clear the transaction type filter and set Product Type to in-app purchases and subscriptions for the second unit count. 3. **Read proceeds**: Switch the measure to **Proceeds** with the same day and groupings. Sales and Trends shows proceeds in one currency already (the one chosen in the view settings), so no conversion is needed; note the currency on the card. 4. **Compare with the same weekday last week**: Change the date to seven days earlier and read the same numbers, or use the **Compare** control to show both days side by side. Work out the change per app and per country and name the biggest mover. The **Download** button above the table gives a CSV when there are more rows than the page shows. Note: Yesterday's data appears in Sales and Trends the next day, generally by 8 a.m. Pacific Time; before that the day shows as empty. Proceeds here are an estimate in the view currency, so they will not match Apple's financial reports to the cent. The UI route works well for one or two apps; across many apps and countries the CSV download is quicker to read than paging the table. ## The report - **First-time downloads** yesterday, the change on the same weekday last week, and 14 days of history. - **Proceeds** yesterday in one currency, from paid downloads, in-app purchases and subscriptions. - **By app**: downloads, in-app and subscription units, and proceeds. - **Top countries** by downloads, with their change. - One line on the mover worth a look, for example "Germany up 64%, almost all Habit Log". ## Post it to Briefkin When `BRIEFKIN_TOKEN` is set, or `~/.config/briefkin/env` exists (the installer from https://briefkin.dev/docs writes it), also send the result to the user's Briefkin board as one card. Keep the `item_key` the same on every run so the card updates in place, use a new `event_id` per run, and put today's real numbers in place of the example ones. If the request fails, say so once and carry on. ```bash [ -n "${BRIEFKIN_TOKEN:-}" ] || . ~/.config/briefkin/env curl -sS -X POST "${BRIEFKIN_URL:-https://briefkin.dev}/v1/events" \ -H "authorization: Bearer $BRIEFKIN_TOKEN" \ -H "content-type: application/json" \ -d @- <<'JSON' { "v": 1, "event_id": "app-store-connect-daily-downloads-and-proceeds/", "item_key": "app-store-connect-daily-downloads-and-proceeds", "project": "Acme Apps", "source": "App Store Connect daily downloads and proceeds skill", "kind": "metric", "title": "Downloads up 11% on the same day last week", "metric": { "label": "First-time downloads", "value": 1248, "better": "higher", "period_start": "", "period_end": "" }, "glance": [ { "type": "Grid", "props": { "columns": 3 }, "children": [ { "type": "Stat", "props": { "label": "Proceeds", "value": 2416, "prefix": "$", "delta": 9 } }, { "type": "Stat", "props": { "label": "In-app and subscriptions", "value": 312, "delta": 6 } }, { "type": "Stat", "props": { "label": "Refunds", "value": 4, "better": "lower" } } ] }, { "type": "Badges", "props": { "items": [ { "label": "↑ Germany +64%", "tone": "ok" }, { "label": "↑ Brazil +12%", "tone": "ok" }, { "label": "↓ Japan -9%", "tone": "bad" } ] } } ], "widget": [ { "type": "Table", "props": { "columns": [ "App", "Downloads", "In-app units", "Proceeds" ], "align": [ "left", "right", "right", "right" ], "rows": [ [ "Habit Log", 812, 214, "$1,604" ], [ "Focus Timer", 391, 98, "$812" ], [ "Habit Log for Mac", 45, 0, "$0" ] ] } }, { "type": "Table", "props": { "columns": [ "Country", "Downloads", "vs same day last week" ], "align": [ "left", "right", "right" ], "rows": [ [ "United States", 418, "+6%" ], [ "Germany", 176, "+64%" ], [ "United Kingdom", 121, "+3%" ], [ "Japan", 88, "-9%" ], [ "Brazil", 74, "+12%" ] ] } }, { "type": "Callout", "props": { "text": "Germany drove most of the rise: 176 downloads against 107 a week earlier, nearly all of them Habit Log.", "tone": "info" } } ], "size": "md" } JSON ``` Widgets come from the Briefkin catalog (https://briefkin.dev/v1/catalog). Without a token, just give the user the report. Set `period_start` and `period_end` to the window the number covers: the tile names it from them ("Last 7 days", "Today", "This month"). For a count right now (open items, a balance), send `"period_label": ""` so no period shows; for another name, send it as `period_label` (at most 24 characters). ## Run it on a schedule Suggested: Daily at 12:00 (`0 12 * * *`). From cron, with the agent signed in on that machine: ```bash 0 12 * * * claude -p "Run the app-store-connect-daily-downloads-and-proceeds skill" # Codex: codex exec, Gemini CLI: gemini -p, Copilot CLI: copilot -p, OpenCode: opencode run ``` Or use the agent's own scheduler (Claude Code routines, Codex automations, Claude or ChatGPT scheduled tasks): https://briefkin.dev/skills/app-store-connect-daily-downloads-and-proceeds#schedule Source: https://briefkin.dev/skills/app-store-connect-daily-downloads-and-proceeds