ROAS pipeline for a mobile game
Ad costs and revenue from four networks in one model, ready for BI.
An ELT pipeline that builds a ROAS aggregate table (OLAP) and feeds it to BI. It includes:
- API extracts of ad costs from Meta Ads and Google Ads
- API extracts of ad revenue from Appodeal and AppLovin
- In-app purchase revenue from Firebase in-app events
- Pipeline design in Dataform to produce OLAP data connected to BI
Need something similar? mirlan@dataengineer.fi
Next: Kimball data architecture for mobile games →