iap_acquisitions__twice AS()

in src/lib/bigquery.ts [112:119]


        iap_acquisitions__twice AS (
            SELECT SUM(amount)*2 AS amount
            FROM datalake.fact_acquisition_event
            WHERE event_timestamp >= '${
							config.StartDate
						}' AND event_timestamp < TIMESTAMP(DATE_SUB('${
		config.EndDate
	}', INTERVAL 1 MONTH))