Integration Specifications

This article will help you learn about how Daasity replicates data from GA First Click, limitations to the data we can extract and where the data is stored in the GA First Click schema.

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.

Integration Availability

This integration is available for:

• Enterprise

• Growth

API Endpoints

The Daasity GA First Click extractor is built based on the Google Analytics Multi-Channel Funnel Reporting API. The following endpoint is used by Daasity to replicate data from GA:

• Multi-Channel Funnel Reporting

Entity Relationship Diagram (ERD)

Click here to view the Daasity GA First Click integration illustrating the different tables and keys to join across tables.

GA First Click Schema

The Daasity GA First Click 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.

• Multi-Channel
• Multi-Channel Funnel

Multi-Channel

• Endpoint: Multi-Channel Funnel Reporting
• Update Method: UPSERT

• Table Name: [ga.multi_channel]

JSON Element	Database Column
MD5 Hash of 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

Multi-Channel Funnel

• Endpoint: Multi-Channel Funnel Reporting
• Update Method: UPSERT

• Table Name: [ga.multi_channel_funnel]

JSON Element	Database Column
MD5 Hash of 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