模板介绍

模板说明

本模板把百度统计网站访问统计量概况数据拉取到本地MySQL数据库中

流程图

依赖组件

1.需要下载百度统计分类的拉取网站访问统计量概况组件。
2.需要创建相应的表结构或者用库表输出组件自动建表。

依赖表结构

CREATE TABLE `baidu_tongji_site_overview`  (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `old_pv_count` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '老访客浏览量(PV)',
  `old_visitor_count` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '老访客数',
  `old_avg_visit_time` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '老访客访问时间',
  `old_bounce_ratio` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '老访客的反弹率',
  `old_avg_visit_pages` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '老访客的访问页数',
  `old_ratio` int(20) NULL DEFAULT NULL COMMENT '老访客比例',
  `new_pv_count` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '新访客浏览量(PV)',
  `new_visitor_count` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '新访客数',
  `new_avg_visit_time` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '新访客访问时间',
  `new_bounce_ratio` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '新访客的反弹率',
  `new_avg_visit_pages` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '新访客的访问页数',
  `new_ratio` int(20) NULL DEFAULT NULL COMMENT '新访客比例',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

使用评价