Programmatic Ad
Data Integration
Led the design and implementation of a unified data pipeline connecting all major programmatic advertising platforms to give Bitkraft Ventures (Loot Labs' VC partner) direct, real-time access to paid media performance data. The goal: eliminate manual reporting entirely and empower the investor team to build their own custom dashboards and analysis on top of live data.
Manual reporting doesn't scale
Loot Labs was managing significant paid media spend across five major advertising platforms: Google, Meta, TikTok, Reddit, and Snap. Their VC partner, Bitkraft Ventures, needed regular visibility into how that spend was performing. The problem was that every reporting cycle required someone on the Loot Labs team to manually pull data from each platform, compile it, and send it over.
This process was time-consuming, error-prone, and always lagging behind reality. By the time reports were compiled and delivered, the data was already stale. Bitkraft couldn't run their own analysis, spot trends in real-time, or build the custom views they needed to make informed decisions about their investment.
The ask was clear: give Bitkraft programmatic, self-serve access to all paid media performance data, and make it live.
A unified data pipeline across every channel
I led the implementation of API integrations across all five programmatic ad platforms, creating a centralised data pipeline that streamed performance metrics directly into a system Bitkraft could access and query independently. No more waiting for manual exports. The data flowed automatically.
Google Ads API
Integrated the Google Ads API to stream campaign-level spend, impressions, clicks, conversions, and ROAS data. This covered Search, Shopping, Display, and YouTube campaigns, the largest share of Loot Labs' paid media portfolio.
Meta Marketing API
Connected Facebook and Instagram ad data through Meta's Marketing API. Campaign performance, audience breakdowns, and spend allocation, all flowing into the unified pipeline alongside the other platforms.
TikTok Ads API
Integrated TikTok's advertising API to capture spend and performance data from a platform that was becoming an increasingly important channel for reaching younger collector audiences.
Reddit Ads API
Connected Reddit's advertising data, a key channel for reaching engaged collectibles communities and niche subreddits where high-intent buyers gathered.
Snap Ads API
Brought Snapchat advertising data into the pipeline, ensuring complete coverage across every platform where Loot Labs was running paid campaigns.
Mixpanel: Transaction Data
Beyond ad spend, I ensured the Mixpanel integration was properly configured to stream customer transaction and conversion data. This gave Bitkraft the complete picture, not just what was being spent, but what was being earned. Full-funnel visibility from ad impression to purchase.
From manual exports to self-serve analytics
The integration fundamentally changed how Bitkraft interacted with Loot Labs' performance data. Instead of waiting for periodic reports, their team could now access live data, build custom dashboards, and run their own analysis at any time.
Zero manual reporting: eliminated the recurring time sink of pulling, compiling, and formatting data from five separate platforms. Hours saved every reporting cycle.
Custom dashboards: Bitkraft could now build their own views and analysis on top of the raw data, slicing by platform, campaign, time period, or any dimension they needed.
Real-time data: no more stale weekly or monthly exports. Bitkraft could see spend and performance data as it happened, enabling faster and more informed decision-making.
Full-funnel visibility: by combining ad platform spend data with Mixpanel transaction data, Bitkraft got the complete picture, cost of acquisition through to revenue, across every channel.
Stronger investor relationship: transparency builds trust. Giving Bitkraft direct data access demonstrated confidence in the numbers and strengthened the partnership between operator and investor.
Scalable foundation: as Loot Labs expanded to new ad channels or adjusted their media mix, the pipeline architecture made it straightforward to add new data sources without rebuilding from scratch.
The full stack
Need to unify your marketing data?
Let me know if you need help building data integrations that give your stakeholders the visibility they need.
Get in touch