Case Study:
Facebook Ads Analytics Pipeline

The Client: Uplift Campaigns

Uplift Campaigns is an advertising firm that develops programs for Democratic campaigns and progressive issue organizations.

The Challenge: Bring data from multiple platforms together

We needed to find a way to navigate the APIs of the client’s various ad platforms to download their data and upload it into a uniform database at regular intervals.

The Solution: Create customized scripts and automations

The Pantheon team wrote a series of Python scripts to interface with the various APIs to request and download the requisite data. From there the data is uploaded automatically to Google’s BigQuery web platform, where the client has free range to access, edit, and present it as they see fit. These scripts were then deployed onto a private server under the control of the client where they run every four hours to keep their data stream clean and up-to-date.