序号,字段名,类型,注释
1,数据时间,BIGINT,
2,上传时间,BIGINT,
3,视频id,BIGINT,
4,是否当日新推荐,BIGINT,
5,历史入流量池次数,BIGINT,
6,创建天数间隔,BIGINT,
7,是否七日内创建,BIGINT,
8,视频地址,STRING,
9,grafana链接,STRING,
10,站内uid,BIGINT,
11,发布者昵称,STRING,
12,owner,STRING,
13,标题,STRING,
14,一级品类,STRING,
15,映射一级品类,STRING,
16,二级品类,STRING,
17,热点品类,STRING,
18,类型,STRING,
19,上传渠道,STRING,
20,推荐状态,STRING,
21,首次审核类型,STRING,
22,审核人,STRING,
23,首次审核时间,DATETIME,
24,首次审核日期,BIGINT,
25,首次机审审核状态,STRING,
26,首次机审不通过原因,STRING,
27,首次机审推荐状态,STRING,
28,首次机审不推荐原因,STRING,
29,7日策略入池次数,BIGINT,
30,7日rov入池次数,BIGINT,
31,7日vov入池次数,BIGINT,
32,7日低曝光高ros入池次数,BIGINT,
33,7日手动入池次数,BIGINT,
34,7日内最近一次非自动送入时间,DATETIME,
35,最近一次非自动送入类型,STRING,
36,送入人,STRING,
37,抓取平台,STRING,
38,抓取目标,STRING,
39,视频时长,BIGINT,
40,首发videoid,BIGINT,
41,首发uid,BIGINT,
42,首发时间,DATETIME,
43,首发日期,BIGINT,
44,首发播放量,BIGINT,
45,首发来源,STRING,
46,首发渠道,STRING,
47,是否首发视频,BIGINT,
48,是否首发来源,BIGINT,
49,是否首发渠道,BIGINT,
50,首发距今时间,BIGINT,
51,当日分发曝光pv,BIGINT,
52,当日曝光收益,BIGINT,
53,当日分发分享pv,BIGINT,
54,当日分发回流uv,BIGINT,
55,当日分发拉回曝光pv,BIGINT,
56,vov_t0,DOUBLE,
57,rov_t0,DOUBLE,
58,vor_t0,DOUBLE,
59,str_t0,DOUBLE,
60,ros_t0,DOUBLE,
61,当日推荐当日分发曝光pv,BIGINT,
62,当日推荐当日曝光收益,BIGINT,
63,当日推荐当日分发分享pv,BIGINT,
64,当日推荐当日分发回流uv,BIGINT,
65,当日推荐当日分发拉回曝光pv,BIGINT,
66,当日推荐vov_t0,DOUBLE,
67,当日推荐rov_t0,DOUBLE,
68,当日推荐vor_t0,DOUBLE,
69,当日推荐str_t0,DOUBLE,
70,当日推荐ros_t0,DOUBLE,
71,流量池曝光,BIGINT,
72,流量池播放,BIGINT,
73,流量池分享,BIGINT,
74,流量池回流,BIGINT,
75,流量池str,DOUBLE,
76,流量池ros,DOUBLE,
77,流量池rov,DOUBLE,
78,推荐曝光,BIGINT,
79,推荐播放,BIGINT,
80,推荐分享,BIGINT,
81,推荐回流,BIGINT,
82,推荐str,DOUBLE,
83,推荐ros,DOUBLE,
84,推荐rov,DOUBLE,
85,0_1日分发曝光pv,BIGINT,
86,0_1当日分发分享pv,BIGINT,
87,0_1日分发回流uv,BIGINT,
88,0_1日分发拉回曝光pv,BIGINT,
89,vov_t0_1,DOUBLE,
90,rov_t0_1,DOUBLE,
91,vor_t0_1,DOUBLE,
92,str_t0_1,DOUBLE,
93,ros_t0_1,DOUBLE,
94,0_2日分发曝光pv,BIGINT,
95,0_2当日分发分享pv,BIGINT,
96,0_2日分发回流uv,BIGINT,
97,0_2日分发拉回曝光pv,BIGINT,
98,vov_t0_2,DOUBLE,
99,rov_t0_2,DOUBLE,
100,vor_t0_2,DOUBLE,
101,str_t0_2,DOUBLE,
102,ros_t0_2,DOUBLE,
103,0_3日分发曝光pv,BIGINT,
104,0_3当日分发分享pv,BIGINT,
105,0_3日分发回流uv,BIGINT,
106,0_3日分发拉回曝光pv,BIGINT,
107,vov_t0_3,DOUBLE,
108,rov_t0_3,DOUBLE,
109,vor_t0_3,DOUBLE,
110,str_t0_3,DOUBLE,
111,ros_t0_3,DOUBLE,
112,过去7日总发布量,BIGINT,
113,过去7日总推荐量,BIGINT,
114,姓名,STRING,
115,出生年份,BIGINT,
116,身份证号码,BIGINT,
117,性别,STRING,
118,测试品类,STRING,
119,title_duration,STRING,
120,最近复推日期,STRING,
121,rov入池距当前天数,BIGINT,
122,vov入池距当前天数,BIGINT,
123,低曝光高ros入池距当前天数,BIGINT,
124,手动入池距当前天数,BIGINT,
125,人打二级标签复用,STRING,
126,1日分发回流uv,BIGINT,
127,1日分发拉回曝光pv,BIGINT,
128,2日分发回流uv,BIGINT,
129,2日分发拉回曝光pv,BIGINT,
130,3日分发回流uv,BIGINT,
131,3日分发拉回曝光pv,BIGINT,
132,7日分发回流uv,BIGINT,
133,7日分发拉回曝光pv,BIGINT,
134,14日分发回流uv,BIGINT,
135,14日分发拉回曝光pv,BIGINT,
136,30日分发回流uv,BIGINT,
137,30日分发拉回曝光pv,BIGINT,
138,0_7日分发回流uv,BIGINT,
139,0_7日分发拉回曝光pv,BIGINT,
140,0_14日分发回流uv,BIGINT,
141,0_14日分发拉回曝光pv,BIGINT,
142,0_30日分发回流uv,BIGINT,
143,0_30日分发拉回曝光pv,BIGINT,
144,ai标签集合,STRING,
145,ai标签top1,STRING,
146,ai标签top2,STRING,
147,ai标签top3,STRING,
148,首次推荐时间,BIGINT,
149,最近复推时间,BIGINT,
150,推荐天数间隔,BIGINT,
151,复推天数间隔,BIGINT,
152,人工及ai标签复用二级品类,STRING,
153,人工及ai标签映射一级品类,STRING,
154,人工及复用二级品类,STRING,
155,merge二级品类,STRING,
156,merge一级品类,STRING,
157,在top50,STRING,
158,在top200,STRING,
159,回流rank,STRING,
160,入池人,STRING,
161,人工入池层数,BIGINT,
162,人工入池距今天数,BIGINT,
163,入池策略,STRING,
164,策略入池层数,BIGINT,
165,策略入池距今天数,BIGINT,
166,首次人审审核状态,STRING,
167,首次人审不通过原因,STRING,
168,首次人审推荐状态,STRING,
169,策略,STRING,
170,策略标签距今天数,BIGINT,
171,实验角色,STRING,
172,实验角色标签距今天数,BIGINT,
173,实验层,STRING,
174,实验层标签距今天数,BIGINT,
175,分辨率,STRING,分辨率
176,分辨率比值,STRING,分辨率比值
177,视觉音乐文字,STRING,视觉音乐文字
178,内容选题,STRING,内容选题
179,视频主题,STRING,视频主题
180,视频关键词,STRING,视频关键词
181,视频主体,STRING,视频主体
182,视频场景,STRING,视频场景
183,情感倾向,STRING,情感倾向
184,视频风格,STRING,视频风格
185,是否有片尾引导,STRING,是否有片尾引导
186,引导时长,STRING,引导时长
187,引导强度,STRING,引导强度
188,传播性判断,STRING,传播性判断
189,推测观众地域,STRING,推测观众地域
190,推测观众年龄段,STRING,推测观众年龄段
191,推测观众性别,STRING,推测观众性别
192,推测观众价值类型,STRING,推测观众价值类型
193,推测观众用户价值点,STRING,推测观众用户价值点
194,推测观众用观众收入,STRING,推测观众用观众收入
195,背景音类型,STRING,背景音类型
196,背景音风格,STRING,背景音风格
197,语音类型,STRING,语音类型
198,歌曲名,STRING,歌曲名
199,音色,STRING,音色
200,产品水印,STRING,产品水印
201,产品名称,STRING,产品名称
202,字幕,STRING,字幕
203,颜色,STRING,颜色
204,字号,STRING,字号
205,位置,STRING,位置
206,视频口播,STRING,视频口播
207,封面主体,STRING,封面主体
208,人物个数,STRING,人物个数
209,文字数量,STRING,文字数量
210,文字关键字,STRING,文字关键字
211,封面主题,STRING,封面主题
212,知名人物,STRING,知名人物
213,人物年龄段,STRING,人物年龄段
214,场景描述,STRING,场景描述
215,时效性_有无时效,STRING,时效性_有无时效
216,时效性_具体时间,STRING,时效性_具体时间
217,1007回流人数,BIGINT,
218,1008回流人数,BIGINT,
219,带来1007回流的分享数,BIGINT,
220,带来1008回流的分享数,BIGINT,
221,1007进入分发曝光pv,BIGINT,
222,1008进入分发曝光pv,BIGINT,
223,1007回流再分享pv,BIGINT,
224,1008回流再分享pv,BIGINT,
225,总分享pv,BIGINT,
226,总回流uv,BIGINT,
227,有回流分享pv,BIGINT,
228,累计分享回流uv,BIGINT,
229,分发分享pv,BIGINT,
230,头部分享pv,BIGINT,
231,当日分发头部分享pv,BIGINT,
232,当日分享当日回流uv,BIGINT,
233,当日分享当日回流首层uv,BIGINT,
234,当日分享当日回流非首层uv,BIGINT,
235,非当日分享回流uv,BIGINT,
236,n当日分发回流uv,BIGINT,
237,非当日分发回流uv,BIGINT,
238,原视频id,BIGINT,原视频ID
239,是否存在热点,STRING,是否存在热点信息
240,该热点的特征,STRING,热点的特征描述
241,热点内容概括,STRING,热点内容的概括
242,判断是热点的原因,STRING,判断为热点的原因
243,曝光rank,BIGINT,
244,拉回曝光rank,BIGINT,
245,流量池1007回流人数,BIGINT,
246,流量池1008回流人数,BIGINT,
247,带来流量池1007回流的分享数,BIGINT,
248,带来流量池1008回流的分享数,BIGINT,
249,首发账号名,STRING,
250,首发owner,STRING,
251,流量池回流人数,BIGINT,
252,带来流量池回流的分享数,BIGINT,
253,aidit详情,STRING,
254,项目名称,STRING,
255,rank,BIGINT,
256,dt,STRING,
