Google Analytics 4
Renta позволяет выгружать данные Google Analytics 4 в хранилище данных: отчёты, собранные из измерений и метрик вашего ресурса GA4, включая кастомные измерения и метрики ресурса.
Аутентификация
Renta использует OAuth для аутентификации в Google. Вы будете перенаправлены в Google, чтобы предоставить Renta ограниченный доступ к аккаунту Google Analytics.
Подключение источника Google Analytics 4
Откройте каталогStep 1
- Перейдите в раздел Connections > Catalog в левом меню.
- Откройте категорию Analytics и нажмите на карточку Google Analytics 4.
Авторизуйте подключениеStep 2
Нажмите Log in to your Google Analytics account. Вы будете перенаправлены в Google для предоставления доступа.
Выберите аккаунт GoogleStep 3
Google покажет экран выбора аккаунта. Выберите аккаунт, у которого есть доступ к вашим ресурсам Google Analytics 4, и разрешите запрошенный доступ. После этого вы вернётесь в Renta.
Назовите подключение и сохранитеStep 4
Завершите настройку:
- Source name.
Укажите название источника данных. Оно используется только в интерфейсе Renta. - Access granted.
Убедитесь, что аккаунт подключён успешно.
Нажмите Save, чтобы завершить.
Источник созданStep 5
Новый источник появится в списке Sources со статусом Active. Теперь его можно использовать в пайплайнах.
Создание пайплайна Google Analytics 4
Выберите Google Analytics 4 как источникStep 1
В левом меню нажмите New pipeline. На шаге Source выберите Google Analytics 4 в списке Already connected и нажмите Next step.
Выберите подключение Google AnalyticsStep 2
Выберите созданное ранее подключение Google Analytics и нажмите Next step.
Выберите назначениеStep 3
На шаге Destination выберите ваше назначение (например, Google BigQuery) и нажмите Next step.
Выберите подключение назначенияStep 4
Выберите подключение назначения, в которое нужно загружать данные, и нажмите Next step.
Настройка пайплайна
На финальном шаге выберите, какие данные Google Analytics 4 выгружать и как Renta будет их загружать.
Настройка отчёта
Укажите аккаунт Google Analytics и ресурс, из которого нужны данные.
- Accounts.
Выберите аккаунт Google Analytics, доступный подключённому пользователю Google. - Properties.
Выберите ресурс GA4, из которого выгружать данные. Каждый пайплайн выгружает данные одного ресурса.
Измерения и метрики
Выберите параметры GA4, которые попадут в таблицу назначения. Схема вашего датасета определяется выбранными здесь параметрами.
| Название | Имя в API | Описание |
|---|---|---|
Achievement ID text | achievementId | The achievement ID in a game for an event. Populated by the event parameter 'achievement_id'. |
Ad format text | adFormat | Describes the way ads looked and where they were located. Typical formats include 'Interstitial', 'Banner', 'Rewarded', and 'Native advanced'. |
Ad source text | adSourceName | The source network that served the ad. Typical sources include 'AdMob Network', 'Liftoff', 'Facebook Audience Network', and 'Mediated house ads'. |
Ad unit text | adUnitName | The name you chose to describe this Ad unit. Ad units are containers you place in your apps to show ads to users. |
App version text | appVersion | The app's versionName (Android) or short bundle version (iOS). |
Audience ID text | audienceId | The numeric identifier of an Audience. Users are reported in the audiences to which they belonged during the report's date range. Current user behavior does not affect historical audience membership in reports. |
Audience name text | audienceName | The given name of an Audience. Users are reported in the audiences to which they belonged during the report's date range. Current user behavior does not affect historical audience membership in reports. |
Interests text | brandingInterest | Interests demonstrated by users who are higher in the shopping funnel. Users can be counted in multiple interest categories. For example, 'Shoppers', 'Lifestyles & Hobbies/Pet Lovers', or 'Travel/Travel Buffs/Beachbound Travelers'. |
Browser text | browser | The browsers used to view your website. |
Campaign ID text | campaignId | The identifier of the marketing campaign. Present only for conversion events. Includes Google Ads Campaigns, Manual Campaigns, & other Campaigns. |
Campaign text | campaignName | The name of the marketing campaign. Present only for conversion events. Includes Google Ads Campaigns, Manual Campaigns, & other Campaigns. |
Character text | character | The player character in a game for an event. Populated by the event parameter 'character'. |
City text | city | The city from which the user activity originated. |
City ID text | cityId | The geographic ID of the city from which the user activity originated, derived from their IP address. |
Cohort text | cohort | The cohort's name in the request. A cohort is a set of users who started using your website or app in any consecutive group of days. If a cohort name is not specified in the request, cohorts are named by their zero based index: cohort_0, cohort_1, etc. |
Daily cohort text | cohortNthDay | Day offset relative to the firstSessionDate for the users in the cohort. For example, if a cohort is selected with the start and end date of 2020-03-01, then for the date 2020-03-02, cohortNthDay will be 0001. |
Monthly cohort text | cohortNthMonth | Month offset relative to the firstSessionDate for the users in the cohort. Month boundaries align with calendar month boundaries. For example, if a cohort is selected with the start and end date in March 2020, then for any date in April 2020, cohortNthMonth will be 0001. |
Weekly cohort text | cohortNthWeek | Week offset relative to the firstSessionDate for the users in the cohort. Weeks start on Sunday and end on Saturday. For example, if a cohort is selected with the start and end date in the range 2020-11-08 to 2020-11-14, then for the dates in the range 2020-11-15 to 2020-11-21, cohortNthWeek will be 0001. |
Content group text | contentGroup | A category that applies to items of published content. Populated by the event parameter 'content_group'. |
Content ID text | contentId | The identifier of the selected content. Populated by the event parameter 'content_id'. |
Content type text | contentType | The category of the selected content. Populated by the event parameter 'content_type'. |
Continent text | continent | The continent from which the user activity originated. For example, 'Americas' or 'Asia'. |
Continent ID text | continentId | The geographic ID of the continent from which the user activity originated, derived from their IP address. |
Country text | country | The country from which the user activity originated. |
Country ID text | countryId | The geographic ID of the country from which the user activity originated, derived from their IP address. Formatted according to ISO 3166-1 alpha-2 standard. |
Date date | date | The date of the event, formatted as YYYYMMDD. |
Date + hour (YYYYMMDDHH) text | dateHour | The combined values of date and hour formatted as YYYYMMDDHH. |
Date hour and minute text | dateHourMinute | The combined values of date, hour, and minute formatted as YYYYMMDDHHMM. |
Day text | day | The day of the month, a two-digit number from 01 to 31. |
Day of week text | dayOfWeek | The integer day of the week. It returns values in the range [0,6] with Sunday as the first day of the week. |
Day of week name text | dayOfWeekName | The day of the week in English. This dimension has values of Sunday, Monday, etc. |
Default channel group text | defaultChannelGroup | The conversion's default channel group is based primarily on source and medium. An enumeration which includes 'Direct', 'Organic Search', 'Paid Social', 'Organic Social', 'Email', 'Affiliates', 'Referral', 'Paid Search', 'Video', and 'Display'. |
Device category text | deviceCategory | The type of device: Desktop, Tablet, or Mobile. |
Device model text | deviceModel | The mobile device model (example: iPhone 10,6). |
Event name text | eventName | The name of the event. |
File extension text | fileExtension | The extension of the downloaded file (for example, 'pdf' or 'txt'). Automatically populated if Enhanced Measurement is enabled. Populated by the event parameter 'file_extension'. |
File name text | fileName | The page path of the downloaded file (for example, '/menus/dinner-menu.pdf'). Automatically populated if Enhanced Measurement is enabled. Populated by the event parameter 'file_name'. |
First session date text | firstSessionDate | The date the user's first session occurred, formatted as YYYYMMDD. |
First user campaign ID text | firstUserCampaignId | Identifier of the marketing campaign that first acquired the user. Includes Google Ads Campaigns, Manual Campaigns, & other Campaigns. |
First user campaign text | firstUserCampaignName | Name of the marketing campaign that first acquired the user. Includes Google Ads Campaigns, Manual Campaigns, & other Campaigns. |
First user default channel group text | firstUserDefaultChannelGroup | The default channel group that first acquired the user. Default channel group is based primarily on source and medium. An enumeration which includes 'Direct', 'Organic Search', 'Paid Social', 'Organic Social', 'Email', 'Affiliates', 'Referral', 'Paid Search', 'Video', and 'Display'. |
First user Google Ads account name text | firstUserGoogleAdsAccountName | The Account name from Google Ads that first acquired the user. |
First user Google Ads ad group ID text | firstUserGoogleAdsAdGroupId | The Ad Group Id in Google Ads that first acquired the user. |
First user Google Ads ad group name text | firstUserGoogleAdsAdGroupName | The Ad Group Name in Google Ads that first acquired the user. |
First user Google Ads ad network type text | firstUserGoogleAdsAdNetworkType | The advertising network that first acquired the user. An enumeration which includes 'Google search', 'Search partners', 'Google Display Network', 'Youtube Search', 'Youtube Videos', 'Cross-network', 'Social', and '(universal campaign)'. |
First user Google Ads campaign ID text | firstUserGoogleAdsCampaignId | Identifier of the Google Ads marketing campaign that first acquired the user. |
First user Google Ads campaign text | firstUserGoogleAdsCampaignName | Name of the Google Ads marketing campaign that first acquired the user. |
First user Google Ads campaign type text | firstUserGoogleAdsCampaignType | The campaign type of the Google Ads campaign that first acquired the user. Campaign types determine where customers see your ads and the settings and options available to you in Google Ads. Campaign type is an enumeration that includes: Search, Display, Shopping, Video, Discovery, App, Smart, Hotel, Local, and Performance Max. To learn more, see <https://support.google.com/google-ads/answer/2567043>. |
First user Google Ads creative ID text | firstUserGoogleAdsCreativeId | The ID of the Google Ads creative that first acquired the user. Creative IDs identify individual ads. |
First user Google Ads customer ID text | firstUserGoogleAdsCustomerId | The Customer ID from Google Ads that first acquired the user. Customer IDs in Google Ads uniquely identify Google Ads accounts. |
First user Google Ads keyword text text | firstUserGoogleAdsKeyword | The matched keyword that first acquired the user. Keywords are words or phrases describing your product or service that you choose to get your ad in front of the right customers. To learn more about Keywords, see <https://support.google.com/google-ads/answer/6323>. |
First user Google Ads query text | firstUserGoogleAdsQuery | The search query that first acquired the user. |
First user manual ad content text | firstUserManualAdContent | The ad content that first acquired the user. Populated by the utm_content parameter. |
First user manual term text | firstUserManualTerm | The term that first acquired the user. Populated by the utm_term parameter. |
First user medium text | firstUserMedium | The medium that first acquired the user to your website or app. |
First user source text | firstUserSource | The source that first acquired the user to your website or app. |
First user source / medium text | firstUserSourceMedium | The combined values of the dimensions 'firstUserSource' and 'firstUserMedium'. |
First user source platform text | firstUserSourcePlatform | The source platform that first acquired the user. Please do not depend on this field returning 'Manual' for traffic that uses UTMs; this field will update from returning 'Manual' to returning '(not set)' for an upcoming feature launch. |
Full page URL text | fullPageUrl | The hostname, page path, and query string for web pages visited; for example, the fullPageUrl portion of https://www.example.com/store/contact-us?query_string=true is www.example.com/store/contact-us?query_string=true. |
Google Ads account name text | googleAdsAccountName | The Account name from Google Ads for the campaign that led to the conversion event. Corresponds to customer.descriptive_name in the Google Ads API. |
Google Ads ad group ID text | googleAdsAdGroupId | The ad group id attributed to the conversion event. |
Google Ads ad group name text | googleAdsAdGroupName | The ad group name attributed to the conversion event. |
Google Ads ad network type text | googleAdsAdNetworkType | The advertising network type of the conversion. An enumeration which includes 'Google search', 'Search partners', 'Google Display Network', 'Youtube Search', 'Youtube Videos', 'Cross-network', 'Social', and '(universal campaign)'. |
Google Ads campaign ID text | googleAdsCampaignId | The campaign ID for the Google Ads campaign attributed to the conversion event. |
Google Ads campaign text | googleAdsCampaignName | The campaign name for the Google Ads campaign attributed to the conversion event. |
Google Ads campaign type text | googleAdsCampaignType | The campaign type for the Google Ads campaign attributed to the conversion event. Campaign types determine where customers see your ads and the settings and options available to you in Google Ads. Campaign type is an enumeration that includes: Search, Display, Shopping, Video, Discovery, App, Smart, Hotel, Local, and Performance Max. To learn more, see <https://support.google.com/google-ads/answer/2567043>. |
Google Ads creative ID text | googleAdsCreativeId | The ID of the Google Ads creative attributed to the conversion event. Creative IDs identify individual ads. |
Google Ads customer ID text | googleAdsCustomerId | The Customer ID from Google Ads for the campaign that led to conversion event. Customer IDs in Google Ads uniquely identify Google Ads accounts. |
Google Ads keyword text text | googleAdsKeyword | The matched keyword that led to the conversion event. Keywords are words or phrases describing your product or service that you choose to get your ad in front of the right customers. To learn more about Keywords, see <https://support.google.com/google-ads/answer/6323>. |
Google Ads query text | googleAdsQuery | The search query that led to the conversion event. |
Group ID text | groupId | The player group ID in a game for an event. Populated by the event parameter 'group_id'. |
Hostname text | hostName | Includes the subdomain and domain names of a URL; for example, the Host Name of www.example.com/contact.html is www.example.com. |
Hour text | hour | The two-digit hour of the day that the event was logged. This dimension ranges from 0-23 and is reported in your property's timezone. |
Is conversion event text | isConversionEvent | The string 'true' if the event is a conversion. Events are marked as conversions at collection time; changes to an event's conversion marking apply going forward. You can mark any event as a conversion in Google Analytics, and some events (i.e. first_open, purchase) are marked as conversions by default. To learn more, see <https://support.google.com/analytics/answer/9267568>. |
ISO week of the year text | isoWeek | 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. |
ISO year text | isoYear | The ISO year of the event. For details, see http://en.wikipedia.org/wiki/ISO_week_date. Example values include 2022 & 2023. |
ISO week of ISO year text | isoYearIsoWeek | The combined values of isoWeek and isoYear. Example values include 201652 & 201701. |
Item affiliation text | itemAffiliation | The name or code of the affiliate (partner/vendor; if any) associated with an individual item. Populated by the 'affiliation' item parameter. |
Item brand text | itemBrand | Brand name of the item. |
Item category text | itemCategory | The hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Apparel is the item category. |
Item category 2 text | itemCategory2 | The hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Mens is the item category 2. |
Item category 3 text | itemCategory3 | The hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Summer is the item category 3. |
Item category 4 text | itemCategory4 | The hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Shirts is the item category 4. |
Item category 5 text | itemCategory5 | The hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, T-shirts is the item category 5. |
Item ID text | itemId | The ID of the item. |
Item list ID text | itemListId | The ID of the item list. |
Item list name text | itemListName | The name of the item list. |
Item list position text | itemListPosition | The position of an item (e.g., a product you sell) in a list. This dimension is populated in tagging by the 'index' parameter in the items array. |
Item location ID text | itemLocationID | The physical location associated with the item (e.g. the physical store location). It's recommended to use the Google Place ID that corresponds to the associated item. A custom location ID can also be used. This field is populated in tagging by the 'location_id' parameter in the items array. |
Item name text | itemName | The name of the item. |
Item promotion creative name text | itemPromotionCreativeName | The name of the item-promotion creative. |
Item promotion creative slot text | itemPromotionCreativeSlot | The name of the promotional creative slot associated with the item. This dimension can be specified in tagging by the 'creative_slot' parameter at the event or item level. If the parameter is specified at both the event & item level, the item-level parameter is used. |
Item promotion ID text | itemPromotionId | The ID of the item promotion. |
Item promotion name text | itemPromotionName | The name of the promotion for the item. |
Item variant text | itemVariant | The specific variation of a product. e.g., XS, S, M, L for size; or Red, Blue, Green, Black for color. Populated by the 'item_variant' parameter. |
Landing page + query string text | landingPagePlusQueryString | The page path + query string associated with the first pageview in a session. |
Language text | language | The language setting of the user's browser or device. e.g. English |
Language code text | languageCode | The language setting (ISO 639) of the user's browser or device. e.g. 'en-us' |
Level text | level | The player's level in a game. Populated by the event parameter 'level'. |
Link classes text | linkClasses | The HTML class attribute for an outbound link. For example if a user clicks a link '<a class="center" href="www.youtube.com">', this dimension will return 'center'. Automatically populated if Enhanced Measurement is enabled. Populated by the event parameter 'link_classes'. |
Link domain text | linkDomain | The destination domain of the outbound link. For example if a user clicks a link '<a href="www.youtube.com">', this dimension will return 'youtube.com'. Automatically populated if Enhanced Measurement is enabled. Populated by the event parameter 'link_domain'. |
Link ID text | linkId | The HTML id attribute for an outbound link or file download. For example if a user clicks a link '<a id="socialLinks" href="www.youtube.com">', this dimension will return 'socialLinks'. Automatically populated if Enhanced Measurement is enabled. Populated by the event parameter 'link_id'. |
Link text text | linkText | The link text of the file download. Automatically populated if Enhanced Measurement is enabled. Populated by the event parameter 'link_text'. |
Link URL text | linkUrl | The full url for an outbound link or file download. For example if a user clicks a link '<a href="https://www.youtube.com/results?search_query=analytics">', this dimension will return 'https://www.youtube.com/results?search_query=analytics'. Automatically populated if Enhanced Measurement is enabled. Populated by the event parameter 'link_url'. |
Manual ad content text | manualAdContent | The ad content attributed to the conversion event. Populated by the utm_content parameter. |
Manual term text | manualTerm | The term attributed to the conversion event. Populated by the utm_term parameter. |
Medium text | medium | The medium attributed to the conversion event. |
Method text | method | The method by which an event was triggered. Populated by the event parameter 'method'. |
Minute text | minute | The two-digit minute of the hour that the event was logged. This dimension ranges from 0-59 and is reported in your property's timezone. |
Device brand text | mobileDeviceBranding | Manufacturer or branded name (examples: Samsung, HTC, Verizon, T-Mobile). |
Device text | mobileDeviceMarketingName | The branded device name (examples: Galaxy S10 or P30 Pro). |
Mobile model text | mobileDeviceModel | The mobile device model name (examples: iPhone X or SM-G950F). |
Month text | month | The month of the event, a two digit integer from 01 to 12. |
New / returning text | newVsReturning | New users have 0 previous sessions, and returning users have 1 or more previous sessions. This dimension returns two values: 'new' or 'returning'. |
Nth day text | nthDay | The number of days since the start of the date range. |
Nth hour text | nthHour | The number of hours since the start of the date range. The starting hour is 0000. |
Nth minute text | nthMinute | The number of minutes since the start of the date range. The starting minute is 0000. |
Nth month text | nthMonth | The number of months since the start of a date range. The starting month is 0000. |
Nth week text | nthWeek | A number representing the number of weeks since the start of a date range. |
Nth year text | nthYear | The number of years since the start of the date range. The starting year is 0000. |
Operating system text | operatingSystem | The operating systems used by visitors to your app or website. Includes desktop and mobile operating systems such as Windows and Android. |
OS version text | operatingSystemVersion | The operating system versions used by visitors to your website or app. For example, Android 10's version is 10, and iOS 13.5.1's version is 13.5.1. |
Operating system with version text | operatingSystemWithVersion | The operating system and version. For example, Android 10 or Windows 7. |
Order coupon text | orderCoupon | Code for the order-level coupon. |
Outbound text | outbound | Returns 'true' if the link lead to a site is not a part of the property’s domain. Automatically populated if Enhanced Measurement is enabled. Populated by the event parameter 'outbound'. |
Page location text | pageLocation | The protocol, hostname, page path, and query string for web pages visited; for example, the pageLocation portion of https://www.example.com/store/contact-us?query_string=true is https://www.example.com/store/contact-us?query_string=true. Populated by the event parameter 'page_location'. |
Page path text | pagePath | The portion of the URL between the hostname and query string for web pages visited; for example, the pagePath portion of https://www.example.com/store/contact-us?query_string=true is /store/contact-us. |
Page path + query string text | pagePathPlusQueryString | The portion of the URL following the hostname for web pages visited; for example, the pagePathPlusQueryString portion of https://www.example.com/store/contact-us?query_string=true is /store/contact-us?query_string=true. |
Page referrer text | pageReferrer | The full referring URL including the hostname and path. This referring URL is the user's previous URL and can be this website's domain or other domains. Populated by the event parameter 'page_referrer'. |
Page title text | pageTitle | The web page titles used on your site. |
Percent scrolled text | percentScrolled | The percentage down the page that the user has scrolled (for example, '90'). Automatically populated if Enhanced Measurement is enabled. Populated by the event parameter 'percent_scrolled'. |
Platform text | platform | The platform on which your app or website ran; for example, web, iOS, or Android. To determine a stream's type in a report, use both platform and streamId. |
Platform / device category text | platformDeviceCategory | The platform and type of device on which your website or mobile app ran. (example: Android / mobile) |
Region text | region | The geographic region from which the user activity originated, derived from their IP address. |
Screen resolution text | screenResolution | The screen resolution of the user's monitor. For example, 1920x1080. |
Search term text | searchTerm | The term searched by the user. For example if the user visits '/some-page.html?q=some-term', this dimension returns 'some-term'. Automatically populated if Enhanced Measurement is enabled. Populated by the event parameter 'search_term'. |
Session campaign ID text | sessionCampaignId | The marketing campaign id for a session. Includes Google Ads Campaigns, Manual Campaigns, & other Campaigns. |
Session campaign text | sessionCampaignName | The marketing campaign name for a session. Includes Google Ads Campaigns, Manual Campaigns, & other Campaigns. |
Session default channel group text | sessionDefaultChannelGroup | The session's default channel group is based primarily on source and medium. An enumeration which includes 'Direct', 'Organic Search', 'Paid Social', 'Organic Social', 'Email', 'Affiliates', 'Referral', 'Paid Search', 'Video', and 'Display'. |
Session Google Ads account name text | sessionGoogleAdsAccountName | The Account name from Google Ads that led to the session. Corresponds to customer.descriptive_name in the Google Ads API. |
Session Google Ads ad group ID text | sessionGoogleAdsAdGroupId | The Ad Group Id in Google Ads for a session. |
Session Google Ads ad group name text | sessionGoogleAdsAdGroupName | The Ad Group Name in Google Ads for a session. |
Session Google Ads ad network type text | sessionGoogleAdsAdNetworkType | The advertising network that led to the session. An enumeration which includes 'Google search', 'Search partners', 'Google Display Network', 'Youtube Search', 'Youtube Videos', 'Cross-network', 'Social', and '(universal campaign)'. |
Session Google Ads campaign ID text | sessionGoogleAdsCampaignId | The Campaign ID for the Google Ads Campaign that led to this session. |
Session Google Ads campaign text | sessionGoogleAdsCampaignName | The Campaign name for the Google Ads Campaign that led to this session. |
Session Google Ads campaign type text | sessionGoogleAdsCampaignType | The campaign type for the Google Ads campaign that led to this session. Campaign types determine where customers see your ads and the settings and options available to you in Google Ads. Campaign type is an enumeration that includes: Search, Display, Shopping, Video, Discovery, App, Smart, Hotel, Local, and Performance Max. To learn more, see <https://support.google.com/google-ads/answer/2567043>. |
Session Google Ads creative ID text | sessionGoogleAdsCreativeId | The ID of the Google Ads creative that lead to a session on your website or app. Creative IDs identify individual ads. |
Session Google Ads customer ID text | sessionGoogleAdsCustomerId | The Customer ID from Google Ads that led to the session. Customer IDs in Google Ads uniquely identify Google Ads accounts. |
Session Google Ads keyword text text | sessionGoogleAdsKeyword | The matched keyword that led to the session. Keywords are words or phrases describing your product or service that you choose to get your ad in front of the right customers. To learn more about Keywords, see <https://support.google.com/google-ads/answer/6323>. |
Session Google Ads query text | sessionGoogleAdsQuery | The search query that led to the session. |
Session manual ad content text | sessionManualAdContent | The ad content that led to a session. Populated by the utm_content parameter. |
Session manual term text | sessionManualTerm | The term that led to a session. Populated by the utm_term parameter. |
Session medium text | sessionMedium | The medium that initiated a session on your website or app. |
Session SA360 ad group name text | sessionSa360AdGroupName | The Ad Group name from Search Ads 360 that led to this session. |
Session SA360 campaign ID text | sessionSa360CampaignId | The Campaign ID from Search Ads 360 that led to this session. |
Session SA360 campaign text | sessionSa360CampaignName | The Campaign name from Search Ads 360 that led to this session. |
Session SA360 creative format text | sessionSa360CreativeFormat | The type of creative in Search Ads 360 that led to this session. For example, 'Responsive search ad' or 'Expanded text ad'. To learn more, see GA4 Traffic Source Dimensions. |
Session SA360 engine account ID text | sessionSa360EngineAccountId | The ID of the engine account in SA360 that led to this session. |
Session SA360 engine account name text | sessionSa360EngineAccountName | The name of the engine account in SA360 that led to this session. |
Session SA360 engine account type text | sessionSa360EngineAccountType | The type of the engine account in Search Ads 360 that led to this session. For example, 'google ads', 'bing', or 'baidu'. |
Session SA360 keyword text text | sessionSa360Keyword | The search engine keyword from Search Ads 360 that led to this session. |
Session SA360 medium text | sessionSa360Medium | The search engine keyword from Search Ads 360 that led to this session. For example, 'cpc'. |
Session SA360 query text | sessionSa360Query | The search query from Search Ads 360 that led to this session. |
Session SA360 source text | sessionSa360Source | The source of the traffic from Search Ads 360 that led to this session. For example, 'example.com' or 'google'. |
Session source text | sessionSource | The source that initiated a session on your website or app. |
Session source / medium text | sessionSourceMedium | The combined values of the dimensions 'sessionSource' and 'sessionMedium'. |
Session source platform text | sessionSourcePlatform | The source platform of the session's campaign. Please do not depend on this field returning 'Manual' for traffic that uses UTMs; this field will update from returning 'Manual' to returning '(not set)' for an upcoming feature launch. |
Shipping tier text | shippingTier | The shipping tier (e.g. Ground, Air, Next-day) selected for delivery of the purchased item. Populated by the 'shipping_tier' event parameter. |
Signed in with user ID text | signedInWithUserId | The string 'yes' if the user signed in with the User-ID feature. To learn more about User-ID, see <https://support.google.com/analytics/answer/9213390>. |
Source text | source | The source attributed to the conversion event. |
Source / medium text | sourceMedium | The combined values of the dimensions 'source' and 'medium'. |
Source platform text | sourcePlatform | The source platform of the conversion event's campaign. Please do not depend on this field returning 'Manual' for traffic that uses UTMs; this field will update from returning 'Manual' to returning '(not set)' for an upcoming feature launch. |
Stream ID text | streamId | The numeric data stream identifier for your app or website. |
Stream name text | streamName | The data stream name for your app or website. |
Test data filter ID text | testDataFilterId | The numeric identifier of a data filter in testing state. You use data filters to include or exclude event data from your reports based on event-parameter values. To learn more, see <https://support.google.com/analytics/answer/10108813>. |
Test data filter name text | testDataFilterName | The name of data filters in testing state. You use data filters to include or exclude event data from your reports based on event-parameter values. To learn more, see <https://support.google.com/analytics/answer/10108813>. |
Transaction ID text | transactionId | The ID of the ecommerce transaction. |
Page path and screen class text | unifiedPagePathScreen | The page path (web) or screen class (app) on which the event was logged. |
Page path + query string and screen class text | unifiedPageScreen | The page path and query string (web) or screen class (app) on which the event was logged. |
Page title and screen class text | unifiedScreenClass | The page title (web) or screen class (app) on which the event was logged. |
Page title and screen name text | unifiedScreenName | The page title (web) or screen name (app) on which the event was logged. |
Age text | userAgeBracket | User age brackets. |
Gender text | userGender | User gender. |
Video provider text | videoProvider | The source of the video (for example, 'youtube'). Automatically populated for embedded videos if Enhanced Measurement is enabled. Populated by the event parameter 'video_provider'. |
Video title text | videoTitle | The title of the video. Automatically populated for embedded videos if Enhanced Measurement is enabled. Populated by the event parameter 'video_title'. |
Video URL text | videoUrl | The url of the video. Automatically populated for embedded videos if Enhanced Measurement is enabled. Populated by the event parameter 'video_url'. |
Virtual currency name text | virtualCurrencyName | The name of a virtual currency with which the user is interacting. i.e. spending or purchasing gems in a game. Populated by the 'virtual_currency_name' event parameter. |
Visible text | visible | Returns 'true' if the content is visible. Automatically populated for embedded videos if Enhanced Measurement is enabled. Populated by the event parameter 'visible'. |
Week text | week | The week of the event, a two-digit number from 01 to 53. Each week starts on Sunday. January 1st is always in week 01. The first and last week of the year have fewer than 7 days in most years. Weeks other than the first and the last week of the year always have 7 days. For years where January 1st is a Sunday, the first week of that year and the last week of the prior year have 7 days. |
Year text | year | The four-digit year of the event e.g. 2020. |
Year month text | yearMonth | The combined values of year and month. Example values include 202212 or 202301. |
Year week text | yearWeek | The combined values of year and week. Example values include 202253 or 202301. |
| Название | Имя в API | Описание |
|---|---|---|
1-day active users integer | active1DayUsers | The number of distinct active users on your site or app within a 1 day period. The 1 day period includes the last day in the report's date range. Note: this is the same as Active Users. |
28-day active users integer | active28DayUsers | The number of distinct active users on your site or app within a 28 day period. The 28 day period includes the last day in the report's date range. |
7-day active users integer | active7DayUsers | The number of distinct active users on your site or app within a 7 day period. The 7 day period includes the last day in the report's date range. |
Active users integer | activeUsers | The number of distinct users who visited your site or app. |
Add to carts integer | addToCarts | The number of times users added items to their shopping carts. |
Ad unit exposure milliseconds | adUnitExposure | The time that an ad unit was exposed to a user, in milliseconds. |
Ads clicks integer | advertiserAdClicks | Total number of times users have clicked on an ad to reach the property. Includes clicks from linked integrations like linked Search Ads 360 advertisers. Also includes uploaded clicks from data import. |
Ads cost currency | advertiserAdCost | The total amount you paid for your ads. Includes costs from linked integrations like linked Google Ads accounts. Also includes uploaded cost from data import; to learn more, see Import cost data. |
Ads cost per click currency | advertiserAdCostPerClick | Ads cost per click is ad cost divided by ad clicks and is often abbreviated CPC. |
Cost per conversion currency | advertiserAdCostPerConversion | Cost per conversion is ad cost divided by conversions. |
Ads impressions integer | advertiserAdImpressions | The total number of impressions. Includes impressions from linked integrations like linked Display & Video 360 advertisers. Also includes uploaded impressions from data import. |
Average purchase revenue currency | averagePurchaseRevenue | The average purchase revenue in the transaction group of events. |
ARPPU currency | averagePurchaseRevenuePerPayingUser | 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. |
Average purchase revenue per user currency | averagePurchaseRevenuePerUser | The average purchase revenue per active user is the total purchase revenue per active user that logged any event. The summary metric is for the time period selected. |
ARPU currency | averageRevenuePerUser | Average revenue per active user (ARPU). The summary metric is for the time period selected. ARPU uses Total Revenue and includes AdMob estimated earnings. |
Average session duration seconds | averageSessionDuration | The average duration (in seconds) of users' sessions. |
Bounce rate float | bounceRate | The percentage of sessions that were not engaged ((Sessions Minus Engaged sessions) divided by Sessions). This metric is returned as a fraction; for example, 0.2761 means 27.61% of sessions were bounces. |
Cart-to-view rate float | cartToViewRate | The number of users who added a product(s) to their cart divided by the number of users who viewed the same product(s). This metric is returned as a fraction; for example, 0.1132 means 11.32% of users who viewed a product also added the same product to their cart. |
Checkouts integer | checkouts | The number of times users started the checkout process. This metric counts the occurrence of the 'begin_checkout' event. |
Cohort active users integer | cohortActiveUsers | The number of users in the cohort who are active in the time window corresponding to the cohort nth day/week/month. For example for the row where cohortNthWeek = 0001, this metric is the number of users (in the cohort) who are active in week 1. |
Cohort total users integer | cohortTotalUsers | The total number of users in the cohort. This metric is the same value in every row of the report for each cohort. Because cohorts are defined by a shared acquisition date, cohortTotalUsers is the same as cohortActiveUsers for the cohort's selection date range. For report rows later than the ochort's selection range, it is typical for cohortActiveUsers to be smaller than cohortTotalUsers. This difference represents users from the cohort that were not active for the later date. cohortTotalUsers is commonly used in the metric expression cohortActiveUsers/cohortTotalUsers to compute a user retention fraction for the cohort. The relationship between activeUsers and totalUsers is not equivalent to the relationship between cohortActiveUsers and cohortTotalUsers. |
Conversions float | conversions | The count of conversion events. Events are marked as conversions at collection time; changes to an event's conversion marking apply going forward. You can mark any event as a conversion in Google Analytics, and some events (i.e. first_open, purchase) are marked as conversions by default. To learn more, see <https://support.google.com/analytics/answer/9267568>. |
Crash-affected users integer | crashAffectedUsers | The number of users that logged a crash in this row of the report. For example if the report is time series by date, this metrics reports total users with at least one crash on this date. Crashes are events with the name "app_exception". |
Crash-free users rate integer | crashFreeUsersRate | The number of users without crash events (in this row of the report) divided by the total number of users. This metric is returned as a fraction; for example, 0.9243 means 92.43% of users were crash-free. |
DAU / MAU float | dauPerMau | The rolling percent of 30-day active users who are also 1-day active users. This metric is returned as a fraction; for example, 0.113 means 11.3% of 30-day active users were also 1-day active users. |
DAU / WAU float | dauPerWau | The rolling percent of 7-day active users who are also 1-day active users. This metric is returned as a fraction; for example, 0.082 means 8.2% of 7-day active users were also 1-day active users. |
Ecommerce purchases integer | ecommercePurchases | The number of times users completed a purchase. This metric counts 'purchase' events; this metric does not count 'in_app_purchase' and subscription events. |
Engaged sessions integer | engagedSessions | The number of sessions that lasted longer than 10 seconds, or had a conversion event, or had 2 or more screen views. |
Engagement rate float | engagementRate | The percentage of engaged sessions (Engaged sessions divided by Sessions). This metric is returned as a fraction; for example, 0.7239 means 72.39% of sessions were engaged sessions. |
Event count integer | eventCount | The count of events. |
Event count per user float | eventCountPerUser | The average number of events per user (Event count divided by Active users). |
Events per session float | eventsPerSession | The average number of events per session (Event count divided by Sessions). |
Event value float | eventValue | The sum of the event parameter named 'value'. |
First-time purchaser conversion float | firstTimePurchaserConversionRate | The percentage of active users who made their first purchase. This metric is returned as a fraction; for example, 0.092 means 9.2% of active users were first time purchasers. |
First time purchasers integer | firstTimePurchasers | The number of users that completed their first purchase event. |
First-time purchasers per new user float | firstTimePurchasersPerNewUser | The average number of first time purchasers per new user. |
Item-list click events integer | itemListClickEvents | The number of times users clicked an item when it appeared in a list. This metric counts the occurrence of the 'select_item' event. |
Item list click through rate float | itemListClickThroughRate | The number of users who selected a list(s) divided by the number of users who viewed the same list(s). This metric is returned as a fraction; for example, 0.2145 means 21.45% of users who viewed a list also selected the same list. |
Item-list view events integer | itemListViewEvents | The number of times the item list was viewed. This metric counts the occurrence of the 'view_item_list' event. |
Item promotion click through rate float | itemPromotionClickThroughRate | The number of users who selected a promotion(s) divided by the number of users who viewed the same promotion(s). This metric is returned as a fraction; for example, 0.1382 means 13.82% of users who viewed a promotion also selected the promotion. |
Item revenue currency | itemRevenue | The total revenue from items only. Item revenue is the product of its price and quantity. Item revenue excludes tax and shipping values; tax & shipping values are specified at the event and not item level. |
Items added to cart integer | itemsAddedToCart | The number of units added to cart for a single item. This metric counts the quantity of items in 'add_to_cart' events. |
Items checked out integer | itemsCheckedOut | The number of units checked out for a single item. This metric counts the quantity of items in 'begin_checkout' events. |
Items clicked in list integer | itemsClickedInList | The number of units clicked in list for a single item. This metric counts the quantity of items in 'select_item' events. |
Items clicked in promotion integer | itemsClickedInPromotion | The number of units clicked in promotion for a single item. This metric counts the quantity of items in 'select_promotion' events. |
Items purchased integer | itemsPurchased | The number of units for a single item included in purchase events. This metric counts the quantity of items in purchase events. |
Items viewed integer | itemsViewed | The number of units viewed for a single item. This metric counts the quantity of items in 'view_item' events. |
Items viewed in list integer | itemsViewedInList | The number of units viewed in list for a single item. This metric counts the quantity of items in 'view_item_list' events. |
Items viewed in promotion integer | itemsViewedInPromotion | The number of units viewed in promotion for a single item. This metric counts the quantity of items in 'view_promotion' events. |
Item view events integer | itemViewEvents | The number of times the item details were viewed. The metric counts the occurrence of the 'view_item' event. |
New users integer | newUsers | The number of users who interacted with your site or launched your app for the first time (event triggered: first_open or first_visit). |
Organic google search average position float | organicGoogleSearchAveragePosition | The average ranking of your website URLs for the query reported from Search Console. For example, if your site's URL appears at position 3 for one query and position 7 for another query, the average position would be 5 (3+7/2). This metric requires an active Search Console link. |
Organic google search clicks integer | organicGoogleSearchClicks | The number of organic Google Search clicks reported from Search Console. This metric requires an active Search Console link. |
Organic google search click through rate float | organicGoogleSearchClickThroughRate | The organic Google Search click through rate reported from Search Console. Click through rate is clicks per impression. This metric is returned as a fraction; for example, 0.0588 means about 5.88% of impressions resulted in a click. This metric requires an active Search Console link. |
Organic google search impressions integer | organicGoogleSearchImpressions | The number of organic Google Search impressions reported from Search Console. This metric requires an active Search Console link. |
Promotion clicks integer | promotionClicks | The number of times an item promotion was clicked. This metric counts the occurrence of the 'select_promotion' event. |
Promotion views integer | promotionViews | The number of times an item promotion was viewed. This metric counts the occurrence of the 'view_promotion' event. |
Publisher ad clicks integer | publisherAdClicks | The number of ad_click events. |
Publisher ad impressions integer | publisherAdImpressions | The number of ad_impression events. |
Purchaser conversion float | purchaserConversionRate | The percentage of active users who made 1 or more purchase transactions. This metric is returned as a fraction; for example, 0.412 means 41.2% of users were purchasers. |
Purchase revenue currency | purchaseRevenue | The sum of revenue from purchases made in your app or site. Purchase revenue sums the revenue for these events: 'purchase', 'ecommerce_purchase', 'in_app_purchase', 'app_store_subscription_convert', and 'app_store_subscription_renew'. Purchase revenue is specified by the 'value' parameter in tagging. |
Purchase-to-view rate float | purchaseToViewRate | The number of users who purchased a product(s) divided by the number of users who viewed the same product(s). This metric is returned as a fraction; for example, 0.128 means 12.8% of users that viewed a product(s) also purchased the same product(s). |
Return on ad spend float | returnOnAdSpend | Return On Ad Spend (ROAS) is total revenue divided by advertiser ad cost. |
Views integer | screenPageViews | The number of app screens or web pages your users viewed. Repeated views of a single page or screen are counted. (screen_view + page_view events). |
Views per session float | screenPageViewsPerSession | The number of app screens or web pages your users viewed per session. Repeated views of a single page or screen are counted. (screen_view + page_view events) / sessions. |
Views per user float | screenPageViewsPerUser | The number of app screens or web pages your users viewed per active user. Repeated views of a single page or screen are counted. (screen_view + page_view events) / active users. |
Scrolled users integer | scrolledUsers | The number of unique users who scrolled down at least 90% of the page. |
Session conversion rate float | sessionConversionRate | The percentage of sessions in which any conversion event was triggered. |
Sessions integer | sessions | The number of sessions that began on your site or app (event triggered: session_start). |
Sessions per user float | sessionsPerUser | The average number of sessions per user (Sessions divided by Active Users). |
Shipping amount currency | shippingAmount | Shipping amount associated with a transaction. Populated by the 'shipping' event parameter. |
Tax amount currency | taxAmount | Tax amount associated with a transaction. Populated by the 'tax' event parameter. |
Total ad revenue currency | totalAdRevenue | The total advertising revenue from both Admob and third-party sources. |
Total purchasers integer | totalPurchasers | The number of users that logged purchase events for the time period selected. |
Total revenue currency | totalRevenue | The sum of revenue from purchases, subscriptions, and advertising (Purchase revenue plus Subscription revenue plus Ad revenue). |
Total users integer | totalUsers | The number of distinct users who have logged at least one event, regardless of whether the site or app was in use when that event was logged. |
Transactions integer | transactions | The count of transaction events with purchase revenue. Transaction events are in_app_purchase, ecommerce_purchase, purchase, app_store_subscription_renew, app_store_subscription_convert, and refund. |
Transactions per purchaser float | transactionsPerPurchaser | The average numer of transactions per purchaser. |
User conversion rate float | userConversionRate | The percentage of users who triggered any conversion event. |
User engagement seconds | userEngagementDuration | The total amount of time (in seconds) your website or app was in the foreground of users' devices. |
WAU / MAU float | wauPerMau | The rolling percent of 30-day active users who are also 7-day active users. This metric is returned as a fraction; for example, 0.234 means 23.4% of 30-day active users were also 7-day active users. |
Conversions count for purchase integer | conversions:purchase | The count of a specific conversion event. |
Session conversion rate for purchase float | sessionConversionRate:purchase | The percentage of sessions in which a specific conversion event was triggered. |
User conversion rate for purchase float | userConversionRate:purchase | The percentage of users who triggered a specific conversion event. |
На вкладке Dimensions отметьте измерения, по которым группируется отчёт: дата, страна, категория устройства, источник трафика и другие.
На вкладке Metrics отметьте метрики для выгрузки: сессии, пользователи, события, доход и другие.
Renta загружает список параметров напрямую из метаданных ресурса, поэтому кастомные измерения и метрики (поля customEvent и customUser) отображаются рядом со стандартными. В таблице назначения имена колонок повторяют API-имена параметров, а двоеточия в именах кастомных полей заменяются на подчёркивания.
Имя таблицы и диапазон дат
Назовите пайплайн и задайте исторический период загрузки.
- Integration name.
Название пайплайна. Оно используется только в интерфейсе Renta. - Table name.
Имя таблицы в назначении. Можно оставить автоматически сгенерированное имя или задать своё. - Date start.
Первая дата периода выгрузки. - Date end.
Последняя дата периода выгрузки. Оставьте значение Today, чтобы собирать новые данные при каждом запуске.
Период перезаписи
Период перезаписи определяет, сколько последних дней Renta перезагружает при каждом запуске.
При каждом запуске Renta заново запрашивает отчёт начиная с даты последнего успешного запуска минус период перезаписи. Затронутые дни удаляются из таблицы назначения и записываются заново, более старые данные не затрагиваются. Варианты: от Without overwrite data до Overwrite all data, по умолчанию Last 1 day.
Расписание
Выберите, как часто запускается пайплайн.
| Тип расписания | Описание |
|---|---|
| Manual | Пайплайн запускается только вручную через интерфейс или по API. |
| Daily | Пайплайн запускается раз в день в указанное время обновления. |
| Interval | Пайплайн запускается через заданные интервалы времени. |
| Cron Expression | Пайплайн запускается по расписанию, заданному cron-выражением. |
Для расписания Daily задайте Update time (точное время запуска), затем нажмите Create pipeline.
Новый пайплайн появится в разделе Pipelines на вкладке ETL, где можно отслеживать запуски, прогресс и имя таблицы назначения.
Стратегия синхронизации
Стратегия синхронизации зависит от того, включено ли в отчёт измерение Date.
| Стратегия | Поддерживаемые типы отчётов | Описание |
|---|---|---|
| Инкрементальное обновление | Отчёты с измерением Date | Каждая строка соответствует одному дню, таблица назначения партиционируется по колонке date. При каждом запуске Renta перезагружает окно от даты последнего успешного запуска минус период перезаписи до конца диапазона дат: эти дневные партиции удаляются и записываются заново, более старые партиции не затрагиваются. |
| Полная перезагрузка | Отчёты без измерения Date | В таблице нет колонки даты для партиционирования, поэтому Renta запрашивает весь настроенный диапазон дат и заменяет датасет при каждом запуске. |
Часто задаваемые вопросы
Ready to get started?
Build your data pipeline today or get a personalized demo. Start free!
Need help?
Get expert support to ensure your project succeeds. We're here to help!
Feature requests?
Help shape our product! Share your ideas for new features and integrations.