Google Analytics MCF
Vendor/Partner | |
|---|---|
Version | v3 |
API Documentation | |
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 |
|
Getting Started
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.
This will lead to a page to select your google account
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 |