[Growth rate using SQL in BigQuery - Part 3] Computing a month over month revenue growth rate #SQL #BigQuery

growth_rate_3.sql

WITH
  revenue_over_month AS (
  SELECT
    DATE_TRUNC(PARSE_DATE('%Y%m%d',
        date),MONTH) AS months,
    ROUND(SUM(totals.totalTransactionRevenue)/10e+6,2) AS revenue,
  FROM
    `bigquery-public-data.google_analytics_sample.ga_sessions_20*`
  GROUP BY
    1)
  -- Main Query
SELECT
  *,
  ROUND((revenue - LAG(revenue) OVER(ORDER BY months ASC)) / LAG(revenue) OVER(ORDER BY months ASC) * 100,2) AS growth_rate
FROM
  revenue_over_month
ORDER BY
  months ASC