Universal Analytics Predefined Reports
  • 4 Minutes to read
  • Dark
    Light
  • PDF

Universal Analytics Predefined Reports

  • Dark
    Light
  • PDF

Article summary

Predefined Reports

The Google Analytics Universal API datasource in Rivery comes with the below predefined reports. Each report will have a short description of the data, a list of customizable fields (if any), and the schema mapping. Due to the standardized nature of these reports, there are a number of locked fields that will only be accessible through the custom reporting functionality.

Prerequisite

To use Universal Analytics Predefined Reports in Rivery, you must initially adhere to the following instructions:

  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. Pick your "Profiles/ Views".

image.png

Standard Sessions

The Standard Sessions report produces a session based metrics table at the ad content and source/medium level. There are two customizations the user can make to this report. They can use the filter option to cut down the output and can customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
date system schemaIntegerDimension
account_id system schemaIntegerDimension
keywordStringDimension
avgsessiondurationFloatMetric
bounceRateFloatMetric
bouncesIntegerMetric
campaignStringDimension
channelgroupingStringDimension
adcontentStringDimension
account_nameStringDimension
mediumStringDimension
newusersIntegerMetric
pageviewsIntegerMetric
percentnewsessionsFloatMetric
sessiondurationFloatMetric
sessionsIntegerMetric
sourceStringDimension
transactionsIntegerMetric
usersIntegerMetric

Standard Events

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

FieldData TypeDimension/Metric
date system schemaIntegerDimension
property_id system schemaStringDimension
account_id system schemaIntegerDimension
eventlabelStringDimension
campaignStringDimension
adwordsCampaignIDStringDimension
eventactionStringDimension
adcontentStringDimension
eventsPerSessionWithEventFloatMetric
keywordStringDimension
account_nameStringDimension
sessionswitheventIntegerMetric
sourcemediumStringDimension
totaleventsIntegerMetric
uniqueeventsIntegerMetric

Standard Users

The Standard Users report produces a user based metrics table at the user type level. The only customization is the type of incremental load associated with this report.

FieldData TypeDimension/Metric
account_id system schemaIntegerDimension
date system schemaIntegerDimension
account_nameStringDimension
deviceCategoryStringDimension
newUsersIntegerMetric
referralPathStringDimension
regionStringDimension
userTypeStringDimension
useragebracketStringDimension
usergenderStringDimension
usersIntegerMetric

Standard Weekly Users

The Standard Users report produces a user based metrics table at the user type level aggregated over a weekly time period. The only customization is the type of incremental load associated with this report.

FieldData TypeDimension/Metric
account_id system schemaIntegerDimension
yearWeek system schemaIntegerDimension
account_nameStringDimension
deviceCategoryStringDimension
newUsersIntegerMetric
regionStringDimension
userAgeBracketStringDimension
userGenderStringDimension
userTypeStringDimension
usersIntegerMetric
referralPathStringDimension

Standard Monthly Users

The Standard Users report produces a user based metrics table at the user type level aggregated over a monthly time period. The only customization is the type of incremental load associated with this report.

FieldData TypeDimension/Metric
account_id system schemaIntegerDimension
yearMonth system schemaIntegerDimension
account_nameStringDimension
deviceCategoryStringDimension
newUsersIntegerMetric
regionStringDimension
userAgeBracketStringDimension
userGenderStringDimension
userTypeStringDimension
usersIntegerMetric
referralPathStringDimension

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. The user can only customize the report's filter option to cut down the output.

FieldData TypeDimension/Metric
account_id system schemaIntegerDimension
cohort system schemaStringDimension
property_id system schemaStringDimension
profile_id system schemaIntegerDimension
goalCompletionsAllIntegerMetric
cohortRetentionRateFloatMetric
cohortTotalUsersIntegerMetric
cohortNthDayIntegerMetric
pageviewsIntegerMetric
cohortGoalCompletionsPerUserFloatMetric
cohortActiveUsersIntegerMetric
sessionDurationFloatMetric
sessionsIntegerMetric
transactionRevenueFloatMetric
transactionsIntegerMetric

Mcf Conversion Path

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

FieldData TypeDimension/Metric
conversionDate system schemaIntegerDimension
conversionType system schemaStringDimension
profile_id system schemaIntegerDimension
timeLagInDaysHistogram system schemaIntegerDimension
totalConversionValueFloatMetric
totalConversionsIntegerMetric

Mcf Time Lag

The Multi-Channel Funnels Time Lag report counts the number of days from the first ad impression to conversion. There are two customizations the user can make to this report. They can use the filter option to cut down the output and can customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
campaignName system schemaStringDimension
conversionDate system schemaIntegerDimension
profile_id system schemaIntegerDimension
timeLagInDaysHistogram system schemaIntegerDimension
totalConversionValueFloatMetric
totalConversionsIntegerMetric

Mcf Assisted Conversions

The Multi-Channel Funnels Assisted Conversions report summarizes the channels' roles and contributions. There are two customizations the user can make to this report. They can use the filter option to cut down the output and can customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
medium system schemaStringDimension
source system schemaStringDimension
basicChannelGrouping system schemaStringDimension
campaignName system schemaStringDimension
conversionDate system schemaIntegerDimension
conversionGoalNumber system schemaStringDimension
conversionType system schemaStringDimension
profile_id system schemaIntegerDimension
assistedConversionsIntegerMetric
lastInteractionConversionsIntegerMetric
lastInteractionValueFloatMetric
firstInteractionValueFloatMetric
firstInteractionConversionsIntegerMetric
assistedValueFloatMetric
totalConversionValueFloatMetric
totalConversionsIntegerMetric

Mcf Path Length

The Multi-Channel Funnels Path Length report shows how many conversions resulted from conversion paths that contained 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, or 12+ channel interactions. There are two customizations the user can make to this report. They can use the filter option to cut down the output and can customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
campaignName system schemaStringDimension
conversionDate system schemaIntegerDimension
pathLengthInInteractionsHistogram system schemaIntegerDimension
profile_id system schemaIntegerDimension
totalConversionValueFloatMetric
totalConversionsIntegerMetric

Was this article helpful?