Adding a Connection to Google Analytics

To add a connection to Google Analytics:

1. In the application console, navigate to the Connections page.
2. At the Add Connections panel, select the icon for the connection you want to add.
3. If the Google Analytics icon is not available, click the Add More icon to download and install the Google Analytics connector from the CData site.

For required properties, see the Settings tab.

For connection properties that are not typically required, see the Advanced tab.

Connecting to Google Analytics

Google Analytics 4

Provide the following connection properties before adding the authentication properties.

• Schema: Set this to GoogleAnalytics4.
• PropertyId: Set this to the Google Analytics profile or view you want to connect to. This value can be retrieved from the Properties table. If this is not specified, the first Profile returned will be used.

Authenticating to Google Analytics

The Sync App supports using user accounts and GCP instance accounts for authentication.

The following sections discuss the available authentication schemes for Google Analytics:

• User Accounts (OAuth)
• Service Account (OAuthJWT)
• GCP Instance Account

User Accounts (OAuth)

AuthScheme must be set to OAuth in all user account flows.

Web Applications

When connecting via a Web application, you need to create and register a custom OAuth application with Google Analytics. You can then use the Sync App to acquire and manage the OAuth token values. See Creating a Custom OAuth App for more information about custom applications.

Get an OAuth Access Token

Set the following connection properties to obtain the OAuthAccessToken:

• OAuthClientId: Set this to the Client Id in your application settings.
• OAuthClientSecret: Set this to the Client Secret in your application settings.

Then call stored procedures to complete the OAuth exchange:

1. Call the GetOAuthAuthorizationURL stored procedure. Set the CallbackURL input to the Callback URL you specified in your application settings. The stored procedure returns the URL to the OAuth endpoint.
2. Navigate to the URL that the stored procedure returned in Step 1. Log in to the custom OAuth application and authorize the web application. Once authenticated, the browser redirects you to the callback URL.
3. Call the GetOAuthAccessToken stored procedure. Set AuthMode to WEB and the Verifier input to the "code" parameter in the query string of the callback URL.

Once you have obtained the access and refresh tokens, you can connect to data and refresh the OAuth access token either automatically or manually.

Automatic Refresh of the OAuth Access Token

To have the driver automatically refresh the OAuth access token, set the following on the first data connection:

• InitiateOAuth: Set this to REFRESH.
• OAuthClientId: Set this to the Client Id in your application settings.
• OAuthClientSecret: Set this to the Client Secret in your application settings.
• OAuthAccessToken: Set this to the access token returned by GetOAuthAccessToken.
• OAuthRefreshToken: Set this to the refresh token returned by GetOAuthAccessToken.
• OAuthSettingsLocation: Set this to the location where the Sync App saves the OAuth token values, which persist across connections.

On subsequent data connections, the values for OAuthAccessToken and OAuthRefreshToken are taken from OAuthSettingsLocation.

Manual Refresh of the OAuth Access Token

The only value needed to manually refresh the OAuth access token when connecting to data is the OAuth refresh token.

Use the RefreshOAuthAccessToken stored procedure to manually refresh the OAuthAccessToken after the ExpiresIn parameter value returned by GetOAuthAccessToken has elapsed, then set the following connection properties:

• OAuthClientId: Set this to the Client Id in your application settings.
• OAuthClientSecret: Set this to the Client Secret in your application settings.

Then call RefreshOAuthAccessToken with OAuthRefreshToken set to the OAuth refresh token returned by GetOAuthAccessToken. After the new tokens have been retrieved, open a new connection by setting the OAuthAccessToken property to the value returned by RefreshOAuthAccessToken.

Finally, store the OAuth refresh token so that you can use it to manually refresh the OAuth access token after it has expired.

Headless Machines

To configure the driver to use OAuth with a user account on a headless machine, you need to authenticate on another device that has an internet browser.

1. Choose one of two options:
   • Option 1: Obtain the OAuthVerifier value as described in "Obtain and Exchange a Verifier Code" below.
   • Option 2: Install the Sync App on a machine with an internet browser and transfer the OAuth authentication values after you authenticate through the usual browser-based flow, as described in "Transfer OAuth Settings" below.
2. Then configure the Sync App to automatically refresh the access token on the headless machine.

Option 1: Obtain and Exchange a Verifier Code

To obtain a verifier code, you must authenticate at the OAuth authorization URL.

Follow the steps below to authenticate from the machine with an internet browser and obtain the OAuthVerifier connection property.

1. Choose one of these options:
   • If you are using the Embedded OAuth Application click Google Analytics OAuth endpoint to open the endpoint in your browser.
   • If you are using a custom OAuth application, create the Authorization URL by setting the following properties:
     • InitiateOAuth: Set to OFF.
     • OAuthClientId: Set to the client Id assigned when you registered your application.
     • OAuthClientSecret: Set to the client secret assigned when you registered your application.
     Then call the GetOAuthAuthorizationURL stored procedure with the appropriate CallbackURL. Open the URL returned by the stored procedure in a browser.
2. Log in and grant permissions to the Sync App. You are then redirected to the callback URL, which contains the verifier code.
3. Save the value of the verifier code. Later you will set this in the OAuthVerifier connection property.

Next, you need to exchange the OAuth verifier code for OAuth refresh and access tokens. Set the following properties:

On the headless machine, set the following connection properties to obtain the OAuth authentication values:

• InitiateOAuth: Set this to REFRESH.
• OAuthVerifier: Set this to the verifier code.
• OAuthClientId: (custom applications only) Set this to the Client Id in your custom OAuth application settings.
• OAuthClientSecret: (custom applications only) Set this to the Client Secret in the custom OAuth application settings.
• OAuthSettingsLocation: Set this to persist the encrypted OAuth authentication values to the specified location.

After the OAuth settings file is generated, you need to re-set the following properties to connect:

• InitiateOAuth: Set this to REFRESH.
• OAuthClientId: (custom applications only) Set this to the client Id assigned when you registered your application.
• OAuthClientSecret: (custom applications only) Set this to the client secret assigned when you registered your application.
• OAuthSettingsLocation: Set this to the location containing the encrypted OAuth authentication values. Make sure this location gives read and write permissions to the Sync App to enable the automatic refreshing of the access token.

Option 2: Transfer OAuth Settings

Prior to connecting on a headless machine, you need to create and install a connection with the driver on a device that supports an internet browser. Set the connection properties as described in "Desktop Applications" above.

After completing the instructions in "Desktop Applications", the resulting authentication values are encrypted and written to the location specified by OAuthSettingsLocation. The default filename is OAuthSettings.txt.

Once you have successfully tested the connection, copy the OAuth settings file to your headless machine.

On the headless machine, set the following connection properties to connect to data:

• InitiateOAuth: Set this to REFRESH.
• OAuthClientId: (custom applications only) Set this to the client Id assigned when you registered your application.
• OAuthClientSecret: (custom applications only) Set this to the client secret assigned when you registered your application.
• OAuthSettingsLocation: Set this to the location of your OAuth settings file. Make sure this location gives read and write permissions to the Sync App to enable the automatic refreshing of the access token.

GCP Instance Accounts

When running on a GCP virtual machine, the Sync App can authenticate using a service account tied to the virtual machine. To use this mode, set AuthScheme to GCPInstanceAccount.

Required Scopes and Endpoint Domains for Google Analytics

When integrating with Google Analytics, your application needs specific permissions to interact with the API.

These permissions are defined by access scopes, which determine what data your application can access and what actions it can perform.

This topic provides information about the required access scopes and endpoint domains for the Google Analytics Sync App.

Understanding Scopes

Scopes are a way to limit an application's access to a user's data. They define the specific actions that an application can perform on behalf of the user.

For example, a read-only scope might allow an application to view data, while a full access scope might allow it to modify data.

Required Scopes for Google Analytics

Scope	Description
googleapis.com/auth/analytics.readonly	Read-only access to the Google Analytics API. Accepted values are NONE, CONSENT, and the default SELECT ACCOUNT.

Understanding Endpoint Domains

Endpoint domains are the specific URLs that the application needs to communicate with in order to authenticate, retrieve records, and perform other essential operations.

Allowlisting these domains ensures that the network traffic between your application and the API is not blocked by firewalls or security settings.

Note: Most users do not need to make any special configurations. Allowlisting is typically only necessary for environments with strict security measures, such as restricted outbound network traffic.

Required Endpoint Domains for Google Analytics

Domain	Always Required	Description
accounts.google.com	TRUE	The domain used for OAuth.
analyticsadmin.googleapis.com	FALSE	This domain is required if Schema=GoogleAnalytics4, which is the default.

Google Analytics data is organized into various metrics (Sessions, Impressions, AdClicks, etc.), which can be queried over various dimensions (Country, Month, etc.). There are many valid combinations of metrics and dimensions. The Sync App surfaces some of the most commonly used combinations as tables for ease of use.

Additionally, the Sync App allows you to query all valid combinations, even those not included in the predefined tables, using two methods: by using the Dimensions and Metrics columns and by defining custom schemas. Refer to Advanced Queries for more information. Below is a guide to getting started with the default tables.

Selecting Dimensions and Measures

The dimensions and metrics are clearly defined for each table and can be seen in the Data Model: Simply select the metrics and dimensions you are interested in. For example, to find the number of sessions in each month, query the Session metric over the Month dimension. This would return 12 rows: one for each month.

SELECT Sessions, Month FROM Traffic 

To separate out the months in each year, include both the month and the year dimensions in the query:

SELECT Sessions, Month, Year FROM Traffic 

Date Ranges

All Google Analytics reports cover a specific date range. The default behavior is to pull the last month of data if the StartDate and EndDate inputs are left unset. To override this behavior, the values can be set directly in the query. For example:

SELECT Sessions, Month, Year FROM Traffic WHERE StartDate = '90daysAgo' AND EndDate = 'Today'

The supported inputs for StartDate and EndDate in the Google Analytics API are 'today', 'yesterday', 'NdaysAgo' (where N is some number), and an exact date. Starting with the v4 API, up to two separate date ranges can be set in the filter.

SELECT * Query

Unlike most database tables, it is not very helpful to select all metrics and dimensions in a given table.

In some cases, it is not possible to do this since Google Analytics allows a maximum of nine dimensions and 10 metrics in a single query.

The Sync App interprets the SELECT * query as a request for a default set of metrics and dimensions.

This includes queries that explicitly select all columns. For schemas with fewer than 10 metrics, all metrics are returned.

Refer to the individual view's documentation in Data Model to see which fields are the default for each schema.

Google Analytics has a very large number of metrics and dimensions that would clutter table definitions, so the table definitions included with the product only list the most commonly used combinations. We offer two alternatives to this design choice: You can use the Dimensions and Metrics columns to request fields that are not in the default table, or you can define your own table.

Using the Dimensions and Metrics Columns

To request additional dimensions or metrics for any existing table, the recommended approach is to define custom schemas; however, you can also set the Dimensions and Metrics inputs in the WHERE clause. Both inputs take a comma-separated list so that you can specify multiple fields at once. The values will be returned in the corresponding Dimensions and Metrics column in the same order that you submitted them. For example, the following query will query the Traffic table for Sessions, the Goal 1 Conversion Rate, and Goal 1 Completions and group these metrics together by the User Age Bracket dimension:

SELECT Sessions, Dimensions, Metrics FROM Traffic WHERE Dimensions='UserAgeBracket' AND Metrics='Goal1ConversionRate,Goal1Completions'

In the results from the query above, the value for UserAgeBracket will be returned in the Dimensions field for each row. The Metrics field will contain a comma-separated value containing the requested metrics for Goal 1.

This section details a selection of advanced features of the Google Analytics Sync App.

User Defined Views

The Sync App supports the use of user defined views, virtual tables whose contents are decided by a pre-configured user defined query. These views are useful when you cannot directly control queries being issued to the drivers. For an overview of creating and configuring custom views, see User Defined Views .

SSL Configuration

Use SSL Configuration to adjust how Sync App handles TLS/SSL certificate negotiations. You can choose from various certificate formats;. For further information, see the SSLServerCert property under "Connection String Options" .

Firewall and Proxy

Configure the Sync App for compliance with Firewall and Proxy, including Windows proxies and HTTP proxies. You can also set up tunnel connections.

Query Processing

The Sync App offloads as much of the SELECT statement processing as possible to Google Analytics and then processes the rest of the query in memory (client-side).

For further information, see Query Processing.

Logging

