API and Data Warehouse

Marketing data from 405 platforms from one API or data warehouse connector

The API and data warehouse integration you need to get data flowing in minutes.

enterprise data warehouse software

Get trial access after the demo.

Trusted by the world's most data-driven businesses

How it works

Feed advertising and marketing data into your data warehouse in minutes

1. Connect

enterprise data warehouse tools

Connect your marketing and advertising sources to Funnel

2. Feed

enterprise data warehouse

Feed to your data warehouse ...

3. Use

enterprise data warehouse

Use in any application (BI tools, data viz, backend)

Feed data from any marketing platform

Out of the box integrations to 400+ data sources

Benefits

Enjoy the benefits of connecting your marketing data directly to your data warehouse

Flexible mapping open to end users

Allow end users to introduce derived dimensions (labels/tags of data rows) using simple "contains" rules or regular expressions.

Derived dimensions can be used to "join" data from different data sources on partial values, or values from different source dimensions. E.g join on a prefix in utm_campaign from Google Analytics with the full value of Facebook Ad Campaign.

Changes to advertising campaign structure can be updated by the marketing team or business user without consuming internal developer resources.

Cost efficiency

Support not just your current ad platforms, but allow marketing to add new platforms over time without lead time or new developer costs.

Self-service tool, with simple data warehouse integration, designed for end users to connect ad accounts including managing logins, passwords, tokens etc.

Direct integration with Google BigQuery, AWS S3, Microsoft Azure and Google Cloud Storage with automatic scheduled updates.

Analyst friendly data schema allows queries without need for excessive joins.

Automatic currency conversion available for all monetary values.

Spend analyst and developer time on understanding your data instead of building and maintaining multiple data warehouse or api connections.

Built-in domain knowledge

Funnel compensates for ad platforms that are eventually inconsistent, with historic data changing for multiple reasons.

Adjust for quotas, rate limits, retries, temporary errors.

Monitor scheduled version upgrades, and manage unscheduled breaking changes as top priority.

Understand the dimension and metric structure of data sources, default normalization and mapping of columns like campaign, cost, impressions, clicks.

Connect to your enterprise data warehouse or backend

Amazon S3/Redshift

enterprise data warehouse Documentation

Google BigQuery

enterprise data warehouse Documentation

Funnel API

enterprise data warehouse Documentation

Microsoft Azure

enterprise data warehouse Documentation

Google Cloud Storage

enterprise data warehouse Documentation

Brainlabs Case Study

“We looked at doing this as an internal project, but realised that we’d be spending unsustainable amounts of developer time on building and maintaining what would essentially still be an inferior product to Funnel.”

James Freeman
Software Developer
Brainlabs

See more case studies

What our customers say about Funnel

  1. February 20, 2017

    "Take control of your ad spend"
     

    March 16, 2018

    "Solve all your problem with gathering cost data from ANY source"

    February 20, 2018

    "Great timesaver with simple setup"
     

  2. February 16, 2017

    "Great tool to combine Google Analytics data and ad platform costdata"

    March 16, 2018

    "Automation at its best"
     

    February 20, 2017

    "Funnel's customer service is top notch!"
     

More reviews

"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."

Mark Bosold
Head of Analytics & BI, Dein Handy

Read the case study

"Funnel has the most complete library of advertising platforms I have ever seen."

Johnathan Romero
Head of Analytics, The 7 Stars

Read the case study