From initial setup to professional data architecture in 2 days

Enter Digital was working on email campaign analytics for a client. There was already a first version of an ETL script that loaded CSV source files into BigQuery, but the structure to generate reliable business insights was missing. Digital strategist Rutger Meekers was looking for a specialist to professionalize the existing setup.

The challenge: a working script, but no architecture

The foundation was there: five CSV source files with over 500 MB of mailing data, recipient records, clicks, and company data, and a script that loaded this data into BigQuery. But there was no layered data model, no business logic, and no pre-calculated metrics. Every analysis required complex queries directly on the raw data.

“The data was in BigQuery, but we lacked the structure to actually steer with it. We needed someone who could bridge the gap between raw data and actionable insights.”

— Rutger Meekers, Digital Strategist, Enter Digital

The solution: medallion architecture

In two days, Xudo professionalized the existing pipeline into a full medallion architecture in BigQuery:

• Bronze layer — The existing CSV ingestion enhanced with basic transformations: date parsing, language detection, tag splitting, and deduplication
• Silver layer — Enriched fact tables with business logic
• Gold layer — 16 pre-aggregated metrics tables, optimized for instant dashboard queries

The result: 26 well-documented tables, approximately 750 lines of production SQL, and an automated orchestration script that runs the entire pipeline in minutes.

Ready for Looker Studio

All heavy calculations happen in BigQuery. The gold tables are designed so Looker Studio can connect directly — no joins, no calculations, no complex filters needed. Enter Digital could immediately start building dashboards for:

• Campaign performance — Open rates, click rates, CTOR, and unsubscribe rates per mailing
• Email pressure analysis — How many emails does each recipient receive per week/month?
• Company benchmarking — Compare performance at the organizational level
• Trend analysis — Period-over-period comparisons via a built-in date dimension

The result

“Wouter guided our data project from start to finish in a highly professional and skilled manner. No surprises, no delays, just quality.”

Learn more about Data Engineering