For an overview of configuration settings that can be used to refine CData logging, see Logging. Only two connection properties are required for basic logging, but there are numerous features that support more refined logging, which enables you to use the LogModules connection property to specify subsets of information to be logged.

Customizing the SSL Configuration

By default, the Sync App attempts to negotiate TLS with the server. The server certificate is validated against the default system trusted certificate store. You can override how the certificate gets validated using the SSLServerCert connection property.

To specify another certificate, see the SSLServerCert connection property.

Connecting Through a Firewall or Proxy

HTTP Proxies

To authenticate to an HTTP proxy, set the following:

• ProxyServer: the hostname or IP address of the proxy server that you want to route HTTP traffic through.
• ProxyPort: the TCP port that the proxy server is running on.
• ProxyAuthScheme: the authentication method the Sync App uses when authenticating to the proxy server.
• ProxyUser: the username of a user account registered with the proxy server.
• ProxyPassword: the password associated with the ProxyUser.

Other Proxies

Set the following properties:

• To use a proxy-based firewall, set FirewallType, FirewallServer, and FirewallPort.
• To tunnel the connection, set FirewallType to TUNNEL.
• To authenticate, specify FirewallUser and FirewallPassword.
• To authenticate to a SOCKS proxy, additionally set FirewallType to SOCKS5.

The CData Sync App models Google Analytics entities in relational Tables, Views, and Stored Procedures. The provided tables will give you an overview of your account information and the profiles available for Google Analytics queries. Google Analytics allows for Dimensions and Metrics to be queried in a large number of arrangements. Some sample views are provided based on common Google Analytics reports. You can, however, also create your own custom views based on any combination of Dimensions and Metrics you need.

API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.

Create Additional Schemas

The CreateCustomSchema stored procedure can be used to easily generate new schema files with a custom combination of Dimensions and Metrics. This procedure takes the TableName and a comma-separated lists of Dimensions and Metrics and builds a schema file that can be read by the Sync App. Each Dimension or Metric in the list takes the name of the value from Google Analytics (without the 'ga:' prefix). For example:

Dimensions=UserType,SessionCount

Metrics=Users,PercentNewSessions

If the Location connection property is set, the file will be output to that folder. Otherwise, the OutputFolder input can be used to specify an output folder. To begin querying these new files, simply set the Location connection property to the folder containing these new schema files.

Using Google Analytics 4 API

See GoogleAnalytics4 Data Model for the available entities in the Google Analytics 4 API.

The CData Sync App models the Google Analytics 4 API as relational tables, views, and stored procedures. The provided tables give you an overview of your account information and the profiles available for Google Analytics queries. Google Analytics supports the querying of dimensions and metrics in various arrangements. Some sample views are provided based on common Google Analytics reports.

You can also create your own custom views based on any combination of Dimensions and Metrics you need. API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations. However, there is a strict limit of nine dimensions and 10 metrics per query, unless otherwise stated in the specific table or view pages.

Views

Views are tables that cannot be modified, such as Accounts, Properties, Events, Acquisitions, and Engagement. Typically, data that is read-only and cannot be updated are shown as views. Two types of views are made available:

• Base Views are statically defined to model Engagements, Acquisitions, Active Users, and more. You can use base views to create your custom reports. By default, these views return data from all time aggregated into a single row. All base views are subsets of GlobalAccessObject, a view that contains all data for all available dimensions and metrics.
• Predefined Report Views are a set of standard reports that mimic exactly what you see in the Google Analytics UI. All Predefined Report Views have "report" appended to their name. By default, these views return data from all time with a daily breakdown.

Date Ranges and Aggregation

Date Ranges You can specify date ranges in the WHERE clause using the "Date" field with these operators: =, <,>

Additional predefined date fields are available:

• week
• month
• quarter

When filtering on these time intervals, you can use the = operator, specifying the date of first day of the time period. If you specify a different date, an error is returned. For example, to specify the month of May in the year 2022, use the following, specifying the first day of that month:

month = '2022-05-01' 

NOTE: The default time interval for views is 30 days.

Aggregation

Aggregation is the process of reducing and summarizing data. You can apply aggregation at multiple levels:

The following examples show the syntax of aggregation queries:

SELECT Date,NewUsers, TotalUsers From Tech where StartDate = '2022-01-01' and EndDate = '2023-05-18'

SELECT Hour,NewUsers, TotalUsers From Tech where StartDate = '2022-01-01' and EndDate = '2023-05-18'

SELECT Day,NewUsers, TotalUsers From Tech where StartDate = '2022-01-01' and EndDate = '2023-05-18'

SELECT Week,NewUsers, TotalUsers From Tech where StartDate = '2022-01-01' and EndDate = '2023-05-18'

SELECT Month,NewUsers, TotalUsers From Tech where StartDate = '2022-01-01' and EndDate = '2023-05-18'

SELECT Year,NewUsers, TotalUsers From Tech where StartDate = '2022-01-01' and EndDate = '2023-05-18' 

Some comments about the aggregation code examples:

• Date: returns daily data in the query results.
• Hour: returns data aggregated by hour across the specified date range. For example, querying two years worth of data and selecting "Hour" returns 24 rows of data (one for each hour) with two years data aggregated for each hour.
• Day: returns data aggregated by day across the specified date range. For example, querying two years worth of data and selecting "Day" returns seven rows of data (one for each day) with two years data aggregated for each day
• Week: returns data aggregated by week across the specified date range. For example, querying two years worth of data and selecting "Week" returns 104 rows of data (one for each week) with data aggregated for each week
• Month: returns data aggregated by month across the specified date range. For example, querying two years worth of data and selecting "Month" returns 24 rows of data (one for each month) with data aggregated for each month.
• Year: returns data aggregated by year across the specified date range. For example, querying two years worth of data and selecting "Year" returns two rows of data (one for each year) with data aggregated by year.

NOTE: choosing "Date" as a metric overrides any other date metric you select. Only daily data is returned.

Stored Procedures

Stored Procedures are function-like interfaces to the data source. You can use these to search, update, and modify information in the data source.

Server Side Filtering

Fully qualified queries support both the OR and AND operators used together. The OR operator can only be used with the same columns if it is combined with the AND operator for filtering dimensions or metrics. If the OR operator is used with different columns in combination with the AND operator, it may produce unexpected results. For example, the following query may give unexpected results:

 SELECT * FROM [Acquisitions] WHERE [StartDate] = '2023-03-22' AND [EndDate] = '2023-03-22' AND [PagePath] LIKE '%as' OR [Country] LIKE 'US' 

Given below are a few valid queries:

 SELECT * FROM [Acquisitions] WHERE [StartDate] = '2023-03-22' AND [EndDate] = '2023-03-22' AND ([Country] LIKE 'US' OR [Country] LIKE '%In') 

 SELECT * FROM [Acquisitions] WHERE [StartDate] = '2023-03-22' AND [EndDate] = '2023-03-22' OR [PagePath] LIKE '%as' 

 SELECT * FROM [Acquisitions] WHERE [PagePath] LIKE '%as' OR  [PagePath] LIKE 'A' OR [Country] LIKE '%In' 

 SELECT * FROM [Acquisitions] WHERE [PagePath] LIKE '%as' AND [Country] LIKE '%In' 

 SELECT * FROM [Acquisitions] WHERE [PagePath] LIKE '%as' AND ([Country] LIKE 'India' OR [Country] LIKE '%US') 

 SELECT * FROM [Tech] WHERE [StartDate] = '2021-01-01' AND [EndDate] = '2021-05-18' AND [NewUsers] >= 26 AND [NewUsers] < 35 AND ([Browser] IN ('Chrome', 'Edge') OR [Browser] = 'Edge') 

 SELECT * FROM [TechDeviceModelReport] WHERE [Date] >= '2020-05-13' AND [Date] <= '2023-06-13' AND [DeviceModel] != '(not set)' AND [DeviceModel] != '(test)' AND ([NewUsers] = 15 OR [NewUsers] = 20) 

 SELECT * FROM [Tech] WHERE [StartDate] = '2017-01-01' AND [EndDate] = '2023-05-02' AND CONTAINS ([Browser], 'ed') OR CONTAINS ([Browser], 'ch') 

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

Google Analytics Connector for CData Sync Views

Name	Description
Accounts	Lists all Accounts to which the user has access.
AccountSummaries	Lists summaries of all Accounts to which the user has access.
Acquisitions	A base view that retrieves Acquisitions data.
AcquisitionsFirstUserCampaignReport	A predefined view that retrieves Acquisitions first user Campaign data.
AcquisitionsFirstUserGoogleAdsAdGroupNameReport	A predefined view that retrieves user Acquisitions first user google ads ad group name data.
AcquisitionsFirstUserGoogleAdsNetworkTypeReport	A predefined view that retrieves Acquisitions first user google ads ad network type platform data.
AcquisitionsFirstUserMediumReport	A predefined view that retrieves Acquisitions first user medium data.
AcquisitionsFirstUserSourceMediumReport	A predefined view that retrieves Acquisitions first user source medium data.
AcquisitionsFirstUserSourcePlatformReport	A predefined view that retrieves Acquisitions first user source platform data.
AcquisitionsFirstUserSourceReport	A predefined view that retrieves Acquisitions first user source data.
AcquisitionsSessionCampaignReport	A predefined view that retrieves Acquisitions session campaign report data.
AcquisitionsSessionDefaultChannelGroupingReport	A predefined view that retrieves Acquisitions session default channel grouping report data.
AcquisitionsSessionMediumReport	A predefined view that retrieves Acquisitions session medium report data.
AcquisitionsSessionSourceMediumReport	A predefined view that retrieves Acquisitions session source medium report data.
AcquisitionsSessionSourcePlatformReport	A predefined view that retrieves Acquisitions session source platform report data.
AcquisitionsSessionSourceReport	A predefined view that retrieves Acquisitions session source report data.
ActiveUsers	A base view that retrieves Active Users data.
DemographicAgeReport	A predefined view that retrieves Demographics UserAgeBracket data.
DemographicCityReport	A predefined view that retrieves Demographics City data.
DemographicCountryReport	A predefined view that retrieves Demographics Country data.
DemographicGenderReport	A predefined view that retrieves Demographics UserGender data.
DemographicInterestsReport	A predefined view that retrieves Demographics BrandingInterest data.
DemographicLanguageReport	A predefined view that retrieves Demographics Language data.
DemographicRegionReport	A predefined view that retrieves Demographics Region data.
Demographics	A base view that retrieves Demographics data.
EcommPurchasesItemBrandReport	A predefined view that retrieves Ecommerce purchase item brand data.
EcommPurchasesItemCategory2Report	A predefined view that retrieves Ecommerce purchase item category data.
EcommPurchasesItemCategory3Report	A predefined view that retrieves Ecommerce purchase item category data.
EcommPurchasesItemCategory4Report	A predefined view that retrieves Ecommerce purchase item category data.
EcommPurchasesItemCategory5Report	A predefined view that retrieves Ecommerce purchase item category data.
EcommPurchasesItemCategoryReport	A predefined view that retrieves Ecommerce purchase item category data.
EcommPurchasesItemCategoryReportCombined	A predefined view that retrieves Ecommerce purchase item category data.
EcommPurchasesItemIdReport	A predefined view that retrieves Ecommerce purchase item data.
EcommPurchasesItemNameReport	A predefined view that retrieves Ecommerce purchase item data.
Engagement	A base view that retrieves Engagement data
EngagementContentGroupReport	A predefined view that retrieves Engagement Content Group Report data.
EngagementConversionsReport	A predefined view that retrieves Engagement conversions data.
EngagementEventsReport	A predefined view that retrieves Engagement events data.
EngagementPagesPathReport	A predefined view that retrieves Engagement Pages path report data.
EngagementPagesTitleAndScreenClassReport	A predefined view that retrieves Engagement Pages title and screen class data.
EngagementPagesTitleAndScreenNameReport	A predefined view that retrieves Engagement Pages Title And ScreenName data.
Events	A base view that retrieves Event data
GamesReporting	A base view that retrieves Games Reporting data.
GlobalAccessObject	Retrieves data for all the available dimensions and metrics.
KeyEvents	A base view that retrieves KeyEvents data
MetaData	Retrieves metadata information for standard and custom dimensions / metrics.
Monetization	A base view that retrieves Monetization data.
MonetizationPublisherAdsAdFormatReport	A predefined view that retrieves publisher ads page ad format data.
MonetizationPublisherAdsAdSourceReport	A predefined view that retrieves publisher ads ad source data.
MonetizationPublisherAdsAdUnitReport	A predefined view that retrieves publisher ads ad unit data.
MonetizationPublisherAdsPagePathReport	A predefined view that retrieves publisher ads page path data.
Properties	Lists all Properties to which the user has access.
PropertiesAccessBindings	Lists all access bindings on an account or property. Requires one of the following OAuth scopes: https://www.googleapis.com/auth/analytics.manage.users.readonly https://www.googleapis.com/auth/analytics.manage.users
PropertiesAudiences	Lists Audiences on a property.
PropertiesDataStreams	Lists all data streams under a property to which the user has access. Attribute Parent (e.g: 'properties/123') or Name (e.g: 'properties/123/webDataStreams/456') is required to query the table.
PropertiesFireBaseLinks	Lists all FirebaseLinks on a property to which the user has access.
PropertiesGoogleAdsLinks	Lists all GoogleAdsLinks on a property to which the user has access.
PropertiesKeyEvents	Returns a list of Key Events in the specified parent property.
ScreenPageViews	A base view that retrieves ScreenPage data
Tech	A base view that retrieves Tech data.
TechAppVersionReport	A predefined view that retrieves Tech App Version data.
TechBrowserReport	A predefined view that retrieves Tech Browser data.
TechDeviceCategoryReport	A predefined view that retrieves Tech Device Category data.
TechDeviceModelReport	A predefined view that retrieves Tech Device Model data.
TechOSSystemReport	A predefined view that retrieves Tech os system data.
TechOSVersionReport	A predefined view that retrieves Tech Os version data.
TechPlatformDeviceCategoryReport	A predefined view that retrieves Tech platform device category data.
TechPlatformReport	A predefined view that retrieves Tech platform data.
TechScreenResolutionReport	A predefined view that retrieves Tech Screen Resolution data.

