Google Analytics First Click Extractor Documentation (V1)

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: