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:
- Login to Google Analytics in your preferred browser.
- Expand the 'Audience' report on the left side of the screen.
- Choose 'User Explorer' option.
Client IDs will be displayed under column 'Client Id'. Use one of those values when building the query in the driver, e.g.:
SELECT * FROM UserActivity WHERE ClientId = '194067010.1581918826'
Note: Profile is also required for this table.
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. |