Columns¶
This article documents core columns available in the HTTP API. Additional columns may become available through Integrations.
Note
Each column listed in this document defines a Scopes attribute. To get better performance, report is calculated from session scope whenever possible. When using dimension that doesn’t support a session scope, then the report is computed from a relevant scope. Example: if you request product_name column, report will be computed in product scope. This might distort some custom metrics such as averages of a session dimension (e.g. average session time).
Metrics¶
The table below lists core metrics that may be used in queries (they are not available in Raw data). Additional metrics may be created using dimension transformations.
Metric Name | Column ID | Scopes | Real-time | Type | Notes |
---|---|---|---|---|---|
Events | events | event, product, session | ✔ | int | |
Consent form impressions | consent_form_impressions | event, product | ✔ | int | |
Consent form clicks | consent_form_clicks | event, product | ✔ | int | |
First consents | consents_first | event, product | ✔ | int | |
Changed consents | consents_changed | event, product | ✔ | int | |
Full consents | consents_full | event, product | ✔ | int | |
Any consents | consents_any | event, product | ✔ | int | |
No consents | consents_none | event, product | ✔ | int | |
No decisions | consents_no_decision | event, product | ✔ | int | |
Analytics consents | consents_analytics | event, product | ✔ | int | |
A/B testing personalization consents | consents_ab_testing_personalization | event, product | ✔ | int | |
Conversion tracking consents | consents_conversion_tracking | event, product | ✔ | int | |
Marketing automation consents | consents_marketing_automation | event, product | ✔ | int | |
Remarketing consents | consents_remarketing | event, product | ✔ | int | |
User feedback consents | consents_user_feedback | event, product | ✔ | int | |
Custom consent 1 | consents_custom_1 | event, product | ✔ | int | |
Page views | page_views | event, product, session | ✔ | int | |
Unique page views | unique_page_views | event, product, session | ✖ | int | |
Entries | entries | event, product, session | ✖ | int | |
Exits | exits | event, product, session | ✖ | int | |
Bounces | bounces | event, product, session | ✖ | int | |
Sessions | sessions | event, product, session | ✖ | int | |
Visitors | visitors | event, product, session | ✔ | int | |
% of returning visitors | returning_visitors_rate | event, product, session | ✖ | float | |
Users | users | event, product, session | ✔ | int | |
Visitor IPs | visitor_ips | event, product, session | ✔ | int | |
Outlinks | outlinks | event, product, session | ✔ | int | |
Unique outlinks | unique_outlinks | event, product, session | ✖ | int | |
Downloads | downloads | event, product, session | ✔ | int | |
Unique downloads | unique_downloads | event, product, session | ✖ | int | |
Searches | searches | event, product, session | ✔ | int | |
Unique searches | unique_searches | event, product, session | ✖ | int | |
Custom events | custom_events | event, product, session | ✔ | int | |
Unique custom events | unique_custom_events | event, product, session | ✖ | int | |
Content impressions | content_impressions | event, product, session | ✔ | int | |
Unique content impressions | unique_content_impressions | event, product, session | ✖ | int | |
Content interactions | content_interactions | event, product, session | ✔ | int | |
Unique content interactions | unique_content_interactions | event, product, session | ✖ | int | |
Orders | ecommerce_conversions | event, product, session | ✔ | int | |
Product detail views | product_detail_views | event, product, session | ✔ | int | |
Product adds to cart | cart_additions | event, product, session | ✔ | int | |
Product removes from cart | cart_removals | event, product, session | ✔ | int | |
Cart-to-detail rate | cart_to_detail_rate | event, product, session | ✔ | float | |
Order-to-detail rate | order_to_detail_rate | event, product, session | ✔ | float | |
Total quantity (deprecated) | total_quantity | event, product | ✖ | int | deprecated, use ‘product_quantity’ with ‘sum’ transformation instead |
Abandoned carts | ecommerce_abandoned_carts | event, product, session | ✖ | int | |
Unique purchases (deprecated) | unique_purchases | event, product | ✖ | int | deprecated, use ‘ecommerce_conversions’ instead |
Entry rate | entry_rate | event, product, session | ✖ | float | |
Exit rate | exit_rate | event, product, session | ✖ | float | |
Exit rate events | exit_rate_events | event, product, session | ✖ | float | |
Bounce rate | bounce_rate | event, product, session | ✖ | float | |
Bounce rate | bounce_rate_events | event, product, session | ✖ | float | |
Content interaction rate | content_interaction_rate | event, product, session | ✔ | float | |
Order rate | ecommerce_conversion_rate | event, product, session | ✖ | float | |
Cart abandonment rate | abandoned_cart_rate | event, product, session | ✖ | float | |
Events per session | events_per_session | event, product, session | ✖ | float | |
Goal conversions | goal_conversions | event, product, session | ✔ | int | |
Unique goal conversions | unique_goal_conversions | event, product, session | ✖ | int | |
Goal conversion rate | goal_conversion_rate | event, product, session | ✖ | float |
Dimensions¶
The table below lists core dimensions that may be used in queries.
Note: “Database type” column presents the type of source column of the dimension (in case of enum - type of the ID, in case of dynamic dimensions - not applicable).
Dimension Name | Column ID | Scopes | Real-time | Query API | Raw data API | Type | Database Type | Nullable | Notes |
---|---|---|---|---|---|---|---|---|---|
Visitor ID | visitor_id | event, product, session | ✔ | ✔ | ✔ | hex | uint64 | False | by default in Raw data API |
User ID | user_id | event, product, session | ✔ | ✔ | ✔ | str | string | False | |
Cookie ID | cookie_id | event, product, session | ✔ | ✔ | ✔ | hex | uint64 | False | |
Returning visitor | visitor_returning | event, product, session | ✖ | ✔ | ✔ | [int, str] | uint8 | False | visitor_returning.json |
Session number | visitor_session_number | event, product, session | ✔ | ✔ | ✔ | int | uint16 | False | |
Days since last session | visitor_days_since_last_session | event, product, session | ✔ | ✔ | ✔ | int | uint16 | True | |
Days since first session | visitor_days_since_first_session | event, product, session | ✔ | ✔ | ✔ | int | uint16 | True | |
Days since last order | visitor_days_since_order | event, product, session | ✔ | ✔ | ✔ | int | uint16 | True | |
Events in session | session_total_events | event, product, session | ✖ | ✔ | ✔ | int | uint16 | False | |
Session time | session_total_time | event, product, session | ✖ | ✔ | ✔ | int | uint32 | False | in seconds |
Page views in session | session_total_page_views | event, product, session | ✖ | ✔ | ✔ | int | uint16 | False | |
Outlinks in session | session_total_outlinks | event, product, session | ✖ | ✔ | ✔ | int | uint16 | False | |
Downloads in session | session_total_downloads | event, product, session | ✖ | ✔ | ✔ | int | uint16 | False | |
Site searches in session | session_total_site_searches | event, product, session | ✖ | ✔ | ✔ | int | uint16 | False | |
Custom events in session | session_total_custom_events | event, product, session | ✖ | ✔ | ✔ | int | uint16 | False | |
Content impressions in session | session_total_content_impressions | event, product, session | ✖ | ✔ | ✔ | int | uint16 | False | |
Content interactions in session | session_total_content_interactions | event, product, session | ✖ | ✔ | ✔ | int | uint16 | False | |
Goal conversions in session | session_total_goal_conversions | event, product, session | ✖ | ✔ | ✔ | int | uint16 | False | |
Orders in session | session_total_ecommerce_conversions | event, product, session | ✖ | ✔ | ✔ | int | uint16 | False | |
Abandoned carts in session | session_total_abandoned_carts | event, product, session | ✖ | ✔ | ✔ | int | uint16 | False | |
Product detail views in session | session_total_product_detail_views | event, product, session | ✖ | ✔ | ✔ | int | uint16 | False | |
Adds to cart in session | session_total_cart_additions | event, product, session | ✖ | ✔ | ✔ | int | uint16 | False | |
Removes from cart in session | session_total_cart_removals | event, product, session | ✖ | ✔ | ✔ | int | uint16 | False | |
Unique page views in session | session_unique_page_views | event, product, session | ✖ | ✔ | ✔ | int | uint16 | False | |
Unique outlinks in session | session_unique_outlinks | event, product, session | ✖ | ✔ | ✔ | int | uint16 | False | |
Unique downloads in session | session_unique_downloads | event, product, session | ✖ | ✔ | ✔ | int | uint16 | False | |
Unique site searches in session | session_unique_searches | event, product, session | ✖ | ✔ | ✔ | int | uint16 | False | |
Unique custom events in session | session_unique_custom_events | event, product, session | ✖ | ✔ | ✔ | int | uint16 | False | |
Unique content impressions in session | session_unique_content_impressions | event, product, session | ✖ | ✔ | ✔ | int | uint16 | False | |
Unique content interactions in session | session_unique_content_interactions | event, product, session | ✖ | ✔ | ✔ | int | uint16 | False | |
Goals converted in session | session_goals | event, product, session | ✖ | ✔ | ✔ | array | array of int32 | False | |
Goals converted in session (uuid) | session_goal_uuids | event, product, session | ✖ | ✔ | ✔ | array(uuid) | array of string(16) | False | |
Shopping stage | session_ecommerce_status | event, product, session | ✖ | ✔ | ✔ | [int, str] | uint8 | False | session_ecommerce_status.json |
Source | source | event, product, session | ✔ | ✔ | ✔ | str_nocase | string | False | |
Medium | medium | event, product, session | ✔ | ✔ | ✔ | str_nocase | string | False | |
Source/Medium | source_medium | event, product, session | ✔ | ✔ | ✔ | str_nocase | string | False | |
Keyword | keyword | event, product, session | ✔ | ✔ | ✔ | str | string | False | |
Channel | referrer_type | event, product, session | ✔ | ✔ | ✔ | [int, str] | uint8 | False | referrer_type.json |
Referrer URL | referrer_url | event, product, session | ✔ | ✔ | ✔ | str | string | False | |
Campaign name | campaign_name | event, product, session | ✔ | ✔ | ✔ | str | string | False | |
Campaign ID | campaign_id | event, product, session | ✔ | ✔ | ✔ | str | string | False | |
Campaign content | campaign_content | event, product, session | ✔ | ✔ | ✔ | str | string | False | |
Google Click ID | campaign_gclid | event, product, session | ✔ | ✔ | ✔ | str | string | True | |
Operating system | operating_system | event, product, session | ✔ | ✔ | ✔ | [str, str] | string(3) | True | operating_system.json |
Operating system version | operating_system_version | event, product, session | ✔ | ✔ | ✔ | str | string | False | |
Browser engine | browser_engine | event, product, session | ✔ | ✔ | ✔ | str | string | False | |
Browser name | browser_name | event, product, session | ✔ | ✔ | ✔ | [str, str] | string(3) | True | browser_name.json |
Browser version | browser_version | event, product, session | ✔ | ✔ | ✔ | str | string | False | |
Browser language | browser_language_iso639 | event, product, session | ✔ | ✔ | ✔ | [str, str] | string(2) | True | browser_language_iso639.json |
Browser fingerprint | browser_fingerprint | event, product, session | ✖ | ✖ | ✔ | int | uint64 | False | |
Device type | device_type | event, product, session | ✔ | ✔ | ✔ | [int, str] | uint8 | True | device_type.json |
Device brand | device_brand | event, product, session | ✔ | ✔ | ✔ | [str, str] | string(3) | True | device_brand.json |
Device model | device_model | event, product, session | ✔ | ✔ | ✔ | str | string | False | |
Resolution | resolution | event, product, session | ✔ | ✔ | ✔ | str | string | True | |
Resolution width | resolution_width | event, product, session | ✔ | ✔ | ✔ | int | uint16 | True | |
Resolution height | resolution_height | event, product, session | ✔ | ✔ | ✔ | int | uint16 | True | |
PDF plugin | plugin_pdf | event, product, session | ✖ | ✔ | ✔ | int(0,1) | uint8 | False | |
Flash plugin | plugin_flash | event, product, session | ✖ | ✔ | ✔ | int(0,1) | uint8 | False | |
Java plugin | plugin_java | event, product, session | ✖ | ✔ | ✔ | int(0,1) | uint8 | False | |
Director plugin | plugin_director | event, product, session | ✖ | ✔ | ✔ | int(0,1) | uint8 | False | |
QuickTime plugin | plugin_quicktime | event, product, session | ✖ | ✔ | ✔ | int(0,1) | uint8 | False | |
RealPlayer plugin | plugin_realplayer | event, product, session | ✖ | ✔ | ✔ | int(0,1) | uint8 | False | |
Windows Media Player plugin | plugin_windowsmedia | event, product, session | ✖ | ✔ | ✔ | int(0,1) | uint8 | False | |
Gears plugin | plugin_gears | event, product, session | ✖ | ✔ | ✔ | int(0,1) | uint8 | False | |
Silverlight plugin | plugin_silverlight | event, product, session | ✖ | ✔ | ✔ | int(0,1) | uint8 | False | |
Cookie support | plugin_cookie | event, product, session | ✖ | ✔ | ✔ | int(0,1) | uint8 | False | |
Continent | location_continent_iso_code | event, product, session | ✔ | ✔ | ✔ | [str, str] | string(2) | True | location_continent_iso_code.json |
Country | location_country_name | event, product, session | ✔ | ✔ | ✔ | [str, str] | string | True | ISO 3166-2 codes (e.g. “PL”) |
Subdivision | location_subdivision_1_name | event, product, session | ✔ | ✔ | ✔ | [str, str] | string | True | ISO 3166-2 codes (e.g. “PL-DS”) |
Subdivision 2 | location_subdivision_2_name | event, product, session | ✔ | ✔ | ✔ | [str, str] | string | True | ISO 3166-2 codes (e.g. “ES-M”) |
City | location_city_name | event, product, session | ✔ | ✔ | ✔ | [int, str] | string | True | unique identifiers as specified by GeoNames |
Designated market area (deprecated) | location_metro_code | event, product, session | ✔ | ✔ | ✔ | [str, str] | string(3) | True | deprecated, available only in old reports location_metro_code.json |
Latitude | location_latitude | event, product, session | ✔ | ✔ | ✔ | float | float64 | True | |
Longitude | location_longitude | event, product, session | ✔ | ✔ | ✔ | float | float64 | True | |
Provider | location_provider | event, product, session | ✔ | ✔ | ✔ | str | string | False | |
Organization | location_organization | event, product, session | ✔ | ✔ | ✔ | str | string | False | |
Session exit URL | session_exit_url | event, product, session | ✖ | ✔ | ✔ | str | string | False | |
Session exit title | session_exit_title | event, product, session | ✖ | ✔ | ✔ | str | string | False | |
Session entry URL | session_entry_url | event, product, session | ✖ | ✔ | ✔ | str | string | False | |
Session entry title | session_entry_title | event, product, session | ✖ | ✔ | ✔ | str | string | False | |
Session second URL | session_second_url | event, product, session | ✖ | ✔ | ✔ | str | string | False | |
Session second title | session_second_title | event, product, session | ✖ | ✔ | ✔ | str | string | False | |
Session bounce | is_bounce | event, product, session | ✖ | ✔ | ✔ | int(0,1) | uint8 | False | |
Event ID | event_id | event, product | ✔ | ✔ | ✔ | int | uint64 | False | by default in Raw data API |
Session ID | session_id | event, product, session | ✖ | ✔ | ✔ | int | uint64 | False | by default in Raw data API |
Exit view | is_exit | event, product | ✖ | ✖ | ✔ | int(0,1) | uint8 | False | |
Entry view | is_entry | event, product | ✖ | ✖ | ✔ | int(0,1) | uint8 | False | |
Event type | event_type | event, product | ✔ | ✔ | ✔ | [int, str] | uint8 | False | event_type.json |
Page URL | event_url | event, product | ✔ | ✔ | ✔ | str | string | False | |
Page title | event_title | event, product | ✔ | ✔ | ✔ | str | string | False | |
Outlink URL | outlink_url | event, product | ✔ | ✔ | ✔ | str | string | False | |
Download URL | download_url | event, product | ✔ | ✔ | ✔ | str | string | False | |
Search keyword | search_keyword | event, product | ✔ | ✔ | ✔ | str | string | False | |
Search category | search_category | event, product | ✖ | ✔ | ✔ | str | string | False | |
Search results count | search_results_count | event, product | ✔ | ✔ | ✔ | int | uint32 | True | |
Custom event category | custom_event_category | event, product | ✔ | ✔ | ✔ | str | string | False | |
Custom event action | custom_event_action | event, product | ✔ | ✔ | ✔ | str | string | False | |
Custom event name | custom_event_name | event, product | ✔ | ✔ | ✔ | str | string | False | |
Custom event value | custom_event_value | event, product | ✔ | ✔ | ✔ | float | float64 | True | |
Content name | content_name | event, product | ✔ | ✔ | ✔ | str | string | False | |
Content piece | content_piece | event, product | ✔ | ✔ | ✔ | str | string | False | |
Content target | content_target | event, product | ✔ | ✔ | ✔ | str | string | False | |
Previous page view URL | previous_event_url | event, product | ✖ | ✔ | ✔ | str | string | False | |
Previous page view title | previous_event_title | event, product | ✖ | ✔ | ✔ | str | string | False | |
Next page view URL | next_event_url | event, product | ✖ | ✔ | ✔ | str | string | False | |
Next page view title | next_event_title | event, product | ✖ | ✔ | ✔ | str | string | False | |
Event index | event_index | event, product | ✖ | ✖ | ✔ | int | uint16 | False | |
Page view index | page_view_index | event, product | ✖ | ✖ | ✔ | int | uint16 | True | |
Time on page | time_on_page | event, product | ✖ | ✔ | ✔ | int | uint32 | True | in seconds |
Page generation time | page_generation_time | event, product | ✔ | ✔ | ✔ | float | float64 | True | in milliseconds |
Goal name (deprecated) | goal_id | event, product | ✖ | ✔ | ✔ | [int, str] | int32 | True | removed, to identify Goals, use goal_uuid |
Goal name (uuid) | goal_uuid | event, product | ✔ | ✔ | ✔ | [str, str] | string(16) | True | goal UUID from Analytics |
Goal revenue | goal_revenue | event, product | ✔ | ✔ | ✔ | float | float64 | True | |
Abandoned cart value | lost_revenue | event, product | ✖ | ✔ | ✔ | float | float64 | True | |
Order ID | order_id | event, product | ✔ | ✔ | ✔ | str | string | False | |
Unique item count (deprecated) | item_count | event, product | ✔ | ✔ | ✔ | int | uint16 | True | deprecated, use ‘product_count’ instead |
Revenue | revenue | event, product | ✔ | ✔ | ✔ | float | float64 | True | |
Subtotal | revenue_subtotal | event, product | ✔ | ✔ | ✔ | float | float64 | True | |
Tax | revenue_tax | event, product | ✔ | ✔ | ✔ | float | float64 | True | |
Shipping | revenue_shipping | event, product | ✔ | ✔ | ✔ | float | float64 | True | |
Discount | revenue_discount | event, product | ✔ | ✔ | ✔ | float | float64 | True | |
Time until DOM is ready | timing_dom_interactive | event, product | ✖ | ✔ | ✔ | int | uint32 | True | in milliseconds |
Time to interact | timing_event_end | event, product | ✖ | ✔ | ✔ | int | uint32 | True | |
Consent form view source | consent_source | event, product | ✔ | ✔ | ✔ | [int, str] | uint8 | True | consent_source.json |
Consent form interaction type | consent_form_button | event, product | ✔ | ✔ | ✔ | [int, str] | uint8 | True | consent_form_button.json |
Consent scope | consent_scope | event, product | ✔ | ✔ | ✔ | [int, str] | uint8 | True | consent_scope.json |
Consent action | consent_action | event, product | ✔ | ✔ | ✔ | [int, str] | uint8 | True | consent_action.json |
Analytics consent | consent_type_analytics | event, product | ✔ | ✔ | ✔ | int(0,1) | uint8 | True | |
AB testing personalization consent | consent_type_ab_testing_personalization | event, product | ✔ | ✔ | ✔ | int(0,1) | uint8 | True | |
Conversion tracking consent | consent_type_conversion_tracking | event, product | ✔ | ✔ | ✔ | int(0,1) | uint8 | True | |
Marketing automation consent | consent_type_marketing_automation | event, product | ✔ | ✔ | ✔ | int(0,1) | uint8 | True | |
Remarketing consent | consent_type_remarketing | event, product | ✔ | ✔ | ✔ | int(0,1) | uint8 | True | |
User feedback consent | consent_type_user_feedback | event, product | ✔ | ✔ | ✔ | int(0,1) | uint8 | True | |
Custom consent 1 | consent_type_custom_1 | event, product | ✔ | ✔ | ✔ | int(0,1) | uint8 | True | |
Event custom dimension 1 | event_custom_dimension_1 | event, product | ✔ | ✔ | ✔ | str | string | False | |
Event custom dimension 2 | event_custom_dimension_2 | event, product | ✔ | ✔ | ✔ | str | string | False | |
Event custom dimension 3 | event_custom_dimension_3 | event, product | ✔ | ✔ | ✔ | str | string | False | |
Event custom dimension 4 | event_custom_dimension_4 | event, product | ✔ | ✔ | ✔ | str | string | False | |
Event custom dimension 5 | event_custom_dimension_5 | event, product | ✔ | ✔ | ✔ | str | string | False | |
Event custom dimension * | event_custom_dimension_* | event, product | ✔ | ✔ | ✔ | str | string | False | read more about slots |
Event custom variable key 1 | event_custom_variable_key_1 | event, product | ✔ | ✔ | ✔ | str | string | False | |
Event custom variable value 1 | event_custom_variable_value_1 | event, product | ✔ | ✔ | ✔ | str | string | False | |
Event custom variable key 2 | event_custom_variable_key_2 | event, product | ✔ | ✔ | ✔ | str | string | False | |
Event custom variable value 2 | event_custom_variable_value_2 | event, product | ✔ | ✔ | ✔ | str | string | False | |
Event custom variable key 3 | event_custom_variable_key_3 | event, product | ✔ | ✔ | ✔ | str | string | False | |
Event custom variable value 3 | event_custom_variable_value_3 | event, product | ✔ | ✔ | ✔ | str | string | False | |
Event custom variable key 4 | event_custom_variable_key_4 | event, product | ✔ | ✔ | ✔ | str | string | False | |
Event custom variable value 4 | event_custom_variable_value_4 | event, product | ✔ | ✔ | ✔ | str | string | False | |
Event custom variable key 5 | event_custom_variable_key_5 | event, product | ✔ | ✔ | ✔ | str | string | False | |
Event custom variable value 5 | event_custom_variable_value_5 | event, product | ✔ | ✔ | ✔ | str | string | False | |
Event custom variable key * | event_custom_variable_key_* | event, product | ✔ | ✔ | ✔ | str | string | False | read more about slots |
Event custom variable value * | event_custom_variable_value_* | event, product | ✔ | ✔ | ✔ | str | string | False | read more about slots |
Session custom dimension 1 | session_custom_dimension_1 | event, product, session | ✖ | ✔ | ✔ | str | string | False | |
Session custom dimension 2 | session_custom_dimension_2 | event, product, session | ✖ | ✔ | ✔ | str | string | False | |
Session custom dimension 3 | session_custom_dimension_3 | event, product, session | ✖ | ✔ | ✔ | str | string | False | |
Session custom dimension 4 | session_custom_dimension_4 | event, product, session | ✖ | ✔ | ✔ | str | string | False | |
Session custom dimension 5 | session_custom_dimension_5 | event, product, session | ✖ | ✔ | ✔ | str | string | False | |
Session custom dimension * | session_custom_dimension_* | event, product, session | ✖ | ✔ | ✔ | str | string | False | read more about slots |
Session custom variable key 1 | session_custom_variable_key_1 | event, product, session | ✖ | ✔ | ✔ | str | string | False | |
Session custom variable value 1 | session_custom_variable_value_1 | event, product, session | ✖ | ✔ | ✔ | str | string | False | |
Session custom variable key 2 | session_custom_variable_key_2 | event, product, session | ✖ | ✔ | ✔ | str | string | False | |
Session custom variable value 2 | session_custom_variable_value_2 | event, product, session | ✖ | ✔ | ✔ | str | string | False | |
Session custom variable key 3 | session_custom_variable_key_3 | event, product, session | ✖ | ✔ | ✔ | str | string | False | |
Session custom variable value 3 | session_custom_variable_value_3 | event, product, session | ✖ | ✔ | ✔ | str | string | False | |
Session custom variable key 4 | session_custom_variable_key_4 | event, product, session | ✖ | ✔ | ✔ | str | string | False | |
Session custom variable value 4 | session_custom_variable_value_4 | event, product, session | ✖ | ✔ | ✔ | str | string | False | |
Session custom variable key 5 | session_custom_variable_key_5 | event, product, session | ✖ | ✔ | ✔ | str | string | False | |
Session custom variable value 5 | session_custom_variable_value_5 | event, product, session | ✖ | ✔ | ✔ | str | string | False | |
Session custom variable key * | session_custom_variable_key_* | event, product, session | ✖ | ✔ | ✔ | str | string | False | read more about slots |
Session custom variable value * | session_custom_variable_value_* | event, product, session | ✖ | ✔ | ✔ | str | string | False | read more about slots |
Timestamp | timestamp | event, product, session | ✔ | ✔ | ✖ | date | not applicable | False | by default in Raw data API |
Local hour | local_hour | event, product, session | ✔ | ✔ | ✔ | int | not applicable | False | |
Product name | product_name | product | ✔ | ✔ | ✖ | str | array of string | False | |
Product SKU | product_sku | product | ✔ | ✔ | ✖ | str | array of string | False | |
Product brand | product_brand | product | ✔ | ✔ | ✖ | str | array of string | False | |
Product variant | product_variant | product | ✔ | ✔ | ✖ | str | array of string | False | |
Product price | product_price | product | ✔ | ✔ | ✖ | float | array of float32 | False | |
Product quantity | product_quantity | product | ✔ | ✔ | ✖ | int | array of uint32 | False | |
Product revenue | product_revenue | product | ✔ | ✔ | ✖ | float | array of float32 | False | |
Product category | product_category | product | ✔ | ✔ | ✖ | str | array of string | False | |
Product category (Level 1) | product_category1 | product | ✔ | ✔ | ✖ | str | array of string | False | |
Product category (Level 2) | product_category2 | product | ✔ | ✔ | ✖ | str | array of string | False | |
Product category (Level 3) | product_category3 | product | ✔ | ✔ | ✖ | str | array of string | False | |
Product category (Level 4) | product_category4 | product | ✔ | ✔ | ✖ | str | array of string | False | |
Product category (Level 5) | product_category5 | product | ✔ | ✔ | ✖ | str | array of string | False | |
Product dimension 1 | product_dimension1 | product | ✔ | ✔ | ✔ | str | array of string | False | |
Product dimension 2 | product_dimension2 | product | ✔ | ✔ | ✔ | str | array of string | False | |
Product dimension 3 | product_dimension3 | product | ✔ | ✔ | ✔ | str | array of string | False | |
Product dimension 4 | product_dimension4 | product | ✔ | ✔ | ✔ | str | array of string | False | |
Product dimension 5 | product_dimension5 | product | ✔ | ✔ | ✔ | str | array of string | False | |
Product dimension * | product_dimension* | product | ✔ | ✔ | ✔ | str | array of string | False | read more about slots |
Unique product count | product_count | event, product | ✔ | ✔ | ✔ | int | uint16 | True | |
Time of redirections | redirections_time | event, product | ✖ | ✔ | ✔ | int | uint16 | True | in milliseconds |
Domain Lookup Time | domain_lookup_time | event, product | ✖ | ✔ | ✔ | int | uint16 | True | in milliseconds |
Server Connection Time | server_connection_time | event, product | ✖ | ✔ | ✔ | int | uint16 | True | in milliseconds |
Server Response Time | server_response_time | event, product | ✖ | ✔ | ✔ | int | uint16 | True | in milliseconds |
Page Rendering Time | page_rendering_time | event, product | ✖ | ✔ | ✔ | int | uint32 | True | in milliseconds |
IPv4 address | ipv4_address | event, product, session | ✔ | ✔ | ✔ | ipv4 | not applicable | True | |
IPv6 address | ipv6_address | event, product, session | ✔ | ✔ | ✔ | ipv6 | not applicable | True | |
Website Name | website_name | event, product, session | ✔ | ✔ | ✔ | [str, str] | not applicable | False | website UUID |
Product name (Array) | products.name | event, product | ✔ | ✖ | ✔ | array | array of string | False | |
Product SKU (Array) | products.sku | event, product | ✔ | ✖ | ✔ | array | array of string | False | |
Product price (Array) | products.price | event, product | ✔ | ✖ | ✔ | array | array of float32 | False | |
Product quantity (Array) | products.quantity | event, product | ✔ | ✖ | ✔ | array | array of uint32 | False | |
Product revenue (Array) | products.revenue | event, product | ✔ | ✖ | ✔ | array | array of float32 | False | |
Product brand (Array) | products.brand | event, product | ✔ | ✖ | ✔ | array | array of string | False | |
Product variant (Array) | products.variant | event, product | ✔ | ✖ | ✔ | array | array of string | False | |
Product category (Array) | products.category | event, product | ✔ | ✖ | ✔ | array | array of string | False | |
Product category 1 (Array) | products.category1 | event, product | ✔ | ✖ | ✔ | array | array of string | False | |
Product category 2 (Array) | products.category2 | event, product | ✔ | ✖ | ✔ | array | array of string | False | |
Product category 3 (Array) | products.category3 | event, product | ✔ | ✖ | ✔ | array | array of string | False | |
Product category 4 (Array) | products.category4 | event, product | ✔ | ✖ | ✔ | array | array of string | False | |
Product category 5 (Array) | products.category5 | event, product | ✔ | ✖ | ✔ | array | array of string | False | |
Product dimension 1 (Array) | products.dimension1 | event, product | ✔ | ✔ | ✔ | array | array of string | False | |
Product dimension 2 (Array) | products.dimension2 | event, product | ✔ | ✔ | ✔ | array | array of string | False | |
Product dimension 3 (Array) | products.dimension3 | event, product | ✔ | ✔ | ✔ | array | array of string | False | |
Product dimension 4 (Array) | products.dimension4 | event, product | ✔ | ✔ | ✔ | array | array of string | False | |
Product dimension 5 (Array) | products.dimension5 | event, product | ✔ | ✔ | ✔ | array | array of string | False | |
Product dimension * (Array) | products.dimension* | event, product | ✔ | ✔ | ✔ | array | array of string | False | read more about slots |
Note
Please note that the number of available custom slots (dimensions, variables) depends on your organisation’s configuration. Standard number of slots is:
- session_custom_dimension/event_custom_dimension: 200
- session_custom_variable/event_custom_variable: 10
- product_custom_dimension: 20
Transformations¶
The tables below list all transformations that may be used to transform dimensions to metrics or different dimensions.
Transformation Name | Transformation ID | Source Types | Result Type |
---|---|---|---|
Unique Count | unique_count | int, str | int |
Min | min | float, int | (as source) |
Max | max | float, int | (as source) |
Average | average | float, int | float |
Median | median | float, int | (as source) |
Sum | sum | float, int | (as source) |
Transformation Name | Transformation ID | Source Types | Result Type |
---|---|---|---|
Date To Day | to_date | date, datetime | date |
Date To Start Of Hour | to_start_of_hour | datetime | datetime |
Date To Start Of Week | to_start_of_week | date, datetime | date |
Date To Start Of Month | to_start_of_month | date, datetime | date |
Date To Start Of Quarter | to_start_of_quarter | date, datetime | date |
Date To Start Of Year | to_start_of_year | date, datetime | date |
Date To Hour Of Day | to_hour_of_day | datetime | int |
Date To Day Of Week | to_day_of_week | date, datetime | int |
Date To Month Number | to_month_number | date, datetime | int |
Date To Start Of Minute | to_start_of_minute | datetime | datetime |
Lowercase | lower | str | str |
URL To Path | to_path | str | str |
URL To Domain | to_domain | str | str |
URL Strip Query String | strip_qs | str | str |
Exporter¶
The tables in the following sections shows all columns that may be easily used in raw data exports config. For sessions and events scope there is preferred list of columns due to performance and reliability reasons.
Note
The columns "timestamp," "session_id," "visitor_id"
within the session scope,
as well as "timestamp," "session_id," "visitor_id," "event_id"
within the event scope,
are exported by default. It’s unnecessary to specify them explicitly in the "columns": [...]
.
Sessions scope - preferred¶
"columns": [
"browser_engine",
"browser_fingerprint",
"browser_language_iso639",
"browser_name",
"browser_version",
"campaign_content",
"campaign_gclid",
"campaign_id",
"campaign_name",
"cookie_id",
"device_brand",
"device_model",
"device_type",
"ipv4_address",
"ipv6_address",
"is_bounce",
"keyword",
"local_hour",
"location_city_name",
"location_continent_iso_code",
"location_country_name",
"location_latitude",
"location_longitude",
"location_metro_code",
"location_organization",
"location_provider",
"location_subdivision_1_name",
"location_subdivision_2_name",
"medium",
"operating_system",
"operating_system_version",
"plugin_cookie",
"plugin_director",
"plugin_flash",
"plugin_gears",
"plugin_java",
"plugin_pdf",
"plugin_quicktime",
"plugin_realplayer",
"plugin_silverlight",
"plugin_windowsmedia",
"referrer_type",
"referrer_url",
"resolution",
"resolution_height",
"resolution_width",
"session_custom_dimension_1",
"session_custom_dimension_2",
"session_custom_dimension_3",
"session_custom_dimension_4",
"session_custom_dimension_5",
"session_custom_dimension_6",
"session_custom_dimension_7",
"session_custom_dimension_8",
"session_custom_dimension_9",
"session_custom_dimension_10",
"session_custom_dimension_11",
"session_custom_dimension_12",
"session_custom_dimension_13",
"session_custom_dimension_14",
"session_custom_dimension_15",
"session_custom_dimension_16",
"session_custom_dimension_17",
"session_custom_dimension_18",
"session_custom_dimension_19",
"session_custom_dimension_20",
"session_custom_dimension_21",
"session_custom_dimension_22",
"session_custom_dimension_23",
"session_custom_dimension_24",
"session_custom_dimension_25",
"session_custom_dimension_26",
"session_custom_dimension_27",
"session_custom_dimension_28",
"session_custom_dimension_29",
"session_custom_dimension_30",
"session_custom_dimension_31",
"session_custom_dimension_32",
"session_custom_dimension_33",
"session_custom_dimension_34",
"session_custom_dimension_35",
"session_custom_dimension_36",
"session_custom_dimension_37",
"session_custom_dimension_38",
"session_custom_dimension_39",
"session_custom_dimension_40",
"session_custom_dimension_41",
"session_custom_dimension_42",
"session_custom_dimension_43",
"session_custom_dimension_44",
"session_custom_dimension_45",
"session_custom_dimension_46",
"session_custom_dimension_47",
"session_custom_dimension_48",
"session_custom_dimension_49",
"session_custom_dimension_50",
"session_custom_dimension_51",
"session_custom_dimension_52",
"session_custom_dimension_53",
"session_custom_dimension_54",
"session_custom_dimension_55",
"session_custom_dimension_56",
"session_custom_dimension_57",
"session_custom_dimension_58",
"session_custom_dimension_59",
"session_custom_dimension_60",
"session_custom_dimension_61",
"session_custom_dimension_62",
"session_custom_dimension_63",
"session_custom_dimension_64",
"session_custom_dimension_65",
"session_custom_dimension_66",
"session_custom_dimension_67",
"session_custom_dimension_68",
"session_custom_dimension_69",
"session_custom_dimension_70",
"session_custom_dimension_71",
"session_custom_dimension_72",
"session_custom_dimension_73",
"session_custom_dimension_74",
"session_custom_dimension_75",
"session_custom_dimension_76",
"session_custom_dimension_77",
"session_custom_dimension_78",
"session_custom_dimension_79",
"session_custom_dimension_80",
"session_custom_dimension_81",
"session_custom_dimension_82",
"session_custom_dimension_83",
"session_custom_dimension_84",
"session_custom_dimension_85",
"session_custom_dimension_86",
"session_custom_dimension_87",
"session_custom_dimension_88",
"session_custom_dimension_89",
"session_custom_dimension_90",
"session_custom_dimension_91",
"session_custom_dimension_92",
"session_custom_dimension_93",
"session_custom_dimension_94",
"session_custom_dimension_95",
"session_custom_dimension_96",
"session_custom_dimension_97",
"session_custom_dimension_98",
"session_custom_dimension_99",
"session_custom_dimension_100",
"session_custom_dimension_101",
"session_custom_dimension_102",
"session_custom_dimension_103",
"session_custom_dimension_104",
"session_custom_dimension_105",
"session_custom_dimension_106",
"session_custom_dimension_107",
"session_custom_dimension_108",
"session_custom_dimension_109",
"session_custom_dimension_110",
"session_custom_dimension_111",
"session_custom_dimension_112",
"session_custom_dimension_113",
"session_custom_dimension_114",
"session_custom_dimension_115",
"session_custom_dimension_116",
"session_custom_dimension_117",
"session_custom_dimension_118",
"session_custom_dimension_119",
"session_custom_dimension_120",
"session_custom_dimension_121",
"session_custom_dimension_122",
"session_custom_dimension_123",
"session_custom_dimension_124",
"session_custom_dimension_125",
"session_custom_dimension_126",
"session_custom_dimension_127",
"session_custom_dimension_128",
"session_custom_dimension_129",
"session_custom_dimension_130",
"session_custom_dimension_131",
"session_custom_dimension_132",
"session_custom_dimension_133",
"session_custom_dimension_134",
"session_custom_dimension_135",
"session_custom_dimension_136",
"session_custom_dimension_137",
"session_custom_dimension_138",
"session_custom_dimension_139",
"session_custom_dimension_140",
"session_custom_dimension_141",
"session_custom_dimension_142",
"session_custom_dimension_143",
"session_custom_dimension_144",
"session_custom_dimension_145",
"session_custom_dimension_146",
"session_custom_dimension_147",
"session_custom_dimension_148",
"session_custom_dimension_149",
"session_custom_dimension_150",
"session_custom_dimension_151",
"session_custom_dimension_152",
"session_custom_dimension_153",
"session_custom_dimension_154",
"session_custom_dimension_155",
"session_custom_dimension_156",
"session_custom_dimension_157",
"session_custom_dimension_158",
"session_custom_dimension_159",
"session_custom_dimension_160",
"session_custom_dimension_161",
"session_custom_dimension_162",
"session_custom_dimension_163",
"session_custom_dimension_164",
"session_custom_dimension_165",
"session_custom_dimension_166",
"session_custom_dimension_167",
"session_custom_dimension_168",
"session_custom_dimension_169",
"session_custom_dimension_170",
"session_custom_dimension_171",
"session_custom_dimension_172",
"session_custom_dimension_173",
"session_custom_dimension_174",
"session_custom_dimension_175",
"session_custom_dimension_176",
"session_custom_dimension_177",
"session_custom_dimension_178",
"session_custom_dimension_179",
"session_custom_dimension_180",
"session_custom_dimension_181",
"session_custom_dimension_182",
"session_custom_dimension_183",
"session_custom_dimension_184",
"session_custom_dimension_185",
"session_custom_dimension_186",
"session_custom_dimension_187",
"session_custom_dimension_188",
"session_custom_dimension_189",
"session_custom_dimension_190",
"session_custom_dimension_191",
"session_custom_dimension_192",
"session_custom_dimension_193",
"session_custom_dimension_194",
"session_custom_dimension_195",
"session_custom_dimension_196",
"session_custom_dimension_197",
"session_custom_dimension_198",
"session_custom_dimension_199",
"session_custom_dimension_200",
"session_custom_variable_key_1",
"session_custom_variable_key_2",
"session_custom_variable_key_3",
"session_custom_variable_key_4",
"session_custom_variable_key_5",
"session_custom_variable_key_6",
"session_custom_variable_key_7",
"session_custom_variable_key_8",
"session_custom_variable_key_9",
"session_custom_variable_key_10",
"session_custom_variable_value_1",
"session_custom_variable_value_2",
"session_custom_variable_value_3",
"session_custom_variable_value_4",
"session_custom_variable_value_5",
"session_custom_variable_value_6",
"session_custom_variable_value_7",
"session_custom_variable_value_8",
"session_custom_variable_value_9",
"session_custom_variable_value_10",
"session_ecommerce_status",
"session_entry_title",
"session_entry_url",
"session_exit_title",
"session_exit_url",
"session_goal_uuids",
"session_goals",
"session_second_title",
"session_second_url",
"session_total_abandoned_carts",
"session_total_cart_additions",
"session_total_cart_removals",
"session_total_content_impressions",
"session_total_content_interactions",
"session_total_custom_events",
"session_total_downloads",
"session_total_ecommerce_conversions",
"session_total_events",
"session_total_goal_conversions",
"session_total_outlinks",
"session_total_page_views",
"session_total_product_detail_views",
"session_total_sharepoint_comments",
"session_total_sharepoint_creations",
"session_total_sharepoint_deletions",
"session_total_sharepoint_edits",
"session_total_sharepoint_item_attachment_views",
"session_total_sharepoint_item_shares",
"session_total_sharepoint_item_views",
"session_total_sharepoint_likes",
"session_total_sharepoint_opens",
"session_total_sharepoint_promotions",
"session_total_sharepoint_shares",
"session_total_sharepoint_uploads",
"session_total_site_searches",
"session_total_time",
"session_unique_content_impressions",
"session_unique_content_interactions",
"session_unique_custom_events",
"session_unique_downloads",
"session_unique_outlinks",
"session_unique_page_views",
"session_unique_searches",
"sharepoint_department",
"sharepoint_display_name",
"sharepoint_job_title",
"sharepoint_office",
"source",
"source_medium",
"user_id",
"visitor_days_since_first_session",
"visitor_days_since_last_session",
"visitor_days_since_order",
"visitor_returning",
"visitor_session_number",
"website_name"
]
Sessions scope¶
"columns": [
"browser_engine",
"browser_fingerprint",
"browser_language_iso639",
"browser_name",
"browser_version",
"campaign_content",
"campaign_gclid",
"campaign_id",
"campaign_name",
"cookie_id",
"device_brand",
"device_model",
"device_type",
"google_ads_ad_group_ad_id",
"google_ads_ad_group_id",
"google_ads_ad_group_name",
"google_ads_ad_network_type",
"google_ads_campaign_id",
"google_ads_campaign_name",
"google_ads_customer_id",
"google_ads_customer_name",
"ipv4_address",
"ipv6_address",
"is_bounce",
"keyword",
"local_hour",
"location_city_name",
"location_continent_iso_code",
"location_country_name",
"location_latitude",
"location_longitude",
"location_metro_code",
"location_organization",
"location_provider",
"location_subdivision_1_name",
"location_subdivision_2_name",
"medium",
"operating_system",
"operating_system_version",
"plugin_cookie",
"plugin_director",
"plugin_flash",
"plugin_gears",
"plugin_java",
"plugin_pdf",
"plugin_quicktime",
"plugin_realplayer",
"plugin_silverlight",
"plugin_windowsmedia",
"referrer_type",
"referrer_url",
"resolution",
"resolution_height",
"resolution_width",
"session_custom_dimension_1",
"session_custom_dimension_2",
"session_custom_dimension_3",
"session_custom_dimension_4",
"session_custom_dimension_5",
"session_custom_dimension_6",
"session_custom_dimension_7",
"session_custom_dimension_8",
"session_custom_dimension_9",
"session_custom_dimension_10",
"session_custom_dimension_11",
"session_custom_dimension_12",
"session_custom_dimension_13",
"session_custom_dimension_14",
"session_custom_dimension_15",
"session_custom_dimension_16",
"session_custom_dimension_17",
"session_custom_dimension_18",
"session_custom_dimension_19",
"session_custom_dimension_20",
"session_custom_dimension_21",
"session_custom_dimension_22",
"session_custom_dimension_23",
"session_custom_dimension_24",
"session_custom_dimension_25",
"session_custom_dimension_26",
"session_custom_dimension_27",
"session_custom_dimension_28",
"session_custom_dimension_29",
"session_custom_dimension_30",
"session_custom_dimension_31",
"session_custom_dimension_32",
"session_custom_dimension_33",
"session_custom_dimension_34",
"session_custom_dimension_35",
"session_custom_dimension_36",
"session_custom_dimension_37",
"session_custom_dimension_38",
"session_custom_dimension_39",
"session_custom_dimension_40",
"session_custom_dimension_41",
"session_custom_dimension_42",
"session_custom_dimension_43",
"session_custom_dimension_44",
"session_custom_dimension_45",
"session_custom_dimension_46",
"session_custom_dimension_47",
"session_custom_dimension_48",
"session_custom_dimension_49",
"session_custom_dimension_50",
"session_custom_dimension_51",
"session_custom_dimension_52",
"session_custom_dimension_53",
"session_custom_dimension_54",
"session_custom_dimension_55",
"session_custom_dimension_56",
"session_custom_dimension_57",
"session_custom_dimension_58",
"session_custom_dimension_59",
"session_custom_dimension_60",
"session_custom_dimension_61",
"session_custom_dimension_62",
"session_custom_dimension_63",
"session_custom_dimension_64",
"session_custom_dimension_65",
"session_custom_dimension_66",
"session_custom_dimension_67",
"session_custom_dimension_68",
"session_custom_dimension_69",
"session_custom_dimension_70",
"session_custom_dimension_71",
"session_custom_dimension_72",
"session_custom_dimension_73",
"session_custom_dimension_74",
"session_custom_dimension_75",
"session_custom_dimension_76",
"session_custom_dimension_77",
"session_custom_dimension_78",
"session_custom_dimension_79",
"session_custom_dimension_80",
"session_custom_dimension_81",
"session_custom_dimension_82",
"session_custom_dimension_83",
"session_custom_dimension_84",
"session_custom_dimension_85",
"session_custom_dimension_86",
"session_custom_dimension_87",
"session_custom_dimension_88",
"session_custom_dimension_89",
"session_custom_dimension_90",
"session_custom_dimension_91",
"session_custom_dimension_92",
"session_custom_dimension_93",
"session_custom_dimension_94",
"session_custom_dimension_95",
"session_custom_dimension_96",
"session_custom_dimension_97",
"session_custom_dimension_98",
"session_custom_dimension_99",
"session_custom_dimension_100",
"session_custom_dimension_101",
"session_custom_dimension_102",
"session_custom_dimension_103",
"session_custom_dimension_104",
"session_custom_dimension_105",
"session_custom_dimension_106",
"session_custom_dimension_107",
"session_custom_dimension_108",
"session_custom_dimension_109",
"session_custom_dimension_110",
"session_custom_dimension_111",
"session_custom_dimension_112",
"session_custom_dimension_113",
"session_custom_dimension_114",
"session_custom_dimension_115",
"session_custom_dimension_116",
"session_custom_dimension_117",
"session_custom_dimension_118",
"session_custom_dimension_119",
"session_custom_dimension_120",
"session_custom_dimension_121",
"session_custom_dimension_122",
"session_custom_dimension_123",
"session_custom_dimension_124",
"session_custom_dimension_125",
"session_custom_dimension_126",
"session_custom_dimension_127",
"session_custom_dimension_128",
"session_custom_dimension_129",
"session_custom_dimension_130",
"session_custom_dimension_131",
"session_custom_dimension_132",
"session_custom_dimension_133",
"session_custom_dimension_134",
"session_custom_dimension_135",
"session_custom_dimension_136",
"session_custom_dimension_137",
"session_custom_dimension_138",
"session_custom_dimension_139",
"session_custom_dimension_140",
"session_custom_dimension_141",
"session_custom_dimension_142",
"session_custom_dimension_143",
"session_custom_dimension_144",
"session_custom_dimension_145",
"session_custom_dimension_146",
"session_custom_dimension_147",
"session_custom_dimension_148",
"session_custom_dimension_149",
"session_custom_dimension_150",
"session_custom_dimension_151",
"session_custom_dimension_152",
"session_custom_dimension_153",
"session_custom_dimension_154",
"session_custom_dimension_155",
"session_custom_dimension_156",
"session_custom_dimension_157",
"session_custom_dimension_158",
"session_custom_dimension_159",
"session_custom_dimension_160",
"session_custom_dimension_161",
"session_custom_dimension_162",
"session_custom_dimension_163",
"session_custom_dimension_164",
"session_custom_dimension_165",
"session_custom_dimension_166",
"session_custom_dimension_167",
"session_custom_dimension_168",
"session_custom_dimension_169",
"session_custom_dimension_170",
"session_custom_dimension_171",
"session_custom_dimension_172",
"session_custom_dimension_173",
"session_custom_dimension_174",
"session_custom_dimension_175",
"session_custom_dimension_176",
"session_custom_dimension_177",
"session_custom_dimension_178",
"session_custom_dimension_179",
"session_custom_dimension_180",
"session_custom_dimension_181",
"session_custom_dimension_182",
"session_custom_dimension_183",
"session_custom_dimension_184",
"session_custom_dimension_185",
"session_custom_dimension_186",
"session_custom_dimension_187",
"session_custom_dimension_188",
"session_custom_dimension_189",
"session_custom_dimension_190",
"session_custom_dimension_191",
"session_custom_dimension_192",
"session_custom_dimension_193",
"session_custom_dimension_194",
"session_custom_dimension_195",
"session_custom_dimension_196",
"session_custom_dimension_197",
"session_custom_dimension_198",
"session_custom_dimension_199",
"session_custom_dimension_200",
"session_custom_variable_key_1",
"session_custom_variable_key_2",
"session_custom_variable_key_3",
"session_custom_variable_key_4",
"session_custom_variable_key_5",
"session_custom_variable_key_6",
"session_custom_variable_key_7",
"session_custom_variable_key_8",
"session_custom_variable_key_9",
"session_custom_variable_key_10",
"session_custom_variable_value_1",
"session_custom_variable_value_2",
"session_custom_variable_value_3",
"session_custom_variable_value_4",
"session_custom_variable_value_5",
"session_custom_variable_value_6",
"session_custom_variable_value_7",
"session_custom_variable_value_8",
"session_custom_variable_value_9",
"session_custom_variable_value_10",
"session_ecommerce_status",
"session_entry_title",
"session_entry_url",
"session_exit_title",
"session_exit_url",
"session_goal_uuids",
"session_goals",
"session_second_title",
"session_second_url",
"session_total_abandoned_carts",
"session_total_cart_additions",
"session_total_cart_removals",
"session_total_content_impressions",
"session_total_content_interactions",
"session_total_custom_events",
"session_total_downloads",
"session_total_ecommerce_conversions",
"session_total_events",
"session_total_goal_conversions",
"session_total_outlinks",
"session_total_page_views",
"session_total_product_detail_views",
"session_total_sharepoint_comments",
"session_total_sharepoint_creations",
"session_total_sharepoint_deletions",
"session_total_sharepoint_edits",
"session_total_sharepoint_item_attachment_views",
"session_total_sharepoint_item_shares",
"session_total_sharepoint_item_views",
"session_total_sharepoint_likes",
"session_total_sharepoint_opens",
"session_total_sharepoint_promotions",
"session_total_sharepoint_shares",
"session_total_sharepoint_uploads",
"session_total_site_searches",
"session_total_time",
"session_unique_content_impressions",
"session_unique_content_interactions",
"session_unique_custom_events",
"session_unique_downloads",
"session_unique_outlinks",
"session_unique_page_views",
"session_unique_searches",
"sharepoint_department",
"sharepoint_display_name",
"sharepoint_job_title",
"sharepoint_office",
"source",
"source_medium",
"user_id",
"visitor_days_since_first_session",
"visitor_days_since_last_session",
"visitor_days_since_order",
"visitor_returning",
"visitor_session_number",
"website_name"
]
Events scope - preferred¶
"columns": [
"content_interaction",
"content_name",
"content_piece",
"content_target",
"custom_event_action",
"custom_event_category",
"custom_event_name",
"custom_event_value",
"domain_lookup_time",
"download_url",
"event_custom_dimension_1",
"event_custom_dimension_2",
"event_custom_dimension_3",
"event_custom_dimension_4",
"event_custom_dimension_5",
"event_custom_dimension_6",
"event_custom_dimension_7",
"event_custom_dimension_8",
"event_custom_dimension_9",
"event_custom_dimension_10",
"event_custom_dimension_11",
"event_custom_dimension_12",
"event_custom_dimension_13",
"event_custom_dimension_14",
"event_custom_dimension_15",
"event_custom_dimension_16",
"event_custom_dimension_17",
"event_custom_dimension_18",
"event_custom_dimension_19",
"event_custom_dimension_20",
"event_custom_dimension_21",
"event_custom_dimension_22",
"event_custom_dimension_23",
"event_custom_dimension_24",
"event_custom_dimension_25",
"event_custom_dimension_26",
"event_custom_dimension_27",
"event_custom_dimension_28",
"event_custom_dimension_29",
"event_custom_dimension_30",
"event_custom_dimension_31",
"event_custom_dimension_32",
"event_custom_dimension_33",
"event_custom_dimension_34",
"event_custom_dimension_35",
"event_custom_dimension_36",
"event_custom_dimension_37",
"event_custom_dimension_38",
"event_custom_dimension_39",
"event_custom_dimension_40",
"event_custom_dimension_41",
"event_custom_dimension_42",
"event_custom_dimension_43",
"event_custom_dimension_44",
"event_custom_dimension_45",
"event_custom_dimension_46",
"event_custom_dimension_47",
"event_custom_dimension_48",
"event_custom_dimension_49",
"event_custom_dimension_50",
"event_custom_dimension_51",
"event_custom_dimension_52",
"event_custom_dimension_53",
"event_custom_dimension_54",
"event_custom_dimension_55",
"event_custom_dimension_56",
"event_custom_dimension_57",
"event_custom_dimension_58",
"event_custom_dimension_59",
"event_custom_dimension_60",
"event_custom_dimension_61",
"event_custom_dimension_62",
"event_custom_dimension_63",
"event_custom_dimension_64",
"event_custom_dimension_65",
"event_custom_dimension_66",
"event_custom_dimension_67",
"event_custom_dimension_68",
"event_custom_dimension_69",
"event_custom_dimension_70",
"event_custom_dimension_71",
"event_custom_dimension_72",
"event_custom_dimension_73",
"event_custom_dimension_74",
"event_custom_dimension_75",
"event_custom_dimension_76",
"event_custom_dimension_77",
"event_custom_dimension_78",
"event_custom_dimension_79",
"event_custom_dimension_80",
"event_custom_dimension_81",
"event_custom_dimension_82",
"event_custom_dimension_83",
"event_custom_dimension_84",
"event_custom_dimension_85",
"event_custom_dimension_86",
"event_custom_dimension_87",
"event_custom_dimension_88",
"event_custom_dimension_89",
"event_custom_dimension_90",
"event_custom_dimension_91",
"event_custom_dimension_92",
"event_custom_dimension_93",
"event_custom_dimension_94",
"event_custom_dimension_95",
"event_custom_dimension_96",
"event_custom_dimension_97",
"event_custom_dimension_98",
"event_custom_dimension_99",
"event_custom_dimension_100",
"event_custom_dimension_101",
"event_custom_dimension_102",
"event_custom_dimension_103",
"event_custom_dimension_104",
"event_custom_dimension_105",
"event_custom_dimension_106",
"event_custom_dimension_107",
"event_custom_dimension_108",
"event_custom_dimension_109",
"event_custom_dimension_110",
"event_custom_dimension_111",
"event_custom_dimension_112",
"event_custom_dimension_113",
"event_custom_dimension_114",
"event_custom_dimension_115",
"event_custom_dimension_116",
"event_custom_dimension_117",
"event_custom_dimension_118",
"event_custom_dimension_119",
"event_custom_dimension_120",
"event_custom_dimension_121",
"event_custom_dimension_122",
"event_custom_dimension_123",
"event_custom_dimension_124",
"event_custom_dimension_125",
"event_custom_dimension_126",
"event_custom_dimension_127",
"event_custom_dimension_128",
"event_custom_dimension_129",
"event_custom_dimension_130",
"event_custom_dimension_131",
"event_custom_dimension_132",
"event_custom_dimension_133",
"event_custom_dimension_134",
"event_custom_dimension_135",
"event_custom_dimension_136",
"event_custom_dimension_137",
"event_custom_dimension_138",
"event_custom_dimension_139",
"event_custom_dimension_140",
"event_custom_dimension_141",
"event_custom_dimension_142",
"event_custom_dimension_143",
"event_custom_dimension_144",
"event_custom_dimension_145",
"event_custom_dimension_146",
"event_custom_dimension_147",
"event_custom_dimension_148",
"event_custom_dimension_149",
"event_custom_dimension_150",
"event_custom_dimension_151",
"event_custom_dimension_152",
"event_custom_dimension_153",
"event_custom_dimension_154",
"event_custom_dimension_155",
"event_custom_dimension_156",
"event_custom_dimension_157",
"event_custom_dimension_158",
"event_custom_dimension_159",
"event_custom_dimension_160",
"event_custom_dimension_161",
"event_custom_dimension_162",
"event_custom_dimension_163",
"event_custom_dimension_164",
"event_custom_dimension_165",
"event_custom_dimension_166",
"event_custom_dimension_167",
"event_custom_dimension_168",
"event_custom_dimension_169",
"event_custom_dimension_170",
"event_custom_dimension_171",
"event_custom_dimension_172",
"event_custom_dimension_173",
"event_custom_dimension_174",
"event_custom_dimension_175",
"event_custom_dimension_176",
"event_custom_dimension_177",
"event_custom_dimension_178",
"event_custom_dimension_179",
"event_custom_dimension_180",
"event_custom_dimension_181",
"event_custom_dimension_182",
"event_custom_dimension_183",
"event_custom_dimension_184",
"event_custom_dimension_185",
"event_custom_dimension_186",
"event_custom_dimension_187",
"event_custom_dimension_188",
"event_custom_dimension_189",
"event_custom_dimension_190",
"event_custom_dimension_191",
"event_custom_dimension_192",
"event_custom_dimension_193",
"event_custom_dimension_194",
"event_custom_dimension_195",
"event_custom_dimension_196",
"event_custom_dimension_197",
"event_custom_dimension_198",
"event_custom_dimension_199",
"event_custom_dimension_200",
"event_custom_variable_key_1",
"event_custom_variable_key_2",
"event_custom_variable_key_3",
"event_custom_variable_key_4",
"event_custom_variable_key_5",
"event_custom_variable_key_6",
"event_custom_variable_key_7",
"event_custom_variable_key_8",
"event_custom_variable_key_9",
"event_custom_variable_key_10",
"event_custom_variable_value_1",
"event_custom_variable_value_2",
"event_custom_variable_value_3",
"event_custom_variable_value_4",
"event_custom_variable_value_5",
"event_custom_variable_value_6",
"event_custom_variable_value_7",
"event_custom_variable_value_8",
"event_custom_variable_value_9",
"event_custom_variable_value_10",
"event_index",
"event_title",
"event_type",
"event_url",
"goal_id",
"goal_revenue",
"goal_uuid",
"is_entry",
"is_exit",
"item_count",
"lost_revenue",
"next_event_title",
"next_event_url",
"order_id",
"outlink_url",
"page_generation_time",
"page_rendering_time",
"page_view_index",
"previous_event_title",
"previous_event_url",
"product_count",
"products.brand",
"products.category",
"products.category1",
"products.category2",
"products.category3",
"products.category4",
"products.category5",
"products.dimension1",
"products.dimension2",
"products.dimension3",
"products.dimension4",
"products.dimension5",
"products.dimension6",
"products.dimension7",
"products.dimension8",
"products.dimension9",
"products.dimension10",
"products.dimension11",
"products.dimension12",
"products.dimension13",
"products.dimension14",
"products.dimension15",
"products.dimension16",
"products.dimension17",
"products.dimension18",
"products.dimension19",
"products.dimension20",
"products.name",
"products.price",
"products.quantity",
"products.revenue",
"products.sku",
"products.variant",
"redirections_time",
"revenue",
"revenue_discount",
"revenue_shipping",
"revenue_subtotal",
"revenue_tax",
"search_category",
"search_keyword",
"search_results_count",
"server_connection_time",
"server_response_time",
"sharepoint_action",
"sharepoint_author",
"sharepoint_author_department",
"sharepoint_author_display_name",
"sharepoint_author_job_title",
"sharepoint_author_office",
"sharepoint_content_type",
"sharepoint_file_type",
"sharepoint_file_url",
"sharepoint_object_type",
"time_on_page",
"timing_dom_interactive",
"timing_event_end",
"website_name"
]
Events scope¶
"columns": [
"browser_engine",
"browser_fingerprint",
"browser_language_iso639",
"browser_name",
"browser_version",
"campaign_content",
"campaign_gclid",
"campaign_id",
"campaign_name",
"content_interaction",
"content_name",
"content_piece",
"content_target",
"cookie_id",
"custom_event_action",
"custom_event_category",
"custom_event_name",
"custom_event_value",
"device_brand",
"device_model",
"device_type",
"domain_lookup_time",
"download_url",
"event_custom_dimension_1",
"event_custom_dimension_2",
"event_custom_dimension_3",
"event_custom_dimension_4",
"event_custom_dimension_5",
"event_custom_dimension_6",
"event_custom_dimension_7",
"event_custom_dimension_8",
"event_custom_dimension_9",
"event_custom_dimension_10",
"event_custom_dimension_11",
"event_custom_dimension_12",
"event_custom_dimension_13",
"event_custom_dimension_14",
"event_custom_dimension_15",
"event_custom_dimension_16",
"event_custom_dimension_17",
"event_custom_dimension_18",
"event_custom_dimension_19",
"event_custom_dimension_20",
"event_custom_dimension_21",
"event_custom_dimension_22",
"event_custom_dimension_23",
"event_custom_dimension_24",
"event_custom_dimension_25",
"event_custom_dimension_26",
"event_custom_dimension_27",
"event_custom_dimension_28",
"event_custom_dimension_29",
"event_custom_dimension_30",
"event_custom_dimension_31",
"event_custom_dimension_32",
"event_custom_dimension_33",
"event_custom_dimension_34",
"event_custom_dimension_35",
"event_custom_dimension_36",
"event_custom_dimension_37",
"event_custom_dimension_38",
"event_custom_dimension_39",
"event_custom_dimension_40",
"event_custom_dimension_41",
"event_custom_dimension_42",
"event_custom_dimension_43",
"event_custom_dimension_44",
"event_custom_dimension_45",
"event_custom_dimension_46",
"event_custom_dimension_47",
"event_custom_dimension_48",
"event_custom_dimension_49",
"event_custom_dimension_50",
"event_custom_dimension_51",
"event_custom_dimension_52",
"event_custom_dimension_53",
"event_custom_dimension_54",
"event_custom_dimension_55",
"event_custom_dimension_56",
"event_custom_dimension_57",
"event_custom_dimension_58",
"event_custom_dimension_59",
"event_custom_dimension_60",
"event_custom_dimension_61",
"event_custom_dimension_62",
"event_custom_dimension_63",
"event_custom_dimension_64",
"event_custom_dimension_65",
"event_custom_dimension_66",
"event_custom_dimension_67",
"event_custom_dimension_68",
"event_custom_dimension_69",
"event_custom_dimension_70",
"event_custom_dimension_71",
"event_custom_dimension_72",
"event_custom_dimension_73",
"event_custom_dimension_74",
"event_custom_dimension_75",
"event_custom_dimension_76",
"event_custom_dimension_77",
"event_custom_dimension_78",
"event_custom_dimension_79",
"event_custom_dimension_80",
"event_custom_dimension_81",
"event_custom_dimension_82",
"event_custom_dimension_83",
"event_custom_dimension_84",
"event_custom_dimension_85",
"event_custom_dimension_86",
"event_custom_dimension_87",
"event_custom_dimension_88",
"event_custom_dimension_89",
"event_custom_dimension_90",
"event_custom_dimension_91",
"event_custom_dimension_92",
"event_custom_dimension_93",
"event_custom_dimension_94",
"event_custom_dimension_95",
"event_custom_dimension_96",
"event_custom_dimension_97",
"event_custom_dimension_98",
"event_custom_dimension_99",
"event_custom_dimension_100",
"event_custom_dimension_101",
"event_custom_dimension_102",
"event_custom_dimension_103",
"event_custom_dimension_104",
"event_custom_dimension_105",
"event_custom_dimension_106",
"event_custom_dimension_107",
"event_custom_dimension_108",
"event_custom_dimension_109",
"event_custom_dimension_110",
"event_custom_dimension_111",
"event_custom_dimension_112",
"event_custom_dimension_113",
"event_custom_dimension_114",
"event_custom_dimension_115",
"event_custom_dimension_116",
"event_custom_dimension_117",
"event_custom_dimension_118",
"event_custom_dimension_119",
"event_custom_dimension_120",
"event_custom_dimension_121",
"event_custom_dimension_122",
"event_custom_dimension_123",
"event_custom_dimension_124",
"event_custom_dimension_125",
"event_custom_dimension_126",
"event_custom_dimension_127",
"event_custom_dimension_128",
"event_custom_dimension_129",
"event_custom_dimension_130",
"event_custom_dimension_131",
"event_custom_dimension_132",
"event_custom_dimension_133",
"event_custom_dimension_134",
"event_custom_dimension_135",
"event_custom_dimension_136",
"event_custom_dimension_137",
"event_custom_dimension_138",
"event_custom_dimension_139",
"event_custom_dimension_140",
"event_custom_dimension_141",
"event_custom_dimension_142",
"event_custom_dimension_143",
"event_custom_dimension_144",
"event_custom_dimension_145",
"event_custom_dimension_146",
"event_custom_dimension_147",
"event_custom_dimension_148",
"event_custom_dimension_149",
"event_custom_dimension_150",
"event_custom_dimension_151",
"event_custom_dimension_152",
"event_custom_dimension_153",
"event_custom_dimension_154",
"event_custom_dimension_155",
"event_custom_dimension_156",
"event_custom_dimension_157",
"event_custom_dimension_158",
"event_custom_dimension_159",
"event_custom_dimension_160",
"event_custom_dimension_161",
"event_custom_dimension_162",
"event_custom_dimension_163",
"event_custom_dimension_164",
"event_custom_dimension_165",
"event_custom_dimension_166",
"event_custom_dimension_167",
"event_custom_dimension_168",
"event_custom_dimension_169",
"event_custom_dimension_170",
"event_custom_dimension_171",
"event_custom_dimension_172",
"event_custom_dimension_173",
"event_custom_dimension_174",
"event_custom_dimension_175",
"event_custom_dimension_176",
"event_custom_dimension_177",
"event_custom_dimension_178",
"event_custom_dimension_179",
"event_custom_dimension_180",
"event_custom_dimension_181",
"event_custom_dimension_182",
"event_custom_dimension_183",
"event_custom_dimension_184",
"event_custom_dimension_185",
"event_custom_dimension_186",
"event_custom_dimension_187",
"event_custom_dimension_188",
"event_custom_dimension_189",
"event_custom_dimension_190",
"event_custom_dimension_191",
"event_custom_dimension_192",
"event_custom_dimension_193",
"event_custom_dimension_194",
"event_custom_dimension_195",
"event_custom_dimension_196",
"event_custom_dimension_197",
"event_custom_dimension_198",
"event_custom_dimension_199",
"event_custom_dimension_200",
"event_custom_variable_key_1",
"event_custom_variable_key_2",
"event_custom_variable_key_3",
"event_custom_variable_key_4",
"event_custom_variable_key_5",
"event_custom_variable_key_6",
"event_custom_variable_key_7",
"event_custom_variable_key_8",
"event_custom_variable_key_9",
"event_custom_variable_key_10",
"event_custom_variable_value_1",
"event_custom_variable_value_2",
"event_custom_variable_value_3",
"event_custom_variable_value_4",
"event_custom_variable_value_5",
"event_custom_variable_value_6",
"event_custom_variable_value_7",
"event_custom_variable_value_8",
"event_custom_variable_value_9",
"event_custom_variable_value_10",
"event_index",
"event_title",
"event_type",
"event_url",
"goal_id",
"goal_revenue",
"goal_uuid",
"google_ads_ad_group_ad_id",
"google_ads_ad_group_id",
"google_ads_ad_group_name",
"google_ads_ad_network_type",
"google_ads_campaign_id",
"google_ads_campaign_name",
"google_ads_customer_id",
"google_ads_customer_name",
"ipv4_address",
"ipv6_address",
"is_bounce",
"is_entry",
"is_exit",
"item_count",
"keyword",
"local_hour",
"location_city_name",
"location_continent_iso_code",
"location_country_name",
"location_latitude",
"location_longitude",
"location_metro_code",
"location_organization",
"location_provider",
"location_subdivision_1_name",
"location_subdivision_2_name",
"lost_revenue",
"medium",
"next_event_title",
"next_event_url",
"operating_system",
"operating_system_version",
"order_id",
"outlink_url",
"page_generation_time",
"page_rendering_time",
"page_view_index",
"plugin_cookie",
"plugin_director",
"plugin_flash",
"plugin_gears",
"plugin_java",
"plugin_pdf",
"plugin_quicktime",
"plugin_realplayer",
"plugin_silverlight",
"plugin_windowsmedia",
"previous_event_title",
"previous_event_url",
"product_count",
"products.brand",
"products.category",
"products.category1",
"products.category2",
"products.category3",
"products.category4",
"products.category5",
"products.dimension1",
"products.dimension2",
"products.dimension3",
"products.dimension4",
"products.dimension5",
"products.dimension6",
"products.dimension7",
"products.dimension8",
"products.dimension9",
"products.dimension10",
"products.dimension11",
"products.dimension12",
"products.dimension13",
"products.dimension14",
"products.dimension15",
"products.dimension16",
"products.dimension17",
"products.dimension18",
"products.dimension19",
"products.dimension20",
"products.name",
"products.price",
"products.quantity",
"products.revenue",
"products.sku",
"products.variant",
"redirections_time",
"referrer_type",
"referrer_url",
"resolution",
"resolution_height",
"resolution_width",
"revenue",
"revenue_discount",
"revenue_shipping",
"revenue_subtotal",
"revenue_tax",
"search_category",
"search_keyword",
"search_results_count",
"server_connection_time",
"server_response_time",
"session_custom_dimension_1",
"session_custom_dimension_2",
"session_custom_dimension_3",
"session_custom_dimension_4",
"session_custom_dimension_5",
"session_custom_dimension_6",
"session_custom_dimension_7",
"session_custom_dimension_8",
"session_custom_dimension_9",
"session_custom_dimension_10",
"session_custom_dimension_11",
"session_custom_dimension_12",
"session_custom_dimension_13",
"session_custom_dimension_14",
"session_custom_dimension_15",
"session_custom_dimension_16",
"session_custom_dimension_17",
"session_custom_dimension_18",
"session_custom_dimension_19",
"session_custom_dimension_20",
"session_custom_dimension_21",
"session_custom_dimension_22",
"session_custom_dimension_23",
"session_custom_dimension_24",
"session_custom_dimension_25",
"session_custom_dimension_26",
"session_custom_dimension_27",
"session_custom_dimension_28",
"session_custom_dimension_29",
"session_custom_dimension_30",
"session_custom_dimension_31",
"session_custom_dimension_32",
"session_custom_dimension_33",
"session_custom_dimension_34",
"session_custom_dimension_35",
"session_custom_dimension_36",
"session_custom_dimension_37",
"session_custom_dimension_38",
"session_custom_dimension_39",
"session_custom_dimension_40",
"session_custom_dimension_41",
"session_custom_dimension_42",
"session_custom_dimension_43",
"session_custom_dimension_44",
"session_custom_dimension_45",
"session_custom_dimension_46",
"session_custom_dimension_47",
"session_custom_dimension_48",
"session_custom_dimension_49",
"session_custom_dimension_50",
"session_custom_dimension_51",
"session_custom_dimension_52",
"session_custom_dimension_53",
"session_custom_dimension_54",
"session_custom_dimension_55",
"session_custom_dimension_56",
"session_custom_dimension_57",
"session_custom_dimension_58",
"session_custom_dimension_59",
"session_custom_dimension_60",
"session_custom_dimension_61",
"session_custom_dimension_62",
"session_custom_dimension_63",
"session_custom_dimension_64",
"session_custom_dimension_65",
"session_custom_dimension_66",
"session_custom_dimension_67",
"session_custom_dimension_68",
"session_custom_dimension_69",
"session_custom_dimension_70",
"session_custom_dimension_71",
"session_custom_dimension_72",
"session_custom_dimension_73",
"session_custom_dimension_74",
"session_custom_dimension_75",
"session_custom_dimension_76",
"session_custom_dimension_77",
"session_custom_dimension_78",
"session_custom_dimension_79",
"session_custom_dimension_80",
"session_custom_dimension_81",
"session_custom_dimension_82",
"session_custom_dimension_83",
"session_custom_dimension_84",
"session_custom_dimension_85",
"session_custom_dimension_86",
"session_custom_dimension_87",
"session_custom_dimension_88",
"session_custom_dimension_89",
"session_custom_dimension_90",
"session_custom_dimension_91",
"session_custom_dimension_92",
"session_custom_dimension_93",
"session_custom_dimension_94",
"session_custom_dimension_95",
"session_custom_dimension_96",
"session_custom_dimension_97",
"session_custom_dimension_98",
"session_custom_dimension_99",
"session_custom_dimension_100",
"session_custom_dimension_101",
"session_custom_dimension_102",
"session_custom_dimension_103",
"session_custom_dimension_104",
"session_custom_dimension_105",
"session_custom_dimension_106",
"session_custom_dimension_107",
"session_custom_dimension_108",
"session_custom_dimension_109",
"session_custom_dimension_110",
"session_custom_dimension_111",
"session_custom_dimension_112",
"session_custom_dimension_113",
"session_custom_dimension_114",
"session_custom_dimension_115",
"session_custom_dimension_116",
"session_custom_dimension_117",
"session_custom_dimension_118",
"session_custom_dimension_119",
"session_custom_dimension_120",
"session_custom_dimension_121",
"session_custom_dimension_122",
"session_custom_dimension_123",
"session_custom_dimension_124",
"session_custom_dimension_125",
"session_custom_dimension_126",
"session_custom_dimension_127",
"session_custom_dimension_128",
"session_custom_dimension_129",
"session_custom_dimension_130",
"session_custom_dimension_131",
"session_custom_dimension_132",
"session_custom_dimension_133",
"session_custom_dimension_134",
"session_custom_dimension_135",
"session_custom_dimension_136",
"session_custom_dimension_137",
"session_custom_dimension_138",
"session_custom_dimension_139",
"session_custom_dimension_140",
"session_custom_dimension_141",
"session_custom_dimension_142",
"session_custom_dimension_143",
"session_custom_dimension_144",
"session_custom_dimension_145",
"session_custom_dimension_146",
"session_custom_dimension_147",
"session_custom_dimension_148",
"session_custom_dimension_149",
"session_custom_dimension_150",
"session_custom_dimension_151",
"session_custom_dimension_152",
"session_custom_dimension_153",
"session_custom_dimension_154",
"session_custom_dimension_155",
"session_custom_dimension_156",
"session_custom_dimension_157",
"session_custom_dimension_158",
"session_custom_dimension_159",
"session_custom_dimension_160",
"session_custom_dimension_161",
"session_custom_dimension_162",
"session_custom_dimension_163",
"session_custom_dimension_164",
"session_custom_dimension_165",
"session_custom_dimension_166",
"session_custom_dimension_167",
"session_custom_dimension_168",
"session_custom_dimension_169",
"session_custom_dimension_170",
"session_custom_dimension_171",
"session_custom_dimension_172",
"session_custom_dimension_173",
"session_custom_dimension_174",
"session_custom_dimension_175",
"session_custom_dimension_176",
"session_custom_dimension_177",
"session_custom_dimension_178",
"session_custom_dimension_179",
"session_custom_dimension_180",
"session_custom_dimension_181",
"session_custom_dimension_182",
"session_custom_dimension_183",
"session_custom_dimension_184",
"session_custom_dimension_185",
"session_custom_dimension_186",
"session_custom_dimension_187",
"session_custom_dimension_188",
"session_custom_dimension_189",
"session_custom_dimension_190",
"session_custom_dimension_191",
"session_custom_dimension_192",
"session_custom_dimension_193",
"session_custom_dimension_194",
"session_custom_dimension_195",
"session_custom_dimension_196",
"session_custom_dimension_197",
"session_custom_dimension_198",
"session_custom_dimension_199",
"session_custom_dimension_200",
"session_custom_variable_key_1",
"session_custom_variable_key_2",
"session_custom_variable_key_3",
"session_custom_variable_key_4",
"session_custom_variable_key_5",
"session_custom_variable_key_6",
"session_custom_variable_key_7",
"session_custom_variable_key_8",
"session_custom_variable_key_9",
"session_custom_variable_key_10",
"session_custom_variable_value_1",
"session_custom_variable_value_2",
"session_custom_variable_value_3",
"session_custom_variable_value_4",
"session_custom_variable_value_5",
"session_custom_variable_value_6",
"session_custom_variable_value_7",
"session_custom_variable_value_8",
"session_custom_variable_value_9",
"session_custom_variable_value_10",
"session_ecommerce_status",
"session_entry_title",
"session_entry_url",
"session_exit_title",
"session_exit_url",
"session_goal_uuids",
"session_goals",
"session_second_title",
"session_second_url",
"session_total_abandoned_carts",
"session_total_cart_additions",
"session_total_cart_removals",
"session_total_content_impressions",
"session_total_content_interactions",
"session_total_custom_events",
"session_total_downloads",
"session_total_ecommerce_conversions",
"session_total_events",
"session_total_goal_conversions",
"session_total_outlinks",
"session_total_page_views",
"session_total_product_detail_views",
"session_total_sharepoint_comments",
"session_total_sharepoint_creations",
"session_total_sharepoint_deletions",
"session_total_sharepoint_edits",
"session_total_sharepoint_item_attachment_views",
"session_total_sharepoint_item_shares",
"session_total_sharepoint_item_views",
"session_total_sharepoint_likes",
"session_total_sharepoint_opens",
"session_total_sharepoint_promotions",
"session_total_sharepoint_shares",
"session_total_sharepoint_uploads",
"session_total_site_searches",
"session_total_time",
"session_unique_content_impressions",
"session_unique_content_interactions",
"session_unique_custom_events",
"session_unique_downloads",
"session_unique_outlinks",
"session_unique_page_views",
"session_unique_searches",
"sharepoint_action",
"sharepoint_author",
"sharepoint_author_department",
"sharepoint_author_display_name",
"sharepoint_author_job_title",
"sharepoint_author_office",
"sharepoint_content_type",
"sharepoint_department",
"sharepoint_display_name",
"sharepoint_file_type",
"sharepoint_file_url",
"sharepoint_job_title",
"sharepoint_object_type",
"sharepoint_office",
"source",
"source_medium",
"time_on_page",
"timing_dom_interactive",
"timing_event_end",
"user_id",
"visitor_days_since_first_session",
"visitor_days_since_last_session",
"visitor_days_since_order",
"visitor_returning",
"visitor_session_number",
"website_name"
]
Google Ads scope¶
"columns": [
"device_type",
"google_ads_ad_group_ad_id",
"google_ads_ad_group_id",
"google_ads_ad_group_name",
"google_ads_ad_network_type",
"google_ads_average_cpc",
"google_ads_campaign_id",
"google_ads_campaign_name",
"google_ads_clicks",
"google_ads_cost",
"google_ads_ctr",
"google_ads_customer_id",
"google_ads_customer_name",
"google_ads_impressions",
"keyword",
"medium",
"server_date",
"session_entry_url",
"source",
"source_medium",
"website_name"
]