Bello Media
Digital Marketing Agency
Siloed data systems across a various GA, shopify, Meta, and Google Ads, and Salesforce
Tools Used: Apache Airflow, dbt, Snowflake, Tableau
The Problem
Bello Media is a Miami-based full-service digital marketing firm specializing in multi-channel campaigns for mid-market and enterprise clients. The agency manages campaigns across website analytics, Meta (Facebook and Instagram) Ads, Google Ads and Analytics, and various CRM platforms (e.g., Salesforce, HubSpot).
Reporting was a manual process, bootstrapped by the owners. They knew what was important to look at, but it took a very long time to get the answers they needed. Data was fragmented and scattered, leading to slow insights and inconsistent metrics.
CLIENT
Bello Media
YEAR
2022
TECH STACK
Airflow, dbt, Snowflake, Tableau
CATEGORY
Digital Marketing
The Solution
Our team worked with key stakeholders to:
Synced all data into Snowflake
With a custom Airflow application, we ingested data from Google Analytics, Shopify, Meta, Google Ads, and Salesforce into Snowflake.
Standardized & cleaned the data with dbt
Using dbt, we generated raw staging models, and data marts to deliver clean and efficient reporting across internal processes AND client metrics.
Visualization in Tableau
Working with key stakeholders, we designed a suite of dashboards for high-level KPI’s, Channel Performance, Funnel Analysis, and Multi-touch attribution. Executives receive reports on an automated basis, with room for more reports as the business grows.
Impact
Time savings
Reduced manual reporting time from 10 hours to under 30 minutes per week
Data accuracy
Metric discrepancies were eliminated, catching 98% of anomalies prior to visualization and presentation
Revenue growth
Through more precise attribution, the company reallocated budget to high-ROAS campaigns, increasing ROI by 23% YoY.
The Altera Effect
Saved per week on manual reporting
Increased ROI YoY
Data is clean and reliable, right away
Let’s Talk!
Ready to get started?
Schedule a meeting by filling out this form here. Speak directly to one of our engineers, not a sales person.