Introduction

Datasources and destinations

Fields listing for Piwik

Cart abandonment rate
The percentage of sessions during which shoppers abandoned their carts. Cart abandonment rate = Sessions with abandoned cart / Sessions * 100%.
Field IDabandoned_cart_rate
TypePERCENT
Data Typemetric
Bounce rate
The percentage of sessions during which visitors viewed only one page and didn’t continue to another page view, goal conversion, or order. Bounce rate = (Bounces / Sessions) * 100%.
Field IDbounce_rate
TypePERCENT
Data Typemetric
Page bounce rate
An accurate bounce rate for a page URL or page title. The percentage of sessions during which visitors viewed only that page and didn’t continue to another page view, goal conversion, or order. Page bounce rate = (Bounces / Entries) * 100%.
Field IDbounce_rate_events
TypePERCENT
Data Typemetric
Bounces
The number of sessions during which visitors viewed an entry page but didn’t continue to another page view, goal conversion, or order.
Field IDbounces
TypeNUMBER
Data Typemetric
Adds to cart
The number of times shoppers added products to their carts.
Field IDcart_additions
TypeNUMBER
Data Typemetric
Removes from cart
The number of times shoppers removed products from their carts.
Field IDcart_removals
TypeNUMBER
Data Typemetric
Cart-to-detail rate
The percentage counted as: Product adds to cart / Product detail views * 100%. This metric helps you gauge how product details affect cart additions.
Field IDcart_to_detail_rate
TypePERCENT
Data Typemetric
Consent form clicks
Clicks on one of the buttons on the form: accept all, reject all, save choices, close.
Field IDconsent_form_clicks
TypeNUMBER
Data Typemetric
Consent form impressions
Times a visitor is served a consent form.
Field IDconsent_form_impressions
TypeNUMBER
Data Typemetric
Consents to A/B testing and personalization
Times a visitor agreed to A/B testing and personalization.
Field IDconsents_ab_testing_personalization
TypeNUMBER
Data Typemetric
Consents to analytics
Times a visitor agreed to analytics.
Field IDconsents_analytics
TypeNUMBER
Data Typemetric
Any consents
Times a visitor accepted one or more consent types, but not all.
Field IDconsents_any
TypeNUMBER
Data Typemetric
Changed consents
Times a visitor changed their consent.
Field IDconsents_changed
TypeNUMBER
Data Typemetric
Consents to conversion tracking
Times a visitor agreed to conversion tracking.
Field IDconsents_conversion_tracking
TypeNUMBER
Data Typemetric
Custom consents
Times a visitor agreed to custom consent.
Field IDconsents_custom_1
TypeNUMBER
Data Typemetric
First consents
Times a visitor gave their first consent.
Field IDconsents_first
TypeNUMBER
Data Typemetric
Full consents
Times a visitor accepted all consent types.
Field IDconsents_full
TypeNUMBER
Data Typemetric
Consents to marketing automation
Times a visitor agreed to marketing automation.
Field IDconsents_marketing_automation
TypeNUMBER
Data Typemetric
No decisions
Times a visitor ignored the consent form without making any decision.
Field IDconsents_no_decision
TypeNUMBER
Data Typemetric
No consents
Times a visitor didn't consent to anything.
Field IDconsents_none
TypeNUMBER
Data Typemetric
Consents to remarketing
Times a visitor agreed to remarketing.
Field IDconsents_remarketing
TypeNUMBER
Data Typemetric
Consents to user feedback
Times a visitor agreed to user feedback.
Field IDconsents_user_feedback
TypeNUMBER
Data Typemetric
Content impressions
The number of times a content block was displayed to visitors.
Field IDcontent_impressions
TypeNUMBER
Data Typemetric
Content interaction rate
The percentage of visitors who interacted with displayed content. Content interaction rate = (Content interactions / Content impressions) * 100%.
Field IDcontent_interaction_rate
TypePERCENT
Data Typemetric
Content interactions
The number of times visitors interacted with a content block, for example, clicked an element in a content block.
Field IDcontent_interactions
TypeNUMBER
Data Typemetric
Custom events
The number of tracked custom events.
Field IDcustom_events
TypeNUMBER
Data Typemetric
Downloads
The number of clicks on links to downloadable files.
Field IDdownloads
TypeNUMBER
Data Typemetric
Abandoned carts
The total number of abandoned carts. An abandoned cart happens when a shopper places products in a cart but doesn't complete a purchase.
Field IDecommerce_abandoned_carts
TypeNUMBER
Data Typemetric
Order rate
The percentage of sessions during which shoppers completed their orders. Order conversion rate = Sessions with order / Sessions * 100%.
Field IDecommerce_conversion_rate
TypePERCENT
Data Typemetric
Orders
The total number of orders placed in your online store. An order is placed when a shopper completes the checkout process and pays for the product.
Field IDecommerce_conversions
TypeNUMBER
Data Typemetric
Entries
The number of page views for a page that was the first during a session.
Field IDentries
TypeNUMBER
Data Typemetric
Entry rate
The percentage of sessions that started on a selected page. It works only with these dimensions: page URL, page title, session entry URL. Entry rate = (Entries / Sessions) * 100%.
Field IDentry_rate
TypePERCENT
Data Typemetric
Events
The number of events performed by visitors.
Field IDevents
TypeNUMBER
Data Typemetric
Events per session
The average number of events in a session.
Field IDevents_per_session
TypeNUMBER
Data Typemetric
Exit rate
The percentage of sessions that finished on a selected page. Exit rate = (Exits / Sessions) * 100%.
Field IDexit_rate
TypePERCENT
Data Typemetric
Exit rate (events)
The percentage of sessions that finished on a selected event. Exit rate (events) = (Exits / Unique page views) * 100%.
Field IDexit_rate_events
TypePERCENT
Data Typemetric
Exits
The number of page views for a page that was the last during a session.
Field IDexits
TypeNUMBER
Data Typemetric
Goal conversion rate
The percentage of sessions during which visitors completed a goal. Goal conversion rate = (Sessions with a completed goal / Sessions) * 100%.
Field IDgoal_conversion_rate
TypePERCENT
Data Typemetric
Goal conversions
The total number of completed goals, repeated goals included.
Field IDgoal_conversions
TypeNUMBER
Data Typemetric
Order-to-detail rate
The percentage counted as: Orders / Product detail views * 100%. This metric helps you gauge how product details affect product sales.
Field IDorder_to_detail_rate
TypePERCENT
Data Typemetric
Outlinks
The number of clicks on links to external domains.
Field IDoutlinks
TypeNUMBER
Data Typemetric
Page views
The number of times a page was visited.
Field IDpage_views
TypeNUMBER
Data Typemetric
Product detail views
The number of times shoppers viewed the product detail page.
Field IDproduct_detail_views
TypeNUMBER
Data Typemetric
% of returning visitors
The percentage of returning visitors.
Field IDreturning_visitors_rate
TypeNUMBER
Data Typemetric
Searches
The number of searches on your site or app.
Field IDsearches
TypeNUMBER
Data Typemetric
Sessions
The number of sessions performed by visitors. A session starts with the first event and ends 30 minutes after the last event (after the session is over).
Field IDsessions
TypeNUMBER
Data Typemetric
Total quantity
The total number of products in the cart.
Field IDtotal_quantity
TypeNUMBER
Data Typemetric
Unique content impressions
The number of times a content block was uniquely displayed to visitors. Each unique combination of a content name, piece, and target is counted once per session.
Field IDunique_content_impressions
TypeNUMBER
Data Typemetric
Unique content interactions
The number of times visitors uniquely interacted with a content block, for example, clicked an element in a content block. Each unique combination of content name, piece, and target is counted once per session.
Field IDunique_content_interactions
TypeNUMBER
Data Typemetric
Unique custom events
The number of tracked unique custom events. Each unique combination of an event category, action, and name is counted once per session.
Field IDunique_custom_events
TypeNUMBER
Data Typemetric
Unique downloads
The number of unique clicks on links to downloadable files. When a visitor clicks the same link many times during a session, it will be counted only once.
Field IDunique_downloads
TypeNUMBER
Data Typemetric
Unique goal conversions
The number of uniquely completed goals. Repeated goals are counted only once per session.
Field IDunique_goal_conversions
TypeNUMBER
Data Typemetric
Unique outlinks
The number of unique clicks on links to external domains. When a visitor clicks the same link many times during a session, it will be counted only once.
Field IDunique_outlinks
TypeNUMBER
Data Typemetric
Unique page views
The number of times a page was uniquely visited. If a visitor views a page several times during one session, it will be counted only once.
Field IDunique_page_views
TypeNUMBER
Data Typemetric
Unique purchases
The number of the product purchases (orders with the product added to the cart).
Field IDunique_purchases
TypeNUMBER
Data Typemetric
Unique searches
The number of unique searches on your site or app. Each unique combination of a search keyword and category is counted once per session.
Field IDunique_searches
TypeNUMBER
Data Typemetric
Users
The number of visitors with the User ID.
Field IDusers
TypeNUMBER
Data Typemetric
Visitor IPs
The number of unique IP addresses with the IPv4 protocol.
Field IDvisitor_ips
TypeNUMBER
Data Typemetric
Visitors
The number of unique visitors. Every visitor is counted once, even if they visit the site or app many times in a given date range.
Field IDvisitors
TypeNUMBER
Data Typemetric
Currency (site or app)
The currency set in the site or app settings at the time the event was tracked, used during data processing.
Field IDapp_currency
TypeTEXT
Data Typemetric
Currency conversion rate
The exchange rate used for currency conversion.
Field IDapp_currency_conversion_rate
TypePERCENT
Data Typemetric
Browser engine
The name of the visitor’s browser engine.
Field IDbrowser_engine
TypeTEXT
Data Typemetric
Browser fingerprint
Field IDbrowser_fingerprint
TypeNUMBER
Data Typemetric
Browser language
The language of the visitor’s browser.
Field IDbrowser_language_iso639
TypeTEXT
Data Typemetric
Browser name
The name of the visitor’s browser.
Field IDbrowser_name
TypeTEXT
Data Typemetric
Browser version
The version of the visitor’s browser.
Field IDbrowser_version
TypeTEXT
Data Typemetric
Campaign content
The content of an online campaign taken from utm_content.
Field IDcampaign_content
TypeTEXT
Data Typemetric
Gclid
Google Click ID which is assigned to the click on the ad and passed to the landing page.
Field IDcampaign_gclid
TypeTEXT
Data Typemetric
Campaign ID
The ID of an online campaign taken from utm_id.
Field IDcampaign_id
TypeTEXT
Data Typemetric
Campaign name
The name of an online campaign taken from utm_campaign.
Field IDcampaign_name
TypeTEXT
Data Typemetric
Consent action
When consent was given by the visitor: for the first time or changed later on.
Field IDconsent_action
TypeTEXT
Data Typemetric
Consent form button
A button on your consent form: agree all, reject all, save choices or close.
Field IDconsent_form_button
TypeTEXT
Data Typemetric
Consent scope
What consent was given by the visitor: full, any or none.
Field IDconsent_scope
TypeTEXT
Data Typemetric
Consent source
Where visitors clicked to consent or not: a popup or bottom bar, reminder, privacy settings on a page.
Field IDconsent_source
TypeTEXT
Data Typemetric
Consent to A/B testing and personalization
A visitor consents or not to A/B testing and personalization.
Field IDconsent_type_ab_testing_personalization
TypeNUMBER
Data Typemetric
Consent to analytics
A visitor consents or not to analytics.
Field IDconsent_type_analytics
TypeNUMBER
Data Typemetric
Consent to conversion tracking
A visitor consents or not to conversion tracking.
Field IDconsent_type_conversion_tracking
TypeNUMBER
Data Typemetric
Custom consent
A visitor consents or not to the custom consent type.
Field IDconsent_type_custom_1
TypeNUMBER
Data Typemetric
Consent to marketing automation
A visitor consents or not to marketing automation.
Field IDconsent_type_marketing_automation
TypeNUMBER
Data Typemetric
Consent to remarketing
A visitor consents or not to remarketing.
Field IDconsent_type_remarketing
TypeNUMBER
Data Typemetric
Consent to user feedback
A visitor consents or not to user feedback.
Field IDconsent_type_user_feedback
TypeNUMBER
Data Typemetric
Content name
The name of the tracked content block.
Field IDcontent_name
TypeTEXT
Data Typemetric
Content piece
The piece of the tracked content block.
Field IDcontent_piece
TypeTEXT
Data Typemetric
Content target
The target of the tracked content block.
Field IDcontent_target
TypeTEXT
Data Typemetric
Cookie ID
A unique identifier of the browser.
Field IDcookie_id
TypeTEXT
Data Typemetric
Currency conversion date
The date of the exchange rate used for currency conversion.
Field IDcurrency_conversion_rates_date
TypeYEAR_MONTH_DAY
Data Typemetric
Custom event action
The action of the custom event.
Field IDcustom_event_action
TypeTEXT
Data Typemetric
Custom event category
The category of the custom event.
Field IDcustom_event_category
TypeTEXT
Data Typemetric
Custom event name
The name of the custom event.
Field IDcustom_event_name
TypeTEXT
Data Typemetric
Custom event value
The value of the custom event.
Field IDcustom_event_value
TypeNUMBER
Data Typemetric
Device brand
The brand of the visitor’s device.
Field IDdevice_brand
TypeTEXT
Data Typemetric
Device model
The model of visitor’s device.
Field IDdevice_model
TypeTEXT
Data Typemetric
Device type
The type of the visitor’s device.
Field IDdevice_type
TypeTEXT
Data Typemetric
Domain lookup time
The time taken to resolve the server’s IP address.
Field IDdomain_lookup_time
TypeNUMBER
Data Typemetric
Download URL
The URL of the downloadable file clicked by the visitor.
Field IDdownload_url
TypeTEXT
Data Typemetric
Event custom dimension 1
Field IDevent_custom_dimension_1
TypeTEXT
Data Typemetric
Event custom dimension 2
Field IDevent_custom_dimension_2
TypeTEXT
Data Typemetric
Event custom dimension 3
Field IDevent_custom_dimension_3
TypeTEXT
Data Typemetric
Event custom dimension 4
Field IDevent_custom_dimension_4
TypeTEXT
Data Typemetric
Event custom dimension 5
Field IDevent_custom_dimension_5
TypeTEXT
Data Typemetric
Event custom dimension *
Field IDevent_custom_dimension_*
TypeTEXT
Data Typemetric
Event custom variable key 1
Field IDevent_custom_variable_key_1
TypeTEXT
Data Typemetric
Event custom variable key 2
Field IDevent_custom_variable_key_2
TypeTEXT
Data Typemetric
Event custom variable key 3
Field IDevent_custom_variable_key_3
TypeTEXT
Data Typemetric
Event custom variable key 4
Field IDevent_custom_variable_key_4
TypeTEXT
Data Typemetric
Event custom variable key 5
Field IDevent_custom_variable_key_5
TypeTEXT
Data Typemetric
Event custom variable key *
Field IDevent_custom_variable_key_*
TypeTEXT
Data Typemetric
Event custom variable value 1
Field IDevent_custom_variable_value_1
TypeTEXT
Data Typemetric
Event custom variable value 2
Field IDevent_custom_variable_value_2
TypeTEXT
Data Typemetric
Event custom variable value 3
Field IDevent_custom_variable_value_3
TypeTEXT
Data Typemetric
Event custom variable value 4
Field IDevent_custom_variable_value_4
TypeTEXT
Data Typemetric
Event custom variable value 5
Field IDevent_custom_variable_value_5
TypeTEXT
Data Typemetric
Event custom variable value *
Field IDevent_custom_variable_value_*
TypeTEXT
Data Typemetric
Event ID
Field IDevent_id
TypeNUMBER
Data Typemetric
Event index
Field IDevent_index
TypeNUMBER
Data Typemetric
Page title
The title of the page on which an event took place.
Field IDevent_title
TypeTEXT
Data Typemetric
Event type
The type of event such as a page view, download, outlink, performed by a visitor.
Field IDevent_type
TypeTEXT
Data Typemetric
Page URL
The URL of the page on which an event took place.
Field IDevent_url
TypeTEXT
Data Typemetric
Goal name
The name of the goal.
Field IDgoal_id
TypeTEXT
Data Typemetric
Goal revenue
The revenue generated by a goal in the local currency.
Field IDgoal_revenue
TypeNUMBER
Data Typemetric
Goal revenue (converted)
The revenue generated by a goal, converted to the site or app currency.
Field IDgoal_revenue_app_currency
TypeNUMBER
Data Typemetric
Goal revenue (USD)
The revenue generated by a goal, converted to the base currency (USD).
Field IDgoal_revenue_base_currency
TypeNUMBER
Data Typemetric
Goal name
The name of the goal.
Field IDgoal_uuid
TypeTEXT
Data Typemetric
Currency (Google Ads)
The currency set in your Google Ads account settings. It's imported with other Google Ads data.
Field IDgoogle_ads_currency
TypeTEXT
Data Typemetric
IPv4 address
IPv4 address of a visitor. For filtering and segmenting purpose only.
Field IDipv4_address
TypeTEXT
Data Typemetric
IPv6 address
IPv6 address of a visitor. For filtering and segmenting purpose only.
Field IDipv6_address
TypeTEXT
Data Typemetric
Bounced session
A bounced or non-bounced session. Bounce is when a visitor viewed an entry page but didn’t continue to another page view, goal conversion or order.
Field IDis_bounce
TypeNUMBER
Data Typemetric
Entry view
Field IDis_entry
TypeNUMBER
Data Typemetric
Exit view
Field IDis_exit
TypeNUMBER
Data Typemetric
Unique item count
The number of unique items in an order or an abandoned basket.
Field IDitem_count
TypeNUMBER
Data Typemetric
Keyword
The keyword that a visitor used in a search engine or a keyword added as a campaign parameter.
Field IDkeyword
TypeTEXT
Data Typemetric
Local time (hour)
The time of the event in the visitor's time zone.
Field IDlocal_hour
TypeNUMBER
Data Typemetric
City
The city from which a visitor entered your site or app.
Field IDlocation_city_name
TypeTEXT
Data Typemetric
Continent
The continent from which a visitor entered your site or app.
Field IDlocation_continent_iso_code
TypeTEXT
Data Typemetric
Country
The country from which a visitor entered your site or app.
Field IDlocation_country_name
TypeTEXT
Data Typemetric
Latitude
Geographic latitude at which a visitor entered your site or app.
Field IDlocation_latitude
TypeNUMBER
Data Typemetric
Longitude
Geographic longitude at which a visitor entered your site or app.
Field IDlocation_longitude
TypeNUMBER
Data Typemetric
Designated market area
A media region where people receive similar content on TV, radio, newspaper, and internet.
Field IDlocation_metro_code
TypeTEXT
Data Typemetric
Organization
The name of the visitor’s organization, such as a business, educational, government unit. The organization is a company to which the internet service provider has sublet the IP address range. When an organization is not identified, this dimension contains the name of the internet service provider instead of the name of the business.
Field IDlocation_organization
TypeTEXT
Data Typemetric
Provider
The name of the visitor’s internet service provider.
Field IDlocation_provider
TypeTEXT
Data Typemetric
Subdivision
The region, state, province, and the like from which a visitor entered your site or app. It's the principal subdivision coded in ISO-3166.
Field IDlocation_subdivision_1_name
TypeTEXT
Data Typemetric
Subdivision 2
The region, state, province, and the like from which a visitor entered your site or app. It's the secondary subdivision coded in ISO-3166.
Field IDlocation_subdivision_2_name
TypeTEXT
Data Typemetric
Abandoned cart value
The total value of abandoned carts in the local currency, excluding discounts, shipping, and taxes. Abandoned carts happen when shoppers add items to their carts but leave without completing the purchase.
Field IDlost_revenue
TypeNUMBER
Data Typemetric
Abandoned cart value (converted)
The total value of abandoned carts, excluding discounts, shipping, and taxes, converted to the site or app currency. Abandoned carts happen when shoppers add items to their carts but leave without completing the purchase.
Field IDlost_revenue_app_currency
TypeNUMBER
Data Typemetric
Abandoned cart value (USD)
The total value of abandoned carts, excluding discounts, shipping, and taxes, converted to the base currency (USD). Abandoned carts happen when shoppers add items to their carts but leave without completing the purchase.
Field IDlost_revenue_base_currency
TypeNUMBER
Data Typemetric
Medium
The category of the source such as organic (unpaid search in the search engine), cpc (paid search in the search engine), referral (web referral), email (email campaign), and the like.
Field IDmedium
TypeTEXT
Data Typemetric
Next page view title
The title of the page that was viewed next.
Field IDnext_event_title
TypeTEXT
Data Typemetric
Next page view URL
The URL of the page that was viewed next.
Field IDnext_event_url
TypeTEXT
Data Typemetric
Operating system
The name of the visitor’s operating system.
Field IDoperating_system
TypeTEXT
Data Typemetric
Operating system version
The version of the visitor’s operating system.
Field IDoperating_system_version
TypeTEXT
Data Typemetric
Order ID
The unique identifier (ID) of the order.
Field IDorder_id
TypeTEXT
Data Typemetric
Outlink URL
The URL of the external domain that was clicked by the visitor.
Field IDoutlink_url
TypeTEXT
Data Typemetric
Page generation time
The page loading time on the visitor’s device.
Field IDpage_generation_time
TypeNUMBER
Data Typemetric
Page rendering time
The time taken to create the render tree, layout, and finally draw the website in the browser.
Field IDpage_rendering_time
TypeNUMBER
Data Typemetric
Page view index
Field IDpage_view_index
TypeNUMBER
Data Typemetric
Cookie support
An enabled or disabled support for cookies in the visitor’s browser.
Field IDplugin_cookie
TypeNUMBER
Data Typemetric
Director plugin
An enabled or disabled Director plugin in the visitor’s browser.
Field IDplugin_director
TypeNUMBER
Data Typemetric
Flash plugin
An enabled or disabled flash plugin in the visitor’s browser.
Field IDplugin_flash
TypeNUMBER
Data Typemetric
Gears plugin
An enabled or disabled Gears plugin in the visitor’s browser.
Field IDplugin_gears
TypeNUMBER
Data Typemetric
Java plugin
An enabled or disabled Java plugin in the visitor’s browser.
Field IDplugin_java
TypeNUMBER
Data Typemetric
PDF plugin
An enabled or disabled PDF plugin in the visitor’s browser.
Field IDplugin_pdf
TypeNUMBER
Data Typemetric
QuickTime plugin
An enabled or disabled QuickTime plugin in the visitor’s browser.
Field IDplugin_quicktime
TypeNUMBER
Data Typemetric
RealPlayer plugin
An enabled or disabled RealPlayer plugin in the visitor’s browser.
Field IDplugin_realplayer
TypeNUMBER
Data Typemetric
Silverlight plugin
An enabled or disabled Silverlight plugin in the visitor’s browser.
Field IDplugin_silverlight
TypeNUMBER
Data Typemetric
Windows media player plugin
An enabled or disabled Windows Media Player plugin in the visitor’s browser.
Field IDplugin_windowsmedia
TypeNUMBER
Data Typemetric
Previous page view title
The title of the page that was viewed previously.
Field IDprevious_event_title
TypeTEXT
Data Typemetric
Previous page view URL
The URL of the page that was viewed previously.
Field IDprevious_event_url
TypeTEXT
Data Typemetric
Product brand
The brand of the product in your online store.
Field IDproduct_brand
TypeTEXT
Data Typemetric
Product category
A category that includes all product category levels in your online store. Example: "Clothes/Men/T-shirts".
Field IDproduct_category
TypeTEXT
Data Typemetric
Product category (Level 1)
The first-level category of the product in your online store.
Field IDproduct_category1
TypeTEXT
Data Typemetric
Product category (Level 2)
The second-level category of the product in your online store.
Field IDproduct_category2
TypeTEXT
Data Typemetric
Product category (Level 3)
The third-level category of the product in your online store.
Field IDproduct_category3
TypeTEXT
Data Typemetric
Product category (Level 4)
The fourth-level category of the product in your online store.
Field IDproduct_category4
TypeTEXT
Data Typemetric
Product category (Level 5)
The fifth-level category of the product in your online store.
Field IDproduct_category5
TypeTEXT
Data Typemetric
Unique product count
The number of unique products. When a customer orders two iPhone 14s, the product quantity will be 2, and the unique product count will be 1.
Field IDproduct_count
TypeNUMBER
Data Typemetric
Product dimension 1
Field IDproduct_dimension1
TypeTEXT
Data Typemetric
Product dimension 2
Field IDproduct_dimension2
TypeTEXT
Data Typemetric
Product dimension 3
Field IDproduct_dimension3
TypeTEXT
Data Typemetric
Product dimension 4
Field IDproduct_dimension4
TypeTEXT
Data Typemetric
Product dimension 5
Field IDproduct_dimension5
TypeTEXT
Data Typemetric
Product dimension *
Field IDproduct_dimension*
TypeTEXT
Data Typemetric
Product name
The name of the product in your online store.
Field IDproduct_name
TypeTEXT
Data Typemetric
Product price
The price of the product in the local currency.
Field IDproduct_price
TypeNUMBER
Data Typemetric
Product price (converted)
The price of the product, converted to the site or app currency.
Field IDproduct_price_app_currency
TypeNUMBER
Data Typemetric
Product price (USD)
The price of the product, converted to the base currency (USD).
Field IDproduct_price_base_currency
TypeNUMBER
Data Typemetric
Product quantity
The total number of products. When a customer orders two iPhone 14s, the product quantity will be 2, and the unique product count will be 1.
Field IDproduct_quantity
TypeNUMBER
Data Typemetric
Product revenue
The value calculated by multiplying the product price by the product quantity in the local currency.
Field IDproduct_revenue
TypeNUMBER
Data Typemetric
Product revenue (converted)
The value calculated by multiplying the product price by the product quantity, converted to the site or app currency.
Field IDproduct_revenue_app_currency
TypeNUMBER
Data Typemetric
Product revenue (USD)
The value calculated by multiplying the product price by the product quantity, converted to the base currency (USD).
Field IDproduct_revenue_base_currency
TypeNUMBER
Data Typemetric
Product SKU
The stock-keeping unit of the product in your online store.
Field IDproduct_sku
TypeTEXT
Data Typemetric
Product variant
The variant of the product in your online store. Example: color and size.
Field IDproduct_variant
TypeTEXT
Data Typemetric
Product brand (array)
Field IDproducts.brand
TypeTEXT
Data Typemetric
Product category (array)
Field IDproducts.category
TypeTEXT
Data Typemetric
Product category 1 (array)
Field IDproducts.category1
TypeTEXT
Data Typemetric
Product category 2 (array)
Field IDproducts.category2
TypeTEXT
Data Typemetric
Product category 3 (array)
Field IDproducts.category3
TypeTEXT
Data Typemetric
Product category 4 (array)
Field IDproducts.category4
TypeTEXT
Data Typemetric
Product category 5 (array)
Field IDproducts.category5
TypeTEXT
Data Typemetric
Product dimension 1 (array)
Field IDproducts.dimension1
TypeTEXT
Data Typemetric
Product dimension 2 (array)
Field IDproducts.dimension2
TypeTEXT
Data Typemetric
Product dimension 3 (array)
Field IDproducts.dimension3
TypeTEXT
Data Typemetric
Product dimension 4 (array)
Field IDproducts.dimension4
TypeTEXT
Data Typemetric
Product dimension 5 (array)
Field IDproducts.dimension5
TypeTEXT
Data Typemetric
Product dimension * (array)
Field IDproducts.dimension*
TypeTEXT
Data Typemetric
Product name (array)
Field IDproducts.name
TypeTEXT
Data Typemetric
Product price (array)
Field IDproducts.price
TypeTEXT
Data Typemetric
Product price (array, converted)
Field IDproducts.price_app_currency
TypeTEXT
Data Typemetric
Product price (array, USD)
Field IDproducts.price_base_currency
TypeTEXT
Data Typemetric
Product quantity (array)
Field IDproducts.quantity
TypeTEXT
Data Typemetric
Product revenue (array)
Field IDproducts.revenue
TypeTEXT
Data Typemetric
Product revenue (array, converted)
Field IDproducts.revenue_app_currency
TypeTEXT
Data Typemetric
Product revenue (array, USD)
Field IDproducts.revenue_base_currency
TypeTEXT
Data Typemetric
Product SKU (array)
Field IDproducts.sku
TypeTEXT
Data Typemetric
Product variant (array)
Field IDproducts.variant
TypeTEXT
Data Typemetric
Time of redirections
The time of one or more redirects that occurred. Transactions that don’t have any HTTP redirections are not included in calculating the average value.
Field IDredirections_time
TypeNUMBER
Data Typemetric
Channel
The channel of the incoming traffic. The channels are: direct entry, search engine, website, and campaign.
Field IDreferrer_type
TypeTEXT
Data Typemetric
Referrer URL
The URL of the page that referred a visitor to your site or app.
Field IDreferrer_url
TypeTEXT
Data Typemetric
Resolution
The number of horizontal and vertical pixels on the visitor’s device.
Field IDresolution
TypeTEXT
Data Typemetric
Resolution height
The number of horizontal pixels on the visitor’s device.
Field IDresolution_height
TypeNUMBER
Data Typemetric
Resolution width
The number of vertical pixels on the visitor’s device.
Field IDresolution_width
TypeNUMBER
Data Typemetric
Revenue
The total order value in the local currency, including subtotal, tax, shipping and discounts.
Field IDrevenue
TypeNUMBER
Data Typemetric
Revenue (converted)
The total order value, including subtotal, tax, shipping and discounts, converted to the site or app currency.
Field IDrevenue_app_currency
TypeNUMBER
Data Typemetric
Revenue (USD)
The total order value, including subtotal, tax, shipping and discounts, converted to the base currency (USD).
Field IDrevenue_base_currency
TypeNUMBER
Data Typemetric
Discount
The total discount value applied to the order in the local currency.
Field IDrevenue_discount
TypeNUMBER
Data Typemetric
Discount (converted)
The total discount value applied to the order, converted to the site or app currency.
Field IDrevenue_discount_app_currency
TypeNUMBER
Data Typemetric
Discount (USD)
The total discount value applied to the order, converted to the base currency (USD).
Field IDrevenue_discount_base_currency
TypeNUMBER
Data Typemetric
Shipping
The total shipping cost of the order in the local currency.
Field IDrevenue_shipping
TypeNUMBER
Data Typemetric
Shipping (converted)
The total shipping cost of the order, converted to the site or app currency.
Field IDrevenue_shipping_app_currency
TypeNUMBER
Data Typemetric
Shipping (USD)
The total shipping cost of the order, converted to the base currency (USD).
Field IDrevenue_shipping_base_currency
TypeNUMBER
Data Typemetric
Subtotal
The total order value in the local currency, excluding shipping and discounts.
Field IDrevenue_subtotal
TypeNUMBER
Data Typemetric
Subtotal (converted)
The total order value, excluding shipping and discounts, converted to the site or app currency.
Field IDrevenue_subtotal_app_currency
TypeNUMBER
Data Typemetric
Subtotal (USD)
The total order value, excluding shipping and discounts, converted to the base currency (USD).
Field IDrevenue_subtotal_base_currency
TypeNUMBER
Data Typemetric
Tax
The total tax amount of the order in the local currency.
Field IDrevenue_tax
TypeNUMBER
Data Typemetric
Tax (converted)
The total tax amount of the order, converted to the site or app currency.
Field IDrevenue_tax_app_currency
TypeNUMBER
Data Typemetric
Tax (USD)
The total tax amount of the order, converted to the base currency (USD).
Field IDrevenue_tax_base_currency
TypeNUMBER
Data Typemetric
Search category
The category of the keyword used in the search engine on your site or app.
Field IDsearch_category
TypeTEXT
Data Typemetric
Search keyword
The keyword used in the search engine on your site or app. It works only with these metrics: searches, unique searches. .
Field IDsearch_keyword
TypeTEXT
Data Typemetric
Search results count
The count of searches on your site or app.
Field IDsearch_results_count
TypeNUMBER
Data Typemetric
Server connection time
The time taken to establish a connection with the web server.
Field IDserver_connection_time
TypeNUMBER
Data Typemetric
Server response time
The time taken to receive the first byte of response from the server to the browser’s request.
Field IDserver_response_time
TypeNUMBER
Data Typemetric
Session custom dimension 1
Field IDsession_custom_dimension_1
TypeTEXT
Data Typemetric
Session custom dimension 2
Field IDsession_custom_dimension_2
TypeTEXT
Data Typemetric
Session custom dimension 3
Field IDsession_custom_dimension_3
TypeTEXT
Data Typemetric
Session custom dimension 4
Field IDsession_custom_dimension_4
TypeTEXT
Data Typemetric
Session custom dimension 5
Field IDsession_custom_dimension_5
TypeTEXT
Data Typemetric
Session custom dimension *
Field IDsession_custom_dimension_*
TypeTEXT
Data Typemetric
Session custom variable key 1
Field IDsession_custom_variable_key_1
TypeTEXT
Data Typemetric
Session custom variable key 2
Field IDsession_custom_variable_key_2
TypeTEXT
Data Typemetric
Session custom variable key 3
Field IDsession_custom_variable_key_3
TypeTEXT
Data Typemetric
Session custom variable key 4
Field IDsession_custom_variable_key_4
TypeTEXT
Data Typemetric
Session custom variable key 5
Field IDsession_custom_variable_key_5
TypeTEXT
Data Typemetric
Session custom variable key *
Field IDsession_custom_variable_key_*
TypeTEXT
Data Typemetric
Session custom variable value 1
Field IDsession_custom_variable_value_1
TypeTEXT
Data Typemetric
Session custom variable value 2
Field IDsession_custom_variable_value_2
TypeTEXT
Data Typemetric
Session custom variable value 3
Field IDsession_custom_variable_value_3
TypeTEXT
Data Typemetric
Session custom variable value 4
Field IDsession_custom_variable_value_4
TypeTEXT
Data Typemetric
Session custom variable value 5
Field IDsession_custom_variable_value_5
TypeTEXT
Data Typemetric
Session custom variable value *
Field IDsession_custom_variable_value_*
TypeTEXT
Data Typemetric
Shopping stage
A stage that a shopper completed during a session. The stages are: No shopping activity, Ordered, Abandoned cart, Ordered and abandoned cart.
Field IDsession_ecommerce_status
TypeTEXT
Data Typemetric
Session entry title
The title of the first visited page during a session.
Field IDsession_entry_title
TypeTEXT
Data Typemetric
Session entry URL
The URL of the first visited page during the session.
Field IDsession_entry_url
TypeTEXT
Data Typemetric
Session exit title
The page title of the last visited page during the session.
Field IDsession_exit_title
TypeTEXT
Data Typemetric
Session exit URL
The URL of the last visited page during the session.
Field IDsession_exit_url
TypeTEXT
Data Typemetric
Session goals
List of goals on which user converted during the session. It can be used only for filtering purposes.
Field IDsession_goal_uuids
TypeTEXT
Data Typemetric
Session goals
List of goals on which user converted during the session. It can be used only for filtering purposes.
Field IDsession_goals
TypeTEXT
Data Typemetric
Session ID
Field IDsession_id
TypeNUMBER
Data Typemetric
Session second title
The title of the second page visited by a visitor during a session.
Field IDsession_second_title
TypeTEXT
Data Typemetric
Session second URL
The URL of the second page visited by a visitor during a session.
Field IDsession_second_url
TypeTEXT
Data Typemetric
Abandoned carts in session
The number of abandoned carts during a session.
Field IDsession_total_abandoned_carts
TypeNUMBER
Data Typemetric
Adds to cart in session
The number of adds to cart during a session.
Field IDsession_total_cart_additions
TypeNUMBER
Data Typemetric
Removes from cart in session
The number of removes from cart during a session.
Field IDsession_total_cart_removals
TypeNUMBER
Data Typemetric
Content impressions in session
The number of content impressions during a session.
Field IDsession_total_content_impressions
TypeNUMBER
Data Typemetric
Content interactions in session
The number of content interactions during a session.
Field IDsession_total_content_interactions
TypeNUMBER
Data Typemetric
Custom events in session
The number of custom events during a session.
Field IDsession_total_custom_events
TypeNUMBER
Data Typemetric
Downloads in session
The number of download events during a session.
Field IDsession_total_downloads
TypeNUMBER
Data Typemetric
Orders in session
The number of orders placed during a session.
Field IDsession_total_ecommerce_conversions
TypeNUMBER
Data Typemetric
Events in session
The number of events during a session.
Field IDsession_total_events
TypeNUMBER
Data Typemetric
Goal conversions in session
The number of completed goals during a session.
Field IDsession_total_goal_conversions
TypeNUMBER
Data Typemetric
Outlinks in session
The number of clicked outlinks during a session.
Field IDsession_total_outlinks
TypeNUMBER
Data Typemetric
Page views in session
The number of page views during a session.
Field IDsession_total_page_views
TypeNUMBER
Data Typemetric
Product detail views in session
The number of product detail views during a session.
Field IDsession_total_product_detail_views
TypeNUMBER
Data Typemetric
Site searches in session
The number of searches on your site or app during a session.
Field IDsession_total_site_searches
TypeNUMBER
Data Typemetric
Session time
The duration of a session measured from the first to last event during a visit.
Field IDsession_total_time
TypeNUMBER
Data Typemetric
Unique content impressions in session
The number of unique content impressions during a session.
Field IDsession_unique_content_impressions
TypeNUMBER
Data Typemetric
Unique content interactions in session
The number of unique content interactions during a session.
Field IDsession_unique_content_interactions
TypeNUMBER
Data Typemetric
Unique custom events in session
The number of unique custom events during a session.
Field IDsession_unique_custom_events
TypeNUMBER
Data Typemetric
Unique downloads in session
The number of unique download events during a session.
Field IDsession_unique_downloads
TypeNUMBER
Data Typemetric
Unique outlinks in session
The number of uniquely clicked outlinks during a session.
Field IDsession_unique_outlinks
TypeNUMBER
Data Typemetric
Unique page views in session
The number of unique page views during a session.
Field IDsession_unique_page_views
TypeNUMBER
Data Typemetric
Unique site searches in session
The number of unique searches on your site or app during a session.
Field IDsession_unique_searches
TypeNUMBER
Data Typemetric
Source
The origin of the incoming traffic such as direct, a search engine (for example, google) or a domain (example.com).
Field IDsource
TypeTEXT
Data Typemetric
Source / medium
A dimension that combines two dimensions: source and medium. Source is the origin of the incoming traffic. Medium is the category of the source.
Field IDsource_medium
TypeTEXT
Data Typemetric
Time on page
The amount of time the visitor spent on the page.
Field IDtime_on_page
TypeNUMBER
Data Typemetric
Date
Day and time of the event in the site’s time zone.
Field IDtimestamp
TypeYEAR_MONTH_DAY
Data Typemetric
Time until DOM is ready
The time taken to process the page document HTML and CSS.
Field IDtiming_dom_interactive
TypeNUMBER
Data Typemetric
Time to interact
The time from the user request (for example, click a link or submission of the URL in the browser) to the point when page content and main scripts are loaded and the user can interact with the page. It’s the time of the transaction between the client and the server.
Field IDtiming_event_end
TypeNUMBER
Data Typemetric
Currency (event)
The local currency tracked with an event.
Field IDtracked_currency
TypeTEXT
Data Typemetric
User ID
The ID of the visitor coming from an external source.
Field IDuser_id
TypeTEXT
Data Typemetric
Days since first session
The number of days since the visitor had their first session.
Field IDvisitor_days_since_first_session
TypeNUMBER
Data Typemetric
Days since last session
The number of days since the visitor had their last session.
Field IDvisitor_days_since_last_session
TypeNUMBER
Data Typemetric
Days since last order
The number of days since the visitor made their last order.
Field IDvisitor_days_since_order
TypeNUMBER
Data Typemetric
Visitor ID
A unique identifier of the visitor.
Field IDvisitor_id
TypeTEXT
Data Typemetric
Returning visitor
A new or returning visitor.
Field IDvisitor_returning
TypeTEXT
Data Typemetric
Session number
The number of the session counted for a visitor. Each time a visitor starts a session, a session counter increments for that visitor.
Field IDvisitor_session_number
TypeNUMBER
Data Typemetric
Site or app name
Field IDwebsite_name
TypeTEXT
Data Typemetric
Average CPC (Google Ads)
Average cost-per-click (CPC) is the amount you’ve paid for your ad divided by its total clicks. Average CPC = (Cost / Click) * 100%.
Field IDgoogle_ads_average_cpc
TypeNUMBER
Data Typemetric
Clicks (Google Ads)
The number of times people click on your ad.
Field IDgoogle_ads_clicks
TypeNUMBER
Data Typemetric
Cost (Google Ads)
The amount you’ve paid for your ads in Google Ads.
Field IDgoogle_ads_cost
TypeNUMBER
Data Typemetric
CTR (Google Ads)
Click-through rate (CTR) measures how often people click your ad in Google Ads after it’s shown to them. (CTR = (Clicks / Impressions) * 100%).
Field IDgoogle_ads_ctr
TypeNUMBER
Data Typemetric
Impressions (Google Ads)
The number of times your ad was served on Google or Google Network.
Field IDgoogle_ads_impressions
TypeNUMBER
Data Typemetric
ROAS (Google Ads)
ROAS (return on ad spend) is a web analytics metric that shows how much revenue is generated for every dollar spent on Google Ads. ROAS is a ratio of revenue from conversions to ad spend. A ROAS of $3.20 means that each $1 spent on ads generated $3.20 in revenue. Formula: ROAS = (Sum of revenue + Sum of goal revenue) / Cost (Google Ads).
Field IDgoogle_ads_roas
TypeNUMBER
Data Typemetric
Ad group ad ID (Google Ads)
The combination of a unique number that’s assigned to each group and each ad in Google Ads. Ad group ad ID = Ad group + Ad ID.
Field IDgoogle_ads_ad_group_ad_id
TypeTEXT
Data Typemetric
Ad group ID (Google Ads)
The unique number that’s assigned to each ad group in Google Ads.
Field IDgoogle_ads_ad_group_id
TypeNUMBER
Data Typemetric
Ad group name (Google Ads)
The name of your ad group in Google Ads.
Field IDgoogle_ads_ad_group_name
TypeTEXT
Data Typemetric
Ad network type (Google Ads)
The network where your ad was displayed. The networks are: content, mixed, search, search partners, unknown, unspecified, YouTube search, and YouTube watch.
Field IDgoogle_ads_ad_network_type
TypeTEXT
Data Typemetric
Campaign ID (Google Ads)
The unique number that’s assigned to each campaign in Google Ads.
Field IDgoogle_ads_campaign_id
TypeNUMBER
Data Typemetric
Campaign name (Google Ads)
The name of your campaign in Google Ads.
Field IDgoogle_ads_campaign_name
TypeTEXT
Data Typemetric
Account ID (Google Ads)
The unique number that’s assigned to each Google Ads account.
Field IDgoogle_ads_customer_id
TypeTEXT
Data Typemetric
Account (Google Ads)
The name of your Google Ads account.
Field IDgoogle_ads_customer_name
TypeTEXT
Data Typemetric
Keyword match type (Google Ads)
The keyword matching option that you’ve used for keywords in Google Ads. The match types are: broad, exact, and phrase.
Field IDgoogle_ads_keyword_match_type
TypeTEXT
Data Typemetric
Average position (search engine)
The average ranking of your website’s URL for the one or more keywords. For example, if your site’s URL appeared at position 3 for one keyword and position 7 for another keyword, the average position would be 5 ((3+7)/2).
Field IDsearch_engine_average_position
TypeNUMBER
Data Typemetric
Clicks (search engine)
The number of clicks on your website URLs from Google Search results. It doesn’t include clicks on paid Google Ads search results.
Field IDsearch_engine_clicks
TypeNUMBER
Data Typemetric
CTR (search engine)
The click-through rate. CTR = (Clicks / Impressions) * 100 .
Field IDsearch_engine_ctr
TypeNUMBER
Data Typemetric
Impressions (search engine)
The number of times any URL from your site appeared in Google search results and was seen by a visitor. It doesn’t include paid Google Ads search impressions.
Field IDsearch_engine_impressions
TypeNUMBER
Data Typemetric
Search engine keyword
Queries that generated impressions of your website’s URLs in Google organic search results.
Field IDsearch_engine_keyword
TypeTEXT
Data Typemetric
Comments (SharePoint)
The number of posted comments and comment replies.
Field IDsharepoint_comments
TypeNUMBER
Data Typemetric
Creations (SharePoint)
The number of created objects. The creation is counted when a user creates a page, file, and the like.
Field IDsharepoint_creations
TypeNUMBER
Data Typemetric
Deletions (SharePoint)
The number of object deletions. The deletion is counted when a user deletes a page, file, and the like.
Field IDsharepoint_deletions
TypeNUMBER
Data Typemetric
Edits (SharePoint)
The number of object edits. The edit is counted when a user edits a page, file, and the like.
Field IDsharepoint_edits
TypeNUMBER
Data Typemetric
Item attachment views (SharePoint)
The number of item attachment views. The item attachment view is counted when a user views an item attachment on the list by clicking on it.
Field IDsharepoint_item_attachment_views
TypeNUMBER
Data Typemetric
Item shares (SharePoint)
The number of shares of items on the list.
Field IDsharepoint_item_shares
TypeNUMBER
Data Typemetric
Item views (SharePoint)
The number of item views. The item view is counted when a user sees an item on the list by clicking on it or entering a direct URL.
Field IDsharepoint_item_views
TypeNUMBER
Data Typemetric
Likes (SharePoint)
The number of likes that content has received. It doesn’t include comment likes.
Field IDsharepoint_likes
TypeNUMBER
Data Typemetric
File openings (SharePoint)
The number of file openings. The file opening is counted when a user clicks a file in SharePoint to open it. It doesn’t include openings of attachments from list items. (See: Item attachment views).
Field IDsharepoint_opens
TypeNUMBER
Data Typemetric
Promotions (SharePoint)
The number of page promotions such as: Add page to navigation, Post as news, Save as template.
Field IDsharepoint_promotions
TypeNUMBER
Data Typemetric
Shares (SharePoint)
The number of shares such as: Copy link or Send message.
Field IDsharepoint_shares
TypeNUMBER
Data Typemetric
Uploads (SharePoint)
The number of uploaded files.
Field IDsharepoint_uploads
TypeNUMBER
Data Typemetric
Comments in session (SharePoint)
The number of comments and comment replies during a session.
Field IDsession_total_sharepoint_comments
TypeNUMBER
Data Typemetric
Creations in session (SharePoint)
The number of times a content was created during a session. For example, a page was published or a file was uploaded.
Field IDsession_total_sharepoint_creations
TypeNUMBER
Data Typemetric
Deletions in session (SharePoint)
The number of times a content like page or file was deleted.
Field IDsession_total_sharepoint_deletions
TypeNUMBER
Data Typemetric
Edits in session (SharePoint)
The number of times a content was edited during a session.
Field IDsession_total_sharepoint_edits
TypeNUMBER
Data Typemetric
Item attachment views in session (SharePoint)
The number of item attachment views during a session. The item attachment view is counted when a user opens an item attachment on the list by clicking on it.
Field IDsession_total_sharepoint_item_attachment_views
TypeNUMBER
Data Typemetric
Item shares in session (SharePoint)
The number of item shares during a session.
Field IDsession_total_sharepoint_item_shares
TypeNUMBER
Data Typemetric
Item views in session (SharePoint)
The number of item views during a session. The item view is counted when a user views an item on the list by clicking on it or entering a direct URL.
Field IDsession_total_sharepoint_item_views
TypeNUMBER
Data Typemetric
Likes in session (SharePoint)
The number of likes given to pages during a session.
Field IDsession_total_sharepoint_likes
TypeNUMBER
Data Typemetric
File openings in session (SharePoint)
The number of times a file was opened during a session.
Field IDsession_total_sharepoint_opens
TypeNUMBER
Data Typemetric
Promotions in session (SharePoint)
The number of promotions during a session. The promotion is tracked when a user performs one of these actions: Promote: Add page to navigation, Promote: Post as news on this site, Promote: Save as template, Pin to top.
Field IDsession_total_sharepoint_promotions
TypeNUMBER
Data Typemetric
Shares in session (SharePoint)
The number of shares during a session. The share is tracked when a user performs one of these actions: Promote: Send email, Promote: Copy page link, Document library: Item share, In the top bar: Send by email.
Field IDsession_total_sharepoint_shares
TypeNUMBER
Data Typemetric
Uploads in session (SharePoint)
The number of times a file was uploaded during a session.
Field IDsession_total_sharepoint_uploads
TypeNUMBER
Data Typemetric
Action (SharePoint)
The name of an action performed by the user in SharePoint such as Like, Comment, Share.
Field IDsharepoint_action
TypeTEXT
Data Typemetric
Author (SharePoint)
The author of content created in SharePoint.
Field IDsharepoint_author
TypeTEXT
Data Typemetric
Author’s department (SharePoint)
The department of content author.
Field IDsharepoint_author_department
TypeTEXT
Data Typemetric
Author’s full name (SharePoint)
The full name of content author.
Field IDsharepoint_author_display_name
TypeTEXT
Data Typemetric
Author’s job title (SharePoint)
The job title of content author.
Field IDsharepoint_author_job_title
TypeTEXT
Data Typemetric
Author’s office (SharePoint)
The office of content author.
Field IDsharepoint_author_office
TypeTEXT
Data Typemetric
Content type (SharePoint)
The type of page the user interacted with. For example, a news page.
Field IDsharepoint_content_type
TypeTEXT
Data Typemetric
Department (SharePoint)
The department of SharePoint user.
Field IDsharepoint_department
TypeTEXT
Data Typemetric
Full name (SharePoint)
The full name of SharePoint user.
Field IDsharepoint_display_name
TypeTEXT
Data Typemetric
File type (SharePoint)
The type of a file such as xls, docx, pdf.
Field IDsharepoint_file_type
TypeTEXT
Data Typemetric
File URL (SharePoint)
The URL of a file the user interacted with. The URLs of attachments added to list items are not tracked.
Field IDsharepoint_file_url
TypeTEXT
Data Typemetric
Job title (SharePoint)
The job title of SharePoint user.
Field IDsharepoint_job_title
TypeTEXT
Data Typemetric
Object type (SharePoint)
The type of an object the user interacted with such as Page, List, File.
Field IDsharepoint_object_type
TypeTEXT
Data Typemetric
Office (SharePoint)
The office of SharePoint user.
Field IDsharepoint_office
TypeTEXT
Data Typemetric
Year Month Day
Year Month Day such as 20240401.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Week of the year
Week of the year
Field IDweek
TypeWEEK
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Day of the week
Day of the week
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the year
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension