project detail

Portfolio Report Pipeline

Revenue/subscription ETL from Stripe, Apple, Sheets and RevenueCat into BigQuery.

Highlights

Cross-platform financial normalization
Exchange-rate table for consistent reporting
Execution logging and repeat-safe extraction flow

Category

Data Engineering

Stack

Python
Stripe API
App Store Connect
BigQuery

Infrastructure

Scheduled extraction
Historical backfill + monthly update modes

Source Context

Portfolio report pipeline/