How DEINHANDY automated their marketing ROI report

DEINHANDY runs a vast digital marketing operation. With 20+ ad accounts across 10 different ad platforms, it was hard to get an overview to inform decisionmaking. Mark, Head of Analytics & BI, spent too much time either stuck waiting for IT support, or doing manual work to collect data.

Dependant on IT support

Mark embarked on a project to collect and combine all his marketing data in a company-wide marketing data warehouse. He had several options to get advertising data from the bigger ad platforms like AdWords and Facebook into his data warehouse, but he was struggling to maintain a number of the smaller ad platforms. The cost of developer resources was too high, and the IT department had a limited number of developers. Mark was always waiting for IT support. Even in the cases where he got developers to help, some of the platforms didn’t have any API connection possibility.

In the end, the data just wasn’t there when he needed it.

“Funnel exceeded my expectations, and I have already recommended the tool to several people”

Collecting data rather than analysing it

Mark’s process for creating the weekly marketing report was time consuming. Even if he had had developer assistance, several of the smaller ad platforms were impossible to connect via API, instead requiring a manual download of cost, clicks and impressions. Mark then had to match ad data with backend sales data, and upload to the marketing data warehouse (Google BigQuery).

Mark wasn’t analysing data; he was collecting it.

“Funnel brought our reporting to the next level. Before using Funnel, we were doing analysis only on conversion rates. With Funnel, I’m looking at ROI.”