Dataset: Spotify Revenue, Expenses And Its Premium Users

About this Dataset

Spotify Revenue, Expenses And Its Premium Users

Spotify Revenue, Expenses and Its Premium Users contains the number of premium users, number of Ad-supported users and total monthly active users (MAUs).

MAUs include number of premium users as well as number of Ad-supported users.

Note : Sum of Premium Users and Ad-supported users can have some difference from MAUs.
Note : All money figures are in Euro millions except ARPU which is in Euro and as it is.
**Note : All users figures are in millions. **
Note : Kindly Ignore the last row.

Following definitions:
MAUs : It is defined as the total count of Ad-Supported Users and Premium Subscribers that have consumed content for greater than zero milliseconds in the last thirty days from the period-end indicated.
Premium MAUs : It is defined as users that have completed registration with Spotify and have activated a payment method for Premium Service.
Ad MAUs : It is defined as the total count of Ad-Supported Users that have consumed content for greater than zero milliseconds in the last thirty days from the period-end indicated.
Premium ARPU : It is average revenue per user which is monthly measure defined as Premium subscription revenue recognized in the quarter indicated divided by the average daily Premium Subscribers in such quarter, which is then divided by three months.
Cost of Revenue : It is expenses done by company.

Photo by Alexander Shatov on Unsplash

Tables

Spotify Quarterly

@kaggle.mauryansshivam_spotify_revenue_expenses_and_its_premium_users.spotify_quarterly

15.15 KB
26 rows
17 columns


CREATE TABLE spotify_quarterly (
  "date" VARCHAR,
  "total_revenue" DOUBLE,
  "cost_of_revenue" DOUBLE,
  "gross_profit" DOUBLE,
  "premium_revenue" DOUBLE,
  "premium_cost_revenue" DOUBLE,
  "premium_gross_profit" DOUBLE,
  "ad_revenue" DOUBLE,
  "ad_cost_of_revenue" DOUBLE,
  "ad_gross_profit" DOUBLE,
  "maus" DOUBLE,
  "premium_maus" DOUBLE,
  "ad_maus" DOUBLE,
  "premium_arpu" DOUBLE,
  "sales_and_marketing_cost" DOUBLE,
  "research_and_development_cost" DOUBLE,
  "genreal_and_adminstraive_cost" DOUBLE
);