Skip to main content
Skip table of contents

Google Analytics MCF

Overview

Google MCF (Multi-Channel Funnel) is a powerful datasource that gives you the conversion paths of every conversion on the client's website.

While Google Analytics MCF will work with non-GA 360 Premium accounts, it will return less accurate data since it does not include data from Doubleclick.

Vendor/Partner

Google

Version

v3

API Documentation

MCF - API Docs

Sunset Date

Standard Universal Analytics (UA) properties stopped processing data on July 1, 2023. UA 360 properties will stop processing data on July 1, 2024, and some UA 360 features will be deprecated before then, as we migrate to Google Analytics 4. Use the Data API to access the reporting features for GA4 properties.

Channel(s)

Refresh Time (CST)

3 am

Default backfill

5 days

Alli Data Library

(error)

Getting Started

  1. Google Analytics requires a Google account with access to google analytics. You can check which profiles you have access to by visiting Google Analytics. Once you have an account with Google Analytics access, simply click the "Authorize Google Analytics" button.

  2. This will lead to a page to select your google account

  3. The next step is to select a Google Analytics profile. You can only select one profile at a time, however, you can follow the parent / child datasources to bring in multiple profiles.

Define your Data

These selections will be the options you can choose from as your dimensions or metrics. 
You can find more specific details in the API documentation. 

Dimensions

Name

Type

Table Field Name

Description

conversionDate

DATE

conversionDate

The time of the conversion with respect to the view's (profile’s) timezone

transactionId

STRING

transactionId

The transaction ID, supplied by the ecommerce tracking method, for the purchase in the shopping cart

basicChannelGroupingPath

JSON

basicChannelGroupingPath

Sequence of basic channel groupings along conversion paths. Note that the channel groups are always returned in US English

sourcePath

JSON

sourcePath

Sequence of sources along conversion paths

mediumPath

JSON

mediumPath

Sequence of mediums along conversion paths

sourceMediumPath

JSON

sourceMediumPath

Sequence of source/medium pairs along conversion paths

campaignPath

JSON

campaignPath

Sequence of campaign names along conversion paths

keywordPath

JSON

keywordPath

Sequence of keywords along conversion paths

adwordsAdContentPath

JSON

adwordsAdContentPath

Sequence of AdWords ad contents along conversion paths

adwordsAdGroupIDPath

JSON

adwordsAdGroupIDPath

Sequence of AdWords ad group ID along conversion paths

adwordsAdGroupPath

JSON

adwordsAdGroupPath

Sequence of AdWords ad groups along conversion paths

adwordsCampaignIDPath

JSON

adwordsCampaignIDPath

Sequence of AdWords campaign ID along conversion paths

adwordsCampaignPath

JSON

adwordsCampaignPath

Sequence of AdWords campaigns along conversion paths

adwordsCreativeIDPath

JSON

adwordsCreativeIDPath

Sequence of AdWords creative ID along conversion paths

adwordsCriteriaIDPath

JSON

adwordsCriteriaIDPath

Sequence of AdWords criteria ID along conversion paths

adwordsCustomerIDPath

JSON

adwordsCustomerIDPath

Sequence of AdWords customer ID along conversion paths

adwordsDestinationUrlPath

JSON

adwordsDestinationUrlPath

Sequence of AdWords destination URLs along conversion paths

adwordsDisplayUrlPath

JSON

adwordsDisplayUrlPath

Sequence of AdWords display URLs along conversion paths

adwordsKeywordPath

JSON

adwordsKeywordPath

Sequence of AdWords keywords along conversion paths

adwordsMatchedSearchQueryPath

JSON

adwordsMatchedSearchQueryPath

Sequence of AdWords matched search queries along conversion paths

adwordsPlacementDomainPath

JSON

adwordsPlacementDomainPath

Sequence of AdWords placement domains along conversion paths

adwordsPlacementUrlPath

JSON

adwordsPlacementUrlPath

Sequence of AdWords placement URLs along conversion paths

conversionGoalNumber

NUMBER

conversionGoalNumber

The goal number of a conversion, if available. Possible values are between 1 and 20. Format is a 3-digit zero-padded string representing an integer. For example, conversion goal number of 3 is represented as "003"

