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.

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

Enjoy the benefits of connecting your advertising data directly to your enterprise 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 without needing more developer time

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 and AWS S3 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 consistent, 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

Time to market

  • Get data flowing to your enterprise data warehouse in minutes

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