Some calculated properties are not available in Data Flow exports, because they are calculated on the fly and not stored, or because they change over time.
For example, whether a visit is a bounce is not known in advance: it depends on what the visitor does next. Because visit_bounce cannot be determined at export time, it is not available in Data Flow exports.
You can find the full list of excluded properties in the attached document for download or in the table below:
|
propertyKey |
type |
name |
description |
|
app_fsmn |
INTEGER |
First session month number |
Number of the month (from 1 to 12) corresponding to the date of the first session. Information within "event" scope (several possible values per visit). |
|
app_fsw |
INTEGER |
First session week |
Week number corresponding to the date of the first session. Information within "event" scope (several possible values per visit). |
|
app_fswd |
STRING |
First session weekday |
Weekday (Monday to Sunday) corresponding to the date of the first session. Information within "event" range (several possible values per visit). |
|
app_fswdn |
INTEGER |
First session weekday number |
Weekday number (from 1 to 7) corresponding to the date of the first session. Information within "event" scope (several possible values per visit). |
|
app_fswy |
INTEGER |
First session year of week |
Year completing the identification of the week of the first session date (mainly for week 1). Information within "event" scope (several possible values per visit). |
|
app_fsy |
INTEGER |
Year of first session |
Year corresponding to the date of the first session. Information within "event" scope (several possible values per visit). |
|
av_buffer_total_duration |
INTEGER |
AV Session - Buffering time |
Time spent buffering before the start of playback. Information within the "Audio/Video session" scope (several values possible per visit) |
|
av_content_time_consumed |
INTEGER |
AV Session - Duration of content consumed |
Amount of content consumed during the Audio/Video session. Information within the "Audio/Video session" scope (several values possible per visit) |
|
av_playback_completion_rate |
DECIMAL |
AV Session - Completion rate |
Rate between the Audio/Video content duration and the duration of content consumed during the Audio/Video session. Information within the "Audio/Video session" scope (several values possible per visit) |
|
av_playback_total_duration |
INTEGER |
AV Session - Playback time |
Time spent consuming content during the Audio/Video session. Information within the "Audio/Video session" scope (several values possible per visit) |
|
av_rebuffer_total_duration |
INTEGER |
AV Session - Rebuffering time |
Time spent buffering during playback. Information within the "Audio/Video session" scope (several values possible per visit) |
|
av_session_backward |
BOOLEAN |
AV Session - Backward movement |
Information (yes/no) to know whether the Audio/Video playback moved backwards within the session. Information within the "Audio/Video session" scope (several values possible per visit) |
|
av_session_bounce |
BOOLEAN |
AV Bounced session |
Information (yes/no) to know whether an Audio/Video session bounced. A rebound session is an Audio/Video session for which no content has been consumed. Information within the "Audio/Video session" scope (several values possible per visit) |
|
av_session_buffering |
BOOLEAN |
AV Session - With buffering |
Information (yes/no) to find out whether the Audio/Video session suffered buffering before playing. Information within the "Audio/Video session" scope (several values possible per visit) |
|
av_session_content_duration |
INTEGER |
AV Session - Content duration |
Total duration of the Audio/video content (the most recent if several values for the same Audio/Video session). This time serves as a reference for reading completion rates. Information within the "Audio/Video session" scope (several values possible per visit) |
|
av_session_error |
BOOLEAN |
AV Session - With error |
Information (yes/no) to know whether the Audio/Video session encountered a technical error with the player. Information within the "Audio/Video session" scope (several values possible per visit) |
|
av_session_forward |
BOOLEAN |
AV Session - Forward movement |
Information (yes/no) to know whether the Audio/Video playback moved forwards within the session. Information within the "Audio/Video session" scope (several values possible per visit) |
|
av_session_last_event |
STRING |
AV Session - Last event |
Last event of the Audio/Video session. Information within the "Audio/Video session" scope (several values possible per visit) |
|
av_session_rebuffering |
BOOLEAN |
AV Session - With rebuffering |
Information (yes/no) to find out whether the Audio/Video session encountered buffering during the play. Information within the "Audio/Video session" scope (several values possible per visit) |
|
av_session_time |
DATE |
AV Session - Start time |
Timestamp of the first event of the Audio/Video session. Information within the "Audio/Video session" scope (several values possible per visit) |
|
av_session_time_utc |
DATE |
AV Session - Start time (UTC) |
Timestamp (UTC) of the first event of the Audio/Video session. Information within the "Audio/Video session" scope (several values possible per visit) |
|
cart_lifetime |
INTEGER |
Cart lifetime |
Basket lifecycle, which consists of measuring the number of days between its creation and its conversion into a transaction |
|
date |
DATE |
Date |
Date of the event measurement, without the time. This information has a "Day" range (only 1 value per day) |
|
date_day |
STRING |
Weekday |
Weekday of the measurement date (Monday, Tuesday, etc.) |
|
date_month |
INTEGER |
Month |
Month of the measurement date. |
|
date_monthnumber |
INTEGER |
Month number |
Measurement date month number |
|
date_week |
INTEGER |
Week |
Week of the measurement date |
|
date_year |
INTEGER |
Year |
Year of the measurement date |
|
date_yearofweek |
INTEGER |
Year (week) |
Year of the week of the measurement date (useful for week 1 which can overlap 2 years) |
|
event_hour |
INTEGER |
Hour |
Collection time (that of our collectors, depending on the merger associated with the site) of the event. Information within "event" scope (several possible values per visit) |
|
event_minute |
INTEGER |
Minute |
Minute of collection (that of our collectors, depending on the merger associated with the site) of the event. Information within "event" scope (several possible values per visit) |
|
event_position |
INTEGER |
Event position |
Position of the event amongst all the events during the same visit. Information within "event" scope (several possible values per visit). |
|
event_second |
INTEGER |
Second |
Second collection period (that of our collectors, depending on the merger associated with the site) of the event. Information within "event" scope (several possible values per visit) |
|
ise_result |
STRING |
Internal search - Result |
Distribution between the 2 types of search results on internal search engine: with or without result. Information within "event" scope (several possible values per visit) |
|
page_duration |
INTEGER |
Inter-pages duration |
Time elapsed between a page.display event and the next page.display event, within the same visit. Information within "event" scope (several possible values per visit) |
|
page_position |
INTEGER |
Page - Position |
Position of the page amongst all the page loads during the same visit. Information within "event" scope (several possible values per visit) and only for "page.display" events |
|
site |
STRING |
Site |
Label of the site related to the measured event. |
|
src_campaign_ad |
STRING |
Ad - Campaign |
Details of advertising campaigns on third-party sites that generated a visit on your site. Information within "visit" range (only 1 value per visit, duplicated on all its events). It should have value only when the "Source" property contains the value "Advertisement". To get clicks on campaigns, just filter on event "Campaign offsite click". |
|
src_campaign_aff |
STRING |
Affiliation - Campaign |
Details of the affiliation campaigns that generated a visit on your site. Information within "visit" range (only 1 value per visit, duplicated on all its events). It should have value only when the "Source" property contains the value "Affiliation". To get clicks on campaigns, just filter on event "Campaign offsite click". |
|
src_campaign_email |
STRING |
Emailing - Campaign |
Details of the emailing campaigns that generated a visit to your site. Information within "visit" range (only 1 value per visit, duplicated on all its events). It should have value only when the "Source" property contains the value "Email marketing". To get clicks on campaigns, just filter on event "Campaign offsite click". |
|
src_campaign_rss |
STRING |
RSS campaign |
Details of the RSS campaigns that generated a visit to your site. Information within "visit" range (only 1 value per visit, duplicated on all its events). It should have value only when the "Source" property contains the value "RSS". To get clicks on campaigns, just filter on event "Campaign offsite click". |
|
src_campaign_sl |
STRING |
SEA - Campaign |
Details of the SEA campaigns that generated a visit to your site. Information within "visit" range (only 1 value per visit, duplicated on all its events). It should have value only when the "Source" property contains the value "Sponsored links". To get clicks on campaigns, just filter on event "Campaign offsite click". |
|
src_direct_access |
STRING |
Direct access |
Direct accesses are accesses from your site (from page to page) or accesses for which we do not have the referrer information (previous URL). Information within "visit" range (only 1 value per visit, duplicated on all its events). It has value only when the "Source" property contains the value "Direct traffic". |
|
src_email_type |
STRING |
Email - Type |
Category of the emailing campaign (acquisition, retention or promotional). Information within "visit" range (only 1 value per visit, duplicated on all its events). It should have value only when the "Source" property contains the value "Email marketing". To get clicks on campaigns, just filter on event "Campaign offsite click". |
|
src_portal_domain |
STRING |
Portal site - Domain |
URL (complete) that precedes the measured event, regardless of the type of source. Information within the "Event " range (several possible values per visit). |
|
src_portal_site |
STRING |
Portal site |
Site of your organisation that generated a visit on the measured site (Portal option). Information within "visit" range (only 1 value per visit, duplicated on all its events). It has value only when the "Source" property contains the value "Portal sites". |
|
src_portal_url |
STRING |
Portal site - URL |
URL of the site of your organisation that generated a visit on the measured site (Portal option). Information within "visit" range (only 1 value per visit, duplicated on all its events). It has value only when the "Source" property contains the value "Portal sites". |
|
src_referrer_domain |
STRING |
Referrer site - Domain |
Domain of organic sources of the "Referrer Sites" type. Information within "visit" range (only 1 value per visit, duplicated on all its events). It has value only when the "Source" property contains the value "Referrer sites". |
|
src_referrer_site_domain |
STRING |
Referrer site - Domain |
Domain of organic sources of the "Referrer Sites" type. Information within "visit" range (only 1 value per visit, duplicated on all its events). It has value only when the "Source" property contains the value "Referrer sites". |
|
src_referrer_site_url |
STRING |
Referrer - URL |
URLs of organic sources of the "Referrer Sites" type. Information within "visit" range (only 1 value per visit, duplicated on all its events). It has value only when the "Source" property contains the value "Referrer sites".. |
|
src_se |
STRING |
Search engine |
Search engine that generated a visit to your site. Information within "visit" range (only 1 value per visit, duplicated on all its events). It has value only when the "Source" property contains the value "Search engines". |
|
src_sl_platform |
STRING |
SEA - Platform |
Platform linked to your SEA campaigns. Information within "visit" range (only 1 value per visit, duplicated on all its events). It should have value only when the "Source" property contains the value "Sponsored links". To get clicks on campaigns, just filter on event "Campaign offsite click". |
|
src_social_networks |
STRING |
Social network |
Social media that generated a visit on your site. Information within "visit" range (only 1 value per visit, duplicated on all its events). It has value only when the "Source" property contains the value "Social media" |
|
src_webmail |
STRING |
Webmail |
Online electronic messaging that generated a visit on the site. Information within "visit" range (only 1 value per visit, duplicated on all its events). It has value only when the "Source" property contains the value "Webmail". |
|
transaction_date |
DATE |
Transaction date |
Date of the transaction. This information has a "Day" range (only 1 value per day) |
|
visit_bounce |
BOOLEAN |
Bounce visit? |
A bounce visit is a visit that has less than 2 pages (0 or 1, regardless of the number of events). Information (true/false) at "visit" range (only 1 value per visit) |
|
visit_converted |
BOOLEAN |
Visit converted? |
A converted visit is a visit that has achieved a main objective (to be defined in a configuration and which can be based on a page or other). Information (true/false) at "visit" range (only 1 value per visit) |
|
visit_duration |
INTEGER |
Visit duration |
Duration of the visit. It is calculated either between the entry page and the exit page (pre-migration) or between the 1st event and the last one (post-migration). Information within "visit" scope (only 1 value per visit) |
|
visit_entry_aisle1 |
STRING |
Entry aisle - 1st level |
First level of entry aisle informed about events. Information within "visit" scope (only 1 value per visit) |
|
visit_entry_aisle2 |
STRING |
Entry aisle - 2nd level |
Second entry aisle level informed about events. Information within "visit" scope (only 1 value per visit) |
|
visit_entry_aisle3 |
STRING |
Entry aisle - 3rd level |
Third level of entry aisle informed about events. Information within "visit" scope (only 1 value per visit) |
|
visit_entry_aisle4 |
STRING |
Entry aisle - 4th level |
Fourth level of entry aisle informed about events. Information within "visit" scope (only 1 value per visit) |
|
visit_entry_aisle5 |
STRING |
Entry aisle - 5th level |
Fifth level of entry aisle informed about events. Information within "visit" scope (only 1 value per visit) |
|
visit_entry_aisle6 |
STRING |
Entry aisle - 6th level |
Sixth level of entry aisle informed about events. Information within "visit" scope (only 1 value per visit) |
|
visit_entry_site_level2 |
STRING |
Entry level 2 site |
Level 2 in which the 1st measured event of the visit is stored. Information within "visit" scope (only 1 value per visit) |
|
visit_entrypage |
STRING |
Entry page |
Label of the entry pages (the one of the 1st event of type "page.display" of the visit). Information within "visit" scope (only 1 value per visit) |
|
visit_entrypage_chapter1 |
STRING |
Entry page - 1st level |
First level of storage of the entry pages (previously "Chapters"). This information is provided on "Page.display" events. It has a "visit" scope (only 1 value per visit) |
|
visit_entrypage_chapter2 |
STRING |
Entry page - 2nd level |
Second level of storage of the entry pages (previously "Chapters"). This information is provided on "Page.display" events. It has a "visit" scope (only 1 value per visit) |
|
visit_entrypage_chapter3 |
STRING |
Entry page - 3rd level |
Third level of storage of the entry pages (previously "Chapters"). This information is provided on "Page.display" events. It has a "visit" scope (only 1 value per visit) |
|
visit_entrypage_full_name |
STRING |
Entry page - with levels |
Label of the entry pages with complete tree structure (the one of the 1st event of type "page.display" of the visit). Information within "visit" scope (only 1 value per visit) |
|
visit_exit_site_level2 |
STRING |
Exit level 2 site |
Level 2 in which the last measured event of the visit is stored. Information within "visit" scope (only 1 value per visit) |
|
visit_exitpage |
STRING |
Exit page |
Label of the output pages (the one of the last "page.display" event of the visit). Information within "visit" scope (only 1 value per visit) |
|
visit_exitpage_chapter1 |
STRING |
Exit page - 1st level |
First level of storage of exit pages (previously "Chapters"). This information is provided on "Page.display" events. It has a "visit" scope (only 1 value per visit) |
|
visit_exitpage_chapter2 |
STRING |
Exit page - 2nd level |
Second level of storage of exit pages (previously "Chapters"). This information is provided on "Page.display" events. It has a "visit" scope (only 1 value per visit) |
|
visit_exitpage_chapter3 |
STRING |
Exit page - 3rd level |
Third level of storage of exit pages (previously "Chapters"). This information is provided on "Page.display" events. It has a "visit" scope (only 1 value per visit) |
|
visit_exitpage_full_name |
STRING |
Exit page - Full name |
Labelled output pages with the complete tree structure (that of the last "page.display" event of the visit). Information within "visit" scope (only 1 value per visit) |
|
visit_hour |
INTEGER |
Visit start - Hour |
Start time of the visit based on the time of measurement of the 1st event of the visit. Information within "visit" scope (only 1 value per visit) |
|
visit_implication_degree |
INTEGER |
Implication degree (visit) |
Level of interest of the visit, on a scale from 1 to 5 (5 being the highest). Information within "visit" scope (only 1 value per visit). |
|
visit_minute |
INTEGER |
Visit start - Minute |
Minute of the 1st event collected for the visit (that of our collectors, depending on the merger associated with the site). Information within "visit" scope (only 1 value per visit) |
|
visit_page_views |
INTEGER |
Page views (visit) |
Number of pages viewed (all "page.display" events) during a visit. Unlike the "Pages viewed" metric, which sums all these values, this property allows you to have a distribution of the pages viewed for each visit. Information within "visit" scope (only 1 value per visit) |
|
visit_sales |
DECIMAL |
Sales (visit) |
Turnover corresponding to the sum of the turnover excluding VAT of the transactions of the same visit. Information within "visit" scope (only 1 value per visit) |
|
visit_second |
INTEGER |
Visit start - Second |
Second of the 1st event measured of the visit on our collectors, according to the fusion associated with the site) of the event. Information within "visit" scope (only 1 value per visit) |
|
visit_time |
DATE |
Visit start - Date |
Time (date with hour:minute:second) of the first event of the visit. Information within "visit" scope (only 1 value per visit) |