conversionType

STRING

conversionType

A string representing the conversion type. Possible values are "Goal" or "Transaction".

dcmAd

STRING

dcmAd

DCM ad name of the DCM event (impression or click) matching the Google Analytics conversion

dcmAdPath

JSON

dcmAdPath

The path to conversion where interactions on the path are represented by DCM ads

dcmAdType

JSON

dcmAdType

DCM ad type name of the DCM event (impression or click) matching the Google Analytics conversion

dcmAdvertiser

STRING

dcmAdvertiser

DCM advertiser name of the DCM event (impression or click) matching the Google Analytics conversion

dcmAdvertiserPath

JSON

dcmAdvertiserPath

The path to conversion where interactions on the path are represented by DCM advertisers

dcmCampaign

STRING

dcmCampaign

DCM campaign name of the DCM event (impression or click) matching the Google Analytics conversion

dcmCampaignPath

JSON

dcmCampaignPath

The path to conversion where interactions on the path are represented by DCM campaigns

dcmCreative

STRING

dcmCreative

DCM creative name of the DCM event (impression or click) matching the Google Analytics conversion

dcmCreativePath

JSON

dcmCreativePath

The path to conversion where interactions on the path are represented by DCM creatives

dcmCreativeVersion

STRING

dcmCreativeVersion

DCM creative version of the DCM event (impression or click) matching the Google Analytics conversion

dcmCreativeVersionPath

JSON

dcmCreativeVersionPath

The path to conversion where interactions on the path are represented by DCM creative versions

dcmNetwork

STRING

dcmNetwork

The network used

dcmPlacement

STRING

dcmPlacement

DCM site placement name of the DCM event (impression or click) matching the Google Analytics conversion

dcmPlacementPath

JSON

dcmPlacementPath

The path to conversion where interactions on the path are represented by DCM placements

dcmSite

STRING

dcmSite

DCM site name where the DCM creative was shown for the DCM event (impression or click) matching the Google Analytics conversion

dcmSitePath

JSON

dcmSitePath

The path to conversion where interactions on the path are represented by DCM sites

pathLengthInInteractionsHistogram

NUMBER

pathLengthInInteractionsHistogram

The length of conversion paths in number of interactions. The value is a histogram across a range of possible values. Format is a 6-digit zero-padded string representing an integer. For example, path length of 4 is represented as "000004".

timeLagInDaysHistogram

NUMBER

timeLagInDaysHistogram

The length of conversion paths in number of days. The value is a histogram across a range of possible values. Format is a 3-digit zero-padded string representing an integer. For example, time lag of 3 days is represented as "003".

basicChannelGrouping

STRING

basicChannelGrouping

Sources of traffic labeled by the Basic Channel Grouping definition as explained here. Note that the channel groups are always returned in US English

source

STRING

source

The source of referrals. When using manual campaign tracking, the value of the utm_source campaign tracking parameter. When using AdWords autotagging, the value is google. Otherwise the domain of the source referring the user to your website. (e.g. document.referrer). The value may also contain a port address. If the user came to the site without a referrer, the value is "(direct)".

medium

STRING

medium

The type of referrals. When using manual campaign tracking, the value of the utm_medium campaign tracking parameter. When using AdWords autotagging, the value is cpc. If the user comes from a search engine detected by Google Analytics, the value is organic. If the referrer is not a search engine, the value is referral. If the user came directly to the site, and document.referrer is empty, the value is "(none)"

sourceMedium

STRING

sourceMedium

Concatenation of mcf:source/mcf:medium

campaignName

STRING

campaignName

When using manual campaign tracking, the value of the utm_campaign campaign tracking parameter. When using AdWords autotagging, the name(s) of the online ad campaign that you use for your website. Otherwise the value (not set) is used

keyword

STRING

keyword

When using manual campaign tracking, the value of the utm_term campaign tracking parameter. When using AdWords autotagging or if a user used organic search to reach your website, the keywords used by users to reach your website. Otherwise the value is (not set)

adwordsAdContent

STRING

adwordsAdContent

The content of your Adwords ad

adwordsAdGroup

STRING

adwordsAdGroup

