data_query_skill/skills/query-user-behavior-path/references/logs-and-definitions.md

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.