High-Tech Marketing Data Pipeline

Overview

High-Tech is a Saudi digital marketing and creative agency managing advertising campaigns across multiple client brands and Gulf markets. To prove and improve results for clients, the agency needed to know exactly which ad platforms, campaigns, and countries generated the best return — but that answer was locked inside four disconnected advertising accounts (Google Ads, Meta Ads, TikTok Ads, and Snapchat Ads), each with its own metrics, currencies, and naming conventions.

Before this project, answering a simple question like "which channel gets our clients the most conversions at the lowest cost?" meant manually exporting spreadsheets from each platform and stitching them together by hand — a slow, error-prone process that couldn't keep pace with a growing volume of client campaigns across six Gulf countries.

This project solves that by automatically collecting, standardizing, and centralizing all advertising data into one reliable warehouse, converting results into a single currency (Saudi Riyal) and delivering them through role-specific dashboards for agency leadership, marketing, and sales teams.

Key Features

• Automatic data collection — From Google Ads and Meta Ads (TikTok and Snapchat planned for phase two), refreshed hourly with a nightly reconciliation pass to catch delayed or corrected data.
• One consistent currency and vocabulary — Every platform's spend, clicks, and revenue figures are translated into shared, comparable terms and converted to Saudi Riyal.
• Automatic country-level breakdown — Across Saudi Arabia, UAE, Kuwait, Qatar, Bahrain, and Oman, with no manual tagging.
• Built-in performance metrics — Cost per conversion, return on ad spend, click-through and conversion rates — calculated consistently across every platform and campaign.
• Role-based dashboards — Tailored for leadership (overall performance), marketing (campaign-level detail), and sales (revenue attribution).
• Full historical record — Retained permanently, so nothing is lost and results can always be recalculated or audited.
• Built-in data quality checks — That compare warehouse totals against each platform's own reported numbers to catch discrepancies early.

How It Works

Every hour, the system automatically connects to each advertising platform and pulls the latest campaign performance data. That raw data is stored safely, then passed through a standardization process that translates each platform's unique terminology into one common language, converts every figure into Saudi Riyal, calculates key performance metrics, and organizes everything by date, country, platform, and campaign.

The cleaned, organized data then flows into a business intelligence tool (Power BI), where it powers dashboards that refresh automatically. In practice, within about an hour of a campaign running, decision-makers can see exactly how it performed — no manual exports, no spreadsheet merging, no waiting for someone to compile a report.

A second nightly pass revisits the last seven days of data to capture any late-arriving updates (such as conversions confirmed a few days after the ad click), so the numbers stay accurate over time.

Tech Stack

My Role

I designed and built the entire data pipeline architecture end to end — from initial requirements gathering with stakeholders through to the final dashboards. This included:

• Defining how data would be organized for reliable reporting.
• Writing the logic that reconciles four platforms' worth of inconsistent metrics into one clean standard.
• Structuring the data warehouse for fast, cost-efficient queries.
• Setting up the automated schedules and safeguards that keep the system running without manual intervention.

Outcome

The result is a single, trustworthy source of truth for advertising performance across all of High-Tech's Gulf markets — available within an hour of campaign activity, in the currency the agency and its clients operate in, and broken down by the questions leadership actually asks (which channel, which country, at what cost).

It replaces manual, error-prone spreadsheet reporting with an automated system built to scale as client campaign volume grows, and lays the groundwork for adding more advertising platforms in the future without re-architecting the system.