IT/ ENGINEERING

IT/Engineering. A secure, scalable, and accurate solution for data collection and transformation Free yourself from tedious marketing data collection and manipulation tasks to focus on higher-value activities, whilst cutting down on platform maintenance and the number

of support tickets.

SNOWFLAKE CONNECTOR

Snowflake Connector. Automatically feed Business-Ready Data from over 500 platforms to Snowflake. Data from all of the platforms your company uses, cleaned and normalized into one table with the full

granularity intact.

FUNNEL KNOWLEDGE BASE Get started collecting, managing and working with your data in Funnel. +2. 10 articles in this collection. Written by Sven Hamberg, Simon Kalicinski, Megan Lozicki and 2 others.

PRICING | FUNNEL

The perfect plan for the whole team, with Funnel’s unique Data Guarantee which allows you to connect to any data source. from $999 monthly. (billed annually) Book a demo. Everything in Essentials +. Library of 500+ connectors. Data Guarantee. Unlimited workspaces.

Roles

ALL YOUR MARKETING DATA TO GOOGLE SHEETS Funnel collects data from all marketing and advertising platforms, which can then be exported and visualized in Google Sheets. With connections to over 500 data sources, Funnel will be the last connector you’ll ever need. If you’re unable to find the platform you use out-of-the-box, you can request a FEED YOUR DATA DIRECTLY INTO GOOGLE DATA STUDIO Connections to all of your platforms. Funnel integrates with all of your advertising, sales and marketing platforms ensuring everything you need is available in Data Studio. If you can’t find the platform you need in our list of over 500 connectors, simply request it and we’ll build it for you. GOOGLE DATA STUDIO TEMPLATES Monthly Marketing Overview. This template provides a top-level omnichannel overview of your marketing performance. Spot trends and obtain the information required to shift budget from underperforming channels. By Funnel. WHAT DATA CAN I GET FROM GOOGLE ANALYTICS? MICROSOFT AZURE BLOB STORAGE CONFIGURATION You should have a Microsoft Azure account and have created a Storage account of kind 'Blob storage'. Funnel has no opinions about how you configure your account, resource groups, or container. To configure the export you will need: The host name of your service account. You can find this in 'Properties' under 'Primary blob service endpoint' or WHAT DATA CAN I GET FROM DISPLAY & VIDEO 360 (DOUBLECLICK The connection types supported are: Partner, Advertiser and Custom. The Partner and Advertiser connection types allow for downloading non-aggregatable metrics. The connection type Custom allows users to connect and download data from reports created in DV360. You can read more about the connection type Custom by following this link.

IT/ ENGINEERING

IT/Engineering. A secure, scalable, and accurate solution for data collection and transformation Free yourself from tedious marketing data collection and manipulation tasks to focus on higher-value activities, whilst cutting down on platform maintenance and the number

of support tickets.

SNOWFLAKE CONNECTOR

Snowflake Connector. Automatically feed Business-Ready Data from over 500 platforms to Snowflake. Data from all of the platforms your company uses, cleaned and normalized into one table with the full

granularity intact.

FUNNEL KNOWLEDGE BASE Get started collecting, managing and working with your data in Funnel. +2. 10 articles in this collection. Written by Sven Hamberg, Simon Kalicinski, Megan Lozicki and 2 others.

PRICING | FUNNEL

The perfect plan for the whole team, with Funnel’s unique Data Guarantee which allows you to connect to any data source. from $999 monthly. (billed annually) Book a demo. Everything in Essentials +. Library of 500+ connectors. Data Guarantee. Unlimited workspaces.

Roles

ALL YOUR MARKETING DATA TO GOOGLE SHEETS Funnel collects data from all marketing and advertising platforms, which can then be exported and visualized in Google Sheets. With connections to over 500 data sources, Funnel will be the last connector you’ll ever need. If you’re unable to find the platform you use out-of-the-box, you can request a FEED YOUR DATA DIRECTLY INTO GOOGLE DATA STUDIO Connections to all of your platforms. Funnel integrates with all of your advertising, sales and marketing platforms ensuring everything you need is available in Data Studio. If you can’t find the platform you need in our list of over 500 connectors, simply request it and we’ll build it for you. GOOGLE DATA STUDIO TEMPLATES Monthly Marketing Overview. This template provides a top-level omnichannel overview of your marketing performance. Spot trends and obtain the information required to shift budget from underperforming channels. By Funnel. WHAT DATA CAN I GET FROM GOOGLE ANALYTICS? MICROSOFT AZURE BLOB STORAGE CONFIGURATION You should have a Microsoft Azure account and have created a Storage account of kind 'Blob storage'. Funnel has no opinions about how you configure your account, resource groups, or container. To configure the export you will need: The host name of your service account. You can find this in 'Properties' under 'Primary blob service endpoint' or WHAT DATA CAN I GET FROM DISPLAY & VIDEO 360 (DOUBLECLICK The connection types supported are: Partner, Advertiser and Custom. The Partner and Advertiser connection types allow for downloading non-aggregatable metrics. The connection type Custom allows users to connect and download data from reports created in DV360. You can read more about the connection type Custom by following this link. AUTOMATED DATA COLLECTION & MARKETING REPORTS Power your business intelligence tool with marketing data, feed it directly to your data warehouse, dashboard solution, Google Data Studio or Sheets, or any other tool you are using. Data Destinations. Destinations. API and Data Warehouse. Business Intelligence.

ABOUT FUNNEL

Funnel curates and harmonises data in real time to present it to you in a way that creates real insight. With no coding needed, Funnel lets marketers get straight to action, unleashing the true power of performance marketing. Freed from laborious tasks, technical teams and analysts can focus on activities that create true value. MARKETING DASHBOARDS AND REPORTS Marketing dashboards are crucial for centralizing all this data, so you can easily monitor and generate business insights. By providing an overview of the most important metrics, they allow data-driven decision making and give adaptability to the whole marketing

organization.

FEED YOUR DATA DIRECTLY INTO GOOGLE DATA STUDIO Connections to all of your platforms. Funnel integrates with all of your advertising, sales and marketing platforms ensuring everything you need is available in Data Studio. If you can’t find the platform you need in our list of over 500 connectors, simply request it and we’ll build it for you.

ZONNEBRILLEN

At first, Zonnebrillen had a limited number of paid channels to activate. Dylan worked in Excel, downloading CSV files from each platform and aligned performance data with their sales numbers to see the return on investment. CASE STUDY: NA-KD BUILDING AN AUTOMATED MARKETING NA-KD is an online global fashion marketplace, founded by Jarno Vanhatapio who also founded fashion e-tailer Nelly.com. Together with other veterans from the digital fashion world, he launched NA-KD.com with a global market in mind. Since the launch late 2015, growth has been stellar. The company achieved a turnover of 20 MUSD the first year of business, and continue to grow at a blinding pace. MICROSOFT AZURE BLOB STORAGE CONFIGURATION You should have a Microsoft Azure account and have created a Storage account of kind 'Blob storage'. Funnel has no opinions about how you configure your account, resource groups, or container. To configure the export you will need: The host name of your service account. You can find this in 'Properties' under 'Primary blob service endpoint' or WHAT DATA CAN I GET FROM DISPLAY & VIDEO 360 (DOUBLECLICK The connection types supported are: Partner, Advertiser and Custom. The Partner and Advertiser connection types allow for downloading non-aggregatable metrics. The connection type Custom allows users to connect and download data from reports created in DV360. You can read more about the connection type Custom by following this link. HOW TO CONNECT FACEBOOK ADS First off you choose your level of granularity. Selecting "Campaign" will only give you campaign level data. Selecting "Campaign, Ad Set, Ad" will give you the ID and name for all your campaigns, ad sets and ads. For non-aggregatable sources, you have the option of connecting

at account level.

HOW DO I AVOID NULL VALUES WHEN EXPORTING CALCULATED Summary. To avoid problems with null values in metrics exported from Funnel to Google Data Studio, follow these guidelines when creating custom metrics in Funnel: AUTOMATED DATA COLLECTION & MARKETING REPORTS Power your business intelligence tool with marketing data, feed it directly to your data warehouse, dashboard solution, Google Data Studio or Sheets, or any other tool you are using. Data Destinations. Destinations. API and Data Warehouse. Business Intelligence.

IT/ ENGINEERING

IT/Engineering. A secure, scalable, and accurate solution for data collection and transformation Free yourself from tedious marketing data collection and manipulation tasks to focus on higher-value activities, whilst cutting down on platform maintenance and the number

of support tickets.

TABLEAU - CONNECT YOUR MARKETING PLATFORMS AUTOMATICALLY Benefits of using Funnel’s direct Tableau integration. Funnel takes messy, siloed data from all marketing platforms to automatically generate Business-Ready Data that is fully harmonized, up-to-date and always ready for analysis in Tableau. FUNNEL KNOWLEDGE BASE Get started collecting, managing and working with your data in Funnel. +2. 10 articles in this collection. Written by Sven Hamberg, Simon Kalicinski, Megan Lozicki and 2 others.

SNOWFLAKE CONNECTOR

Snowflake Connector. Automatically feed Business-Ready Data from over 500 platforms to Snowflake. Data from all of the platforms your company uses, cleaned and normalized into one table with the full

granularity intact.

FEED YOUR DATA DIRECTLY INTO GOOGLE DATA STUDIO Connections to all of your platforms. Funnel integrates with all of your advertising, sales and marketing platforms ensuring everything you need is available in Data Studio. If you can’t find the platform you need in our list of over 500 connectors, simply request it and we’ll build it for you.

PRICING | FUNNEL

The perfect plan for the whole team, with Funnel’s unique Data Guarantee which allows you to connect to any data source. from $999 monthly. (billed annually) Book a demo. Everything in Essentials +. Library of 500+ connectors. Data Guarantee. Unlimited workspaces.

Roles

AUTOMATED DATA COLLECTION & MARKETING REPORTS Power your business intelligence tool with marketing data, feed it directly to your data warehouse, dashboard solution, Google Data Studio or Sheets, or any other tool you are using. Data Destinations. Destinations. API and Data Warehouse. Business Intelligence.

IT/ ENGINEERING

IT/Engineering. A secure, scalable, and accurate solution for data collection and transformation Free yourself from tedious marketing data collection and manipulation tasks to focus on higher-value activities, whilst cutting down on platform maintenance and the number

of support tickets.

TABLEAU - CONNECT YOUR MARKETING PLATFORMS AUTOMATICALLY Benefits of using Funnel’s direct Tableau integration. Funnel takes messy, siloed data from all marketing platforms to automatically generate Business-Ready Data that is fully harmonized, up-to-date and always ready for analysis in Tableau. FUNNEL KNOWLEDGE BASE Get started collecting, managing and working with your data in Funnel. +2. 10 articles in this collection. Written by Sven Hamberg, Simon Kalicinski, Megan Lozicki and 2 others.

SNOWFLAKE CONNECTOR

Snowflake Connector. Automatically feed Business-Ready Data from over 500 platforms to Snowflake. Data from all of the platforms your company uses, cleaned and normalized into one table with the full

granularity intact.

FEED YOUR DATA DIRECTLY INTO GOOGLE DATA STUDIO Connections to all of your platforms. Funnel integrates with all of your advertising, sales and marketing platforms ensuring everything you need is available in Data Studio. If you can’t find the platform you need in our list of over 500 connectors, simply request it and we’ll build it for you.

PRICING | FUNNEL

The perfect plan for the whole team, with Funnel’s unique Data Guarantee which allows you to connect to any data source. from $999 monthly. (billed annually) Book a demo. Everything in Essentials +. Library of 500+ connectors. Data Guarantee. Unlimited workspaces.

Roles

GOOGLE DATA STUDIO TEMPLATES Monthly Marketing Overview. This template provides a top-level omnichannel overview of your marketing performance. Spot trends and obtain the information required to shift budget from underperforming channels. By Funnel. GOOGLE ANALYTICS UTM TAGGING BEST PRACTICES Google Analytics UTM tagging best practices. Google Analytics is by far the most used analytics tool. BuiltWith estimates that more than 80% of all websites worldwide use Google Analytics for measuring their website usage. Unfortunately, many of the people relying on Google Analytics for measuring their website traffic lack a good understanding of how it works and have not set up their UTMs MICROSOFT AZURE BLOB STORAGE CONFIGURATION You should have a Microsoft Azure account and have created a Storage account of kind 'Blob storage'. Funnel has no opinions about how you configure your account, resource groups, or container. To configure the export you will need: The host name of your service account. You can find this in 'Properties' under 'Primary blob service endpoint' or AUTOMATED DATA COLLECTION & MARKETING REPORTS Power your business intelligence tool with marketing data, feed it directly to your data warehouse, dashboard solution, Google Data Studio or Sheets, or any other tool you are using. Data Destinations. Destinations. API and Data Warehouse. Business Intelligence. MARKETING DASHBOARDS AND REPORTS Marketing dashboards are crucial for centralizing all this data, so you can easily monitor and generate business insights. By providing an overview of the most important metrics, they allow data-driven decision making and give adaptability to the whole marketing

organization.

CONTACT US | FUNNEL

Reach out to us to learn more about our advertising analytics software ALL YOUR MARKETING DATA TO GOOGLE SHEETS Funnel collects data from all marketing and advertising platforms, which can then be exported and visualized in Google Sheets. With connections to over 500 data sources, Funnel will be the last connector you’ll ever need. If you’re unable to find the platform you use out-of-the-box, you can request a FEED YOUR DATA DIRECTLY INTO GOOGLE DATA STUDIO Connections to all of your platforms. Funnel integrates with all of your advertising, sales and marketing platforms ensuring everything you need is available in Data Studio. If you can’t find the platform you need in our list of over 500 connectors, simply request it and we’ll build it for you. GOOGLE DATA STUDIO TEMPLATES Monthly Marketing Overview. This template provides a top-level omnichannel overview of your marketing performance. Spot trends and obtain the information required to shift budget from underperforming channels. By Funnel. MICROSOFT AZURE BLOB STORAGE CONFIGURATION You should have a Microsoft Azure account and have created a Storage account of kind 'Blob storage'. Funnel has no opinions about how you configure your account, resource groups, or container. To configure the export you will need: The host name of your service account. You can find this in 'Properties' under 'Primary blob service endpoint' or WHAT DATA CAN I GET FROM GOOGLE ANALYTICS? The User report is a non-aggregatable report which offers the Users metric with different dimensions. You need to choose the time window which you want each data point to represent in Funnel. You can choose 1 day, 7 day, 14 day, 30 day and Calendar Month time window. Choosing a 7 day time window would mean that on each given date in Funnel 7 WHY IS MY GOOGLE DATA STUDIO REPORT SO SLOW? Here are our recommended steps. 1. Reducing the complexity of your Dashboard. Number of widgets - at present Data Studio will perform one query against Funnel for each widget in your report, even if they are displaying the same data (i.e. the same segmentation or breakdown) filtered in different ways. Minimising the number of widgets therefore WHAT DATA CAN I GET FROM DISPLAY & VIDEO 360 (DOUBLECLICK The connection types supported are: Partner, Advertiser and Custom. The Partner and Advertiser connection types allow for downloading non-aggregatable metrics. The connection type Custom allows users to connect and download data from reports created in DV360. You can read more about the connection type Custom by following this link. AUTOMATED DATA COLLECTION & MARKETING REPORTS Power your business intelligence tool with marketing data, feed it directly to your data warehouse, dashboard solution, Google Data Studio or Sheets, or any other tool you are using. Data Destinations. Destinations. API and Data Warehouse. Business Intelligence.

ABOUT FUNNEL

Funnel curates and harmonises data in real time to present it to you in a way that creates real insight. With no coding needed, Funnel lets marketers get straight to action, unleashing the true power of performance marketing. Freed from laborious tasks, technical teams and analysts can focus on activities that create true value.

IT/ ENGINEERING

IT/Engineering. A secure, scalable, and accurate solution for data collection and transformation Free yourself from tedious marketing data collection and manipulation tasks to focus on higher-value activities, whilst cutting down on platform maintenance and the number

of support tickets.

TABLEAU - CONNECT YOUR MARKETING PLATFORMS AUTOMATICALLY Solution overview. Learn how to enrich Tableau with all of your marketing data using Funnel's direct connector. This video provides an introduction to Funnel, why we created a direct Tableau integration, and what the benefits are. We also dive into Tableau to show you what’s possible with Business-Ready Data! This opens in a new

window.

SNOWFLAKE CONNECTOR

Snowflake Connector. Automatically feed Business-Ready Data from over 500 platforms to Snowflake. Data from all of the platforms your company uses, cleaned and normalized into one table with the full

granularity intact.

FUNNEL KNOWLEDGE BASE Get started collecting, managing and working with your data in Funnel. +2. 10 articles in this collection. Written by Sven Hamberg, Simon Kalicinski, Megan Lozicki and 2 others.

PRICING | FUNNEL

The perfect plan for the whole team, with Funnel’s unique Data Guarantee which allows you to connect to any data source. from $999 monthly. (billed annually) Book a demo. Everything in Essentials +. Library of 500+ connectors. Data Guarantee. Unlimited workspaces.

Roles

GOOGLE ANALYTICS UTM TAGGING BEST PRACTICES Google Analytics UTM tagging best practices. Google Analytics is by far the most used analytics tool. BuiltWith estimates that more than 80% of all websites worldwide use Google Analytics for measuring their website usage. Unfortunately, many of the people relying on Google Analytics for measuring their website traffic lack a good understanding of how it works and have not set up their UTMs MICROSOFT AZURE BLOB STORAGE CONFIGURATION You should have a Microsoft Azure account and have created a Storage account of kind 'Blob storage'. Funnel has no opinions about how you configure your account, resource groups, or container. To configure the export you will need: The host name of your service account. You can find this in 'Properties' under 'Primary blob service endpoint' or HOW DO I AVOID NULL VALUES WHEN EXPORTING CALCULATED Summary. To avoid problems with null values in metrics exported from Funnel to Google Data Studio, follow these guidelines when creating custom metrics in Funnel: AUTOMATED DATA COLLECTION & MARKETING REPORTS Power your business intelligence tool with marketing data, feed it directly to your data warehouse, dashboard solution, Google Data Studio or Sheets, or any other tool you are using. Data Destinations. Destinations. API and Data Warehouse. Business Intelligence.

ABOUT FUNNEL

Funnel curates and harmonises data in real time to present it to you in a way that creates real insight. With no coding needed, Funnel lets marketers get straight to action, unleashing the true power of performance marketing. Freed from laborious tasks, technical teams and analysts can focus on activities that create true value.

IT/ ENGINEERING

IT/Engineering. A secure, scalable, and accurate solution for data collection and transformation Free yourself from tedious marketing data collection and manipulation tasks to focus on higher-value activities, whilst cutting down on platform maintenance and the number

of support tickets.

TABLEAU - CONNECT YOUR MARKETING PLATFORMS AUTOMATICALLY Solution overview. Learn how to enrich Tableau with all of your marketing data using Funnel's direct connector. This video provides an introduction to Funnel, why we created a direct Tableau integration, and what the benefits are. We also dive into Tableau to show you what’s possible with Business-Ready Data! This opens in a new

window.

SNOWFLAKE CONNECTOR

Snowflake Connector. Automatically feed Business-Ready Data from over 500 platforms to Snowflake. Data from all of the platforms your company uses, cleaned and normalized into one table with the full

granularity intact.

FUNNEL KNOWLEDGE BASE Get started collecting, managing and working with your data in Funnel. +2. 10 articles in this collection. Written by Sven Hamberg, Simon Kalicinski, Megan Lozicki and 2 others.

PRICING | FUNNEL

The perfect plan for the whole team, with Funnel’s unique Data Guarantee which allows you to connect to any data source. from $999 monthly. (billed annually) Book a demo. Everything in Essentials +. Library of 500+ connectors. Data Guarantee. Unlimited workspaces.

Roles

GOOGLE ANALYTICS UTM TAGGING BEST PRACTICES Google Analytics UTM tagging best practices. Google Analytics is by far the most used analytics tool. BuiltWith estimates that more than 80% of all websites worldwide use Google Analytics for measuring their website usage. Unfortunately, many of the people relying on Google Analytics for measuring their website traffic lack a good understanding of how it works and have not set up their UTMs MICROSOFT AZURE BLOB STORAGE CONFIGURATION You should have a Microsoft Azure account and have created a Storage account of kind 'Blob storage'. Funnel has no opinions about how you configure your account, resource groups, or container. To configure the export you will need: The host name of your service account. You can find this in 'Properties' under 'Primary blob service endpoint' or HOW DO I AVOID NULL VALUES WHEN EXPORTING CALCULATED Summary. To avoid problems with null values in metrics exported from Funnel to Google Data Studio, follow these guidelines when creating custom metrics in Funnel: AUTOMATED DATA COLLECTION & MARKETING REPORTS Power your business intelligence tool with marketing data, feed it directly to your data warehouse, dashboard solution, Google Data Studio or Sheets, or any other tool you are using. Data Destinations. Destinations. API and Data Warehouse. Business Intelligence. MARKETING DASHBOARDS AND REPORTS Marketing dashboards are crucial for centralizing all this data, so you can easily monitor and generate business insights. By providing an overview of the most important metrics, they allow data-driven decision making and give adaptability to the whole marketing

organization.

CONTACT US | FUNNEL

Reach out to us to learn more about our advertising analytics software ALL YOUR MARKETING DATA TO GOOGLE SHEETS Funnel collects data from all marketing and advertising platforms, which can then be exported and visualized in Google Sheets. With connections to over 500 data sources, Funnel will be the last connector you’ll ever need. If you’re unable to find the platform you use out-of-the-box, you can request a FEED YOUR DATA DIRECTLY INTO GOOGLE DATA STUDIO Connections to all of your platforms. Funnel integrates with all of your advertising, sales and marketing platforms ensuring everything you need is available in Data Studio. If you can’t find the platform you need in our list of over 500 connectors, simply request it and we’ll build it for you. GOOGLE DATA STUDIO TEMPLATES Monthly Marketing Overview. This template provides a top-level omnichannel overview of your marketing performance. Spot trends and obtain the information required to shift budget from underperforming channels. By Funnel. MICROSOFT AZURE BLOB STORAGE CONFIGURATION You should have a Microsoft Azure account and have created a Storage account of kind 'Blob storage'. Funnel has no opinions about how you configure your account, resource groups, or container. To configure the export you will need: The host name of your service account. You can find this in 'Properties' under 'Primary blob service endpoint' or WHAT DATA CAN I GET FROM GOOGLE ANALYTICS? The User report is a non-aggregatable report which offers the Users metric with different dimensions. You need to choose the time window which you want each data point to represent in Funnel. You can choose 1 day, 7 day, 14 day, 30 day and Calendar Month time window. Choosing a 7 day time window would mean that on each given date in Funnel 7 WHY IS MY GOOGLE DATA STUDIO REPORT SO SLOW? Here are our recommended steps. 1. Reducing the complexity of your Dashboard. Number of widgets - at present Data Studio will perform one query against Funnel for each widget in your report, even if they are displaying the same data (i.e. the same segmentation or breakdown) filtered in different ways. Minimising the number of widgets therefore WHAT DATA CAN I GET FROM DISPLAY & VIDEO 360 (DOUBLECLICK The connection types supported are: Partner, Advertiser and Custom. The Partner and Advertiser connection types allow for downloading non-aggregatable metrics. The connection type Custom allows users to connect and download data from reports created in DV360. You can read more about the connection type Custom by following this link. FUNNEL KNOWLEDGE BASE Get started collecting, managing and working with your data in Funnel. +2. 10 articles in this collection. Written by Sven Hamberg, Simon Kalicinski, Megan Lozicki and 2 others.

SNOWFLAKE CONNECTOR

Snowflake Connector. Automatically feed Business-Ready Data from over 500 platforms to Snowflake. Data from all of the platforms your company uses, cleaned and normalized into one table with the full

granularity intact.

MICROSOFT AZURE BLOB STORAGE CONFIGURATION You should have a Microsoft Azure account and have created a Storage account of kind 'Blob storage'. Funnel has no opinions about how you configure your account, resource groups, or container. To configure the export you will need: The host name of your service account. You can find this in 'Properties' under 'Primary blob service endpoint' or WHAT DATA CAN I GET FROM GOOGLE ANALYTICS? COMBINING MULTIPLE DATA SOURCES IN DATA STUDIO Funnel enables you to combine data from multiple sources into a single table or chart: As opposed to having a data source for each individual platform, Funnel combines and groups the data prior to exporting to Data Studio. You can also combine your ad platform data with Google Analytics data to gain a complete overview of your marketing efforts: HOW DO I CONNECT TABLEAU TO FUNNEL? To configure the Funnel Connector in Tableau, go to "Start page -> Connect -> To a Server" and select Web Data Connector. The example below is using Tableau Desktop version 10.5. Copy the web data connector URL from the Tableau page in Funnel and paste into Tableau. Tip: Use the 'copy to clipboard' button found on the right of the URL. WHY IS MY GOOGLE DATA STUDIO REPORT SO SLOW? Here are our recommended steps. 1. Reducing the complexity of your Dashboard. Number of widgets - at present Data Studio will perform one query against Funnel for each widget in your report, even if they are displaying the same data (i.e. the same segmentation or breakdown) filtered in different ways. Minimising the number of widgets therefore WHAT DATA CAN I GET FROM DISPLAY & VIDEO 360 (DOUBLECLICK The connection types supported are: Partner, Advertiser and Custom. The Partner and Advertiser connection types allow for downloading non-aggregatable metrics. The connection type Custom allows users to connect and download data from reports created in DV360. You can read more about the connection type Custom by following this link. HOW TO SETUP A SERVICE ACCOUNT IN ADOBE ANALYTICS New Adobe Analytics data sources in Funnel utilises JWT service accounts, this means personal or technical account is not needed. The service account is connected to the Adobe account and has access to permissions shared in a product profile (step 1), only segments/dimensions/metrics shared with the entire organisation will be viewable in Funnel. WHAT DATA CAN I GET FROM APPNEXUS (XANDR)? Default of advertiser currency. All monetary metrics are by default retrieved in USD from the AppNexus API. There is an option when connecting to Appnexus in Funnel to be able to get the monetary metrics converted into the advertiser currency instead. This option is only available for reports containing monetary metrics. FUNNEL KNOWLEDGE BASE Get started collecting, managing and working with your data in Funnel. +2. 10 articles in this collection. Written by Sven Hamberg, Simon Kalicinski, Megan Lozicki and 2 others.

SNOWFLAKE CONNECTOR

Snowflake Connector. Automatically feed Business-Ready Data from over 500 platforms to Snowflake. Data from all of the platforms your company uses, cleaned and normalized into one table with the full

granularity intact.

MICROSOFT AZURE BLOB STORAGE CONFIGURATION You should have a Microsoft Azure account and have created a Storage account of kind 'Blob storage'. Funnel has no opinions about how you configure your account, resource groups, or container. To configure the export you will need: The host name of your service account. You can find this in 'Properties' under 'Primary blob service endpoint' or WHAT DATA CAN I GET FROM GOOGLE ANALYTICS? COMBINING MULTIPLE DATA SOURCES IN DATA STUDIO Funnel enables you to combine data from multiple sources into a single table or chart: As opposed to having a data source for each individual platform, Funnel combines and groups the data prior to exporting to Data Studio. You can also combine your ad platform data with Google Analytics data to gain a complete overview of your marketing efforts: HOW DO I CONNECT TABLEAU TO FUNNEL? To configure the Funnel Connector in Tableau, go to "Start page -> Connect -> To a Server" and select Web Data Connector. The example below is using Tableau Desktop version 10.5. Copy the web data connector URL from the Tableau page in Funnel and paste into Tableau. Tip: Use the 'copy to clipboard' button found on the right of the URL. WHY IS MY GOOGLE DATA STUDIO REPORT SO SLOW? Here are our recommended steps. 1. Reducing the complexity of your Dashboard. Number of widgets - at present Data Studio will perform one query against Funnel for each widget in your report, even if they are displaying the same data (i.e. the same segmentation or breakdown) filtered in different ways. Minimising the number of widgets therefore WHAT DATA CAN I GET FROM DISPLAY & VIDEO 360 (DOUBLECLICK The connection types supported are: Partner, Advertiser and Custom. The Partner and Advertiser connection types allow for downloading non-aggregatable metrics. The connection type Custom allows users to connect and download data from reports created in DV360. You can read more about the connection type Custom by following this link. HOW TO SETUP A SERVICE ACCOUNT IN ADOBE ANALYTICS New Adobe Analytics data sources in Funnel utilises JWT service accounts, this means personal or technical account is not needed. The service account is connected to the Adobe account and has access to permissions shared in a product profile (step 1), only segments/dimensions/metrics shared with the entire organisation will be viewable in Funnel. WHAT DATA CAN I GET FROM APPNEXUS (XANDR)? Default of advertiser currency. All monetary metrics are by default retrieved in USD from the AppNexus API. There is an option when connecting to Appnexus in Funnel to be able to get the monetary metrics converted into the advertiser currency instead. This option is only available for reports containing monetary metrics.

IT/ ENGINEERING

IT/Engineering. A secure, scalable, and accurate solution for data collection and transformation Free yourself from tedious marketing data collection and manipulation tasks to focus on higher-value activities, whilst cutting down on platform maintenance and the number

of support tickets.

TABLEAU - CONNECT YOUR MARKETING PLATFORMS AUTOMATICALLY Benefits of using Funnel’s direct Tableau integration. Funnel takes messy, siloed data from all marketing platforms to automatically generate Business-Ready Data that is fully harmonized, up-to-date and always ready for analysis in Tableau. GOOGLE DATA STUDIO TEMPLATES Monthly Marketing Overview. This template provides a top-level omnichannel overview of your marketing performance. Spot trends and obtain the information required to shift budget from underperforming channels. By Funnel. ALL YOUR MARKETING DATA TO GOOGLE SHEETS Funnel collects data from all marketing and advertising platforms, which can then be exported and visualized in Google Sheets. With connections to over 500 data sources, Funnel will be the last connector you’ll ever need. If you’re unable to find the platform you use out-of-the-box, you can request a HOW DOES THE FUNNEL MARKETING TEAM USE FUNNEL? Could you answer in a couple of seconds how your cross-channel marketing campaigns are performing? Funnel can! Find out how the marketing team does it. FUNNEL MONTHLY PRODUCT UPDATE, MAY 2021 It's time for your monthly dose of Funnel updates! Here's everything we released during May. WHAT DATA CAN I GET FROM LINKEDIN? Regular metrics. The Standard report will have all currently added metrics and the totals of the report will be correct for the entire LinkedIn account.. The Conversion report only contains tracked conversions ie. not any metrics or dimensions not related to custom conversions.The totals value here will match the Conversion Value in the Standard report. Same conversion count metrics will get WHAT DATA CAN I GET FROM GOOGLE ANALYTICS? The User report is a non-aggregatable report which offers the Users metric with different dimensions. You need to choose the time window which you want each data point to represent in Funnel. You can choose 1 day, 7 day, 14 day, 30 day and Calendar Month time window. Choosing a 7 day time window would mean that on each given date in Funnel 7 WHAT DATA CAN I GET FROM ADWORDS (GOOGLE ADS)? When connecting an Adwords (Google Ads) data source you can choose between eleven different report types: Standard. Geo Performance. Location View. Search Keyword. Placement. Shopping Performance. Placeholder Feed Item. HOW DO I CONNECT TABLEAU TO FUNNEL? To configure the Funnel Connector in Tableau, go to "Start page -> Connect -> To a Server" and select Web Data Connector. The example below is using Tableau Desktop version 10.5. Copy the web data connector URL from the Tableau page in Funnel and paste into Tableau. Tip: Use the 'copy to clipboard' button found on the right of the URL.

Product

Data Data sources Data transformation Destinations API and Data Warehouse Business Intelligence Dashboards and Reports

Google Analytics

Google Data Studio

Google Sheets

Tableau Looker Pricing

Customers

Customers Case studies

Solutions

Industries Agencies Ecommerce Retail User roles Data Analysts/BI Digital Marketing

IT/Engineering

Resources

Blog Best practices Updates

Log in Get started

__

Product

Data sources Data transformation API and Data Warehouse Business Intelligence Dashboards and Reports

Google Analytics

Google Data Studio

Google Sheets

Tableau Looker Pricing

Customers

Customers Case studies

Solutions

Agencies Ecommerce Retail Data Analysts/BI Digital Marketing

IT/Engineering

Resources

Blog Best practices Updates

Log in

ALL YOUR MARKETING AND ADVERTISING DATA WHERE YOU WANT IT INTEGRATIONS WITH OVER 500 DATA SOURCES

*

Type of business (rule based)

GA Client id

Lifecycle Stage

fbclid

gclid

improved_campaign

improved_medium

improved_source

improved_adGroup

unique_tracking_id

__ Get a free trial after the demo. TRUSTED BY THE WORLD'S MOST DATA-DRIVEN BUSINESSES

*

“Funnel is great and it’s very hard to replicate what it does. I'm grateful for all the work that’s behind it.”

BRUNO ALCANTARA

Programmatic Media Director,

Mais Clicks

“Thanks to Funnel, our Analytics team is able to provide complete, unified and quality data to our Marketing team for company level

reporting.”

DOMINIKA ČAMAJOVÁ

Data Analyst,

Kiwi.com

“Funnel has allowed us to do more with fewer team members and fewer

hours.”

GREG DIONNE

Digital Marketing Manager,

Reed Exhibitions

“Funnel has streamlined everything. It’s tidy, easy to use and reliable. It’s definitely an improvement from our previous setup.”

KATE BELFORD

SEM Manager,

Brainlabs

-------------------------

HOW IT WORKS

COLLECT

With integrations to all your marketing and advertising platforms Funnel automatically collects all the data you need from any data source. Data sources __

TRANSFORM

Easily clean, map and group your data in Funnel’s powerful data

mapping interface.

FEED

Feed all your marketing data into any tool you like. Power your business intelligence tool with marketing data, feed it directly to your data warehouse, dashboard solution, Google Data Studio or Sheets, or any other tool you are using. Data destinations __

Destinations

* API and Data Warehouse * Business Intelligence * Google Data Studio

* Google Sheets

* Google Analytics

* Dashboards and Reports ------------------------- UTILIZE YOUR MARKETING DATA ANYWHERE Funnel integrates with your existing tools, feeding Business-Ready Data to any data destination of your choice. BUSINESS INTELLIGENCE Feed marketing data into your business intelligence system.

GOOGLE DATA STUDIO

Visualize all your data in Google Data Studio. API AND DATA WAREHOUSE Feed data to your data warehouse or backend system.

GOOGLE ANALYTICS

Upload advertising cost data to Google Analytics.

GOOGLE SHEETS

Upload all your marketing data to Google Sheets. DASHBOARDS & REPORTS Create dashboards and reports with all your marketing data. ------------------------- BENEFITS ACROSS THE ORGANIZATION

DIGITAL MARKETING

* Meaningful data set you can access at will. * Always understand impact of investments. * Experiment/update business logic without coding or IT support.

MARKETING ANALYTICS

* Data normalized, harmonized – no more stitching. * Preserves full data granularity. * Work in the data visualization tool of your choice.

DATA ANALYTICS/BI

* Fully modular with direct integrations to all major data warehouses and business intelligence tools. * Data from all of your sources, fetched and preserved in full

granularity.

IT TEAM/ ENGINEERING * Free up resources by reducing project backlog for building/maintaining data source connectors and aggregators. * Reduce number of marketing support requests. ------------------------- WHAT MAKES FUNNEL DIFFERENT?

DATA GUARANTEE

Data from all of your marketing platforms at your fingertips. NO-CODE BUSINESS LOGIC You don’t need to be a developer to get the most out of your data. Funnel also empowers the business user. ANYWHERE YOU WANT IT Funnel integrates with your existing tools, giving you the freedom to store and visualise your data wherever you want. CONTEXTUAL DATA MODEL Funnel’s contextual data model provides Business-Ready data

out-of-the-box.

UNIFIED REPOSITORY

Breaking silos by storing all of your data and business logic in one

place.

WORLD-CLASS CUSTOMER SUPPORT Our customer success team is always available for consultation and creative problem solving. ------------------------- HEAR SEEDRS CMO BEN ARONSTEN EXPLAIN HOW SEEDRS USED FUNNEL TO IMPROVE THEIR BUSINESS OBJECTIVES BY 30%

Funnel.io

BOOK A DEMO TO GET STARTED

*

Type of business (rule based) Monthly advertising budget Message to the Funnel team

Lifecycle Stage

GA Client id

fbclid

gclid

improved_medium

improved_source

improved_campaign

improved_adGroup

unique_tracking_id

PRODUCT

* Data sources

* Data transformation * API and Data Warehouse * Business Intelligence * Google Data Studio

* Google Sheets

* Google Analytics

* Dashboards and Reports

PRICING

* Pricing

CUSTOMERS

* Customers

* Case studies

SOLUTIONS

* Ecommerce

* Agencies

* Retail

* Data Analysts/BI

* Digital Marketing

* IT/Engineering

COMPANY

* About us

* Careers

* Contact

* Media Kit

RESOURCES

* Blog

* Product updates

* Best practices

* Help center

* _ LinkedIn _

* _ Twitter _

* _ Facebook _

* Privacy policy

* General Terms and Conditions * Information Security Overview This website uses cookies to ensure you get the best experience on our website. By continuing to use this site, you consent to our cookie policy. Privacy & cookie policy · __ Got it!