Notes
1. as is, this includes qna and unlock revenue (~$15-20k?) as 'new'
in the segment for new/Recurring. could exclude this and only consider subscription revenue by
filtering on `is_subscription`
2. The 3 dashboard metrics 'Net Bookings Revenue', 'Net Bookings Revenue New', and
'Revenue' appear to be three versions of the same thing. The differences appear to be
just artifacts of revisions not synced among the three, rather than intentionaly differing
on what/how they calculate. So, here we just repeat the same values for each.
Summary -
This table records a row for each completed transaction, including payments, refunds, and chargebacks. It unites the various sources like cfw_litle_payments, cfw_payments, cfw_litle_refund_log,cfw_ios_purchase_transactions";