• Projects 30
  • Rating 5.0
  • Rating 5 747

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.

Mobile app with admin
Artem S.

Artem S.

Winning proposal
132 0
  • Projects 132
  • Rating 5.0
  • Rating 10 330

Budget: 10000 UAH Deadline: 7 days

Good day.

For the MVP, I would suggest implementing a solution on a VPS and writing the connectors independently for the required sources: PostgreSQL, Stripe, GA4, Meta/TikTok, and other advertising cabinets. This will significantly save on third-party integration services and make the system more flexible to your logic.

Regarding the storage, there are a few options: if the data volume is small, you can start with PostgreSQL on a VPS. If there is more data or scaling is needed, it’s better to consider a separate PostgreSQL or Google BigQuery.

However, before estimating the implementation, I would suggest conducting a separate audit of the current state: what data is already available, how UTM/click_id/client_id are stored, how users can be linked to Stripe payments, which sources need to be connected, and what needs to be prepared by the backend team.

After the audit, it will be possible to formulate a precise technical specification, architecture, list of necessary data, and separately calculate the cost of my work on implementing the MVP.

  • Projects 14
  • Rating 5.0
  • Rating 7 752

Budget: 9000 UAH Deadline: 8 days

Hello, Denis! I am Nina — the manager of data engineer Valentin. The technical specification is prepared at the level of a top architect. Valentin understands the difference between "just exporting data" and building a Single Source of Truth with a Last Non-Direct Click attribution model.

Proposed stack:

DWH: Google BigQuery (ideal for marketing, natively consumes raw logs from GA4, very cheap on-demand pricing).

ELT: Airbyte (self-hosted on your VPS). No Fivetran/Airbyte Cloud, so you won't pay for row volume. We will use ready-made connectors for Postgres, Stripe, and GA4, and we will connect advertising accounts through Python scripts.

Transformation: dbt Core (models will be incremental, versioned, and fully covered by data tests).

  • Projects 20
  • Rating -
  • Rating 2 116

Budget: 9000 UAH Deadline: 11 days

Hello! I understood the task: to consolidate PostgreSQL, Stripe, GA4, and advertising accounts into one repository and build Day 0 analytics with drill-down from source to creative, with Last Non-Direct Click attribution.

For the stack for the first iteration, I suggest the following. BigQuery as the repository, since you already have a Google ecosystem through GA4, a cheap start on an on-demand tariff, and native integration with Looker Studio. Data collection on Airbyte, self-hosted on a small VPS, to avoid paying for row volume like in Fivetran. Connectors to PostgreSQL, Stripe, and GA4 are available out of the box; for the uncovered advertising accounts, we will create our own connector in Python. Modeling on dbt, so that transformations are versioned, covered by tests, and views are built incrementally. BI on Looker Studio to start, free and sufficient for the Day 0 dashboard, later if needed, Metabase.

Separately, I will immediately prepare a clear instruction for your backend so that tracking does not break: what specific tags to write, click_id, UTM, client_id, and where to place them in the metadata of Stripe Charge or Customer, so that the connection of user_id plus transaction plus marketing tag is maintained throughout. I will consolidate expenses into a hierarchy of source, campaign, adset, creative, and will convert daily into a single currency.

Regarding the infrastructure for a month for the MVP, it turns out to be not much. BigQuery at your volumes is a few dollars on-demand, Airbyte self-hosted is just the price of the VPS, Looker Studio is free, meaning the starting infrastructure stays within a few tens of dollars a month. I will calculate more accurately when I see the data volumes and the list of sources.

I have practical experience with BigQuery, dbt, and writing custom connectors in Python, and I understand the data structure of Stripe. I am ready to start with the design of DWH and ELT for Iteration 1. Please let me know how many advertising accounts there are now and if there is already any tracking layer on the backend, so I can more accurately assess the volume for the connectors?

  • Projects -
  • Rating -
  • Rating 702

Budget: 10000 UAH Deadline: 12 days

Hello. I am ready to take on your MVP, I have relevant experience in building marketing analytics from scratch.

We will use Google BigQuery for storage, and for the tool, we will take Airbyte, which will cover all your sources from PostgreSQL to advertising accounts. For transformations, we will use dbt core to ensure the models are reliable, and for visualization, Looker Studio.

In terms of pricing, BigQuery will cost about $10-20 per month, Airbyte Cloud $100 depending on the volume of rows, dbt and Looker Studio are free, so in total, you can expect around $120. I am ready to collaborate.

Feel free to write.)

  • Projects 5
  • Rating 5.0
  • Rating 1 306

Budget: 10000 UAH Deadline: 10 days

Hello!

I have experience in building data/automation solutions for marketing analytics, API integrations, PostgreSQL, Stripe, Google Sheets/BI, n8n/Python pipelines, and SQL modeling. Your task is clear to me: it is necessary to consolidate disparate sources into a single system where the exact Day 0 return on investment can be seen by Source → Campaign → Adset/Term → Creative.

For Iteration 1, I would suggest the following stack:

**DWH:** Google BigQuery
An optimal choice for MVP, as it is well-suited for marketing analytics, easily scalable, has native integration with GA4, conveniently connects to Looker Studio/Metabase, and allows for quick SQL showcase building without complex infrastructure.

**ELT:** Airbyte or Fivetran

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Current freelance projects in the category Databases & SQL

17 July
16 July
16 July
16 July