DataVolume
Overview
SearchSession View exposes information about each search experience users have via 3S / Microsoft Search. The information exposed by this view includes whether the user was successful with their search, what interactions caused success in their search, how long it took to reach success etc. Each row exposed by this view represents a single search session by a user. This session can be broken down into several conversations, and each conversation can be broken down into individual impressions (requests).
Basic Information
Data Latency: T-3Days
Freshness: Daily Refresh
Upstream Data Source: Cosmos Searchsession Data
Data StartTime: June 1, 2021
Data Retention: No Expiration
Data Content: SearchSession Data Volume data
Columns
| Column Name | Data Type | Description | Sample Value | IsNullable |
|---|---|---|---|---|
| ID | int | Auto-increment field | 52768 | False |
| Date | datetime | Stat Count the time of the Conversation | 2021-10-02 00:00:00.000 | False |
| EntryPoint | varchar(1000) | The product (entrypoint/partner and scenario) combination. For example, officeshared.outlookdesktop represents Outlook Desktop. | bingcom.msb.ux.webserp | False |
| Ring | varchar(1000) | The corresponding Ring the session was in. For example, SDFV2, MSIT, SIP, DONMT, WW. | MSIT | False |
| TotalRows | varchar(1000) | Sum Conversation by Data,EntryPoint,Ring | 44235 | False |
Usage
Sample Scripts
Find specific data according to criteria of the DataVolume,as input or output
SELECT ID
,Date
,EntryPoint
,Ring
,TotalRows
FROM [dbo].[DataVolume]
where Date = '2021-10-02'
and EntryPoint = 'exchangeshared.owa'
Sample Data
| ID | Date | EntryPoint | Ring | TotalRows |
|---|---|---|---|---|
| 52880 | 2021-10-02 00:00:00.000 | exchangeshared.owa | MSIT | 1 |
| 52881 | 2021-10-02 00:00:00.000 | exchangeshared.owa | SIP | 466 |
| 52882 | 2021-10-02 00:00:00.000 | exchangeshared.owa | ## All Ring ## | 10437 |
| 52883 | 2021-10-02 00:00:00.000 | exchangeshared.owa | WW | 9935 |
| 52884 | 2021-10-02 00:00:00.000 | exchangeshared.owa | SDFV2 | 2 |
| 52885 | 2021-10-02 00:00:00.000 | exchangeshared.owa | DONMT | 32 |