Acquia CDP

Google Analytics 4 - Data pulled from the API

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_source campaign tracking parameter. When using AdWords auto-tagging, the value is google. 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_medium campaign tracking parameter. When using AdWords auto-tagging, the value i ppc. 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, and document.referrer is empty, the value is (none). (source: Google Analytics).

  • Campaign: When using manual campaign tracking, this is the value of the utm_campaign campaign 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