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 Scope attribute. If you request a query that includes at least one column which requires event scope, the entire query will be calculated using events, instead of sessions. 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. Additional metrics may be created using dimension transformations.

Base Metrics
Metric Name Column ID Scope Type
Events events session int
Page views page_views session int
Unique page views unique_page_views session int
Entries entries session int
Exits exits session int
Bounces bounces session int
Sessions sessions session int
Visitors visitors session int
% of returning visitors returning_visitors_rate session float
Users users session int
Visitor IPs visitor_ips session int
Outlinks outlinks session int
Unique outlinks unique_outlinks session int
Downloads downloads session int
Unique downloads unique_downloads session int
Searches searches session int
Unique searches unique_searches session int
Custom events custom_events session int
Unique custom events unique_custom_events session int
Content impressions content_impressions session int
Unique content impressions unique_content_impressions session int
Content interactions content_interactions session int
Unique content interactions unique_content_interactions session int
Goal conversions goal_conversions session int
Ecommerce conversions ecommerce_conversions session int
Ecommerce abandoned carts ecommerce_abandoned_carts session int
Unique purchases unique_purchases event int
Entry rate entry_rate session float
Exit rate exit_rate session float
Exit rate events exit_rate_events session float
Bounce rate bounce_rate session float
Bounce rate bounce_rate_events session float
Content interaction rate content_interaction_rate session float
Goal conversion rate goal_conversion_rate session float
Ecommerce conversion rate ecommerce_conversion_rate session float
Events per session events_per_session session float

Dimensions

The table below lists core dimensions that may be used in queries.

