in src/lib/bigquery.ts [91:101]
AND reader_revenue_product IN ('Supporter Plus', 'Tier Three')
AND billing_period = 'Month'
AND transaction_currency = '${config.Currency}'
AND country_code = '${config.CountryCode}'
),
iap_acquisitions__once AS (
SELECT SUM(amount) AS amount
FROM datalake.fact_acquisition_event
WHERE event_timestamp >= '${
config.StartDate
}' AND event_timestamp < '${config.EndDate}'