workTasks/userSign/new.sql

INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2000, 'binPhone', '已绑定手机号',bitmapBuild([toUInt64(0)]) , 2, '2024-10-21 00:00:00', 'wky', 2000);
INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2001, 'bindMail', '已绑定邮箱',bitmapBuild([toUInt64(0)]) , 2, '2024-10-21 00:00:00', 'wky', 2001);
INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2002, 'vip', '超级订阅',bitmapBuild([toUInt64(0)]) , 2, '2024-10-21 00:00:00', 'wky', 2002);
INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2003, 'vipExpire_15', '超级订阅15天到期',bitmapBuild([toUInt64(0)]) , 2, '2024-10-21 00:00:00', 'wky', 2003);
INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2004, 'vipExpire_30', '超级订阅30天到期',bitmapBuild([toUInt64(0)]) , 2, '2024-10-21 00:00:00', 'wky', 2004);
INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2005, 'member', '大会员用户',bitmapBuild([toUInt64(0)]) , 2, '2024-10-21 00:00:00', 'wky', 2005);
INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2006, 'memberExpired', '曾购大会员用户',bitmapBuild([toUInt64(0)]) , 2, '2024-10-21 00:00:00', 'wky', 2006);

INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2007, 'hasPay', '付费用户',bitmapBuild([toUInt64(0)]) , 2, '2024-10-21 00:00:00', 'wky', 2007);
INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2008, 'unBuyVipMonth', '本月加购未购超级订阅',bitmapBuild([toUInt64(0)]) , 2, '2024-10-21 00:00:00', 'wky', 2008);
INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2009, 'unBuyMemberMonth', '本月加购未购大会员',bitmapBuild([toUInt64(0)]) , 2, '2024-10-21 00:00:00', 'wky', 2009);


INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2010, 'active_pc', '30天pc活跃用户',bitmapBuild([toUInt64(0)]) , 2, '2024-10-21 00:00:00', 'wky', 2010);
INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2011, 'active_wx', '30天wx活跃用户',bitmapBuild([toUInt64(0)]) , 2, '2024-10-21 00:00:00', 'wky', 2011);
INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2012, 'active_app', '30天app活跃用户',bitmapBuild([toUInt64(0)]) , 2, '2024-10-21 00:00:00', 'wky', 2012);
INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2013, 'unActive_30', '30天未活跃用户',bitmapBuild([toUInt64(0)]) , 2, '2024-10-21 00:00:00', 'wky', 2013);
INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2014, 'unActive_90', '90天未活跃用户',bitmapBuild([toUInt64(0)]) , 2, '2024-10-21 00:00:00', 'wky', 2014);




INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2018, 'newUser_1', '近第1天注册用户',bitmapBuild([toUInt64(0)]) , 2, '2024-12-17 00:00:00', 'wky', 2018);
INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2019, 'newUser_2', '近第2天注册用户',bitmapBuild([toUInt64(0)]) , 2, '2024-12-17 00:00:00', 'wky', 2019);
INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2020, 'newUser_3', '近第3天注册用户',bitmapBuild([toUInt64(0)]) , 2, '2024-12-17 00:00:00', 'wky', 2020);


INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2027, 'vipExpired_30', '超级订阅已经到期30天',bitmapBuild([toUInt64(0)]) , 2, '2025-03-25 00:00:00', 'wky', 2027);
INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2028, 'vipGift7DayExpired', '超级订阅赠送7天到期',bitmapBuild([toUInt64(0)]) , 2, '2025-03-25 00:00:00', 'wky', 2028);
INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2029, 'unBuyVip45Day', '45天加购未购超级订阅',bitmapBuild([toUInt64(0)]) , 2, '2025-03-25 00:00:00', 'wky', 2029);
INSERT INTO pub_tags.dwd_d_tag (id, code, name, bitobj, groupid, created_at, created_by, bit_num) VALUES(2030, 'visitedVipBuyPage', '近45天浏览超级订阅购买页',bitmapBuild([toUInt64(0)]) , 2, '2025-03-25 00:00:00', 'wky', 2030);