First Delivery · Billing reports

Metabase cards, run on the read replica

API key

Sent only to the report service, as a header. Unless you choose to remember it, it is kept only in this tab. Don't remember it on a shared computer; untick the box to forget it.

Comma-separated, up to 10. Leave blank for every country.
Leave everything unchecked for every provider.
Keeps merchants whose last completed delivery order is on or after this day. Kevin has used 2025-09-01.
Paste one per line or comma-separated. Spaces, quotes and duplicates are removed. Each request holds up to 1,000 IDs; longer lists run as several requests.

    How to use it

    1. Paste the API key from 1Password.
    2. Pick a report on the left and set its parameters. Dates are midnight US/Eastern, the same as Metabase's {{START}} and {{STOP}}. A range covers at most 31 days.
    3. Click Run report and keep this tab open. Most reports take a few seconds and a month about 30. The CSV downloads as <report>_<start>_<stop>_<request id>.csv, and the results show its row count and totals.
    4. The Download CSV link in the results works for 15 minutes. After that, run the report again.
    5. Split reports and long DSP ID lists run as several requests, one after another, because only one report runs at a time. Your browser may ask once whether to allow multiple downloads.
    If something goes wrong
    Message What to do
    A parameter is wrong The message says which one. Fix it and run again.
    The API key is wrong Copy it again from 1Password.
    Access has ended Ask an engineer to extend access.
    Another report is still running The page waits 30 seconds and tries once more. If it still fails, try again in a minute.
    The report failed, with a request ID Send the request ID to an engineer. Don't retry in a loop.
    Couldn't reach the report service Check your connection and try again. If it keeps happening, ask an engineer.
    From a script or Claude Code

    POST the same fields as JSON with the key as a bearer header. A request holds up to 1,000 DSP IDs. This command matches the parameters above; set the key from 1Password, never in a file. 

    
            
    
              
            
    
          
    

          
    
            Columns in this report