Get a month/quarter x dimension crosstab
Get a month/quarter x dimension crosstab
Description
Get a month/quarter x dimension crosstab Buckets royalty and count by time period (month or quarter) crossed with a dimension (country, sale type, or DSP), keeping the top-N dimension values and folding the remainder into an “Other” bucket. Authorization:- Required role:
useror higher
Code Examples
Authorizations
JWT Authorization header using the Bearer scheme. Format: "Bearer {token}"
Query Parameters
Dimension to cross with time period
country, saletype, dsp Number of top dimension values to keep before bucketing the rest into "Other". Clamped to 1-12
1 <= x <= 12Time bucket size. The server auto-switches to quarter (and sets autoRolledUp: true in the response) when the requested window exceeds 24 months, regardless of what is requested here
month, quarter Filters the data by artist. Comma-separated list of artist IDs
Filters the data by user. Specifies a user ID. A single UUID switches the response into per-member (splits-attributed) mode
Filter the data by country. Comma-separated values
Filters by DSP (Digital Service Provider). Comma-separated values
Start date of the period (YYYY-MM-DD format). Also used to decide whether to auto-roll up to quarterly granularity
End date of the period (YYYY-MM-DD format)
Filters by sale type. Comma-separated values
Filters by aggregator. Comma-separated values
Filters by data source table name. Comma-separated values for multiple tables
Filters by UPC (Universal Product Code). Comma-separated values
Filters by ISRC (International Standard Recording Code). Comma-separated values
Selects the time-bucket axis. Defaults to accounting
accounting, sale Response
Successfully retrieved crosstab data
country, saletype, dsp month, quarter Number of top dimension values kept before bucketing the remainder into "Other"
True when the server auto-switched from month to quarter granularity because the requested window exceeds 24 months