ADO.NET Provider for Google Analytics

Build 24.0.9062

Acquisitions

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

SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062