Base Dimensions
Dimension Name Column ID Scope Type Nullable Enum Table
User ID user_id session str false  
Returning visitor visitor_returning session [int, str] false visitor_returning.json
Session number visitor_session_number session int false  
Days since last session visitor_days_since_last_session session int true  
Days since first session visitor_days_since_first_session session int true  
Days since order visitor_days_since_order session int true  
Events in session session_total_events session int false  
Session time session_total_time session int false  
Page views in session session_total_page_views session int false  
Outlinks in session session_total_outlinks session int false  
Downloads in session session_total_downloads session int false  
Site searches in session session_total_site_searches session int false  
Custom events in session session_total_custom_events session int false  
Content impressions in session session_total_content_impressions session int false  
Content interactions in session session_total_content_interactions session int false  
Goal conversions in session session_total_goal_conversions session int false  
Ecommerce conversions in session session_total_ecommerce_conversions session int false  
Abandoned carts in session session_total_abandoned_carts session int false  
Unique page views in session session_unique_page_views session int false  
Unique outlinks in session session_unique_outlinks session int false  
Unique downloads in session session_unique_downloads session int false  
Unique site searches in session session_unique_searches session int false  
Unique custom events in session session_unique_custom_events session int false  
Unique content impressions in session session_unique_content_impressions session int false  
Unique content interactions in session session_unique_content_interactions session int false  
Shopping stage session_ecommerce_status session [int, str] false session_ecommerce_status.json
Source source session str false  
Medium medium session str false  
Source/Medium source_medium session str false  
Keyword keyword session str false  
Channel referrer_type session [int, str] false referrer_type.json
Referrer URL referrer_url session str false  
Campaign name campaign_name session str false  
Campaign ID campaign_id session str false  
Campaign content campaign_content session str false  
Operating system operating_system session [str, str] true operating_system.json
Operating system version operating_system_version session str false  
Browser engine browser_engine session str false  
Browser name browser_name session [str, str] true browser_name.json
Browser version browser_version session str false  
Browser language browser_language_iso639 session [str, str] true browser_language_iso639.json
Device type device_type session [int, str] true device_type.json
Device brand device_brand session [str, str] true device_brand.json
Device model device_model session str false  
Resolution resolution session str true  
Resolution width resolution_width session int true  
Resolution height resolution_height session int true  
PDF plugin plugin_pdf session int(0,1) false  
Flash plugin plugin_flash session int(0,1) false  
Java plugin plugin_java session int(0,1) false  
Director plugin plugin_director session int(0,1) false  
QuickTime plugin plugin_quicktime session int(0,1) false  
RealPlayer plugin plugin_realplayer session int(0,1) false  
Windows Media Player plugin plugin_windowsmedia session int(0,1) false  
Gears plugin plugin_gears session int(0,1) false  
Silverlight plugin plugin_silverlight session int(0,1) false  
Cookie support plugin_cookie session int(0,1) false  
Continent location_continent_iso_code session [str, str] true location_continent_iso_code.json
Country location_country_name session [str, str] true ISO 3166-2 codes (e.g. “PL”)
Subdivision location_subdivision_1_name session [str, str] true ISO 3166-2 codes (e.g. “PL-DS”)
Subdivision 2 location_subdivision_2_name session [str, str] true ISO 3166-2 codes (e.g. “ES-M”)
City location_city_name session [int, str] true unique identifiers as specified by GeoNames
Designated market area location_metro_code session [str, str] true location_metro_code.json
Latitude location_latitude session float true  
Longitude location_longitude session float true  
Provider location_provider session str false  
Organization location_organization session str false  
Session exit URL session_exit_url session str false  
Session exit title session_exit_title session str false  
Session entry URL session_entry_url session str false  
Session entry title session_entry_title session str false  
Session second URL session_second_url session str false  
Session second title session_second_title session str false  
Event type event_type event [int, str] false event_type.json
Page URL event_url event str false  
Page title event_title event str false  
Outlink URL outlink_url event str false  
Download URL download_url event str false  
Search keyword search_keyword event str false  
Search category search_category event str false  
Search results count search_results_count event int true  
Custom event category custom_event_category event str false  
Custom event action custom_event_action event str false  
Custom event name custom_event_name event str false  
Custom event value custom_event_value event float true  
Content name content_name event str false  
Content piece content_piece event str false  
Content target content_target event str false  
Content interaction content_interaction event str false  
Previous page view URL previous_event_url event str false  
Previous page view title previous_event_title event str false  
Next page view URL next_event_url event str false  
Next page view title next_event_title event str false  
Time on page time_on_page event int true  
Page generation time page_generation_time event float true  
Goal name goal_id event [int, str] true goal IDs from Analytics
Goal revenue goal_revenue event float true  
Lost revenue lost_revenue event float true  
Order ID order_id event str false  
Item count item_count event int true  
Revenue revenue event float true  
Revenue (Subtotal) revenue_subtotal event float true  
Revenue (Tax) revenue_tax event float true  
Revenue (Shipping) revenue_shipping event float true  
Revenue (Discount) revenue_discount event float true  
Time until DOM is ready timing_dom_interactive event int true  
Time to interact timing_event_end event int true  
Event custom dimension 1 event_custom_dimension_1 event str false  
Event custom dimension 2 event_custom_dimension_2 event str false  
Event custom dimension 3 event_custom_dimension_3 event str false  
Event custom dimension 4 event_custom_dimension_4 event str false  
Event custom dimension 5 event_custom_dimension_5 event str false  
Event custom variable key 1 event_custom_variable_key_1 event str false  
Event custom variable value 1 event_custom_variable_value_1 event str false  
Event custom variable key 2 event_custom_variable_key_2 event str false  
Event custom variable value 2 event_custom_variable_value_2 event str false  
Event custom variable key 3 event_custom_variable_key_3 event str false  
Event custom variable value 3 event_custom_variable_value_3 event str false  
Event custom variable key 4 event_custom_variable_key_4 event str false  
Event custom variable value 4 event_custom_variable_value_4 event str false  
Event custom variable key 5 event_custom_variable_key_5 event str false  
Event custom variable value 5 event_custom_variable_value_5 event str false  
Session custom dimension 1 session_custom_dimension_1 session str false  
Session custom dimension 2 session_custom_dimension_2 session str false  
Session custom dimension 3 session_custom_dimension_3 session str false  
Session custom dimension 4 session_custom_dimension_4 session str false  
Session custom dimension 5 session_custom_dimension_5 session str false  
Session custom variable key 1 session_custom_variable_key_1 session str false  
Session custom variable value 1 session_custom_variable_value_1 session str false  
Session custom variable key 2 session_custom_variable_key_2 session str false  
Session custom variable value 2 session_custom_variable_value_2 session str false  
Session custom variable key 3 session_custom_variable_key_3 session str false  
Session custom variable value 3 session_custom_variable_value_3 session str false  
Session custom variable key 4 session_custom_variable_key_4 session str false  
Session custom variable value 4 session_custom_variable_value_4 session str false  
Session custom variable key 5 session_custom_variable_key_5 session str false  
Session custom variable value 5 session_custom_variable_value_5 session str false  
Time of redirections redirections_time event int true  
Domain Lookup Time domain_lookup_time event int true  
Server Connection Time server_connection_time event int true  
Server Response Time server_response_time event int true  
Page Rendering Time page_rendering_time event int true  
IPv4 address ipv4_address session ipv4 true  
Website Name website_name session [str, str] false website UUID

Note

Please note that the number of available custom slots (dimensions, variables) depends on your organisation’s configuration.

Transformations

The tables below list all transformations that may be used to transform dimensions to metrics or different dimensions.

Dimension To Metric Transformations
Transformation Name Transformation ID Source Types Result Type
Unique Count unique_count str int
Min min float, int (as source)
Max max float, int (as source)
Average average bool, float, int float
Median median float, int (as source)
Sum sum float, int (as source)
Dimension To Dimension Transformations
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
URL To Path to_path str str
URL To Domain to_domain str str
URL Strip Query String strip_qs str str