KEY TOPICS
INTEGRATION AVAILABILITY
This V1 integration is available for:
-
Pro V1
*You are considered V1 if you have your own Looker instance and signed up for Daasity BEFORE July 15, 2020. If unsure, please reach out to Support@Daasity.com for assistance
INTEGRATION OVERVIEW
Google Analytics Multi-Channel Funnels Reporting API enables you to request Multi-Channel Funnel 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 V1 Google Analytics First Click Data extractor pulls a standard set of data via the Multi-Channel Funnel Reporting API. The Multi-Channel Funnel Reporting API is a report generation API and requires parameters to be passed into the API.
The API has limitations on the level of granularity that can be returned as follows:
- 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.
ERD EMBED
ENDPOINT: Multi-Channel Funnel Reporting API
Documentation on the Google Analytics Multi-Channel Funnel Reporting API can be found here: https://developers.google.com/analytics/devguides/reporting/mcf/v3/reference
Multi-Channel TABLE
Data Mapping.
JSON Element | Database Column | Dataype |
MD5 Hash of all the Dimensions | id | VARCHAR |
View ID selected for the integration | view_id | VARCHAR |
mcf:transactionId | transaction_id | VARCHAR |
mcf:conversionDate | created_on | TIMESTAMP |
mcf:sourcePath | source_path | VARCHAR |
Daasity: 1st node of mcf:sourcePath | source_path_first_node | VARCHAR |
Daasity: Last node of mcf:sourcePath | source_path_last_node | VARCHAR |
mcf:mediumPath | medium_path | VARCHAR |
Daasity: 1st node of mcf:mediumPath | medium_path_first_node | VARCHAR |
Daasity: Last node of mcf:mediumPath | medium_path_last_node | VARCHAR |
mcf:campaignPath | campaign_path | VARCHAR |
Daasity: 1st node of mcf:campaignPath | campaign_path_first_node | VARCHAR |
Daasity: Last node of mcf:campaignPath | campaign_path_last_node | VARCHAR |
mcf:basicChannelGrouping | basic_channel_grouping_path | VARCHAR |
Daasity: 1st node of mcf:basicChannelGrouping | basic_channel_grouping_path_first_node | VARCHAR |
Daasity: Last node of mcf:basicChannelGrouping | basic_channel_grouping_path_last_node | VARCHAR |
mcf:keywordPath | keyword_path | VARCHAR |
Daasity: 1st node of mcf:keywordPath | keyword_path_first_node | VARCHAR |
Daasity: Last node of mcf:keywordPath | keyword_path_last_node | VARCHAR |
mcf:sourceMediumPath | source_medium_path | VARCHAR |
Daasity: 1st node of mcf:sourceMediumPath | source_medium_path_first_node | VARCHAR |
Daasity: Last node of mcf:sourceMediumPath | source_medium_path_last_node | VARCHAR |
mcf:timeLagInDaysHistogram | time_lag_in_days_histogram | VARCHAR |
Daasity: from Channel Mapping Google Sheet | channel_first_click | VARCHAR |
Daasity: from Channel Mapping Google Sheet | vendor_first_click | VARCHAR |
Daasity: from Channel Mapping Google Sheet | sub_channel_first_click | VARCHAR |
Daasity: from Channel Mapping Google Sheet | media_type_first_click | VARCHAR |
Daasity: from Channel Mapping Google Sheet | channel_last_click | VARCHAR |
Daasity: from Channel Mapping Google Sheet | vendor_last_click | VARCHAR |
Daasity: from Channel Mapping Google Sheet | sub_channel_last_click | VARCHAR |
Daasity: from Channel Mapping Google Sheet | media_type_last_click | VARCHAR |
Daasity: from Channel Mapping Google Sheet | attribution_channel | VARCHAR |
Business Rules.
Business Rule | Value |
Load Type | Upsert |
Extraction Frequency | Daily |
Sync Key | All dimensions |
Base Multi-Channel Funnel TABLE
Data Mapping.
JSON Element | Database Column | Datatype |
MD5 Hash of all the Dimensions | id | VARCHAR |
View ID selected for the integration | view_id | VARCHAR |
mcf:transactionId | transaction_id | VARCHAR |
mcf:conversionDate | created_on | TIMESTAMP |
mcf:sourcePath | source_path | VARCHAR |
mcf:basicChannelGrouping | basic_channel_path | VARCHAR |
mcf:sourceMediumPath | source_medium_path | VARCHAR |
mcf:mediumPath | medium_path | VARCHAR |
mcf:campaignPath | campaign_path | VARCHAR |
mcf:keywordPath | keyword_path | VARCHAR |
Daasity: node number | sequence | INT |
Daasity: from Channel Mapping Google Sheet | channel | VARCHAR |
Daasity: from Channel Mapping Google Sheet | vendor | VARCHAR |
Daasity: from Channel Mapping Google Sheet | sub_channel | VARCHAR |
Daasity: from Channel Mapping Google Sheet | media_type | VARCHAR |
Daasity: from Channel Mapping Google Sheet | attribution_channel | VARCHAR |
Business Rules.
Business Rule | Value |
Load Type | Upsert |
Extraction Frequency | Daily |
Sync Key | All dimensions |
EXTRACTION EXAMPLE
Although the GA Multi-Channel Funnel Reporting data extract is API based the best way to sample data is using tools that GA supplies:
- MCF Sample Data: https://developers.google.com/analytics/devguides/reporting/mcf/v3/reference
- Use the Try this API section on the right side of the page.