Budget: 27000 UAH Deadline: 28 days
For the complete Iteration 1, I wouldn't focus on 9000 UAH - this is more of a budget for a short technical analysis or scheme, rather than for DWH, ELT, dbt models, attribution, and BI. A realistic MVP estimate is from 100,000 UAH, with a timeline of 3-4 weeks after access and verification of advertising sources.
I propose the following stack:
> BigQuery as DWH - fits well with GA4, has a cheap start and normal speed for marketing dashboards
> Airbyte Cloud or self-hosted Airbyte for PostgreSQL, Stripe, GA4, and advertising accounts - if the connectors for advertising networks do not cover everything, we will gather part of the cost data through API or export
> dbt for models - so that Last Non-Direct Click, Day 0, currencies, and Creative-level expenses are not just a set of queries, but a reproducible model
> Looker Studio for the first dashboard, Metabase if internal filters and access are needed
Monthly infrastructure at the start - approximately $50-250 for BigQuery, Airbyte or Fivetran, and BI, but Fivetran or Funnel.io can raise the bill to $300-800, depending on the number of accounts and sources. We can keep it simple - start with BigQuery, Airbyte, dbt, and Looker Studio, and only connect expensive services if they really save time.
I suggest moving through a short data schema design, then connecting raw sources, then dbt dashboards, and then verifying metrics on control transactions. Separately, we will provide the backend with instructions on which UTM, click_id, client_id, user_id, and Stripe metadata to write, at what moment, and how not to break attribution after payment.
From you, we need access to PostgreSQL read-only or a dump, Stripe, GA4, advertising accounts, examples of 5-10 real payments, and the logic of what exactly is considered Lead and Sale Day 0.
Clarifications without which the estimate should be kept as preliminary:
> which advertising networks are critical in the first iteration - Meta, TikTok, affiliate, CPC networks
> is user_id already consistently passing from registration to Stripe metadata, or does this still need to be worked out with the backend
Similar cases from Ingello:
> https://business.ingello.com/vorfahr - SaaS, Stripe, automation of product processes and data
> https://business.ingello.com/prime-eva - complex accounting and integration processes for business
> https://systems-fl.ingello.com/ua - Ingello Systems profile for FLH =)