Lists all Accounts to which the user has access.

Table Specific Information

Select

The Accounts table exposes every account the user has access to. The provider uses the GoogleAnalytics4 API to process WHERE clause conditions built with the Name column, which supports the = operator.

The following query is processed server-side:

	SELECT * FROM Accounts WHERE Name = 'accounts/54516992'

The rest of the filter is executed client-side within the provider.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
CreateTime	Datetime				Time the account was created.
DisplayName	String				display name for the account.
Name	String				Account name.
RegionCode	String				Country for the account.
UpdateTime	Datetime				Time the account was last modified.
Deleted	Boolean				Indicates whether this Account is soft-deleted or not.

Lists summaries of all Accounts to which the user has access.

Table Specific Information

Select

The AccountSummaries table exposes summaries of all accounts accessible by the caller. The following query is processed server-side:

    SELECT * FROM AccountSummaries

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
Account	String				Account name referred to by this account summary.
DisplayName	String				display name for the account referred to by this account summary.
Name	String				Account summary name.
Propertysummaries	String				Summaries for child accounts of the specific account.

A base view that retrieves Acquisitions data.

Table Specific Information

Select

Retrieves data for Acquisitions report. At least one metric must be specified in the query. In the query you can also specify up to 9 dimensions.

The following is an example query:

	SELECT Conversions, NewUsers FROM Acquisitions

CustomChannelGroups are added as dimension columns. You can query customChannelGroup in the following way:

 SELECT SessionCustomChannelGroupName, FirstGroupCustomChannelGroupName, SessionDefaultChannelGrouping, Conversions FROM Acquisitions 

NOTE: CustomChannelGroupName is for reference purposes only. The exact value depends on the channelGroupName added.

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.
DayOfWeekName	String	True			The day of the week in English. This dimension has values of Sunday, Monday, etc.
IsoWeek	Integer	True			ISO week number, where each week starts on Monday Example values include 01, 02, 53.
IsoYear	Integer	True			The ISO year of the event. For details, see Example values include 2022 2023.
IsoYearIsoWeek	Integer	True			The combined values of isoWeek and isoYear. Example values include 201652 and 201701.
YearMonth	Integer	True			The combined values of year and month. Example values include 202212 or 202301.
YearWeek	Integer	True			The combined values of year and week. Example values include 202253 or 202301.
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.
FirstUserGoogleAdsAdGroupName	String	True			The Ad Group Name in Google Ads that first acquired the user.
FirstUserGoogleAdsAdNetworkType	String	True			The advertising network that first acquired the user.
FirstUserCampaignName	String	True			Name of the marketing campaign that first acquired the user.
FirstUserGoogleAdsCreativeId	String	True			The campaign creative ID that first acquired the users.
FirstUserMedium	String	True		True	The medium that first acquired the user to the website or app.
FirstUserSource	String	True			The source that first acquired the user to the website or app.
SessionCampaignName	String	True			Campaign that referred the user's session.
SessionDefaultChannelGroup	String	True			Channel groupings are rule-based definitions of your traffic sources. These default system definitions reflect Analytics' current view of what constitutes each channel.
SessionMedium	String	True			Channel that referred the user's session.
SessionSource	String	True			The source that initiated a session on your website or app.
EventName	String	True			The name of the event.
BrandingInterest	String	True			Interests demonstrated by users who are higher in the shopping funnel. Users can be counted in multiple interest categories.
Country	String	True			Country from which user activity originated.
City	String	True			City from which user activity originated.
Language	String	True			Language setting for the device from which activity originated.
UserAgeBracket	String	True			User age brackets.
UserGender	String	True			User gender.
Region	String	True			Geographic region from which activity originated.
UnifiedScreenClass	String	True			The page title (web) or screen class (app) on which the event was logged.
PagePath	String	True			The portion of the URL between the hostname and query string for web.
Conversions	Decimal	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.
EngagedSessionsPerUser	Decimal	False	True		Average number of engaged sessions per user.
EventCount	Integer	False	True		The count of events.
EventsPerSession	Decimal	False	True		The average number of events per session.
NewUsers	Integer	False	True		The number of users who interacted with the site or launched the app for the first time.
Sessions	Integer	False	True		The number of sessions that began on the site or app.
TotalRevenue	Integer	False	True		The sum of revenue from purchases, subscriptions, and advertising.
TotalUsers	Integer	False	True		The total number of users.
UserEngagementDuration	Bigint	False	False		The total amount of time (in seconds) the website or app was in the foreground of users device.
ScreenPageViews	Integer	False	False		The number of app screens or web pages the users viewed. Repeated views of a single page or screen are counted.
EventCountPerUser	Decimal	False	False		Average number of events triggered by each user.
SessionsPerUser	Decimal	False	False		The average number of sessions per user (Sessions divided by Active 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).

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.

A predefined view that retrieves Acquisitions first user Campaign data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• FirstUserGoogleAdsAdGroupName supports the following operator: =
• Date supports the following operators: =, >=, <=, <, >

For example, the following queries are processed server-side:

SELECT * FROM AcquisitionsFirstUserCampaignReport WHERE PropertyId = 342020667
SELECT * FROM AcquisitionsFirstUserCampaignReport WHERE FirstUserGoogleAdsAdGroupName = 'Test' 
SELECT * FROM AcquisitionsFirstUserCampaignReport WHERE Date = '01/05/2023' 
SELECT * FROM AcquisitionsFirstUserCampaignReport WHERE PropertyId = 342020667  AND FirstUserGoogleAdsAdGroupName = 'Test' AND Date = '01/05/2023'
SELECT * FROM AcquisitionsFirstUserCampaignReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM AcquisitionsFirstUserCampaignReport WHERE Date >= '01/01/2022'
SELECT * FROM AcquisitionsFirstUserCampaignReport WHERE Date <= '01/01/2022'
SELECT * FROM AcquisitionsFirstUserCampaignReport WHERE Date >  '01/01/2022'
SELECT * FROM AcquisitionsFirstUserCampaignReport WHERE Date < '01/01/2022'

CustomChannelGroups are added as dimension columns. You can query customChannelGroup in the following way:

 SELECT FirstUserCustomChannelGroupName, SessionDefaultChannelGrouping, Conversions FROM AcquisitionsFirstUserCampaignReport 

NOTE: CustomChannelGroupName is for reference purposes only. The exact value depends on the channelGroupName added. The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
FirstUserCampaignName	String	True		True	Name of the marketing campaign that first acquired the user.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
NewUsers	Integer	False	True		The number of users who interacted with the site or launched the app for the first time.
Conversions	Decimal	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.
TotalRevenue	Integer	False	True		The sum of revenue from purchases, subscriptions, and advertising.
TotalUsers	Integer	False	True		The total number of users.
UserEngagementDuration	Bigint	False	False		The total amount of time (in seconds) the website or app was in the foreground of users

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.

A predefined view that retrieves user Acquisitions first user google ads ad group name data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• FirstUserGoogleAdsAdGroupName supports the following operator: =
• Date supports the following operators: =, >=, <=, <, >

For example, the following queries are processed server-side:

SELECT * FROM AcquisitionsFirstUserGoogleAdsAdGroupNameReport WHERE PropertyId = 342020667
SELECT * FROM AcquisitionsFirstUserGoogleAdsAdGroupNameReport WHERE FirstUserGoogleAdsAdGroupName = 'Test' 
SELECT * FROM AcquisitionsFirstUserGoogleAdsAdGroupNameReport WHERE Date = '01/05/2023' 
SELECT * FROM AcquisitionsFirstUserGoogleAdsAdGroupNameReport WHERE PropertyId = 342020667  AND FirstUserGoogleAdsAdGroupName = 'Test' AND Date = '01/05/2023'
SELECT * FROM AcquisitionsFirstUserGoogleAdsAdGroupNameReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM AcquisitionsFirstUserGoogleAdsAdGroupNameReport WHERE Date >= '01/01/2022'
SELECT * FROM AcquisitionsFirstUserGoogleAdsAdGroupNameReport WHERE Date <= '01/01/2022'
SELECT * FROM AcquisitionsFirstUserGoogleAdsAdGroupNameReport WHERE Date >  '01/01/2022'
SELECT * FROM AcquisitionsFirstUserGoogleAdsAdGroupNameReport WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
FirstUserGoogleAdsAdGroupName	String	True		True	The Ad Group Name in Google Ads that first acquired the user.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
NewUsers	Integer	False	True		The number of users who interacted with the site or launched the app for the first time.
Conversions	Decimal	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.
TotalRevenue	Integer	False	True		The sum of revenue from purchases, subscriptions, and advertising.
TotalUsers	Integer	False	True		The total number of users.
UserEngagementDuration	Bigint	False	True		The total amount of time (in seconds) the website or app was in the foreground of users

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.

A predefined view that retrieves Acquisitions first user google ads ad network type platform data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• FirstUserGoogleAdsNetworkType supports the following operator: =
• Date supports the following operators: =, >=, <=, <, >

For example, the following queries are processed server-side:

SELECT * FROM AcquisitionsFirstUserGoogleAdsNetworkType WHERE PropertyId = 342020667
SELECT * FROM AcquisitionsFirstUserGoogleAdsNetworkType WHERE FirstUserGoogleAdsNetworkType = 'test' 
SELECT * FROM AcquisitionsFirstUserGoogleAdsNetworkType WHERE Date = '01/05/2023' 
SELECT * FROM AcquisitionsFirstUserGoogleAdsNetworkType WHERE PropertyId = 342020667  AND FirstUserGoogleAdsNetworkType = 'test' AND Date = '01/05/2023'
SELECT * FROM AcquisitionsFirstUserGoogleAdsNetworkType WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM AcquisitionsFirstUserGoogleAdsNetworkType WHERE Date >= '01/01/2022'
SELECT * FROM AcquisitionsFirstUserGoogleAdsNetworkType WHERE Date <= '01/01/2022'
SELECT * FROM AcquisitionsFirstUserGoogleAdsNetworkType WHERE Date >  '01/01/2022'
SELECT * FROM AcquisitionsFirstUserGoogleAdsNetworkType WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
FirstUserGoogleAdsAdNetworkType	String	True		True	The source platform that first acquired the user.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
NewUsers	Integer	False	True		The number of users who interacted with the site or launched the app for the first time.
Conversions	Decimal	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.
TotalRevenue	Integer	False	True		The sum of revenue from purchases, subscriptions, and advertising.
TotalUsers	Integer	False	True		The total number of users.
UserEngagementDuration	Bigint	False	True		The total amount of time (in seconds) the website or app was in the foreground of users

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.

