Case study · Education

Modelling ROI and sales funnel using Digital Marketing

A report that combines Digital Marketing and Financial Data to get the insight of the Marketing Department effort.

The situation

The Digital Marketing data were in parquet format and without FK to be related with Financial Data.

What we built

ETL from landing to gold modelling data and making possible the relations between the two different verticals to consume the target KPIs in Power BI.

Databricks SEO Quality PowerBI

Services involved

Next steps

Marketing attribution requires data integration.

If your marketing data lives across multiple platforms and you need to connect it to revenue, we can build the pipelines and models that make ROI tracking possible.