Columns

This article documents core columns available in the HTTP API. Additional columns may become available through Integrations.

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

Dimensions

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

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

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