Data Warehouses
Get trial access after the demo.
Learn how to create a unified marketing data repository using Funnel’s automated Data Warehouse exports. In this video we provide an overview of modern data warehouses, why they are beneficial and the challenges that are faced when feeding data to these locations. We also provide an introduction to Funnel and how these challenges can be overcome.
Connect your marketing and advertising sources to Funnel
Feed to your data warehouse
Use in any application (BI tools, data viz, backend)
Enjoy the benefits of connecting your marketing data directly to your data warehouse
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.
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, Amazon S3, Microsoft Azure, Snowflake 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 connections.
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.
“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
"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
"Funnel has the most complete library of advertising platforms I have ever seen."
Johnathan Romero
Head of Analytics, The 7 Stars
