What data does Customer Data Platform (CDP) pull from Google Analytics 4?
Google Analytics API-based connectors provide access to the Last-touch Revenue-Attribution feed. For information about the logic used by Google Analytics for revenue attribution, see this document.
To obtain the report, CDP pulls the following data from Google Analytics:
Dimensions
- Date: The date of the event.
Source: The source of referrals to your property.
When using manual campaign tracking, this is the value of the
utm_sourcecampaign tracking parameter. When using AdWords auto-tagging, the value isgoogle. Otherwise, the domain of the source refers to the visitor to your property. For example, document.referrer. The value may also contain a port address. If the visitor arrived without a referrer, the value is (direct). (source: Google Analytics).Medium: The type of referrals to your property.
When using manual campaign tracking, this is the value of the
utm_mediumcampaign tracking parameter. When using AdWords auto-tagging, the value ippc. 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 visitor came directly to the property, anddocument.referreris empty, the value is (none). (source: Google Analytics).Campaign: When using manual campaign tracking, this is the value of the
utm_campaigncampaign tracking parameter.When using AdWords auto-tagging, the name(s) of the online ad campaign that you use for your property. Otherwise, the value (not set) is used. (source: Google Analytics).
- AdWords AdGroup: The name of your AdWords ad group.
- TransactionId: The transaction ID for the shopping cart purchase as supplied by your e-commerce tracking method. (source: Google Analytics).
Metrics
- Purchase Revenue : This is not leveraged in any parts of the CDP applications. CDP relies on the more accurate revenue received from either your daily data feeds or CDP’s WebTag. CDP pulls this information to generate a report that helps CDP to extract the rest of the information from the Google Analytics API.
Mapping
The following tables lists the mapping of Google Analytics API data with the corresponding CDP entity. The Source column represents the Google Analytics API fields. The Destination column represents the fields in CDP entities. These tables represent the data coming to CDP from Google Analytics API.
Destination entity: promotion
| Source | Destination |
|---|---|
| sessionCampaignName | SourcePromotionNumber |
| sessionCampaignName | Name |
Destination entity: promotioncampaignxref
| Source | Destination |
|---|---|
| sessionCampaignName | SourcePromotionNumber |
| sessionCampaignName | SourceCampaignNumber |
Destination entity: campaign
| Source | Destination |
|---|---|
| sessionCampaignName | SourceCampaignNumber |
| sessionCampaignName | Name |
Destination entity: dispatch
| Source | Destination |
|---|---|
| sessionCampaignName | SourceCampaignNumber |
| sessionCampaignName | SourceDispatchNumber:campaign |
| sessionMedium | SourceDispatchNumber:medium |
| sessionSource | SourceDispatchNumber:source |
| sessionCampaignName | Name |
| sessionMedium | Type |
| sessionSource | SubType |
Destination entity: message
| Source | Destination |
|---|---|
| sessionCampaignName | SourceMessageNumber:campaign |
| sessionGoogleAdsAdGroupName | SourceMessageNumber:adGroup |
| sessionMedium | SourceMessageNumber:medium |
| sessionSource | SourceMessageNumber:source |
| sessionCampaignName | SourceDispatchNumber:campaign |
| sessionMedium | SourceDispatchNumber:medium |
| sessionSource | SourceDispatchNumber:source |
| sessionCampaignName | Name |
| sessionGoogleAdsAdGroupName | Content |
Destination entity: transactionmessagexref
| Source | Destination |
|---|---|
| sessionCampaignName | SourceMessageNumber:campaign |
| sessionGoogleAdsAdGroupName | SourceMessageNumber:adGroup |
| sessionMedium | SourceMessageNumber:medium |
| sessionSource | SourceMessageNumber:source |
| type | Type |
| transactionId | SourceTransactionNumber |