A predefined view that retrieves Acquisitions first user medium data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• FirstUserMedium supports the following operator: =
• Date supports the following operators: =, >=, <=, <, >

For example, the following queries are processed server-side:

SELECT * FROM AcquisitionsFirstUserMediumReport WHERE PropertyId = 342020667
SELECT * FROM AcquisitionsFirstUserMediumReport WHERE FirstUserMedium = 'test' 
SELECT * FROM AcquisitionsFirstUserMediumReport WHERE Date = '20221115' 
SELECT * FROM AcquisitionsFirstUserMediumReport WHERE PropertyId = 342020667  AND FirstUserMedium = 'test' AND Date = '01/05/2023''
SELECT * FROM AcquisitionsFirstUserMediumReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM AcquisitionsFirstUserMediumReport WHERE Date >= '01/01/2022'
SELECT * FROM AcquisitionsFirstUserMediumReport WHERE Date <= '01/01/2022'
SELECT * FROM AcquisitionsFirstUserMediumReport WHERE Date >  '01/01/2022'
SELECT * FROM AcquisitionsFirstUserMediumReport WHERE Date < '01/01/2022'

CustomChannelGroups are added as dimension columns. You can query customChannelGroup in the following way:

 SELECT FirstUserCustomChannelGroupName, SessionDefaultChannelGrouping, Conversions FROM AcquisitionsFirstUserMediumReport WHERE FirstUserMedium = 'test' 

NOTE: CustomChannelGroupName is for reference purposes only. The exact value depends on the channelGroupName added. The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
FirstUserMedium	String	True		True	The medium that first acquired the user to the website or app.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
NewUsers	Integer	False	True		The number of users who interacted with the site or launched the app for the first time.
Conversions	Decimal	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.
TotalRevenue	Integer	False	True		The sum of revenue from purchases, subscriptions, and advertising.
TotalUsers	Integer	False	True		The total number of users.
UserEngagementDuration	Bigint	False	True		The total amount of time (in seconds) the website or app was in the foreground of users

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.

A predefined view that retrieves Acquisitions first user source medium data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• FirstUserGoogleAdsAdGroupName supports the following operator: =
• Date supports the following operators: =, >=, <=, <, >

For example, the following queries are processed server-side:

SELECT * FROM AcquisitionsFirstUserSourceMediumReport WHERE PropertyId = 342020667
SELECT * FROM AcquisitionsFirstUserSourceMediumReport WHERE FirstUserGoogleAdsAdGroupName = 'Test' 
SELECT * FROM AcquisitionsFirstUserSourceMediumReport WHERE Date = '01/05/2023'' 
SELECT * FROM AcquisitionsFirstUserSourceMediumReport WHERE PropertyId = 342020667  AND FirstUserGoogleAdsAdGroupName = 'Test' AND Date = '01/05/2023'
SELECT * FROM AcquisitionsFirstUserSourceMediumReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM AcquisitionsFirstUserSourceMediumReport WHERE Date >= '01/01/2022'
SELECT * FROM AcquisitionsFirstUserSourceMediumReport WHERE Date <= '01/01/2022'
SELECT * FROM AcquisitionsFirstUserSourceMediumReport WHERE Date >  '01/01/2022'
SELECT * FROM AcquisitionsFirstUserSourceMediumReport WHERE Date < '01/01/2022'

CustomChannelGroups are added as dimension columns. You can query customChannelGroup in the following way:

 SELECT FirstUserCustomChannelGroupName, SessionDefaultChannelGrouping, Conversions FROM AcquisitionsFirstUserSourceMediumReport 

NOTE: CustomChannelGroupName is for reference purposes only. The exact value depends on the channelGroupName added. The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
FirstUserSource	String	True		True	The source that first acquired the user to the website or app.
FirstUserMedium	String	True		True	The medium that first acquired the user to the website or app.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
NewUsers	Integer	False	True		The number of users who interacted with the site or launched the app for the first time.
Conversions	Decimal	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.
TotalRevenue	Integer	False	True		The sum of revenue from purchases, subscriptions, and advertising.
TotalUsers	Integer	False	True		The total number of users.
UserEngagementDuration	Bigint	False	True		The total amount of time (in seconds) the website or app was in the foreground of users

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.

A predefined view that retrieves Acquisitions first user source platform data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• FirstUserSourcePlatform supports the following operator: =
• Date supports the following operators: =, >=, <=, <, >

For example, the following queries are processed server-side:

SELECT * FROM AcquisitionsFirstUserSourcePlatformReport WHERE PropertyId = 342020667
SELECT * FROM AcquisitionsFirstUserSourcePlatformReport WHERE FirstUserSourcePlatform = 'Test' 
SELECT * FROM AcquisitionsFirstUserSourcePlatformReport WHERE Date = '01/05/2023' 
SELECT * FROM AcquisitionsFirstUserSourcePlatformReport WHERE PropertyId = 342020667  AND FirstUserSourcePlatform = 'Test' AND Date = '01/05/2023'
SELECT * FROM AcquisitionsFirstUserSourcePlatformReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM AcquisitionsFirstUserSourcePlatformReport WHERE Date >= '01/01/2022'
SELECT * FROM AcquisitionsFirstUserSourcePlatformReport WHERE Date <= '01/01/2022'
SELECT * FROM AcquisitionsFirstUserSourcePlatformReport WHERE Date >  '01/01/2022'
SELECT * FROM AcquisitionsFirstUserSourcePlatformReport WHERE Date < '01/01/2022'

CustomChannelGroups are added as dimension columns. You can query customChannelGroup in the following way:

 SELECT FirstUserCustomChannelGroupName, SessionDefaultChannelGrouping, Conversions FROM AcquisitionsFirstUserSourcePlatformReport WHERE FirstUserSourcePlatform = 'Test'

NOTE: CustomChannelGroupName is for reference purposes only. The exact value depends on the channelGroupName added. The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
FirstUserSourcePlatform	String	True		True	The source platform that first acquired the user.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
NewUsers	Integer	False	True		The number of users who interacted with the site or launched the app for the first time.
Conversions	Decimal	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.
TotalRevenue	Integer	False	True		The sum of revenue from purchases, subscriptions, and advertising.
TotalUsers	Integer	False	True		The total number of users.
UserEngagementDuration	Bigint	False	True		The total amount of time (in seconds) the website or app was in the foreground of users

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.

A predefined view that retrieves Acquisitions first user source data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• FirstUserSource supports the following operator: =
• Date supports the following operators: =, >=, <=, <, >

For example, the following queries are processed server-side:

SELECT * FROM AcquisitionsFirstUserSourceReport WHERE PropertyId = 342020667
SELECT * FROM AcquisitionsFirstUserSourceReport WHERE FirstUserSource = '(direct)' 
SELECT * FROM AcquisitionsFirstUserSourceReport WHERE Date = '01/05/2023' 
SELECT * FROM AcquisitionsFirstUserSourceReport WHERE PropertyId = 342020667  AND FirstUserSource = '(direct)' AND Date = '01/05/2023'
SELECT * FROM AcquisitionsFirstUserSourceReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM AcquisitionsFirstUserSourceReport WHERE Date >= '01/01/2022'
SELECT * FROM AcquisitionsFirstUserSourceReport WHERE Date <= '01/01/2022'
SELECT * FROM AcquisitionsFirstUserSourceReport WHERE Date >  '01/01/2022'
SELECT * FROM AcquisitionsFirstUserSourceReport WHERE Date < '01/01/2022'

CustomChannelGroups are added as dimension columns. You can query customChannelGroup in the following way:

 SELECT FirstUserCustomChannelGroupName, SessionDefaultChannelGrouping, Conversions FROM AcquisitionsFirstUserSourceReport WHERE FirstUserSource = '(direct)' 

NOTE: CustomChannelGroupName is for reference purposes only. The exact value depends on the channelGroupName added. The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
FirstUserSource	String	True		True	The source that first acquired the user to the website or app.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
NewUsers	Integer	False	True		The number of users who interacted with the site or launched the app for the first time.
Conversions	Decimal	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.
TotalRevenue	Integer	False	True		The sum of revenue from purchases, subscriptions, and advertising.
TotalUsers	Integer	False	True		The total number of users.
UserEngagementDuration	Bigint	False	False		The total amount of time (in seconds) the website or app was in the foreground of users

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.

A predefined view that retrieves Acquisitions session campaign report data.

n

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• SessionDefaultChannelGrouping supports the following operator: =
• Date supports the following operators: =, >=, <=, <, >

For example, the following queries are processed server-side:

SELECT * FROM AcquisitionsSessionDefaultChannelGroupingReport WHERE PropertyId = 342020667
SELECT * FROM AcquisitionsSessionDefaultChannelGroupingReport WHERE SessionDefaultChannelGrouping = 'Direct' 
SELECT * FROM AcquisitionsSessionDefaultChannelGroupingReport WHERE Date = '01/05/2023' 
SELECT * FROM AcquisitionsSessionDefaultChannelGroupingReport WHERE PropertyId = 342020667  AND SessionDefaultChannelGrouping = 'Direct' AND Date = '01/05/2023'
SELECT * FROM AcquisitionsSessionDefaultChannelGroupingReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM AcquisitionsSessionDefaultChannelGroupingReport WHERE Date >= '01/01/2022'
SELECT * FROM AcquisitionsSessionDefaultChannelGroupingReport WHERE Date <= '01/01/2022'
SELECT * FROM AcquisitionsSessionDefaultChannelGroupingReport WHERE Date >  '01/01/2022'
SELECT * FROM AcquisitionsSessionDefaultChannelGroupingReport WHERE Date < '01/01/2022'

CustomChannelGroups are added as dimension columns. You can query customChannelGroup in the following way:

 SELECT SessionCustomChannelGroupName, SessionDefaultChannelGrouping, Conversions FROM AcquisitionsSessionDefaultChannelGroupingReport WHERE SessionDefaultChannelGrouping = 'Direct' 

NOTE: CustomChannelGroupName is for reference purposes only. The exact value depends on the channelGroupName added. The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
SessionCampaignName	String	True		True	Campaign that referred the user
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
Sessions	Integer	False	True		The number of sessions that began on the site or app.
EventsPerSession	Decimal	False	True		The average number of events per session.
Conversions	Decimal	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.
TotalRevenue	Integer	False	True		The sum of revenue from purchases, subscriptions, and advertising.
TotalUsers	Integer	False	True		The total number of users.
UserEngagementDuration	Bigint	False	True		The total amount of time (in seconds) the website or app was in the foreground of users

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.

A predefined view that retrieves Acquisitions session default channel grouping report data.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
SessionDefaultChannelGroup	String	True		True	Channel groupings are rule-based definitions of your traffic sources. These default system definitions reflect Analytics current view of what constitutes each channel.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
Conversions	Decimal	False	True		The count of conversion events.
EventsPerSession	Decimal	False	True		The average number of events per session.
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.
TotalRevenue	Integer	False	True		The sum of revenue from purchases, subscriptions, and advertising.
TotalUsers	Integer	False	True		The total number of users.
UserEngagementDuration	Bigint	False	True		The total amount of time (in seconds) the website or app was in the foreground of users

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.

A predefined view that retrieves Acquisitions session medium report data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• SessionMedium supports the following operator: =
• Date supports the following operators: =, >=, <=, <, >

For example, the following queries are processed server-side:

SELECT * FROM AcquisitionsSessionMediumReport WHERE PropertyId = 342020667
SELECT * FROM AcquisitionsSessionMediumReport WHERE SessionMedium = 'test' 
SELECT * FROM AcquisitionsSessionMediumReport WHERE Date = '01/05/2023' 
SELECT * FROM AcquisitionsSessionMediumReport WHERE PropertyId = 342020667  AND SessionMedium = 'test' AND Date = '01/05/2023'
SELECT * FROM AcquisitionsSessionMediumReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM AcquisitionsSessionMediumReport WHERE Date >= '01/01/2022'
SELECT * FROM AcquisitionsSessionMediumReport WHERE Date <= '01/01/2022'
SELECT * FROM AcquisitionsSessionMediumReport WHERE Date >  '01/01/2022'
SELECT * FROM AcquisitionsSessionMediumReport WHERE Date < '01/01/2022'

CustomChannelGroups are added as dimension columns. You can query customChannelGroup in the following way:

 SELECT SessionCustomChannelGroupName, SessionDefaultChannelGrouping, Conversions FROM AcquisitionsSessionMediumReport WHERE SessionMedium = 'test'

