Integration: Google Analytics Multi-Channel Funnels Reporting V2

This article will help you learn about how Daasity replicates data from Google Analytics Multi-Channel Funnels Reporting, limitations to the data we can extract and where the data is stored in the Google Analytics MCF V2 schema

KEY TOPICS

Click on the links below to take you to the section where you can learn more about this Integration


INTEGRATION AVAILABILITY

This integration is available for:

  • Growth
  • Pro V2

NOTE: You are considered V2 if...

  • You are a Growth customer
  • Your account says Pro V2 in the Daasity App

Not sure? Reach out to Support@Daasity.com 

INTEGRATION OVERVIEW

Google Analytics Multi-Channel Funnels Reporting API enables you to request Multi-Channel Funnels data which is derived from conversion path data and shows user interactions with various traffic sources over multiple sessions prior to converting. This allows the merchant to analyze how multiple marketing channels influence conversions over time.

The Daasity V2 Google Analytics MCF extractor pulls a standard set of data via the Multi-Channel Funnels Reporting API. The Multi-Channel Funnels Reporting API is a report generation API and requires parameters to be passed into the API.

 

NOTE: The API has limitations on the level of granularity that can be returned:

  • Dimensions are limited to 7 per report
  • Metrics are limited to 10 per report

Daasity queries each report for each day which thus removes the need to include the ga:Date as a parameter and thus allowing the full 7 dimensions to be used.

API Endpoints

The Daasity V2 Google Analytics MCF extractor is built based on this Google Analytics Multi-Channel Funnels Reporting API Documentation. The following endpoints are used by Daasity to replicate data from Google Analytics MCF V2:

Entity Relationship Diagram (ERD)

The embedded diagram houses the ERD for the Daasity Google Analytics Multi-Channel Funnels integration illustrating the different tables and keys to join across tables.  Hover over the embedded diagram to reveal controls to zoom and scroll.

Google Analytics Multi-Channel Funnel Reporting Schema

The Daasity Google Analytics MCF extractor creates these tables using the endpoints and replication methods listed.  The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.​

Base Multi-Channel

  • Endpoint: MCF
  • Update Methdod: UPSERT
  • Table Name: ga.base_multi_channel
JSON Element  Database Column 
MD5(all the dimensions) id
View ID selected for the integration view_id
mcf:transactionId transaction_id
mcf:conversionDate created_on
mcf:sourcePath source_path
Daasity: 1st node of mcf:sourcePath source_path_first_node
Daasity: Last node of mcf:sourcePath source_path_last_node
mcf:mediumPath medium_path
Daasity: 1st node of mcf:mediumPath medium_path_first_node
Daasity: Last node of mcf:mediumPath medium_path_last_node
mcf:campaignPath campaign_path
Daasity: 1st node of mcf:campaignPath campaign_path_first_node
Daasity: Last node of mcf:campaignPath campaign_path_last_node
mcf:basicChannelGrouping basic_channel_grouping_path
Daasity: 1st node of mcf:basicChannelGrouping basic_channel_grouping_path_first_node
Daasity: Last node of mcf:basicChannelGrouping basic_channel_grouping_path_last_node
mcf:keywordPath keyword_path
Daasity: 1st node of mcf:keywordPath keyword_path_first_node
Daasity: Last node of mcf:keywordPath keyword_path_last_node
mcf:sourceMediumPath source_medium_path
Daasity: 1st node of mcf:sourceMediumPath source_medium_path_first_node
Daasity: Last node of mcf:sourceMediumPath source_medium_path_last_node
mcf:timeLagInDaysHistogram time_lag_in_days_histogram
Daasity: from Channel Mapping Google Sheet channel_first_click
Daasity: from Channel Mapping Google Sheet vendor_first_click
Daasity: from Channel Mapping Google Sheet sub_channel_first_click
Daasity: from Channel Mapping Google Sheet media_type_first_click
Daasity: from Channel Mapping Google Sheet channel_last_click
Daasity: from Channel Mapping Google Sheet vendor_last_click
Daasity: from Channel Mapping Google Sheet sub_channel_last_click
Daasity: from Channel Mapping Google Sheet media_type_last_click
Daasity: from Channel Mapping Google Sheet attribution_channel

 

NOTE: There are two extractions being made for this report, due to dimension limits within an extraction. The primary table will contain the full set of columns while their stage tables will have a subset of metrics. Stage tables are stitched together to complete the primary table, updating rows with matching sync keys.

Base Multi-Channel Funnel

  • Endpoint: MCF
  • Update Method: UPSERT
  • Table Name: ga.base_multi_channel_funnel
JSON Element  Database Column 
MD5(all the dimensions) id
View ID selected for the integration view_id
mcf:transactionId transaction_id
mcf:conversionDate created_on
mcf:sourcePath source_path
mcf:basicChannelGrouping basic_channel_path
mcf:sourceMediumPath source_medium_path
mcf:mediumPath medium_path
mcf:campaignPath campaign_path
mcf:keywordPath keyword_path
Daasity: node number sequence
Daasity: from Channel Mapping Google Sheet channel
Daasity: from Channel Mapping Google Sheet vendor
Daasity: from Channel Mapping Google Sheet sub_channel
Daasity: from Channel Mapping Google Sheet media_type
Daasity: from Channel Mapping Google Sheet attribution_channel
 

 

NOTE: There are two extractions being made for this report, due to dimension limits within an extraction. The primary table will contain the full set of columns while their stage tables will have a subset of metrics. Stage tables are stitched together to complete the primary table, updating rows with matching sync keys.

​Related Resources

Although the GA Multi-Channel Funnel Reporting data extract is API based the best way to sample data is using tools that GA supplies: