Portfolio / Meshads
Ads Customer Portal
We partnered with Meshads to develop a client-facing analytics portal that consolidates performance data from multiple ad accounts, backend systems, and financial sources. The platform automates data extraction, transformation, and reporting, turning fragmented ad data into actionable insights.Through advanced modeling in BigQuery, automated pipelines, and Superset dashboards, Meshads gained a single view of performance across all campaigns, clients, and geographies. The solution integrates hourly updates, exchange rate automation, and granular role-based access control, providing decision-makers with accurate, real-time metrics to optimize budget allocation and campaign strategies.In addition, AI-powered data agents allow users to query their data in natural language, delivering instant insights, uncovering trends, and highlighting anomalies to accelerate decision-making.
Before
- Dispersed ad data across Google Ads, Airtable, and backend systems.
- Delays and inconsistencies in data updates and financial synchronization.
- Manual and error-prone client reporting with no role-based access control.
Key improvements
- Unified all ad sources into a single, automated BigQuery data model.
- Achieved near real-time updates with 15-minute data pipeline refreshes.
- Deployed secure, role-based dashboards in Superset for client access.
How we did it
Architecture design
We analyzed Meshads’ data ecosystem, defined the integration scope across Google Ads, Airtable, and backend systems, and designed architecture diagrams covering extraction logic, data models, and reporting layers.
Data pipelines
Developed ETL processes using BigQuery, dbt, and Fivetran to automate ingestion, transformation, and enrichment of campaign, conversion, and exchange rate data.
Analytics layer
Built interactive dashboards and data agents with multi-level KPIs, hourly updates, and visual breakdowns by country, device, and service type.
Access control
Configured role-based access and Row-Level Security integrated with Google Sheets and Airtable for account and media-buyer segmentation.
“Datakimia helped us turn our complex, scattered ad data into a reliable and automated intelligence platform for our clients and internal teams. We now have complete visibility of performance by campaign, client, and region, all in one place.”Christopher Henseler · Co-Founder
Fullstack Revops · Marketing Analytics · Canada
Datadriven · Business Intelligence · United States
January Spring · Marketing Agency · United States