NOTE: CustomChannelGroupName is for reference purposes only. The exact value depends on the channelGroupName added. The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
SessionMedium	String	True		True	Channel that referred the user
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
Sessions	Integer	False	True		The number of sessions that began on the site or app.
EventsPerSession	Decimal	False	True		The average number of events per session.
Conversions	Decimal	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.
TotalRevenue	Integer	False	True		The sum of revenue from purchases, subscriptions, and advertising.
TotalUsers	Integer	False	True		The total number of users.
UserEngagementDuration	Bigint	False	True		The total amount of time (in seconds) the website or app was in the foreground of users

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.

A predefined view that retrieves Acquisitions session source medium report data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• FirstUserGoogleAdsAdGroupName supports the following operator: =
• Date supports the following operators: =, >=, <=, <, >

For example, the following queries are processed server-side:

SELECT * FROM AcquisitionsSessionSourceMediumReport WHERE PropertyId = 342020667
SELECT * FROM AcquisitionsSessionSourceMediumReport WHERE FirstUserGoogleAdsAdGroupName = 'Test' 
SELECT * FROM AcquisitionsSessionSourceMediumReport WHERE Date = '01/05/2023' 
SELECT * FROM AcquisitionsSessionSourceMediumReport WHERE PropertyId = 342020667  AND FirstUserGoogleAdsAdGroupName = 'Test' AND Date = '01/05/2023'
SELECT * FROM AcquisitionsSessionSourceMediumReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM AcquisitionsSessionSourceMediumReport WHERE Date >= '01/01/2022'
SELECT * FROM AcquisitionsSessionSourceMediumReport WHERE Date <= '01/01/2022'
SELECT * FROM AcquisitionsSessionSourceMediumReport WHERE Date >  '01/01/2022'
SELECT * FROM AcquisitionsSessionSourceMediumReport WHERE Date < '01/01/2022'

CustomChannelGroups are added as dimension columns. You can query customChannelGroup in the following way:

 SELECT SessionCustomChannelGroupName, SessionDefaultChannelGrouping, Conversions FROM AcquisitionsSessionSourceMediumReport 

NOTE: CustomChannelGroupName is for reference purposes only. The exact value depends on the channelGroupName added. The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
SessionMedium	String	True		True	Channel that referred the user
SessionSource	String	True		True	The source that initiated a session on your website or app.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
Sessions	Integer	False	True		The number of sessions that began on the site or app.
EventsPerSession	Decimal	False	True		The average number of events per session.
Conversions	Decimal	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.
TotalRevenue	Integer	False	True		The sum of revenue from purchases, subscriptions, and advertising.
TotalUsers	Integer	False	True		The total number of users.
UserEngagementDuration	Bigint	False	False		The total amount of time (in seconds) the website or app was in the foreground of users

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.

A predefined view that retrieves Acquisitions session source platform report data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• FirstUserGoogleAdsAdGroupName supports the following operator: =
• Date supports the following operators: =, >=, <=, <, >

For example, the following queries are processed server-side:

SELECT * FROM AcquisitionsSessionSourcePlatformReport WHERE PropertyId = 342020667
SELECT * FROM AcquisitionsSessionSourcePlatformReport WHERE FirstUserGoogleAdsAdGroupName = 'Test' 
SELECT * FROM AcquisitionsSessionSourcePlatformReport WHERE Date = '01/05/2023' 
SELECT * FROM AcquisitionsSessionSourcePlatformReport WHERE PropertyId = 342020667  AND FirstUserGoogleAdsAdGroupName = 'Test' AND Date = '01/05/2023'
SELECT * FROM AcquisitionsSessionSourcePlatformReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM AcquisitionsSessionSourcePlatformReport WHERE Date >= '01/01/2022'
SELECT * FROM AcquisitionsSessionSourcePlatformReport WHERE Date <= '01/01/2022'
SELECT * FROM AcquisitionsSessionSourcePlatformReport WHERE Date >  '01/01/2022'
SELECT * FROM AcquisitionsSessionSourcePlatformReport WHERE Date < '01/01/2022'

CustomChannelGroups are added as dimension columns. You can query customChannelGroup in the following way:

 SELECT SessionCustomChannelGroupName, SessionDefaultChannelGrouping, Conversions FROM AcquisitionsSessionSourcePlatformReport 

NOTE: CustomChannelGroupName is for reference purposes only. The exact value depends on the channelGroupName added. The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
SessionSourcePlatform	String	True		True	The source platform of the session
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
Conversions	Decimal	False	True		The count of conversion events.
EventsPerSession	Decimal	False	True		The average number of events per session.
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.
TotalRevenue	Integer	False	True		The sum of revenue from purchases, subscriptions, and advertising.
TotalUsers	Integer	False	True		The total number of users.
UserEngagementDuration	Bigint	False	False		The total amount of time (in seconds) the website or app was in the foreground of users

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.

A predefined view that retrieves Acquisitions session source report data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• FirstUserGoogleAdsAdGroupName supports the following operator: =
• Date supports the following operators: =, >=, <=, <, >

For example, the following queries are processed server-side:

SELECT * FROM AcquisitionsSessionSourceReport WHERE PropertyId = 342020667
SELECT * FROM AcquisitionsSessionSourceReport WHERE FirstUserGoogleAdsAdGroupName = 'Test' 
SELECT * FROM AcquisitionsSessionSourceReport WHERE Date = '01/01/2022' 
SELECT * FROM AcquisitionsSessionSourceReport WHERE PropertyId = 342020667  AND FirstUserGoogleAdsAdGroupName = 'Test' AND Date = '01/05/2023'
SELECT * FROM AcquisitionsSessionSourceReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM AcquisitionsSessionSourceReport WHERE Date >= '01/01/2022'
SELECT * FROM AcquisitionsSessionSourceReport WHERE Date <= '01/01/2022'
SELECT * FROM AcquisitionsSessionSourceReport WHERE Date >  '01/01/2022'
SELECT * FROM AcquisitionsSessionSourceReport WHERE Date < '01/01/2022'

CustomChannelGroups are added as dimension columns. You can query customChannelGroup in the following way:

 SELECT SessionCustomChannelGroupName, SessionDefaultChannelGrouping, Conversions FROM AcquisitionsSessionSourceReport 

NOTE: CustomChannelGroupName is for reference purposes only. The exact value depends on the channelGroupName added. The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
SessionSource	String	True		True	The source that initiated a session on your website or app.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
Sessions	Integer	False	True		The number of sessions that began on the site or app.
EventsPerSession	Decimal	False	True		The average number of events per session.
Conversions	Decimal	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.
TotalRevenue	Integer	False	True		The sum of revenue from purchases, subscriptions, and advertising.
TotalUsers	Integer	False	True		The total number of users.
UserEngagementDuration	Bigint	False	False		The total amount of time (in seconds) the website or app was in the foreground of users

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.

A base view that retrieves Active Users data.

Table Specific Information

Select

Retrieves data for ActiveUsers report. At least one metric must be specified in the query. This endpoint uses the realtime report API endpoint to get more up to date data than the standard reporting endpoint. The realtime reporting API supports a maximum of four dimensions compared to the standard nine for the standard report API.

The following is an example query:

	SELECT ActiveUsers, Platform FROM ActiveUsers

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
AppVersion	String	True			The app's versionName (Android) or short bundle version (iOS).
City	String	True			The city from which the user activity originated.
Country	String	True			The country from which the user activity originated.
DeviceCategory	String	True			The type of device: Desktop, Tablet, or Mobile.
Platform	String	True		True	The platform on which your app or website ran.
AudienceName	String	True			The given name of an Audience.
UnifiedScreenName	String	True			The page title (web) or screen name (app) on which the event was logged.
ActiveUsers	Integer	False	True		The total number of active users.
AudienceId	Long	True			The numeric identifier of an Audience.
AudienceResourceName	String	True			The resource name of this audience.
CityId	Integer	True			The geographic ID of the city from which the user activity originated, derived from their IP address.
CountryId	String	True			The geographic ID of the country from which the user activity originated, derived from their IP address.
MinutesAgo	Integer	True			The number of minutes ago that an event was collected. 00 is the current minute, and 01 means the previous minute.
StreamId	Long	True			The numeric data stream identifier for your app or website.
StreamName	String	True			The data stream name for your app or website.
EventName	String	True			The name of the event

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.

A predefined view that retrieves Demographics UserAgeBracket data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the '=' operator.
• UserAgeBracket supports the '=' operator.
• Date supports the '=,>=,<=,<,>' operators.

For example, the following queries are processed server-side:

SELECT * FROM DemographicAgeReport WHERE PropertyId = 342020667
SELECT * FROM DemographicAgeReport WHERE UserAgeBracket = '18-24' 
SELECT * FROM DemographicAgeReport WHERE Date = '01/05/2023' 
SELECT * FROM DemographicAgeReport WHERE PropertyId = 342020667 AND Date = '01/05/2023' AND UserAgeBracket = '18-24'
SELECT * FROM DemographicAgeReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM DemographicAgeReport WHERE Date >= '01/01/2022'
SELECT * FROM DemographicAgeReport WHERE Date <= '01/01/2022'
SELECT * FROM DemographicAgeReport WHERE Date >  '01/01/2022'
SELECT * FROM DemographicAgeReport WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
UserAgeBracket	String	True		True	User age brackets.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
Conversions	Decimal	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.
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.

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.

A predefined view that retrieves Demographics City data.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
City	String	True		True	City from which user activity originated.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
Conversions	Decimal	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.
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.

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.

A predefined view that retrieves Demographics Country data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the '=' operator.
• Country supports the '=' operator.
• Date supports the '=,>=,<=,<,>' operators.

For example, the following queries are processed server-side:

SELECT * FROM DemographicCountryReport WHERE PropertyId = 342020667
SELECT * FROM DemographicCountryReport WHERE Country = 'America' 
SELECT * FROM DemographicCountryReport WHERE Date = '01/05/2023' 
SELECT * FROM DemographicCountryReport WHERE PropertyId = 342020667 AND Date = '01/05/2023' AND Country = 'America'
SELECT * FROM DemographicCountryReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM DemographicCountryReport WHERE Date >= '01/01/2022'
SELECT * FROM DemographicCountryReport WHERE Date <= '01/01/2022'
SELECT * FROM DemographicCountryReport WHERE Date >  '01/01/2022'
SELECT * FROM DemographicCountryReport WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
Country	String	True		True	Country from which user activity originated.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
Conversions	Decimal	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.
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.

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.

A predefined view that retrieves Demographics UserGender data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the '=' operator.
• UserGender supports the '=' operator.
• Date supports the '=,>=,<=,<,>' operators.

For example, the following queries are processed server-side:

SELECT * FROM DemographicGenderReport WHERE PropertyId = 342020667
SELECT * FROM DemographicGenderReport WHERE UserGender = 'Female' 
SELECT * FROM DemographicGenderReport WHERE Date = '01/01/2022' 
SELECT * FROM DemographicGenderReport WHERE PropertyId = 342020667 AND Date = '01/01/2022' AND UserGender = 'Female'
SELECT * FROM DemographicGenderReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM DemographicGenderReport WHERE Date >= '01/01/2022'
SELECT * FROM DemographicGenderReport WHERE Date <= '01/01/2022'
SELECT * FROM DemographicGenderReport WHERE Date >  '01/01/2022'
SELECT * FROM DemographicGenderReport WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
UserGender	String	True		True	User gender.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
Conversions	Decimal	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.
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.

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.

A predefined view that retrieves Demographics BrandingInterest data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the '=' operator.
• BrandingInterest supports the '=' operator.
• Date supports the '=,>=,<=,<,>' operators.

For example, the following queries are processed server-side:

SELECT * FROM DemographicInterestsReport WHERE PropertyId = 342020667
SELECT * FROM DemographicInterestsReport WHERE BrandingInterest = 'Marketing' 
SELECT * FROM DemographicInterestsReport WHERE Date = '01/05/2023' 
SELECT * FROM DemographicInterestsReport WHERE PropertyId = 342020667 AND Date = '01/05/2023' AND BrandingInterest = 'Marketing'
SELECT * FROM DemographicInterestsReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM DemographicInterestsReport WHERE Date >= '01/01/2022'
SELECT * FROM DemographicInterestsReport WHERE Date <= '01/01/2022'
SELECT * FROM DemographicInterestsReport WHERE Date >  '01/01/2022'
SELECT * FROM DemographicInterestsReport WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
BrandingInterest	String	True		True	Interests demonstrated by users who are higher in the shopping funnel. Users can be counted in multiple interest categories.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
Conversions	Decimal	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.
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.

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.

