Universal Analytics predefined reports

The Google Analytics Universal API data source in Data Integration includes predefined reports. Each report contains a short description of the data, a list of customizable fields (if any), and the schema mapping.

Since these reports follow a standardized format, a few fields are locked, and you can only access them through the Custom Reports feature.

Prerequisite

To use Universal Analytics predefined reports in Data Integration, you must:

1. Choose Predefined Reports as your River mode.
2. Select the API version as Universal Analytics.
3. Choose your Accounts.
4. Select your Properties.
5. Select your Profiles/ Views.

Standard sessions

The Standard sessions report produces a session-based metrics table at the ad content and source/medium levels. You can use the filter option to cut down the output and customize the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
date	Integer	Dimension
account_id	Integer	Dimension
keyword	String	Dimension
avgsessionduration	Float	Metric
bounceRate	Float	Metric
bounces	Integer	Metric
campaign	String	Dimension
channelgrouping	String	Dimension
adcontent	String	Dimension
account_name	String	Dimension
medium	String	Dimension
newusers	Integer	Metric
pageviews	Integer	Metric
percentnewsessions	Float	Metric
sessionduration	Float	Metric
sessions	Integer	Metric
source	String	Dimension
transactions	Integer	Metric
users	Integer	Metric

Standard events

The Standard events report produces an events-based metrics table at the event, ad content, and source/medium level. You can only customize the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
date	Integer	Dimension
property_id	String	Dimension
account_id	Integer	Dimension
eventlabel	String	Dimension
campaign	String	Dimension
adwordsCampaignID	String	Dimension
eventaction	String	Dimension
adcontent	String	Dimension
eventsPerSessionWithEvent	Float	Metric
keyword	String	Dimension
account_name	String	Dimension
sessionswithevent	Integer	Metric
sourcemedium	String	Dimension
totalevents	Integer	Metric
uniqueevents	Integer	Metric

Standard users

The Standard users report produces a user-based metrics table at the user type level. You can only customize the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
account_id	Integer	Dimension
date	Integer	Dimension
account_name	String	Dimension
deviceCategory	String	Dimension
newUsers	Integer	Metric
referralPath	String	Dimension
region	String	Dimension
userType	String	Dimension
useragebracket	String	Dimension
usergender	String	Dimension
users	Integer	Metric

Standard weekly users

The Standard Users report produces a user-based metrics table aggregated weekly at the user type level. You can only customize the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
account_id	Integer	Dimension
yearWeek	Integer	Dimension
account_name	String	Dimension
deviceCategory	String	Dimension
newUsers	Integer	Metric
region	String	Dimension
userAgeBracket	String	Dimension
userGender	String	Dimension
userType	String	Dimension
users	Integer	Metric
referralPath	String	Dimension

Standard monthly users

The Standard Users report produces a user-based metrics table at the user type level, aggregated monthly. You can only customize the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
account_id	Integer	Dimension
yearMonth	Integer	Dimension
account_name	String	Dimension
deviceCategory	String	Dimension
newUsers	Integer	Metric
region	String	Dimension
userAgeBracket	String	Dimension
userGender	String	Dimension
userType	String	Dimension
users	Integer	Metric
referralPath	String	Dimension

Cohort by 7 days

The Cohort by 7 days report produces a cohort-based metrics table at the profile level, aggregated over the last 7 days. You can only customize the report filter option to cut down the output.

Field	Data Type	Dimension/Metric
account_id	Integer	Dimension
cohort	String	Dimension
property_id	String	Dimension
profile_id	Integer	Dimension
goalCompletionsAll	Integer	Metric
cohortRetentionRate	Float	Metric
cohortTotalUsers	Integer	Metric
cohortNthDay	Integer	Metric
pageviews	Integer	Metric
cohortGoalCompletionsPerUser	Float	Metric
cohortActiveUsers	Integer	Metric
sessionDuration	Float	Metric
sessions	Integer	Metric
transactionRevenue	Float	Metric
transactions	Integer	Metric

Mcf conversion path

The Multi-Channel Funnels Conversion Path report shows all the unique conversion paths that led to conversions, the number of conversions from each path, and the value of those conversions. You can use the filter option to cut down the output and customize the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
conversionDate	Integer	Dimension
conversionType	String	Dimension
profile_id	Integer	Dimension
timeLagInDaysHistogram	Integer	Dimension
totalConversionValue	Float	Metric
totalConversions	Integer	Metric

Mcf time lag

The Multi-Channel Funnels Time Lag report counts the days from the first ad impression to conversion. You can use the filter option to cut down the output and customize the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
campaignName	String	Dimension
conversionDate	Integer	Dimension
profile_id	Integer	Dimension
timeLagInDaysHistogram	Integer	Dimension
totalConversionValue	Float	Metric
totalConversions	Integer	Metric

Mcf assisted conversions

The Multi-Channel Funnels Assisted Conversions report summarizes the channels' roles and contributions. You can use the filter option to cut down the output and customize the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
medium	String	Dimension
source	String	Dimension
basicChannelGrouping	String	Dimension
campaignName	String	Dimension
conversionDate	Integer	Dimension
conversionGoalNumber	String	Dimension
conversionType	String	Dimension
profile_id	Integer	Dimension
assistedConversions	Integer	Metric
lastInteractionConversions	Integer	Metric
lastInteractionValue	Float	Metric
firstInteractionValue	Float	Metric
firstInteractionConversions	Integer	Metric
assistedValue	Float	Metric
totalConversionValue	Float	Metric
totalConversions	Integer	Metric

Mcf path length

The Multi-Channel Funnels Path Length report shows the number of conversions that resulted from conversion paths that contained 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, or 12+ channel interactions. You can use the filter option to reduce the output and customize the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
campaignName	String	Dimension
conversionDate	Integer	Dimension
pathLengthInInteractionsHistogram	Integer	Dimension
profile_id	Integer	Dimension
totalConversionValue	Float	Metric
totalConversions	Integer	Metric