Google Ad Manager (DFP) integration use case

Google DFP connector integrates ad management functions with multiple internal systems. That ensures seamless access and analytics of real time data gathered from CRM, ERP and other applications and therefore allows for better advertising margins.

A leading Media Company in the UK uses Google Ad Manager (previously DoubleClick for Publishers – DFP) tool to manage their advertising revenue. It handles both advertisement tracking and payments. The accounts department of the Media company uses a different tool for their accounts. This presented a problem because the data resided in two separate repos. Payments are tracked in Google Ad Manager (DFP),  thus the accounting package needs to be updated with every change manually. Ricston proposed a solution to the Media company to automate their process, by integrating different systems with Mule. The whole process was automated in 2 days.

In a nutshell

Google Ad Manager (DFP) Connector

Google Ad Manager (DFP) offers an API to integrate with their system, however, Google has also written libraries in the most popular languages for ease of integration. Using the provided library, Ricston developed a custom-made Google Ad Manager (DFP) connector for the Client.

Google DFP to Accounting System

For the integration of Google Ad Manager (DFP) to the Accounting System, a reconciliation report is generated and downloaded from Google Ad Manager (DFP) through the Mule connector once every few days. This report is read a line at a time, and in parallel, it is transformed via Smooks to the data structure expected by the Accounting System.

Accounting System to Google Ad Manager (DFP)

Every couple of days, a CSV report is generated from the accounting system with updates like changes in names of companies, new companies added, and others removed. This report is downloaded by Mule from an FTP location and processed in parallel. Each entry is parsed using Smooks, and through the Google Ad Manager (DFP) connector, the new updates are pushed to the cloud.

Error Handling

Ricston implemented an improved solution by storing all errors temporarily in a file system while all the processing is happening. When the whole batch process is complete, a separate error handling flow is triggered which through the help of the Mule Module Requester, a single file is taken in and sent as an attachment to the operations team.

Property Encryption

Leaving passwords stored in plain text was not an option. Ricston implemented a solution using Jasypt, a Java library which integrates very well with Spring and makes password encryption in property files really simple.

Read more: MuleSoft Google Ad Manager (DFP) Connector

To download Google Ad Manager (DFP) datasheet, please fill in the below form.

  • You can withdraw your consent and unsubscribe at any time. Please see Privacy Policy & Legal notice for more information.

Contact Us

Ricston Ltd.
Triq G.F. Agius De Soldanis,
Birkirkara, BKR 4850,
MT: +356 2133 4457
UK: +44 (0)2071935107

Send Ryan a message

Ryan Delia
Services Director