A predefined view that retrieves Demographics Language data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the '=' operator.
• Language supports the '=' operator.
• Date supports the '=,>=,<=,<,>' operators.

For example, the following queries are processed server-side:

SELECT * FROM DemographicLanguageReport WHERE PropertyId = 342020667
SELECT * FROM DemographicLanguageReport WHERE Language = 'English' 
SELECT * FROM DemographicLanguageReport WHERE Date = '01/05/2023' 
SELECT * FROM DemographicLanguageReport WHERE PropertyId = 342020667 AND Date = '01/05/2023' AND Language = 'English'
SELECT * FROM DemographicLanguageReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM DemographicLanguageReport WHERE Date >= '01/01/2022'
SELECT * FROM DemographicLanguageReport WHERE Date <= '01/01/2022'
SELECT * FROM DemographicLanguageReport WHERE Date >  '01/01/2022'
SELECT * FROM DemographicLanguageReport WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
Language	String	True		True	Language setting for the device from which activity originated.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
Conversions	Decimal	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.
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.

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.

A predefined view that retrieves Demographics Region data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the '=' operator.
• Region supports the '=' operator.
• Date supports the '=,>=,<=,<,>' operators.

For example, the following queries are processed server-side:

SELECT * FROM DemographicRegionReport WHERE PropertyId = 342020667
SELECT * FROM DemographicRegionReport WHERE Region = 'California' 
SELECT * FROM DemographicRegionReport WHERE Date = '01/05/2023' 
SELECT * FROM DemographicRegionReport WHERE PropertyId = 342020667 AND Date = '01/05/2023' AND Region = 'California'
SELECT * FROM DemographicRegionReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM DemographicRegionReport WHERE Date >= '01/01/2022'
SELECT * FROM DemographicRegionReport WHERE Date <= '01/01/2022'
SELECT * FROM DemographicRegionReport WHERE Date >  '01/01/2022'
SELECT * FROM DemographicRegionReport WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
Region	String	True		True	Geographic region from which activity originated.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
Conversions	Decimal	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.
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.

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.

A base view that retrieves Demographics data.

Table Specific Information

Select

Retrieves data for Demographics report. At least one metric must be specified in the query. In the query you can also specify up to nine dimensions. The following is an example query:

	SELECT Conversions, TotalRevenue FROM Demographics

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.
DayOfWeekName	String	True			The day of the week in English. This dimension has values of Sunday, Monday, etc.
IsoWeek	Integer	True			ISO week number, where each week starts on Monday. Example values include 01, 02, 53.
IsoYear	Integer	True			The ISO year of the event.Example values include 2022 2023.
IsoYearIsoWeek	Integer	True			The combined values of isoWeek and isoYear. Example values include 201652 and 201701.
YearMonth	Integer	True			The combined values of year and month. Example values include 202212 or 202301.
YearWeek	Integer	True			The combined values of year and week. Example values include 202253 or 202301.
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.
BrandingInterest	String	True			Interests demonstrated by users who are higher in the shopping funnel. Users can be counted in multiple interest categories.
Country	String	True		True	Country from which user activity originated.
City	String	True			City from which user activity originated.
Language	String	True			Language setting for the device from which activity originated.
UserAgeBracket	String	True			User age brackets.
UserGender	String	True			User gender.
Region	String	True			Geographic region from which activity originated.
Conversions	Decimal	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.
EngagedSessionsPerUser	Decimal	False	True		Average number of engaged sessions per user.
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).

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.

A predefined view that retrieves Ecommerce purchase item brand data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• ItemBrand supports the following operator: =
• Date supports the following operators: =,>=,<=,<,>

For example, the following queries are processed server-side:

SELECT * FROM EcommPurchasesItemBrandReport WHERE PropertyId = 342020667
SELECT * FROM EcommPurchasesItemBrandReport WHERE ItemBrand = 'test' 
SELECT * FROM EcommPurchasesItemBrandReport WHERE Date = '01/05/2023' 
SELECT * FROM EcommPurchasesItemBrandReport WHERE PropertyId = 342020667  AND ItemBrand = 'test' AND Date = '01/05/2023'
SELECT * FROM EcommPurchasesItemBrandReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM EcommPurchasesItemBrandReport WHERE Date >= '01/01/2022'
SELECT * FROM EcommPurchasesItemBrandReport WHERE Date <= '01/01/2022'
SELECT * FROM EcommPurchasesItemBrandReport WHERE Date >  '01/01/2022'
SELECT * FROM EcommPurchasesItemBrandReport WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
ItemBrand	String	True		True	Brand name of the item.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
ItemsAddedToCart	Integer	False	True		The number of times users added items to their shopping carts. Since AddToCarts is not compatible with item-scoped dimensions, hence this is the replacement of the AddToCarts metric.
CartToViewRate	Decimal	False	True		The number of users who added a product(s) to their cart divided by the number of users who viewed the same product(s).
EcommercePurchases	Integer	False			The number of times users completed a purchase. This metric is not compatible with item-scoped dimensions.
PurchaseToViewRate	Decimal	False	True		The total cost of shipping.
ItemsPurchased	Integer	False	True		The total amount of tax. ItemPurchaseQuantity metric has been renamed to this metric.
ItemRevenue	Decimal	False	True		The total revenue from items only. Item revenue is the product of its price and quantity.
ItemsViewed	Integer	False	True		The number of units viewed for a single item. This metric counts the quantity of items in 'view_item' events.

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.

A predefined view that retrieves Ecommerce purchase item category data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• ItemCategory2 supports the following operator: =
• Date supports the following operators: =,>=,<=,<,>

For example, the following queries are processed server-side:

SELECT * FROM EcommPurchasesItemCategory2Report WHERE PropertyId = 342020667
SELECT * FROM EcommPurchasesItemCategory2Report WHERE ItemCategory2 = 'Apparel' 
SELECT * FROM EcommPurchasesItemCategory2Report WHERE Date = '01/05/2023' 
SELECT * FROM EcommPurchasesItemCategory2Report WHERE PropertyId = 342020667  AND ItemCategory2 = 'Apparel' AND Date = '01/05/2023'
SELECT * FROM EcommPurchasesItemCategory2Report WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM EcommPurchasesItemCategory2Report WHERE Date >= '01/01/2022'
SELECT * FROM EcommPurchasesItemCategory2Report WHERE Date <= '01/01/2022'
SELECT * FROM EcommPurchasesItemCategory2Report WHERE Date >  '01/01/2022'
SELECT * FROM EcommPurchasesItemCategory2Report WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
ItemCategory2	String	True		True	Hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Mens is the item category2
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
ItemsAddedToCart	Integer	False	True		The number of times users added items to their shopping carts. Since AddToCarts is not compatible with item-scoped dimensions, hence this is the replacement of the AddToCarts metric.
CartToViewRate	Decimal	False	True		The number of users who added a product(s) to their cart divided by the number of users who viewed the same product(s).
EcommercePurchases	Integer	False			The number of times users completed a purchase. This metric is not compatible with item-scoped dimensions.
PurchaseToViewRate	Decimal	False	True		The total cost of shipping.
ItemsPurchased	Integer	False	True		The total amount of tax. ItemPurchaseQuantity metric has been renamed to this metric.
ItemRevenue	Decimal	False	True		The total revenue from items only. Item revenue is the product of its price and quantity.
ItemsViewed	Integer	False	True		The number of units viewed for a single item. This metric counts the quantity of items in 'view_item' events.

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.

A predefined view that retrieves Ecommerce purchase item category data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• ItemCategory3 supports the following operator: =
• Date supports the following operators: =,>=,<=,<,>

For example, the following queries are processed server-side:

SELECT * FROM EcommPurchasesItemCategory3Report WHERE PropertyId = 342020667
SELECT * FROM EcommPurchasesItemCategory3Report WHERE ItemCategory3 = 'Apparel' 
SELECT * FROM EcommPurchasesItemCategory3Report WHERE Date = '01/05/2023' 
SELECT * FROM EcommPurchasesItemCategory3Report WHERE PropertyId = 342020667  AND ItemCategory3 = 'Apparel' AND Date = '01/05/2023'
SELECT * FROM EcommPurchasesItemCategory3Report WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM EcommPurchasesItemCategory3Report WHERE Date >= '01/01/2022'
SELECT * FROM EcommPurchasesItemCategory3Report WHERE Date <= '01/01/2022'
SELECT * FROM EcommPurchasesItemCategory3Report WHERE Date >  '01/01/2022'
SELECT * FROM EcommPurchasesItemCategory3Report WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
ItemCategory3	String	True		True	Hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Summer is the item category3.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
ItemsAddedToCart	Integer	False	True		The number of times users added items to their shopping carts. Since AddToCarts is not compatible with item-scoped dimensions, hence this is the replacement of the AddToCarts metric.
CartToViewRate	Decimal	False	True		The number of users who added a product(s) to their cart divided by the number of users who viewed the same product(s).
EcommercePurchases	Integer	False			The number of times users completed a purchase. This metric is not compatible with item-scoped dimensions.
PurchaseToViewRate	Decimal	False	True		The total cost of shipping.
ItemsPurchased	Integer	False	True		The total amount of tax. ItemPurchaseQuantity metric has been renamed to this metric.
ItemRevenue	Decimal	False	True		The total revenue from items only. Item revenue is the product of its price and quantity.
ItemsViewed	Integer	False	True		The number of units viewed for a single item. This metric counts the quantity of items in 'view_item' events.

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.

A predefined view that retrieves Ecommerce purchase item category data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• ItemCategory4 supports the following operator: =
• Date supports the following operators: =,>=,<=,<,>

For example, the following queries are processed server-side:

SELECT * FROM EcommPurchasesItemCategory4Report WHERE PropertyId = 342020667
SELECT * FROM EcommPurchasesItemCategory4Report WHERE ItemCategory4 = 'Apparel' 
SELECT * FROM EcommPurchasesItemCategory4Report WHERE Date = '01/05/2023' 
SELECT * FROM EcommPurchasesItemCategory4Report WHERE PropertyId = 342020667  AND ItemCategory4 = 'Apparel' AND Date = '01/05/2023'
SELECT * FROM EcommPurchasesItemCategory4Report WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM EcommPurchasesItemCategory4Report WHERE Date >= '01/01/2022'
SELECT * FROM EcommPurchasesItemCategory4Report WHERE Date <= '01/01/2022'
SELECT * FROM EcommPurchasesItemCategory4Report WHERE Date >  '01/01/2022'
SELECT * FROM EcommPurchasesItemCategory4Report WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
ItemCategory4	String	True		True	Hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Shirts is the item category4.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
ItemsAddedToCart	Integer	False	True		The number of times users added items to their shopping carts. Since AddToCarts is not compatible with item-scoped dimensions, hence this is the replacement of the AddToCarts metric.
CartToViewRate	Decimal	False	True		The number of users who added a product(s) to their cart divided by the number of users who viewed the same product(s).
EcommercePurchases	Integer	False			The number of times users completed a purchase. This metric is not compatible with item-scoped dimensions.
PurchaseToViewRate	Decimal	False	True		The total cost of shipping.
ItemsPurchased	Integer	False	True		The total amount of tax. ItemPurchaseQuantity metric has been renamed to this metric.
ItemRevenue	Decimal	False	True		The total revenue from items only. Item revenue is the product of its price and quantity.
ItemsViewed	Integer	False	True		The number of units viewed for a single item. This metric counts the quantity of items in 'view_item' events.

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.

A predefined view that retrieves Ecommerce purchase item category data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• ItemCategory5 supports the following operator: =
• Date supports the following operators: =,>=,<=,<,>

For example, the following queries are processed server-side:

