Gross Revenue By Month

1-- Gross revenue (recurring + one-time, net of refunds) per month, split by recurring vs one-time.
2-- Replace <revenue_item_view> with the discovered managed view name (see mrr_and_arr.sql).
3SELECT
4    toStartOfMonth(timestamp)                       AS month,
5    sum(amount)                                     AS gross_revenue,
6    sumIf(amount, is_recurring)                     AS recurring_revenue,
7    sumIf(amount, NOT is_recurring)                 AS one_time_revenue,
8    sumIf(amount, amount < 0)                       AS refunds
9FROM <revenue_item_view>
10GROUP BY month
11ORDER BY month