MuleSoft Connector for Google Analytics

Build 20.0.7587

UserActivity

List information on a user's activity.

Table Specific Information

Select

This view requires column 'ClientID' to be specified in order to execute a query. Unfortunately, we don't expose a 'Clients' or 'Users' table (or equivalent) to display client IDs. This is an API limitation.

Because of this, the only way to retrieve a ClientID is by following the below steps:

  1. Login to Google Analytics in your preferred browser.
  2. Expand the 'Audience' report on the left side of the screen.
  3. Choose 'User Explorer' option.

Client IDs will be displayed under column 'Client Id'. Use one of those values when building the query in the connector, e.g.:

SELECT * FROM UserActivity WHERE ClientId = '194067010.1581918826' 

Columns

Name Type ReadOnly Description
ClientId String True

The Client ID or User ID associated with the user. This can be found in the 'User Explorer' section of Google Analytics' UI.

ActivityTime String True

Timestamp of the activity.

Source String True

The source of referrals. For manual campaign tracking, it is the value of the utm_source campaign tracking parameter. For AdWords autotagging, it is google. If you use neither, it is the domain of the source (e.g., document.referrer) referring the users. It may also contain a port address. If users arrived without a referrer, its value is (direct).

Medium String True

The type of referrals. For manual campaign tracking, it is the value of the utm_medium campaign tracking parameter. For AdWords autotagging, it is cpc. If users came from a search engine detected by Google Analytics, it is organic. If the referrer is not a search engine, it is referral. If users came directly to the property and document.referrer is empty, its value is (none).

ChannelGrouping String True

The Channel Group associated with an end user's session for this View (defined by the View's Channel Groupings).

Campaign String True

For manual campaign tracking, it is the value of the utm_campaign campaign tracking parameter. For AdWords autotagging, it is the name(s) of the online ad campaign(s) you use for the property. If you use neither, its value is (not set).

Keyword String True

For manual campaign tracking, it is the value of the utm_term campaign tracking parameter. For AdWords traffic, it contains the best matching targeting criteria. For the display network, where multiple targeting criteria could have caused the ad to show up, it returns the best matching targeting criteria as selected by Ads. This could be display_keyword, site placement, boomuserlist, user_interest, age, or gender. Otherwise its value is (not set).

Hostname String True

The hostname from which the tracking request was made.

LandingPagePath String True

The first page in users' sessions, or the landing page.

ActivityType String True

Type of this activity.

Event String True

This field contains all the details pertaining to an event and will be set if activityType equals EVENT.

PageView String True

This will be set if activityType equals PAGEVIEW. This field contains all the details about the visitor and the page that was visited.

AppView String True

This will be set if activityType equals SCREEN_VIEW.

Ecommerce String True

This will be set if activityType equals ECOMMERCE.

Goals String True

This will be set if activityType equals GOAL.

StartDate String True

Start date for fetching Analytics data. Either a date string or a relative date (e.g., today, yesterday, or #daysAgo).

EndDate String True

End date for fetching Analytics data. Either a date string or a relative date (e.g., today, yesterday, or #daysAgo).

SamplesReadCounts String True

Comma separated list of samples read counts when the response data is sampled.

SamplingSpaceSizes String True

Comma separated list of samples space sizes counts when the response data is sampled.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587