SELECT * FROM EcommPurchasesItemCategory5Report WHERE PropertyId = 342020667
SELECT * FROM EcommPurchasesItemCategory5Report WHERE ItemCategory4 = 'Apparel' 
SELECT * FROM EcommPurchasesItemCategory5Report WHERE Date = '01/05/2023' 
SELECT * FROM EcommPurchasesItemCategory5Report WHERE PropertyId = 342020667  AND ItemCategory5 = 'Apparel' AND Date = '01/05/2023'
SELECT * FROM EcommPurchasesItemCategory5Report WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM EcommPurchasesItemCategory5Report WHERE Date >= '01/01/2022'
SELECT * FROM EcommPurchasesItemCategory5Report WHERE Date <= '01/01/2022'
SELECT * FROM EcommPurchasesItemCategory5Report WHERE Date >  '01/01/2022'
SELECT * FROM EcommPurchasesItemCategory5Report WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
ItemCategory5	String	True		True	Hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, T-shirts is the item category5.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
ItemsAddedToCart	Integer	False	True		The number of times users added items to their shopping carts. Since AddToCarts is not compatible with item-scoped dimensions, hence this is the replacement of the AddToCarts metric.
CartToViewRate	Decimal	False	True		The number of users who added a product(s) to their cart divided by the number of users who viewed the same product(s).
EcommercePurchases	Integer	False			The number of times users completed a purchase. This metric is not compatible with item-scoped dimensions.
PurchaseToViewRate	Decimal	False	True		The total cost of shipping.
ItemsPurchased	Integer	False	True		The total amount of tax. ItemPurchaseQuantity metric has been renamed to this metric.
ItemRevenue	Decimal	False	True		The total revenue from items only. Item revenue is the product of its price and quantity.
ItemsViewed	Integer	False	True		The number of units viewed for a single item. This metric counts the quantity of items in 'view_item' events.

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.

A predefined view that retrieves Ecommerce purchase item category data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• ItemCategory supports the following operator: =
• Date supports the following operators: =,>=,<=,<,>

For example, the following queries are processed server-side:

SELECT * FROM EcommPurchasesItemCategoryReport WHERE PropertyId = 342020667
SELECT * FROM EcommPurchasesItemCategoryReport WHERE ItemCategory = 'Apparel' 
SELECT * FROM EcommPurchasesItemCategoryReport WHERE PropertyId = 342020667  AND ItemCategory = 'Apparel' AND Date = '01/05/2023'
SELECT * FROM EcommPurchasesItemCategoryReport WHERE Date = '01/05/2023' 
SELECT * FROM EcommPurchasesItemCategoryReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM EcommPurchasesItemCategoryReport WHERE Date >= '01/01/2022'
SELECT * FROM EcommPurchasesItemCategoryReport WHERE Date <= '01/01/2022'
SELECT * FROM EcommPurchasesItemCategoryReport WHERE Date >  '01/01/2022'
SELECT * FROM EcommPurchasesItemCategoryReport WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
ItemCategory	String	True		True	Hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Apparel is the item category.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
ItemsAddedToCart	Integer	False	True		The number of times users added items to their shopping carts. Since AddToCarts is not compatible with item-scoped dimensions, hence this is the replacement of the AddToCarts metric.
CartToViewRate	Decimal	False	True		The number of users who added a product(s) to their cart divided by the number of users who viewed the same product(s).
EcommercePurchases	Integer	False			The number of times users completed a purchase. This metric is not compatible with item-scoped dimensions.
PurchaseToViewRate	Decimal	False	True		The total cost of shipping.
ItemsPurchased	Integer	False	True		The total amount of tax. ItemPurchaseQuantity metric has been renamed to this metric.
ItemRevenue	Decimal	False	True		The total revenue from items only. Item revenue is the product of its price and quantity.
ItemsViewed	Integer	False	True		The number of units viewed for a single item. This metric counts the quantity of items in 'view_item' events.

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.

A predefined view that retrieves Ecommerce purchase item category data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• ItemCategory supports the following operator: =
• ItemCategory2 supports the following operator: =
• ItemCategory3 supports the following operator: =
• ItemCategory3 supports the following operator: =
• ItemCategory5 supports the following operator: =
• Date supports the following operators: =,>=,<=,<,>

For example, the following queries are processed server-side:

SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE PropertyId = 342020667
SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE ItemCategory = 'Apparel' 
SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE ItemCategory2 = 'Mens' 
SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE ItemCategory3 = 'Summer' 
SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE ItemCategory4 = 'Shirts' 
SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE ItemCategory5 = 'T-shirts' 
SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE Date = '01/05/2023' 
SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE PropertyId = 342020667  AND ItemCategory = 'Apparel' AND Date = '01/05/2023'
SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE Date >= '01/01/2022'
SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE Date <= '01/01/2022'
SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE Date >  '01/01/2022'
SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
ItemCategory	String	True		True	Hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Apparel is the item category.
ItemCategory2	String	True		True	Hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Mens is the item category2
ItemCategory3	String	True		True	Hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Summer is the item category3.
ItemCategory4	String	True		True	Hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Shirts is the item category4.
ItemCategory5	String	True		True	Hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, T-shirts is the item category5.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
ItemsAddedToCart	Integer	False	True		The number of times users added items to their shopping carts. Since AddToCarts is not compatible with item-scoped dimensions, hence this is the replacement of the AddToCarts metric.
CartToViewRate	Decimal	False	True		The number of users who added a product(s) to their cart divided by the number of users who viewed the same product(s).
EcommercePurchases	Integer	False			The number of times users completed a purchase. This metric is not compatible with item-scoped dimensions.
PurchaseToViewRate	Decimal	False	True		The total cost of shipping.
ItemsPurchased	Integer	False	True		The total amount of tax. ItemPurchaseQuantity metric has been renamed to this metric.
ItemRevenue	Decimal	False	True		The total revenue from items only. Item revenue is the product of its price and quantity.
ItemsViewed	Integer	False	True		The number of units viewed for a single item. This metric counts the quantity of items in 'view_item' events.

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.

A predefined view that retrieves Ecommerce purchase item data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• ItemId supports the following operator: =
• Date supports the following operators: =,>=,<=,<,>

For example, the following queries are processed server-side:

SELECT * FROM EcommPurchasesItemIdReport WHERE PropertyId = 342020667
SELECT * FROM EcommPurchasesItemIdReport WHERE ItemId = '1234' 
SELECT * FROM EcommPurchasesItemIdReport WHERE Date = '01/05/2023' 
SELECT * FROM EcommPurchasesItemIdReport WHERE PropertyId = 342020667  AND ItemId = '1234' AND Date = '01/05/2023'
SELECT * FROM EcommPurchasesItemIdReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM EcommPurchasesItemIdReport WHERE Date >= '01/01/2022'
SELECT * FROM EcommPurchasesItemIdReport WHERE Date <= '01/01/2022'
SELECT * FROM EcommPurchasesItemIdReport WHERE Date >  '01/01/2022'
SELECT * FROM EcommPurchasesItemIdReport WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
ItemId	String	True		True	ID of the item.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
ItemsAddedToCart	Integer	False	True		The number of times users added items to their shopping carts. Since AddToCarts is not compatible with item-scoped dimensions, hence this is the replacement of the AddToCarts metric.
CartToViewRate	Decimal	False	True		The number of users who added a product(s) to their cart divided by the number of users who viewed the same product(s).
EcommercePurchases	Integer	False			The number of times users completed a purchase. This metric is not compatible with item-scoped dimensions.
PurchaseToViewRate	Decimal	False	True		The total cost of shipping.
ItemsPurchased	Integer	False	True		The total amount of tax. ItemPurchaseQuantity metric has been renamed to this metric.
ItemRevenue	Decimal	False	True		The total revenue from items only. Item revenue is the product of its price and quantity.

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.

A predefined view that retrieves Ecommerce purchase item data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• ItemName supports the following operator: =
• Date supports the following operators: =,>=,<=,<,>

For example, the following queries are processed server-side:

SELECT * FROM EcommPurchasesItemNameReport WHERE PropertyId = 342020667
SELECT * FROM EcommPurchasesItemNameReport WHERE ItemName = 'test' 
SELECT * FROM EcommPurchasesItemNameReport WHERE Date = '01/05/2023' 
SELECT * FROM EcommPurchasesItemNameReport WHERE PropertyId = 342020667  AND ItemName = 'test' AND Date = '01/05/2023'
SELECT * FROM EcommPurchasesItemNameReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM EcommPurchasesItemNameReport WHERE Date >= '01/01/2022'
SELECT * FROM EcommPurchasesItemNameReport WHERE Date <= '01/01/2022'
SELECT * FROM EcommPurchasesItemNameReport WHERE Date >  '01/01/2022'
SELECT * FROM EcommPurchasesItemNameReport WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
ItemName	String	True		True	The name of the item.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
ItemsAddedToCart	Integer	False	True		The number of times users added items to their shopping carts. Since AddToCarts is not compatible with item-scoped dimensions, hence this is the replacement of the AddToCarts metric.
CartToViewRate	Decimal	False	True		The number of users who added a product(s) to their cart divided by the number of users who viewed the same product(s).
EcommercePurchases	Integer	False			The number of times users completed a purchase. This metric is not compatible with item-scoped dimensions.
PurchaseToViewRate	Decimal	False	True		The total cost of shipping.
ItemsPurchased	Integer	False	True		The total amount of tax. ItemPurchaseQuantity metric has been renamed to this metric.
ItemRevenue	Decimal	False	True		The total revenue from items only. Item revenue is the product of its price and quantity.

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.

A base view that retrieves Engagement data

Table Specific Information

Select

Retrieves data for Engagement report. At least one metric must be specified in the query. In the query you can also specify up to 9 dimensions. The following are example queries:

	SELECT NewUsers, TotalRevenue FROM Engagement

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. A two digit integer from 01 to 12.
Week	Integer	True			The week of the session. A two-digit number from 01 to 53. Each week starts on Sunday.
Day	Integer	True			The day of the month. A two-digit number from 01 to 31.
DayOfWeekName	String	True			The day of the week in English. This dimension has values of Sunday, Monday, etc.
IsoWeek	Integer	True			ISO week number, where each week starts on Monday. For details, see http://en.wikipedia.org/wiki/ISO_week_date. Example values include 01, 02, 53.
IsoYear	Integer	True			The ISO year of the event. For details, see http://en.wikipedia.org/wiki/ISO_week_date. Example values include 2022 2023.
IsoYearIsoWeek	Integer	True			The combined values of isoWeek and isoYear. Example values include 201652 and 201701.
YearMonth	Integer	True			The combined values of year and month. Example values include 202212 or 202301.
YearWeek	Integer	True			The combined values of year and week. Example values include 202253 or 202301.
Hour	Integer	True			A two-digit hour of the day ranging from 00-23 in the timezone configured for the account. This value is also corrected for daylight savings time.
ContentGroup	String	True			A category that applies to items of published content
EventName	String	True			The name of the event
UnifiedPageScreen	String	True			The page path (web) or screen class (app) on which the event was logged
UnifiedScreenClass	String	True		True	The page title (web) or screen class (app) on which the event was logged
UnifiedScreenName	String	True			The page title (web) or screen name (app) on which the event was logged
PagePath	String	True			The portion of the URL between the hostname and query string for web
PageTitle	String	True			The web page titles used on your site
Conversions	Decimal	False	True		The count of conversion events
EngagedSessionsPerUser	Decimal	False	True		Average number of engaged sessions per user
EventCount	Integer	False	True		The count of events
EventCountPerUser	Decimal	False	True		Average number of events triggered by each user
NewUsers	Integer	False	True		The number of users who interacted with the site or launched the app for the first time
ScreenPageViews	Integer	False	True		The number of app screens or web pages the users viewed. Repeated views of a single page or screen are counted.
TotalRevenue	Integer	False	True		The sum of revenue from purchases, subscriptions, and advertising
TotalUsers	Integer	False	True		The number of distinct users who visited the site or app
userEngagementDuration	Bigint	False	True		The total amount of time (in seconds) the website or app was in the foreground of users' device
ViewsPerUser	Decimal	False	True		Average number of screens viewed by each user
SessionsPerUser	Decimal	False	False		The average number of sessions per user (Sessions divided by Active 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).

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

A predefined view that retrieves Engagement Content Group Report data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• ContentGroup supports the following operator: =
• Date supports the following operators: =,>=,<=,<,>

For example, the following queries are processed server-side:

