# Logs and definitions

## Offline logs

| Source label | Table | Identifier | Time field | Role |
|---|---|---|---|---|
| `video` | `loghubods.video_action_log_applet` | `mid` | `clienttimestamp` | Video exposure and playback actions |
| `ad` | `loghubods.ad_action_log_own` | `machinecode` | `clienttimestamp` | Ad lifecycle actions |
| `play` | `loghubods.video_play_log` | `mid` | `clienttimestamp` | Playback logs |
| `simpleevent` | `loghubods.simpleevent_log` | `machinecode` | `clienttimestamp` | Independent user and app events |
| `useractive` | `loghubods.useractive_log` | `machinecode` | `clienttimestamp` | User-active path records |

The same supplied identifier is used as both `mid` and `machinecode`.

## Explicit real-time table map

| Source label | Real-time table | Date filter | Notes |
|---|---|---|---|
| `video` | `loghubods.video_action_log_per5min` | `dt` from `YYYYMMDD000000` to `YYYYMMDD235959` | There is no `video_action_log_applet_per5min`. |
| `ad` | `loghubods.ad_action_log_own_per5min` | Same 5-minute `dt` range | |
| `play` | `loghubods.video_play_log_per5min` | Same 5-minute `dt` range | |
| `simpleevent` | `loghubods.simpleevent_log_flow` | `year/month/day` (optionally hour) | No `_per5min` table; short real-time retention. |
| `useractive` | `loghubods.useractive_log_per5min` | Same 5-minute `dt` range | |

Use this map only when the user explicitly asks for real-time data. The result is the currently available real-time window; it is not a substitute for a complete offline daily path.

For a multi-user real-time output, the input CSV must include `用户标识`; `命中策略` is optional. The batch script deduplicates users, merges their strategy labels, and writes both a filterable event sheet and a user-count summary sheet.

## Output fields

Offline output additionally includes `endRoutePath`, `isAdPlaying`, and `creativeCode` after `pagesource`. Real-time output keeps its existing fields unless the user explicitly requests the same extension.

`pagesource` is the scene where the behavior occurred. Order timestamps using raw millisecond `clienttimestamp`; convert to China Standard Time only for output.

For offline `simpleevent_log`, output `endRoutePath` and parse `isAdPlaying` and `creativeCode` from `extparams`; force these exact camel-case column names before writing Excel because ODPS aliases can be returned in lowercase.

## Exclude

Do not output rows where `businesstype` is one of:

- `deviceId`
- `openGIdSuccess`
- `buttonView`

For source `simpleevent` only, also exclude `openGIdError`.

## Confirmed Chinese definitions

| Source | businesstype | pagesource condition | 中文行为定义 | Evidence |
|---|---|---|---|---|
| `video` | `videoView` | ends with `user-videos-share` | 头部视频曝光 | Player marks this path as `headVideo` |
| `video` | `videoPlay` | ends with `user-videos-share` | 头部视频播放 | Same scene rule |
| `ad` | `adRequest` | ends with `user-videos-share` | 头部视频页广告请求 | Ad component reporting |
| `ad` | `adLoaded` | ends with `user-videos-share` | 头部视频页广告加载 | Ad component reporting |
| `ad` | `adView` | ends with `user-videos-share` | 头部视频页广告曝光 | Ad component reporting |
| `ad` | `adPlay` | ends with `user-videos-share` | 头部视频页广告播放 | Ad component reporting |
| `simpleevent` | `pageView` | ends with `category_55` | 首页分类页曝光（分类55） | `pages/category.js` |
| `simpleevent` | `pageView` | ends with `user-videos-share` | 视频分享页曝光 | `PageSource.videoShare` |
| `simpleevent` | `detailRequest` | ends with `user-videos-share` | 视频分享页详情接口请求成功 | Event ID `22022221` |
| `simpleevent` | `userCaptureScreen` | ends with `user-videos-share` | 用户在视频分享页截图 | Event ID `550001` |
| `simpleevent` | `userPause` | any | 视频暂停 | Player `reportPaused` |
| `simpleevent` | `userActiveEnd` | any | 小程序进入后台 | App `onHide` |

Leave any other definition blank unless the user confirms it or source code supplies evidence.

## Mini-program evidence

- `longVideoFactory/src/utils/Enum.js`: `PageSource.videoShare` is `vlog-pages/user-videos-share`.
- `longVideoFactory/src/components/video/videoPlayerNew/pqVideoPlayer.js`: this path ending marks a head video.
- `longVideoFactory/src/logcenter/logEnum.js`: page, detail, capture-screen event IDs.
- `longVideoFactory/src/app.js`: `userActiveEnd` is reported in `onHide`.