The name of your AdWords ad group

adwordsAdGroupID

STRING

adwordsAdGroupID

Corresponds to AdWords API AdGroup.id

adwordsAdNetworkType

STRING

adwordsAdNetworkType

The type of network used to deliver your Adwords ads. Note that the types are always returned in US English

adwordsCampaign

STRING

adwordsCampaign

The name of your AdWords campaign

adwordsCampaignID

STRING

adwordsCampaignID

Corresponds to AdWords API Campaign.id

adwordsCreativeID

STRING

adwordsCreativeID

Corresponds to AdWords API Ad.id

adwordsCriteriaID

STRING

adwordsCriteriaID

Corresponds to AdWords API Criterion.id

adwordsCustomerID

STRING

adwordsCustomerID

Corresponds to AdWords API Customer.id.

adwordsDestinationUrl

STRING

adwordsDestinationUrl

The URLs to which your AdWords ads referred traffic

adwordsDisplayUrl

STRING

adwordsDisplayUrl

The URLs your AdWords ads displayed

adwordsKeyword

STRING

adwordsKeyword

The keyword of your AdWords ad

adwordsMatchedSearchQuery

STRING

adwordsMatchedSearchQuery

The search queries that triggered impressions of your AdWords ads

adwordsMatchType

STRING

adwordsMatchType

The match types applied to your keywords (Phrase, Exact, Broad, etc.). Ads on the content network are identified as "Content network". Note that the types are always returned in US English

adwordsPlacementDomain

STRING

adwordsPlacementDomain

The domains where your ads on the content network were placed

adwordsPlacementType

STRING

adwordsPlacementType

Placement type of your AdWords ad. Note that the types are always returned in US English

adwordsPlacementUrl

STRING

adwordsPlacementUrl

The URLs where your ads on the content network were placed

adwordsTargetingType

STRING

adwordsTargetingType

How your AdWords ads were targeted (keyword, placement, and vertical targeting, etc.). Note that the types are always returned in US English

nthDay

STRING

nthDay

Index for each day in the specified date range. Index for the first day (i.e., start-date) in the date range is 0, 1 for the second day, and so on

Metrics

Name

Type

Description

firstImpressionConversions

NUMBER

firstImpressionConversions

The number of conversions for which a DCM campaign impression was the first conversion interaction in a 30-day lookback window. This metric includes both goal completions and transactions

firstImpressionValue

NUMBER

firstImpressionValue

The value of conversions for which a DCM campaign impression was the first conversion interaction in a 30-day lookback window. This metric includes both goal completions and transactions

impressionAssistedConversions

NUMBER

impressionAssistedConversions

The number of conversions for which a DCM campaign impression appeared on the conversion path, but was not the final conversion interaction. This metric includes both goal completions and transactions

impressionAssistedValue

NUMBER

impressionAssistedValue

The value of conversions for which a DCM campaign impression appeared on the conversion path, but was not the final conversion interaction. This metric includes both goal completions and transactions

totalConversions

NUMBER

totalConversions

Total number of conversions. This metric includes both goal completions and transactions

totalConversionValue

NUMBER

totalConversionValue

Total value of conversions. This metric includes both goal completions and transactions

assistedConversions

NUMBER

assistedConversions

The number of conversions for which this channel appeared on the conversion path, but was not the final conversion interaction. This metric includes both goal completions and transactions

assistedValue

NUMBER

assistedValue

The value of conversions for which this channel appeared on the conversion path, but was not the final conversion interaction. This metric includes both goal completions and transactions

firstInteractionConversions

NUMBER

firstInteractionConversions

The number of conversions for which this channel was the first conversion interaction in a 30-day lookback window. This metric includes both goal completions and transactions

firstInteractionValue

NUMBER

firstInteractionValue

The value of conversions for which this channel was the first conversion interaction in a 30-day lookback window. This metric includes both goal completions and transactions

lastInteractionConversions

NUMBER

lastInteractionConversions

The number of conversions for which this channel was the final conversion interaction. This metric includes both goal completions and transactions

lastInteractionValue

NUMBER

lastInteractionValue

The value of conversions for which this channel was the final conversion interaction. This metric includes both goal completions and transactions

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.