SELECT * FROM EngagementContentGroupReport WHERE PropertyId = 342020667
SELECT * FROM EngagementContentGroupReport WHERE ContentGroup = 'CData Test' 
SELECT * FROM EngagementContentGroupReport WHERE Date = '01/05/2023' 
SELECT * FROM EngagementContentGroupReport WHERE PropertyId = 342020667  AND ContentGroup = 'CData Test' AND Date = '01/05/2023'
SELECT * FROM EngagementContentGroupReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM EngagementContentGroupReport WHERE Date >= '01/01/2022'
SELECT * FROM EngagementContentGroupReport WHERE Date <= '01/01/2022'
SELECT * FROM EngagementContentGroupReport WHERE Date >  '01/01/2022'
SELECT * FROM EngagementContentGroupReport WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
ContentGroup	String	True		True	A category that applies to items of published content.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
Conversions	Decimal	False	True		The count of conversion events.
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.
ScreenPageViews	Integer	False	True		The number of app screens or web pages the users viewed. Repeated views of a single page or screen are counted.
TotalRevenue	Integer	False	True		The sum of revenue from purchases, subscriptions, and advertising.
TotalUsers	Integer	False	True		The number of distinct users who visited the site or app.
UserEngagementDuration	Bigint	False	True		The total amount of time (in seconds) the website or app was in the foreground of users device.

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.

A predefined view that retrieves Engagement conversions data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• EventName supports the following operator: =
• Date supports the following operators: =,>=,<=,<,>

For example, the following queries are processed server-side:

SELECT * FROM EngagementConversionsReport WHERE PropertyId = 342020667
SELECT * FROM EngagementConversionsReport WHERE EventName = 'page_view' 
SELECT * FROM EngagementConversionsReport WHERE Date = '01/05/2023' 
SELECT * FROM EngagementConversionsReport WHERE PropertyId = 342020667  AND EventName = 'page_view' AND Date = '01/05/2023'
SELECT * FROM EngagementConversionsReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM EngagementConversionsReport WHERE Date >= '01/01/2022'
SELECT * FROM EngagementConversionsReport WHERE Date <= '01/01/2022'
SELECT * FROM EngagementConversionsReport WHERE Date >  '01/01/2022'
SELECT * FROM EngagementConversionsReport WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
EventName	String	True		True	The name of the event.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
Conversions	Decimal	False	True		The count of conversion events.
EventCountPerUser	Decimal	False	True		Average number of events triggered by each user.
EventCount	Integer	False	True		The count of events.
TotalRevenue	Integer	False	True		The sum of revenue from purchases, subscriptions, and advertising.
TotalUsers	Integer	False	True		The number of distinct users who visited the site or app.

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.

A predefined view that retrieves Engagement events data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• EventName supports the following operator: =
• Date supports the following operators: =,>=,<=,<,>

For example, the following queries are processed server-side:

SELECT * FROM EngagementEventsReport WHERE PropertyId = 342020667
SELECT * FROM EngagementEventsReport WHERE EventName = 'page_view' 
SELECT * FROM EngagementEventsReport WHERE Date = '01/05/2023' 
SELECT * FROM EngagementEventsReport WHERE PropertyId = 342020667  AND EventName = 'page_view' AND Date = '01/05/2023'
SELECT * FROM EngagementEventsReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM EngagementEventsReport WHERE Date >= '01/01/2022'
SELECT * FROM EngagementEventsReport WHERE Date <= '01/01/2022'
SELECT * FROM EngagementEventsReport WHERE Date >  '01/01/2022'
SELECT * FROM EngagementEventsReport WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
EventName	String	True		True	The name of the event.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
EventCountPerUser	Decimal	False	True		Average number of events triggered by each user.
EventCount	Integer	False	True		The count of events.
TotalRevenue	Integer	False	True		The sum of revenue from purchases, subscriptions, and advertising.
TotalUsers	Integer	False	True		The number of distinct users who visited the site or app.

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	The Property Id value to be used when querying this table.

A predefined view that retrieves Engagement Pages path report data.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
PagePath	String	True		True	The portion of the URL between the hostname and query string for web.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
Conversions	Decimal	False	True		The count of conversion events.
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.
ScreenPageViews	Integer	False	True		The number of app screens or web pages the users viewed. Repeated views of a single page or screen are counted.
TotalRevenue	Integer	False	True		The sum of revenue from purchases, subscriptions, and advertising.
TotalUsers	Integer	False	True		The number of distinct users who visited the site or app.
UserEngagementDuration	Bigint	False	True		The total amount of time (in seconds) the website or app was in the foreground of users device.

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.

A predefined view that retrieves Engagement Pages title and screen class data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• UnifiedScreenClass supports the following operator: =
• Date supports the following operators: =,>=,<=,<,>

For example, the following queries are processed server-side:

SELECT * FROM EngagementPagesTitleAndScreenClassReport WHERE PropertyId = 342020667
SELECT * FROM EngagementPagesTitleAndScreenClassReport WHERE UnifiedScreenClass = 'CData Test' 
SELECT * FROM EngagementPagesTitleAndScreenClassReport WHERE Date = '01/05/2023' 
SELECT * FROM EngagementPagesTitleAndScreenClassReport WHERE PropertyId = 342020667  AND UnifiedScreenClass = 'CData Test' AND Date = '01/05/2023'
SELECT * FROM EngagementPagesTitleAndScreenClassReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM EngagementPagesTitleAndScreenClassReport WHERE Date >= '01/01/2022'
SELECT * FROM EngagementPagesTitleAndScreenClassReport WHERE Date <= '01/01/2022'
SELECT * FROM EngagementPagesTitleAndScreenClassReport WHERE Date >  '01/01/2022'
SELECT * FROM EngagementPagesTitleAndScreenClassReport WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
UnifiedScreenClass	String	True		True	The page title (web) or screen class (app) on which the event was logged.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
Conversions	Decimal	False	True		The count of conversion events.
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.
ScreenPageViews	Integer	False	True		The number of app screens or web pages the users viewed. Repeated views of a single page or screen are counted.
TotalRevenue	Integer	False	True		The sum of revenue from purchases, subscriptions, and advertising.
TotalUsers	Integer	False	True		The number of distinct users who visited the site or app.
UserEngagementDuration	Bigint	False	True		The total amount of time (in seconds) the website or app was in the foreground of users device.

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.

A predefined view that retrieves Engagement Pages Title And ScreenName data.

Select

The Sync App uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

• PropertyId supports the following operator: =
• UnifiedScreenName supports the following operator: =
• Date supports the following operators: =,>=,<=,<,>

For example, the following queries are processed server-side:

SELECT * FROM EngagementPagesTitleAndScreenNameReport WHERE PropertyId = 342020667
SELECT * FROM EngagementPagesTitleAndScreenNameReport WHERE UnifiedScreenName = 'CData Test' 
SELECT * FROM EngagementPagesTitleAndScreenNameReport WHERE Date = '01/05/2023' 
SELECT * FROM EngagementPagesTitleAndScreenNameReport WHERE PropertyId = 342020667  AND UnifiedScreenName = 'CData Test' AND Date = '01/05/2023'
SELECT * FROM EngagementPagesTitleAndScreenNameReport WHERE Date >= '01/01/2022' AND <= '01/05/2023'
SELECT * FROM EngagementPagesTitleAndScreenNameReport WHERE Date >= '01/01/2022'
SELECT * FROM EngagementPagesTitleAndScreenNameReport WHERE Date <= '01/01/2022'
SELECT * FROM EngagementPagesTitleAndScreenNameReport WHERE Date >  '01/01/2022'
SELECT * FROM EngagementPagesTitleAndScreenNameReport WHERE Date < '01/01/2022'

The rest of the filter is executed client-side in the Sync App.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
UnifiedScreenName	String	True		True	The page title (web) or screen name (app) on which the event was logged.
Date	Date	True		True	The date of the session formatted as YYYYMMDD.
Conversions	Decimal	False	True		The count of conversion events.
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.
ScreenPageViews	Integer	False	True		The number of app screens or web pages the users viewed. Repeated views of a single page or screen are counted.
TotalRevenue	Integer	False	True		The sum of revenue from purchases, subscriptions, and advertising.
TotalUsers	Integer	False	True		The number of distinct users who visited the site or app.
UserEngagementDuration	Bigint	False	True		The total amount of time (in seconds) the website or app was in the foreground of users device.

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.

A base view that retrieves Event data

Table Specific Information

Select

Retrieves data for Events reports. At least one metric must be specified in the query. This endpoint uses the real-time report API endpoint to get more up-to-date data than the standard reporting endpoint. The real-time reporting API supports a maximum of four dimensions compared to nine for the standard report API.

The following is an example query:

	SELECT EventCount, Platform FROM Events

Since PagePath and PlatTitle dimensions are not available in the runRealReport endpoint, use the connection property ReportType = reports to leverage the result with these dimensions.

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
AppVersion	String	True			The application's versionName (Android) or short bundle version (iOS)
City	String	True			The city from which the user activity originated
Country	String	True			The country from which the user activity originated
DeviceCategory	String	True			The type of device: Desktop, Tablet, or Mobile
Platform	String	True			The platform on which your app or website ran
AudienceName	String	True			The given name of an Audience
UnifiedScreenName	String	True			The page title (web) or screen name (app) on which the event was logged
EventName	String	True		True	The name of the event
PagePath	String	True			The portion of the URL between the hostname and query string for web. This works when connection property ReportType=reports;.
PageTitle	String	True			The web page titles used on your site. This works when connection property ReportType=reports;
EventCount	Integer	False	True		Number of times an individual event was triggered
Conversions	Decimal	False	True		The count of conversion events
AudienceId	Long	True			The numeric identifier of an Audience.
AudienceResourceName	String	True			The resource name of this audience.
CityId	Integer	True			The geographic ID of the city from which the user activity originated, derived from their IP address.
CountryId	String	True			The geographic ID of the country from which the user activity originated, derived from their IP address.
MinutesAgo	Integer	True			The number of minutes ago that an event was collected. 00 is the current minute, and 01 means the previous minute.
StreamId	Long	True			The numeric data stream identifier for your app or website.
StreamName	String	True			The data stream name for your app or website.

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

A base view that retrieves Games Reporting data.

Table Specific Information

Select

Retrieves data for GamesReporting report. At least one metric must be specified in the query. In the query you can also specify up to 9 dimensions.

The following is an example query:

	SELECT AveragePurchaseRevenue, AverageRevenuePerUser FROM GamesReporting

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. A two digit integer from 01 to 12.
Week	Integer	True			The week of the session. A two-digit number from 01 to 53. Each week starts on Sunday.
Day	Integer	True			The day of the month. A two-digit number from 01 to 31.
DayOfWeekName	String	True			The day of the week in English. This dimension has values of Sunday, Monday, etc.
IsoWeek	Integer	True			ISO week number, where each week starts on Monday. Example values include 01, 02, 53.
IsoYear	Integer	True			The ISO year of the event. Example values include 2022 2023.
IsoYearIsoWeek	Integer	True			The combined values of isoWeek and isoYear. Example values include 201652 and 201701.
YearMonth	Integer	True			The combined values of year and month. Example values include 202212 or 202301.
YearWeek	Integer	True			The combined values of year and week. Example values include 202253 or 202301.
Hour	Integer	True			A two-digit hour of the day ranging from 00-23 in the timezone configured for the account. This value is also corrected for daylight savings time.
AudienceName	String	True			The given name of an Audience.
FirstUserCampaignName	String	True			Name of the marketing campaign that first acquired the user.
FirstUserGoogleAdsCreativeId	String	True			The campaign creative ID that first acquired the user.
FirstUserGoogleAdsAdGroupId	String	True			The Ad Group Id in Google Ads that first acquired the user.
FirstUserGoogleAdsAdGroupName	String	True			The Ad Group Name in Google Ads that first acquired the user.
FirstUserGoogleAdsAdNetworkType	String	True			The advertising network that first acquired the user.
FirstUserMedium	String	True		True	The medium that first acquired the user to the website or app.
FirstUserSource	String	True			The source that first acquired the user to the website or app.
AveragePurchaseRevenue	Decimal	False	True		The average purchase revenue in the transaction group of events.
AveragePurchaseRevenuePerPayingUser	Decimal	False	True		Average revenue per paying user (ARPPU) is the total purchase revenue per active user that logged a purchase event. The summary metric is for the time period selected.
AverageRevenuePerUser	Decimal	False	True		Average revenue per active user (ARPU). The summary metric is for the time period selected.
EngagedSessionsPerUser	Decimal	False	True		Average number of engaged sessions per user.
FirstTimeBuyersPerNewUsers	Decimal	False	True		Percentage of unique new users to the game who made their first in-app purchase.
FirstTimePurchasers	Integer	False	True		The number of users that completed their first purchase event.
NewUsers	Integer	False	True		The number of users who interacted with the site or launched the app for the first time.
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).

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.