What is the calculation of each metric?

metric_key

Label

Description

Formula

m_prod_purchased

Purchases

Number of events involving product purchase during a transaction (regardless of product quantity

COUNT of  "product.purchased" or "st.product.purchased"

m_prod_page_to_purchase_rate

Purchases/Product page

Ratio between the number of purchase actions and the product page displays

m_prod_purchased / m_prod_page_loads

m_transactions_users

Buyers

Number of users who made a transaction

COUNT_DISTINCT of "user_id" which have loaded an event "transaction.confirmation" or "st.transaction.confirmation"

m_rm_email

"Send by email" actions

Number of clicks to send the content by email (Rich Media).

COUNT of "rm.email"

m_rm_favorite

"Add as bookmark" actions

Number of clicks to bookmark content (Rich Media).

COUNT of "rm.favor"

m_rm_share

"Share" actions

Number of clicks to share content (Rich Media).

COUNT of "rm.share"

m_rm_download

"Download" actions

Number of clicks to download the content (Rich Media).

COUNT of "rm.download"

m_carts_display

Carts displayed

Number of times cart content was displayed

COUNT of "cart.display" or "st.cart.display"

m_prod_add_cart

Added to cart

Number of events involving a product being added to the cart (regardless of product quantity

COUNT of "product.add_to_cart" or "st.product.add_to_cart"

m_prod_page_to_cart_rate

Adds to cart/Product page

Ratio between the number of add-to-cart events and product page displays

m_prod_add_cart / m_prod_page_loads

m_app_news

App - 1st sessions

Number of 1st sessions that took place following the application installation, or following the app's uninstallation and reinstallation.

COUNT_DISTINCT of "app_sessionid" where "app_session_status" is equal to "New session"

m_app_crash

App - Crashes

A technical incident which closes the application and interrupts the user experience

COUNT of where "app_crash" is not empty

m_app_newvisitors

App - New visitors

Number of visitors who install the application for the first time, or reinstall the application after having uninstalled it. During a given day, a visitor can only have a single status: new or returning

COUNT_DISTINCT of "visitor_id"  where "app_visitor_status" is equal to "New"

m_app_session

App - Sessions

A set of events that begins when an application is launched or brought into the foreground, and ends when the application is sent to the background for more than 60 seconds (adjustable) or when the application is closed.

COUNT_DISTINCT of "app_sessionid" 

m_app_session_newvr

App - New visitors sessions

Number of sessions made by a new visitor

COUNT_DISTINCT of "app_sessionid"  where "app_visitor_status" is equal to "New"

m_app_session_returnvr

App - Returning visitors sessions

Number of sessions made by a visitor from the 2nd day of use (he becomes a returning visitor)

COUNT_DISTINCT of "app_sessionid"  where "app_visitor_status" is equal to "Returning"

m_app_returnv

App - Returning visitors

Number of visitors on a given day who are not new (2nd day of use)

COUNT_DISTINCT of "visitor_id"  where "app_visitor_status" is equal to "Returning"

m_transactions_arppu_taxfree

ARPPU excl. tax

Average Revenue Per Paying User (excl. tax). Calculation: Sum of turnover excl tax from transactions/Number of buyers

m_transactions_turnover_taxfree / m_transactions_users

m_transactions_arppu_withtax

ARPPU incl. tax

Average Revenue Per Paying User (incl. tax). Calculation: Sum of turnover including tax from transactions/Number of buyers. The user_id property must be specified for the transaction_confirmation event in order for this metric to be accurate

m_transactions_turnover_withtax / m_transactions_users

m_av_fullscreen_on

AV - Enable fullscreen

Number of times fullscreen was actived

COUNT of "av.fullscreen.on"

m_av_subtitles_on

AV - Enable subtitles

Number of times subtitles were enabled

COUNT of "av.subtitle.on"

m_av_bufferings

AV - Cumulative bufferings

Cumulative number of buffering periods before playback start over all A/V sessions

COUNT of "av.buffer.start"

m_av_ad_clicks

AV - Ad clicks

Number of clicks on Ad content

COUNT of "av.ad.click"

m_av_content_time_consumed

AV - Cumulative content-time consumed

Cumulative duration of content consumed. This metric is expressed in milliseconds.

SUM of "av_cursor_difference"

m_av_average_content_time_consumed

AV - Content-time consumed

Duration of content consumed in average during an Audio/Video Playback. This metric is expressed in milliseconds

m_av_content_time_consumed / m_av_playbacks

m_av_fullscreen_off

AV - Disable fullscreen

Number of times fullscreen was deactivated

COUNT of "av.fullscreen.off"

m_av_subtitles_off

AV - Disable subtitles

Number of times subtitles were disabled

COUNT of "av.subtitle.off"

m_av_content_total_duration

AV - Cumulative duration of contents

Cumulative duration fo contents for all Audio/Video sessions. This metric is expressed in milliseconds.

SUM of "av_session_content_duration"

m_av_ebvs

AV - EBVS

Exit before video start. Number of Audio/Video sessions where no Audio/Video content was consumed

m_av_sessions - m_av_playbacks

m_av_errors

AV - Errors

Number of technical errors over all Audio/Video sessions

COUNT of "av.error"

m_av_playbacks

AV - Playbacks

Number of Audio/Video sessions where Audio/Video content was consumed

COUNT_DISTINCT of "av_session_id" where "av_cursor_difference" is greater than "0"

m_av_full_playbacks

AV - Full playbacks

Number of full Audio/Video playbacks. A complete reading is a reading whose completion rate is above a certain threshold (95% by default)

COUNT_DISTINCT of "av_session_id" where "av_playback_conversion_rate" is greater than or equal to "0,95"

m_av_sessions_ad

AV - Ad playbacks

Number of Audio/Video sessions where Ad content was consumed

COUNT_DISTINCT of "av_session_id" where "av_ad_type" isn't empty

m_av_volumes

AV -Volume changes

Number of times the audio volume was changed

COUNT of  "av.volume" or "rm.volume"

m_av_backwards

AV - Moves backward

Cumulative number of moves backward.

COUNT of  "av.backward" or "rm.backward" or "rm.back"

m_av_forwards

AV - Moves forward

Cumulative number of moves forward.

COUNT of  "av.forward" or "rm.forward"

m_av_shares

AV - Shares

Number of Audio/Video content shares

COUNT of  "av.share" or "rm.share"

m_av_pauses

AV - Pauses

Number of pauses over all Audio/Video sessions

COUNT of  "av.pause" or "rm.pause"

m_av_plays

AV - Plays

Number of plays over all Audio/Video sessions

COUNT of  "av.play" or "rm.play"

m_av_ads_skip

AV - Ad skipped

Number Ad contents skipped

COUNT of  "av.ad.skip"

m_av_quality

AV - Playback quality

Number of times content play quality was changed

COUNT of  "av.quality"

m_av_rebufferings

AV - Cumulative rebufferings

Cumulative number of buffering periods after playback start over all Audio/Video sessions

COUNT of  "av.rebuffer.start"

m_av_displays

AV - Recommendations

Number of recommendations displayed

COUNT of  "av.display"

m_av_resumes

AV - Resumes

Number of resume playback over all Audio/Video sessions

COUNT of  "av.resume"

m_av_sessions

AV - Sessions

Number of Audio/Video sessions. A session is created from the first Audio/Video event, even if no Audio/Video content was consumed. A session is created after a STOP and also as soon as the content consumed changes

COUNT_DISTINCT of "av_session_id" 

m_av_sessions_buffering

AV - Sessions with buffering

Number of Audio/Video sessions with at least one buffering period before playback start

COUNT_DISTINCT of "av_session_id" where "av.buffer.start" occured

m_av_sessions_rebuffering

AV - Sessions with rebuffering

Number of Audio/Video sessions with at least one buffering period after playback start

COUNT_DISTINCT of "av_session_id" where "av.rebuffer.start" occured

m_av_starts

AV - Starts

Number of playback starts over all Audio/Video sessions

COUNT of  "av.start"

m_av_stops

AV - Stops

Number of stops over all Audio/Video sessions

COUNT of  "av.stop" or "rm.stop"

m_av_average_bufferings

AV - Buffering rate

Average number of buffering periods before playback start, during an Audio/Video session

m_av_bufferings / m_av_sessions

m_av_average_playback_completion_rate

AV - Playback completion rate

Rate between content-time consumed and cumulative duration fo contents. This metric is expressed in percentage.

AVG of (av_content_time_consumed / "av_session_content_duration")

m_av_average_rebufferings

AV - Rebuffering rate

Average number of buffering periods after playback start, during an Audio/Video session

m_av_rebufferings / m_av_sessions

m_av_ebvs_rate

AV - EBVS rate

Ratio between total Audio/Video sessions and Audio/Video sessions with no content consumption

m_av_ebvs / m_av_sessions

m_av_full_playbacks_rate

AV - Full playbacks rate

Ratio between the amount of full Audio/Video playbacks and the amount of Audio/Video playbacks

m_av_full_playbacks / m_av_playbacks

m_av_average_global_time_buffering

AV - Total time buffering

Time spent buffering (before and after playback start), on average during an Audio/Video session. This metric is expressed in milliseconds

m_av_global_time_buffering / m_av_sessions

m_av_time_buffering

AV - Cumulative time spent buffering

Time spent buffering before playback start, over all Audio/Video sessions. This metric is expressed in milliseconds

SUM of "av_buffer_duration"

m_av_global_time_buffering

AV - Cumulative total time spent buffering

Time spent buffering before and after playback start, over all Audio/Video sessions. This metric is expressed in milliseconds

m_av_time_buffering + m_av_time_rebuffering

m_av_time_playback

AV - Cumulative playback time

Time spent consuming content, over all Audio/Video sessions. This metric does not include pause and buffering periods. This metric is expressed in milliseconds

SUM of "av_playback_duration"

m_av_time_rebuffering

AV - Cumulative time spent rebuffering

Time spent buffering after playback start, over all Audio/Video sessions. This metric is expressed in milliseconds

SUM of "av_rebuffer_duration"

m_av_average_time_spent

AV - Time spent

Time spent on average during an Audio/Video session. This metric includes pause and buffering time spent. This metric is expressed in milliseconds

m_av_time_spent / m_av_sessions

m_av_average_time_buffering

AV - Time spent buffering

Time spent buffering before playback start, on average, during an Audio/Video session. This metric is expressed in milliseconds

m_av_time_buffering / m_av_sessions

m_av_time_spent

AV - Cumulative time spent

Cumulative time spent on Audio/Video contents. This metric includes pause and buffering time spent. This metric is expressed in milliseconds

SUM of "av_duration"

m_av_average_time_playback

AV - Playback time

Time spent consuming content, on average, during an Audio/Video playback. This metric does not include pause and buffering periods. This metric is expressed in milliseconds

m_av_time_playback / m_av_playbacks

m_av_average_time_rebuffering

AV - Time spent rebuffering

Time spent buffering after playback start, on average, during an Audio/Video session. This metric is expressed in milliseconds

m_av_time_rebuffering / m_av_sessions

m_av_speed

AV - Playback speed

Number of times playback speed was changed

COUNT of  "av.speed"

m_av_playback_more_25

AV Playbacks - Completion rate ≥  25%

Number of Audio/Video playbacks for which the completion rate is at least 25%

COUNT_DISTINCT of "av_session_id" where "av_playback_conversion_rate" is greater than or equal to "0,25"

m_av_playback_more_50

AV Playbacks - Completion rate ≥ 50%

Number of Audio/Video playbacks for which the completion rate is at least 50%

COUNT_DISTINCT of "av_session_id" where "av_playback_conversion_rate" is greater than or equal to "0,5"

m_av_playback_more_75

AV Playbacks - Completion rate ≥ 75%

Number of Audio/Video playbacks for which the completion rate is at least 75%

COUNT_DISTINCT of "av_session_id" where "av_playback_conversion_rate" is greater than or equal to "0,75"

m_av_playback_less_25

AV Playbacks - Completion rate between 0 and 25%

Number of Audio/Video playbacks for which the completion rate is higher than 0% and below 25%

COUNT_DISTINCT of "av_session_id" where "av_playback_conversion_rate" is greater than or equal to "0" and less than "0,25"

m_av_playback_less_50

AV Playbacks - Completion rate between 25 and 50%

Number of Audio/Video playbacks for which the completion rate is equal or higher than 25% and below 50%

m_av_playback_less_75

AV Playbacks - Completion rate between 50 and 75%

Number of Audio/Video playbacks for which the completion rate is equal or higher than 50% and below 75%

m_av_playback_less_95

AV Playbacks - Completion rate between 75 and 95%

Number of Audio/Video playbacks for which the completion rate is  equal or higher than 75% and below 95%

m_carts_amount_taxfree

Turnover excl. tax (carts in progress)

Turnover (excluding tax) from carts with an event during the analysis period

SUM of "cart_last_turnovertaxfree"

m_avg_carts_amount_taxfree

Turnover excl. tax / current cart

Average value (excl. tax) of carts over the analysis period. Calculation: sum of cart amounts excl. tax / number of carts 

m_carts_amount_taxfree / m_carts

m_transactions_avg_turnover_taxfree

Average order value (excl. tax)

Calculation: Sum of transactions (excl. tax)/Number of transactions

m_transactions_turnover_taxfree / m_transactions_with_turnover

m_carts_co_lost_turnover_taxfree_step0

Lost turnover excl. tax (step 0)

Turnover (excl. tax) of carts that were displayed and that did not trigger any events from subsequent steps during the analysis period

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_lost_turnover_taxfree_step1

Lost turnover excl. tax (step 1)

Turnover (excl. tax) of carts that triggered the event linked to Step 1 but that did not trigger any events from subsequent steps during the analysis period

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_lost_turnover_taxfree_step2

Lost turnover excl. tax (step 2)

Turnover (excl. tax) of carts that triggered the event linked to Step 2 but that did not trigger any events from subsequent steps during the analysis period

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_lost_turnover_taxfree_step3

Lost turnover excl. tax (step 3)

Turnover (excl. tax) of carts that triggered the event linked to Step 3 but that did not trigger any events from subsequent steps during the analysis period

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_amount_withtax

Turnover incl. tax (carts in progress)

Turnover (incl. tax) from carts with an event during the analysis period

SUM of "cart_last_turnovertaxincluded"

m_avg_carts_amount_withtax

Turnover incl. tax / current cart

Average value (incl. tax) of carts over the analysis period. Calculation: sum of cart amounts incl. tax / number of carts

m_carts_amount_withtax / m_carts

m_transactions_avg_turnover_withtax

Average order value (incl. tax)

Calculation: Sum of transactions (incl. tax)/Number of transactions

m_transactions_turnover_withtax / m_transactions_with_turnover

m_carts_co_lost_turnover_withtax_step0

Lost turnover incl. tax (step 0)

Turnover (incl. tax) of carts that were displayed and that did not trigger any events from subsequent steps during the analysis period

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_lost_turnover_withtax_step1

Lost turnover incl. tax (step 1)

Turnover (incl. tax) of carts that triggered the event linked to Step 1 but that did not trigger any events from subsequent steps during the analysis period

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_lost_turnover_withtax_step2

Lost turnover incl. tax (step 2)

Turnover (incl. tax) of carts that triggered the event linked to Step 2 but that did not trigger any events from subsequent steps during the analysis period

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_lost_turnover_withtax_step3

Lost turnover incl. tax (step 3)

Turnover (incl. tax) of carts that triggered the event linked to Step 3 but that did not trigger any events from subsequent steps during the analysis period

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_v_sales

Turnover (visits)

Turnover generated during the visit

SUM of "cart_turnovertaxincluded" where event is equal to "transaction.confirmation" or "st.transaction.confirmation"

m_sales_per_buyer

Turnover / buyer

Sales / buyer

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_v_sales_per_user

Turnover / user

Average turnover per user (identified visitors

m_v_sales / m_users

m_v_sales_per_visitor

Turnover / visitor

Average turnover per visitor

m_v_sales / m_unique_visitors

m_carts_turnover_taxfree

Turnover excl. tax (carts in progress)

Cart turnover (excl. tax

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_prod_turnover_taxfree

Turnover excl. tax (product)

Turnover (excl. tax) generated by the product on transactions (multiplied by the quantity in the cart

SUM of "product_pricetaxfree" * "product_quantity" where event is equal to "product.purchased" or "st.product.purchased"

m_transactions_turnover_taxfree

Turnover excl. tax (transaction)

Turnover (excl. tax) from transactions

SUM of "cart_turnovertaxfree" where event is equal to "transaction.confirmation" or "st.transaction.confirmation"

m_carts_co_lost_turnover_taxfree_global

Lost turnover excl. tax (purchasing process)

Turnover (excl. tax) of carts that had an interaction during the purchasing process but that were not confirmed during the analysis period

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_turnover_withtax

Turnover incl. tax (carts in progress)

Cart turnover (incl. tax

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_prod_turnover_withtax

Turnover incl. tax (product)

Turnover (incl. tax) generated by the product on transactions (multiplied by the quantity in the cart

SUM of "product_price_taxincluded" * "product_quantity"  where event is equal to "product.purchased" or "st.product.purchased"

m_transactions_turnover_withtax

Turnover incl. tax (transaction)

Turnover (incl. tax) from transactions

SUM of "cart_turnovertaxincluded" where event is equal to "transaction.confirmation" or "st.transaction.confirmation"

m_carts_co_lost_turnover_withtax_global

Lost turnover incl. tax (purchasing process)

Turnover (incl. tax) of carts that had an interaction during the purchasing process but that were not confirmed during the analysis period

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_sp_clicks

Self-promotion clicks

Number of clicks on a banner to promote internal content on the site.

COUNT of "self_promotion.click"

m_action_clicks

Action clicks

Action clicks

COUNT of "click.action"

m_navigation_clicks

Navigation clicks

Navigation clicks number

COUNT of "click.navigation"

m_exit_clicks

Exit clicks

Exit clicks number

COUNT of "click.exit"

m_download_clicks

Download clicks

Download clicks number

COUNT of "click.download"

m_clicks

Usability clicks

Number of usability clicks (Action, Navigation, Download, Exit)

m_action_clicks + m_download_clicks + m_exit_clicks + m_navigation_clicks

m_ise_clicks

Internal search clicks

Number of clicks on the search results of the internal engine.

COUNT of "internal_search_result.click"

m_pub_clicks

Publisher clicks

Number of clicks on a banner to promote third-party content.

COUNT of "publisher.click"

m_conv1_loads

Conversions

Number of page loads for pages defined as the main goal.

COUNT of "goal_type"  where "goal_type" is not empty AND is not equal to "Non-goals" AND is not equal to "Secondary goals"

m_conversions1_visits

Conversions

Number of visits that have loaded a main goal page at least once.

COUNT_DISTINCT of "visit_id" where ("visit_converted" is set AND is not equal to "Secondary goals" AND is not equal to "Non-goals") OR (event_name is equal to "transaction.confirmation" or "st.transaction.confirmation")

m_conv2_loads

Secondary conversions

Events number with goal type diffrent from "main"

COUNT of "goal_type"  where "goal_type" is equal to "Secondary goals" AND event_name is equal to "page.display"

m_conversions2_visits

Secondary conversions

Number of visits that have loaded a secondary goal page at least once.

COUNT_DISTINCT of "visit_id" where "goal_type" is equal to "Secondary goals"

m_rm_move

Moves (RM)

Number of movement of the progress bar cursor (Rich Media).

COUNT of "rm.move"

m_transactions_avg_cart_lifetime

Average cart lifetime

Average time between cart creation and cart's conversion into an order. Calculation: Cart lifetime/Transaction (with duration

m_transactions_cart_lifetime / m_transactions_with_date

m_transactions_cart_lifetime

Cart lifetime

Time between cart creation and transaction events

DIFFERENCE between "cart_creation_utc" AND "event_time_utc" where (event_name is equal to "transaction.confirmation" OR "st.transaction.confirmation")

m_carts_co_conv_step3_direct

Entered at this step

Number of carts that directly entered Step 3 of the purchase process and viewed at least one of the subsequent steps.

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_delivery

Shipping stage

Number of times the shipping option was displayed during the purchasing process

COUNT of  "cart.delivery" or "st.cart.delivery"

m_carts_payment

Payment step

Number of times the payment option was displayed during the purchasing process

COUNT of  "cart.payment" or "st.cart.payment"

m_events_with_duration

Events with duration

Number of events with duration

COUNT of "event_duration" greater than "0"

m_events

Events

Number of times an event occurred.

COUNT of event_name different than ["rm.refresh" | "av.heartbeat" | "av.buffer.hearbeat" | "av.rebuffer.heartbeat"] AND "exclusion_type" is empty

m_events_all

Events (all)

Number of events counted, including excluded events.

COUNT of event_name different than ["rm.refresh" | "av.heartbeat" | "av.buffer.hearbeat" | "av.rebuffer.heartbeat"]

m_prod_page_loads

Product pages

Number of product page display events

COUNT of  "product.page.display" or "st.product.page.display"

m_prod_loads_to_page_rate

Product pages/Impression

Ratio between the number of product page display events and the number of total product impression events

m_prod_page_loads / m_prod_loads

m_prod_discounted

Promotional impressions

Number of times the product was shown with a promotion

COUNT of "product_discount" where is equal to "true"

m_prod_out_of_stock

Out-of-stock impressions

Number of times the product was shown as out of stock

COUNT of "product_stock" where is equal to "true"

m_prod_loads

Impressions

Number of product display actions on the site (not including product pages

COUNT of  "product.display" or "st.product.display"

m_sp_impressions

Self-promotion impressions

Number of banner displays designed to promote internal content on the site.

COUNT of  "self_promotion.display"

m_pub_impressions

Publisher impressions

Number of banner displays designed to promote third-party content.

COUNT of  "publisher.display"

m_carts_actions

Interactions (carts in progress)

Number of interactions across all carts during the analysis period

COUNT of  "cart.creation" or "st.cart.creation" or "cart.display" or "st.cart.display" or "cart.delivery" or "st.cart.delivery" or "cart.payment" or "st.cart.payment" or "cart.update" or "st.cart.update" or "cart.awaiting_payment" or "st.cart.awaiting.payment"

m_days

Days

Number of days with traffic.

COUNT_DISTINCT of "date" 

m_rm_playcounts

Playcounts (RM)

Number of playbacks of content (Rich Media).

COUNT_DISTINCT of "rm_session_id" 

m_transactions_shipping_taxfree

Shipping costs excl. tax

Shipping costs (excl. tax) indicated in transactions

SUM of "shipping_costtaxfree" where event is equal to "transaction.confirmation" or "st.transaction.confirmation"

m_transactions_shipping_withtax

Shipping costs incl. tax

Shipping costs (incl. tax) indicated in transactions

SUM of "shipping_costtaxincluded" where event is equal to "transaction.confirmation" or "st.transaction.confirmation"

m_email_opens

Email opens

Number of times an email is opened.

COUNT of  "email.display.offsite"

m_page_loads

Page views

Number of times a page has been loaded. If the analysed element was not present on a page, the value of this metric will necessarily be 0. This metric has an Event scope and should not be confused with the "Pages Views (visits)" metric (which gives all the pages viewed during a visit, without relation to the analysed page)

m_page_views

Page views (visit)

Total number of page loads/views during the visit

COUNT of  "page.display" for the whole "visit_id"

m_page_views_per_visits

Page views (visit) / visits

Average number of page loads that occur during a visit.  Calculation: pages viewed / visits This is a visit-scope metric and should not be confused with the "Loads/Visits" metric. It should also be used carefully for event-scope dimensions (pages, chapters, etc.)

m_page_views / m_visits

m_page_views_per_iv

Page views / user

Average number of page views per identified visitor

m_page_views / m_users

m_page_loads_per_visit

Page views / visit

Average number of page loads that occur during a visit. Calculation: page views / visits

m_page_loads / m_visit_with_pages

m_page_views_per_uv

Page views / visitor

Average number of page views per unique visitors

m_page_views / m_uv

m_page_loads_with_duration

Page views with duration

Number of times a page has been loaded filtered on loads with duration. This metric excludes the last page of a visit and the pages who are followed within the same second by another page.display event.

COUNT of  "page.display" where "page_duration" is greater than "0"

m_ise_page_views

Page views with search

Number of times the search results page is loaded (internal search engine).

COUNT of  "page.display" where "ise_keyword" is not empty

m_carts_awaiting_payment

Pending payments 

Number of times customer tried to pay for an order

COUNT of  "cart.awaiting.payment" or "st.cart.awaiting.payment"

m_carts_total

Carts

Number of distinct carts that had an interaction during the analysis period

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_final_step

Carts (last step)

Total number of carts with confirmed orders (during the analysis period

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_step0

Carts (step 0)

Total number of carts displayed (converted + abandoned

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_step1

Carts (step 1)

Total number of carts that arrived at Step 1 of the checkout funnel (converted + abandoned

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_step2

Carts (step 2)

Total number of carts that arrived at Step 2 of the checkout funnel (converted + abandoned

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_step3

Carts (step 3)

Total number of carts that arrived at Step 3 of the checkout funnel (converted + abandoned

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_checkout_process

Carts (purchasing process)

Number of carts with an interaction during the purchasing process

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_abandon_step0

Abandoned carts (step 0)

Number of carts that were displayed and did not trigger any events from subsequent steps during the analysis period

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_abandon_step1

Abandoned carts (step 1)

Number of carts that triggered the event linked to Step 1 but that did not trigger any events from subsequent steps during the analysis period

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_abandon_step2

Abandoned carts (step 2)

Number of carts that triggered the event linked to Step 2 but that did not trigger any events from subsequent steps during the analysis period

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_abandon_step3

Abandoned carts (step 3)

Number of carts that triggered the event linked to Step 3 but that did not trigger any events from subsequent steps during the analysis period

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_conv_final_step

Carts ordered

Number of carts that were ordered

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_conv_step0

Converted carts (step 0)

Number of carts that were displayed and that triggered at least one event from a subsequent step during the analysis period

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_conv_step1

Converted carts (step 1)

Number of carts that triggered the event linked to Step 1 and that triggered at least one event from a subsequent step during the analysis period

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_conv_step2

Converted carts (step 2)

Number of carts that triggered the event linked to Step 2 and that triggered at least one event from a subsequent step during the analysis period

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_conv_step3

Converted carts (step 3)

Number of carts that triggered the event linked to Step 3 and that triggered at least one event from a subsequent step during the analysis period

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_created

Carts created

Number of cart creations

COUNT of  "cart.creation" or "st.cart.creation"

m_carts

Carts in progress

Number of distinct carts that had an interaction during the analysis period

COUNT_DISTINCT of "cart_id" 

m_carts_co_conv_step1_direct

Started on this step (step 1)

Number of carts that directly entered Step 1 of the purchasing process and viewed at least one of the subsequent steps

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_conv_step2_direct

Started on this step (step 2)

Number of carts that directly entered Step 2 of the purchasing process and viewed at least one of the subsequent steps

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_abandon_step1_direct

Carts started on step 1

Number of carts that directly entered Step 1 of the purchasing process and did not view any subsequent steps

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_abandon_step2_direct

Carts started on step 2

Number of carts that directly entered Step 2 of the purchasing process and did not view any subsequent steps

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_abandon_step3_direct

Carts started on step 3

Number of carts that directly entered Step 3 of the purchasing process and did not view any subsequent steps

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_abandon_global

Abandoned carts (purchasing process)

Number of abandoned carts

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_abandon_step1_prev

Carts from a previous step

Number of carts that came from a previous step of the purchasing process and did not view any subsequent steps

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_abandon_step2_prev

Carts from a previous step

Number of carts that came from a previous step of the purchasing process and did not view any subsequent steps

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_abandon_step3_prev

Carts from a previous step

Number of carts that came from a previous step of the purchasing process and did not view any subsequent steps

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_conv_step1_prev

Carts from a previous step

Number of carts that came from a previous step of the purchasing process and viewed at least one of the subsequent steps

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_conv_step2_prev

Carts from a previous step

Number of carts that came from a previous step of the purchasing process and viewed at least one of the subsequent steps

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_conv_step3_prev

Carts from a previous step

Number of carts that came from a previous step of the purchasing process and viewed at least one of the subsequent steps

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_rm_pause

Pause actions

Number of clicks on the 'Pause' button of the content (Rich Media).

COUNT of "rm.pause"

m_rm_play

Play actions

Number of clicks on the 'Play' button of the content (Rich Media).

COUNT of "rm.play"

m_app_newsau

First sessions after update

Number of sessions after the update of the application

COUNT_DISTINCT of "app_sessionid" where "app_session_status" is equal to "New session after update"

m_carts_prod

Products (carts in progress)

Number of distinct products pending in carts (carts that may have converted after the period, or that may still convert later

SUM of "cart_last_nbdistinctproduct" for the whole "cart_id"

m_transactions_prod_bought

Distinct products (transaction)

Number of distinct products in transactional events

SUM of "cart_last_nbdistinctproduct"  where (event_name is equal to "transaction.confirmation" OR "st.transaction.confirmation")

m_transactions_avg_pdt_bought

Products / transaction

Number of distinct products per transaction. Calculation: Sum of distinct products for each transaction/Number of transactions

m_transactions_prod_bought / m_transactions_with_turnover

m_avg_pdt_carts

Distinct products / current cart

Number of distinct pending products in carts. Calculation : Sum of distinct products in carts  / Number of carts

m_carts_prod / m_carts

m_transactions_avg_pdt_bought_qty

Product quantities / transaction

Average quantity of products per transaction. Calculation: Sum of product quantities ordered/Number of transactions

m_transactions_prod_bought_qty / m_transactions_with_turnover

m_carts_prod_qty

Product quantities (carts in progress) 

Summed quantities of products pending in carts

SUM of "cart_last_quantity"  for the whole "cart_id"

m_transactions_prod_bought_qty

Product quantities (transaction)

Summed quantities of products present in transactional events

SUM of "cart_quantity"   where (event_name is equal to "transaction.confirmation" OR "st.transaction.confirmation")

m_avg_pdt_carts_qty

Products quantities / current cart

Average quantity of pending products in carts. Calculation : Summed product quantities in carts/ Number of carts

m_carts_prod_qty / m_carts

m_prod_qty_purchased

Purchased quantities

Sum of product quantities purchased during transactions

SUM of "product_quantity"  where (event_name is equal to "product.purchased" OR "st.product.purchased")

m_prod_qty_add_cart

Quantities added to cart

Sum of product quantitites added to cart

SUM of "product_quantity"  where (event_name is equal to "product.add_to_cart" OR "st.product.add_to_cart")

m_prod_qty_remove_cart

Quantities removed from cart

Sum of product quantities removed from a cart

SUM of "product_quantity"  where (event_name is equal to "product.remove_from_cart" OR "st.product.remove_from_cart")

m_prod_remove_cart

Removed from cart

Number of events involving a product being removed from the cart (regardless of product quantity

COUNT of  "product.remove_from_cart" or "st.product.remove_from_cart"

m_rm_stop

Stop actions

Number of clicks on the 'Stop' button of the content (Rich Media).

COUNT of "rm.stop"

m_carts_co_loss_rate_step0

Abandon rate (carts viewed)

Number of viewed carts that did not continue to a subsequent step during the analysis period, divided by the number of viewed carts (converted carts + abandoned carts

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_loss_rate_step1

Step 1 abandon rate

Number of carts from Step 1 that did not continue to a subsequent step during the analysis period, divided by the total number of carts that arrived at Step 1 (converted carts + abandoned carts

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_loss_rate_step2

Step 2 abandon rate

Number of carts from Step 2 that did not continue to a subsequent step during the analysis period, divided by the total number of carts that arrived at Step 2 (converted carts + abandoned carts

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_carts_co_loss_rate_step3

Step 3 abandon rate

Number of carts from Step 3 that did not continue to a subsequent step during the analysis period, divided by the total number of carts that arrived at Step 3 (converted carts + abandoned carts

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_entry_rate

Entry rate

Ratio between entrering visits (with 2 page views and more) and all page visits. Calculation: Entering visits / Visits.

m_entering_visits / m_visits

m_sp_click_rate

Self-promotion clicks rate

Ratio between self-promotion clicks and self-promotion impressions. Calculation: Self-promotion clicks / Self-promotion impressions.

m_sp_clicks / m_sp_impressions

m_pub_click_rate

Publisher clicks rate

Ratio between Publisher clicks and Publisher impressions. Calculation: Publisher clicks / Publisher impressions.

m_pub_clicks / m_pub_impressions

m_conv1_iv_per_all_iv

Conversion rate

Number of unique identified visitors who converted divided by the total number of unique identified visitors

m_conv1_iv/ m_iv

m_conv1_uv_per_all_uv

Conversion rate

Number of unique visitors who converted divided by the total number of unique visitors

m_conv1_uv/ m_uv

m_conv1_rate

Conversion rate

Ratio between the number of visits converted to a main goal and the total number of visits.

m_conv1_visits / m_visits

m_carts_co_conv_rate_global

Conversion rate (purchasing process)

Conversion rate for the purchasing process (number of cart confirmations / (number of abandoned carts + number of cart confirmations)

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_conv1_user_rate

Conversion rate (user)

Ratio between the number of users who converted to a main goal and the total number of users. Calculation: converted users / users.

m_conv1_users / m_users

m_conv1_visitor_rate

Conversion rate (visitor)

Ratio between the number of visitors who converted to a main goals and the total number of visitors. Calculation: Converted visitors / Visitors.

m_conv1_visitors / m_unique_visitors

m_link_percentage

Links rate

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_bounce_rate

Bounce rate

Ratio between bounces (visits with only 1 page view) and all visits with pages.

m_bounces / m_visits

m_exits_rate

Exits rate

m_exits_page / m_page_loads

m_exits_page

Number of exits on the page

COUNT of" visit_id" where the page is the exit page

m_time_spent

Time spent

Total time spent on site. This metric is expressed in milliseconds.

SUM of "event_duration" 

m_time_spent_per_pages_loads

Time spent (page) / page

Time spent on the same page on average per page. Calculation: Cumulation of the durations of a page P / Loads of this page P (with duration). Excludes bounced visit pages and last visit pages. This metric has a Pages range and is expressed in seconds.

m_time_spent_loads / m_page_loads_with_duration

m_time_spent_loads

Time spent (pages)

Cumulative time spent on pages. Calculation : Sum of inter-pages durations. Excludes bounced  visit pages and last visit pages. This metric is expressed in seconds.

SUM of "page_duration" 

m_time_spent_per_events

Time spent / event

Average time spent between events. Calculation : Time spent / number of events with duration

m_time_spent / m_events_with_duration

m_time_spent_per_app_session

Time spent / sessions (apps)

Average time spent on apps session for the site. Calculation: cumulative time spent / apps session with duration.

m_time_spent / m_app_session

m_time_spent_per_iv

Time spent / user

Average time spent on the site per unique visitors

m_time_spent_visits / m_iv

m_time_spent_per_user

Time spent / user

Average time spent on the site by users (visitors who have been identified).

m_time_spent / m_users_with_duration

m_time_spent_per_user_loads

Time spent / user (pages)

Average time spent on the site by visitors (those who have made at least 2 page loads within a visit).

m_time_spent_loads / m_users_time_spent

m_time_spent_per_visits_loads

Time spent / visit (pages)

Average duration of visits to the site. Calculation: cumulative time spent / visits with duration. Visits without duration are excluded from this calculation. This metric has a Visit range and is expressed in seconds.

m_time_spent_loads / m_visits_with_duration_loads

m_time_spent_per_visits

Time spent / visit

Average duration of visits to the site. Calculation: cumulative time spent / visits with duration. This metric has a Visit range and is expressed in milliseconds.

m_time_spent / m_visits_with_duration

m_time_spent_per_uv

Time spent / visitor

Average time spent on the site per unique identified visitors

m_time_spent_visits / m_uv

m_time_spent_per_visitor

Time spent / visitor

Average time spent on the site by visitors (those who have made at least 1 visit).

m_time_spent / m_visitors_with_duration

m_time_spent_per_visitor_loads

Time spent / visitor (pages)

Average time spent on the site by visitors (those who have made at least 2 page loads within a visit).

m_time_spent_loads / m_visitors_with_time_spent

m_time_spent_visits

Cumulative time spent (visits)

Total time spent on site (bounces not included). This metric is expressed in seconds.

SUM of "visits_duration" 

m_transactions

Transactions

Number of transaction.confirmation events

COUNT of  "transaction.confirmation" or "st.transaction.confirmation"

m_transactions_with_turnover

Transactions with turnover

Number of transaction events with turnover

COUNT of "transaction.confirmation" or "st.transaction.confirmation" where "cart_turnovertaxfree" or "cart_turnovertaxfree" is not empty

m_transactions_with_date

Transactions with date

Number of transaction events with date

COUNT of "transaction.confirmation" or "st.transaction.confirmation" where "cart_creation_utc" is not empty

m_users_with_time_spent

Users with time spent

Users with time spent 

COUNT_DISTINCT of "user_id" where "visit_duration" is greater than "0"

m_iv

Users

Number of deduplicated identified visitors during the period

COUNT_DISTINCT of "user_id"

m_users

Users

Number of users (identified visitors). These users are quite distinct over the period.

COUNT_DISTINCT of "user_id"

m_users_with_duration

Users with duration

Users with duration 

COUNT_DISTINCT of "user_id" where "event_duration" is greater than "0"

m_conv1_users

Converted users

Number of users who have converted to a main goals

COUNT_DISTINCT of "user_id" where (first value of "goal_type" is not equal to "Secondary goals" and not empty) or where ("event_name" is equal to "transaction.confirmation" or "st.transaction.confirmation")

m_v_sales_per_iv

Sales / user

Average sales turnover/revenue per unique identified visitors

m_v_sales / m_iv

m_v_sales_per_uv

Sales / visitor

Average sales turnover/reveue per unique visitors.

m_v_sales / m_users

m_visit_with_pages

Visit with pages

Metric used in order to calculate "Page views per visit"

COUNT_DISTINCT of "user_id" where "visit_page_views" is greater than "0"

m_visits

Visits

A visit is defined as a set of events that occured on your site ("onsite" event) by the same visitor. If no event is measured during a defined period of time (usually 30 minutes), the visit ends.

COUNT_DISTINCT of "visit_id"

m_visits_per_iv

Visits / user

Average number of visits per unique identified visitors

m_visits / m_iv

m_visits_per_user

Visits / user

Average number of visits per user (identified visitors).

m_visits / m_users

m_visits_per_uv

Visits / visitor

Average number of visits per unique visitors

m_visits / m_uv

m_visits_per_visitor

Visits / visitor

Average number of visits per visitor.

m_visits / m_unique_visitors

m_visits_with_duration

Visits with duration

Number of visits with duration.

COUNT_DISTINCT of "visit_id" where "event_duration" is greater than "0"

m_visits_with_duration_loads

Visits with duration (pages)

Number of visits with inter-page duration

COUNT_DISTINCT of "visit_id" where "page_duration" is greater than "0"

m_bounces

Bounces

Number of visits with only 1 page view. These visits can have duration.

COUNT_DISTINCT of "visit_id" where "visit_bounce" is equal to "true"

m_conv1_visits

Converted visits

Number of visits that have loaded a main goal page at least once.

COUNT_DISTINCT of "visit_id" where (first value of "goal_type" is not equal to "Secondary goals" and not empty) or where ("event_name" is equal to "transaction.confirmation" or "st.transaction.confirmation")

m_conv2_visits

Converted visits (secondary)

Number of visits that have loaded a secondary goal page at least once.

COUNT_DISTINCT of "visit_id" where first value of "goal_type" is equal to "Secondary goals"

m_entering_visits

Entering visits

Number of visits with at least 2 page loads.

COUNT_DISTINCT of "visit_id" where "visit_page_views" is greater than "0"

m_entering_visits_with_duration

Entering visits with duration

Number of entering visits with duration.

COUNT_DISTINCT of "visit_id" where "page_duration" is greater than "0"

m_visitors_with_time_spent

Visitors with time spent

Visitors with time spent 

COUNT_DISTINCT of "visitor_id" where "visit_duration" is greater than "0"

m_uv

Unique Visitors

A unique visitor is an individual, most of the time identified via cookie or a device ID, who has made at least one visit with one page view during the given period. Each individual is considered unique on the analysed period.

COUNT_DISTINCT of "visitor_id"

m_unique_visitors

Visitors

Number of visitors (each people recognized mainly with a cookie and who has made at least 1 visit). These visitors are distincts on the period.

COUNT_DISTINCT of "visitor_id"

m_visitors_with_duration

Visitors with duration

Visitors with duration 

COUNT_DISTINCT of "visitor_id" where "event_duration" is greater than "0"

m_conv1_visitors

Converted visitors

Number of visitors who converted to a main objective

COUNT_DISTINCT of "visitor_id" where (first value of "goal_type" is not equal to "Secondary goals" and not empty) or where ("event_name" is equal to "transaction.confirmation" or "st.transaction.confirmation")

m_prod_vu

Unique visitors (product)

Number of unique visitors exposed to a product event (added and removed from cart, impressions, product pages, purchases

SQA it means that the metric is calculated via a specific query on specific analysis in Explorer

m_conv1_uv

Buying unique visitors

Number of unique visitors who converted

COUNT_DISTINCT of "visitor_id" where (first value of "goal_type" is not equal to "Secondary goals" and not empty) or where ("event_name" is equal to "transaction.confirmation" or "st.transaction.confirmation")

m_conv1_iv

Buying unique identified visitors

Number of unique identified visitors who converted

COUNT_DISTINCT of "user_id" where (first value of "goal_type" is not equal to "Secondary goals" and not empty) or where ("event_name" is equal to "transaction.confirmation" or "st.transaction.confirmation")