TDV Adapter for Google Analytics

Build 21.0.8137

Tech

Retrieves Tech data.

Table Specific Information

Select

Retrieves data for Tech report. At least one metric must be specified in the query. The following are example queries:

	SELECT Conversions, EngagementRate, EventCount FROM Tech

Columns

Name Type Dimension DefaultMetric DefaultDimension Description
Date Date True The date of the session formatted as YYYYMMDD.
Year Integer True The year of the session. A four-digit year from 2005 to the current year.
Month Integer True The month of the session. An integer from 01 to 12.
Week Integer True The week of the session. A number from 01 to 53. Each week starts on Sunday.
Day Integer True The day of the month. A number from 01 to 31.
Hour Integer True An hour of the day ranging from 00-23 in the timezone configured for the account. This value is also corrected for daylight savings time.
AppVersion String True Version of the app.
Browser String True True Browser used to engage with the site.
DeviceCategory String True Type of device used to engage with the site/app: Desktop, Tablet, or Mobile.
DeviceModel String True Model of the device used to engage with the site/app.
OperatingSystem String True Operating systems used by visitors to the app or website.
OperatingSystemVersion String True Version of the operating systems used by visitors to the app or website.
OperatingSystemWithVersion String True Operating system name and version.
Platform String True Platform for the app or site (Android, iOS, Web).
ScreenResolution String True Resolution of the screen used to engage with the site/app.
Conversions Integer False True The count of conversion events.
EngagementRate Decimal False True The percentage of engaged sessions.
EngagedSessions Integer False True The number of sessions that lasted longer than 10 seconds, or had a conversion event, or had 2 or more screen views.
EventCount Integer False True The count of events.
NewUsers Integer False True The number of users who interacted with the site or launched the app for the first time.
TotalRevenue Integer False True The sum of revenue from purchases, subscriptions, and advertising.
TotalUsers Integer False True The total number of users.
StartDate String Start date for fetching Analytics data. Either a date string or a relative date (e.g., today, yesterday, or #daysAgo).
EndDate String End date for fetching Analytics data. Either a date string or a relative date (e.g., today, yesterday, or #daysAgo).
Dimensions String A comma-separated list of dimensions to retrieve in addition to the columns defined in the schema. Set to empty string to retrieve no dimensions.
Metrics String A comma-separated list of metrics to retrieve in addition to the columns defined in the schema.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PropertyId String Property ID value to be used when querying this table.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137