论坛 › 江西 › 全网推广运营数据报表设计（含日报/周报/月报/年报）

l14107cb 发表于 2024-8-31 03:44:16

全网推广运营数据报表设计（含日报/周报/月报/年报）

    <h3 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">点击关注▲艾奇SEM</span></h3>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">知识&nbsp;|&nbsp;<span style="color: black;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">经</span></strong></span><strong style="color: blue;"><span style="color: black;">验</span></strong></span>|&nbsp;<span style="color: black;"><span style="color: black;">新闻</span>&nbsp;</span>|&nbsp;<span style="color: black;">资料</span>&nbsp;四大版块</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">从SEM到互联网整合营销</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/fbac17wmeIFtICQ9bFUUjWfQicqZpYKdIUbO87p9B4P9s6Zc94JasV4Gm5WZ1AMSpibpwWNEUMYJiaZH0AUFOBOLQ/0?wx_fmt=gif&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">作者：涂俊杰（<span style="color: black;">微X</span>：ffeels），SOM/热爱分享，保持好奇</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">微X</span>公众号：百天自律行动。<span style="color: black;">分享时间管理＆运营技能＆成长感悟，倡导每100天公开进行一项自律行动，你<span style="color: black;">能够</span>做得更好。</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">人们常说「报表做得好，升职加薪少不了」。这句话奠定了数据报告的两个重要<span style="color: black;">功效</span>，<span style="color: black;">第1</span>是<strong style="color: blue;">可<span style="color: black;">指点</span>性，是内核</strong>，让人看完报表之后恍然大悟「哦，原来问题出在<span style="color: black;">这儿</span>」；第二是<strong style="color: blue;">美观性，是包装</strong>，让人看<span style="color: black;">第1</span>眼就赞叹「哇塞，这报告真牛b」。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">这篇<span style="color: black;">文案</span>，分享<span style="color: black;">有些</span>我在设计运营报告时的做法和思考，<span style="color: black;">期盼</span>能让你变得牛B。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">整篇<span style="color: black;">文案</span>我将分为如下五个部分详述：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_png/wHHv4wgtwtdZKeibnibFwEnReVibdSIUajGJwn25YlqT5Aw3yqNNqL3U9G8XSlqXquwpOs2brH0e8y9k9zINXXbuw/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">[<span style="color: black;">文案</span>大纲]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">01</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">为何</span>运营比分析师更应该制表</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">因为</span><span style="color: black;">分部</span>分工<span style="color: black;">原由</span>，最<span style="color: black;">起始</span>所有数据工作都是「数据分析师」主导，每周出一份运营报告，明示进度并<span style="color: black;">供给</span>改进<span style="color: black;">意见</span>。时间久了我就<span style="color: black;">发掘</span><span style="color: black;">有些</span>很尴尬的事，于是申请接手制表工作，<span style="color: black;">起始</span><span style="color: black;">根据</span>业务<span style="color: black;">归类</span>修正原有报表，新旧版本对<span style="color: black;">例如</span>下。<span style="color: black;">（全文所有数据均经过处理。）</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">1、原报告（分析师版本）</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/fbac17wmeIFVdr40ajXL7k9fBNALcmFBjQdnQiaCl1jGrAUxVu45vSU8GfQPEBGSDNmwVM3Xf9ZxUzjaa1fHutw/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[分析师PPT]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">2、新报告（运营者版本）</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_png/wHHv4wgtwtcARy3QjYUTTHRbeDnr2HHo1hbaNN3sZyWsIrfQGQtNEyOJPIzDqCibfSovOdYOgcsw1GVMUrXdXEA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[运营者PPT-因私模糊处理]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">之<span style="color: black;">因此</span>说尴尬是<span style="color: black;">由于</span>大<span style="color: black;">都数</span>据分析师并不直接接触<span style="color: black;">分部</span>业务<span style="color: black;">（<span style="color: black;">或</span>是人手<span style="color: black;">不足</span>，专精在其他方面，运营数据只做辅助支持）</span>，这就<span style="color: black;">引起</span>运营报告：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1）部分指标缺失。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2）数据分析的深度<span style="color: black;">不足</span>。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">3）报表的优化不<span style="color: black;">即时</span>。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">这三点是分析师制表时最<span style="color: black;">平常</span>的问题。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">想要<span style="color: black;">处理</span>这些问题，当然<span style="color: black;">能够</span>和分析师进行<span style="color: black;">持续</span>的修改磨合，<span style="color: black;">然则</span>我更愿意直接接手。<span style="color: black;">那样</span>在接手制作运营报告的前期，需要思考<span style="color: black;">那些</span>问题呢？</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">3、前期思考</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">运营者确定制表后，<span style="color: black;">能够</span>用「前中后」三部曲思维分解问题。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1）谁做？</span><span style="color: black;">（制作前）</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">运营人<span style="color: black;">（其他人<span style="color: black;">亦</span><span style="color: black;">同样</span>）</span>不要把制表类任务当做<span style="color: black;">负担</span>，甩锅给分析师。自己<span style="color: black;">分部</span>的东西不搞清楚弄明白，指望分析师帮你捋清楚，别做梦了。<span style="color: black;">（附赠一条不管你信不信的「潜规则」，做报表的人有管理层光环 /微笑）</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2）谁看？</span><span style="color: black;">（制作中）</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">做报表，<span style="color: black;">首要</span>是<strong style="color: blue;"><span style="color: black;">自己看</span></strong>。制作者必须清楚的从数据中<span style="color: black;">发掘</span>问题，<span style="color: black;">才可</span>提出<span style="color: black;">指点</span>性<span style="color: black;">意见</span>，制作报表和<span style="color: black;">通常</span>看数据的区别等同阅读<span style="color: black;">文案</span>和抄写<span style="color: black;">文案</span>；</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">其次是<strong style="color: blue;"><span style="color: black;">领导看</span></strong>，这个是大头，领导时间宝贵，学会节约他人时间，快速的指明关键问题和你准备好的<span style="color: black;">处理</span>办法；</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">最后，<span style="color: black;"><strong style="color: blue;">团队成员<span style="color: black;">亦</span>会看</strong></span>，团队成员起到的是监督<span style="color: black;">功效</span>，监督制表人是不是忽悠。我<span style="color: black;">亦</span>提醒我自己，报表或许<span style="color: black;">能够</span>忽悠领导，<span style="color: black;">然则</span>你能忽悠群众吗？</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">3）谁<span style="color: black;">守护</span>？</span><span style="color: black;">（制作后）</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">倘若</span>是你来做表，<span style="color: black;">那样</span>你能<span style="color: black;">守护</span>多久？什么时候能达到稳定版本并交接给其他人呢？多在制表途中记录「操作<span style="color: black;">过程</span>」和「更新内容」，有助于复盘和交接。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">怎样</span>设置<span style="color: black;">基本</span>表格和关键数据</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">为何</span>说制作总表考验人？<span style="color: black;">由于</span>总表只是高层建筑，它<span style="color: black;">是由于</span>一张张<span style="color: black;">基本</span>数据表堆叠起来的。这就<span style="color: black;">需求</span><span style="color: black;"><strong style="color: blue;">制表人必须清楚<span style="color: black;">分部</span>分工和<span style="color: black;">区别</span>小组、<span style="color: black;">区别</span>责任人分别背负了<span style="color: black;">那些</span>关键指标</strong><span style="color: black;">，</span></span>出问题的时候<span style="color: black;">能够</span>点对点找到人。我以常规业务举例。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">1、业务划分</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1）<span style="color: black;">微X</span>运营</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_png/wHHv4wgtwtcARy3QjYUTTHRbeDnr2HHoT4tHo2iapTl1ElqDw4a4mDdDgRFySeOiazRJrUxaOdmnBlMUfibzG3Q9Q/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[<span style="color: black;">微X</span>图文分析]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_png/wHHv4wgtwtcARy3QjYUTTHRbeDnr2HHoXhp9ZSVK71gBn5rLbgtWqtD9uAZibjtv1PqxTic8XgNrJvjmicoj0BCyQ/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[<span style="color: black;">微X</span>用户分析]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">橙底</span>：拖拽填充<span style="color: black;">就可</span>。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">灰底</span>：从后台数据表复制粘贴。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">蓝底</span>：手动填写。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">粉字</span>：备注栏填「加转」，自动变色。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">灰字</span>：公式计算，非重要项，减轻阅读压力。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">红字</span>：「星期」栏凡周末变红字。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">*细心地读者可能会<span style="color: black;">发掘</span>，在「粉丝分析」这张表中，5/18-5/24的「新关注人数」字体变红，是<span style="color: black;">由于</span><span style="color: black;">源自</span>部分需要手动填写，难免出错，当所有<span style="color: black;">源自</span>数相加≠新关注人数时，字颜色会变红，用于提醒填表人。（运用「本质安全」法。）</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">*Poka-Yoke理念（本质安全）：<span style="color: black;">倘若</span>在系统设计的时候，把所有<span style="color: black;">形成</span>危险的<span style="color: black;">原因</span><span style="color: black;">所有</span>去除（<span style="color: black;">倘若</span>可能的话），<span style="color: black;">那样</span>意外就不会<span style="color: black;">出现</span>。在实践中，<span style="color: black;">咱们</span><span style="color: black;">能够</span><span style="color: black;">经过</span>“<strong style="color: blue;">自动完成任务、区域划分、利用形状，<span style="color: black;">秘码</span>等进行校验、将流程编号，依次执行、<span style="color: black;">经过</span>形状，颜色指引</strong>
      </span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">”等<span style="color: black;">办法</span>减少出错。</p>

    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">微X</span>运营的报表设置了3张Sheet，分别是图文数据、图文数据明细、粉丝增长分析，数据<span style="color: black;">能够</span>直接从后台获取。不想手动这么麻烦，考拉新<span style="color: black;">媒介</span>助手<span style="color: black;">（xu1s.com）</span>出了「一键获取<span style="color: black;">微X</span>公众号统计数据」功能，大大简化了普通运营者获取后台数据的成本，有兴趣的<span style="color: black;">伴侣</span><span style="color: black;">能够</span>试一下。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2）<span style="color: black;">博客</span>运营</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_png/wHHv4wgtwtcARy3QjYUTTHRbeDnr2HHo9vNjrGDWVI6ks9ftTv8G0T6utfQVZ1ibIEicRssuvw0z0sX10NS07sWA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[<span style="color: black;">博客</span>数据统计]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">3）外网推广</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_png/wHHv4wgtwtcARy3QjYUTTHRbeDnr2HHoM7PUR2I79xZuwBlo6icleibpUcoCCjEdvAQsABTic0CbsQmQodtVYdibxQ/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">橙底</span>：对比前一天数据差。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">绿底</span>：对比前一天数据好。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">红字</span>：「星期」栏凡周末变红字。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">官网流量报表设置了6张Sheet，分别是趋势分析、<span style="color: black;">源自</span><span style="color: black;">归类</span>、来路页面、受访页面、<span style="color: black;">拜访</span>明细、搜索词，数据<span style="color: black;">能够</span>直接从统计平台下载。<span style="color: black;">尤其</span>提醒的是Sheet的命名最好和统计软件后台的名<span style="color: black;">叫作</span>一致，<span style="color: black;">这般</span>一眼就能<span style="color: black;">晓得</span>该表的数据从后台的哪个栏目获取。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_png/wHHv4wgtwtcARy3QjYUTTHRbeDnr2HHoAHurEwcB1LXYkhk8hdkamibjDcWkyAEqJ1FB5udfIZUXpglss8B9F8w/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[竞价数据概况]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">竞价流量概况表设置了4张Sheet，分别是推广概况、客服成功率、竞价后台数据、分时转化数。竞价对数据分析<span style="color: black;">需求</span>高，表格众多，本文不详述。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">4）社群运营</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_png/wHHv4wgtwtcARy3QjYUTTHRbeDnr2HHohFXnkkU5fBoCKWuqF28tXU94nzZhhxqH5ZpiaBOjBROvOAXjibsfIe6g/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[社群数据统计]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_png/wHHv4wgtwtcARy3QjYUTTHRbeDnr2HHoEjic7Zb3sW0v7FAicREAV9JmjvERCSzIqvE95V41GtrZ25VbYkXstaKA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[社群活跃统计]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">上图列出表格是我为<span style="color: black;">分部</span>各小组设计的部分<span style="color: black;">基本</span>表格，设计的思路是，当前工作中你能获取到的数据有<span style="color: black;">那些</span>，在人力<span style="color: black;">准许</span>的范围内尽可能的<span style="color: black;">增多</span>量化<span style="color: black;">要求</span>，<span style="color: black;">而后</span>在<span style="color: black;">实质</span><span style="color: black;">状况</span>中增减。<span style="color: black;">基本</span>表是日后所有报告的源头，<span style="color: black;">必定</span>要注重数据的<span style="color: black;"><strong style="color: blue;">完整性</strong></span>和<span style="color: black;"><strong style="color: blue;">真实性</strong></span>。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">2、类型划分</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1）流量分析</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">a.<span style="color: black;">制品</span>流量</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">自有<span style="color: black;">制品</span>的流量统计，<span style="color: black;">倘若</span>暂时<span style="color: black;">无</span>数据后台，<span style="color: black;">能够</span><span style="color: black;">运用</span>像「百度统计」、「友盟」、「诸葛IO」之类的三方软件。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/wHHv4wgtwtcARy3QjYUTTHRbeDnr2HHoVB0HYbUs1vVic75nj7ATCQpHdCwMMfyviatq8Jrp8xFmzqKPHv0B0VYQ/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[官网流量-CNZZ]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/wHHv4wgtwtcARy3QjYUTTHRbeDnr2HHoicsS4Gjiaib1h974JrCD8z7eLJEhHmvYQGNXFDQkhOpicAtOwyq7iajfngw/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">b.<span style="color: black;">宣传</span>流量</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/wHHv4wgtwtcARy3QjYUTTHRbeDnr2HHoBz6S5bibicbRyKBstkRQoCuShZLqKejMcuppiciaiaen5X3GRia5gDJVI0sw/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/wHHv4wgtwtcARy3QjYUTTHRbeDnr2HHoRnyL3gABMZiaOovjusLBSXxvx1TGJrdic2odicEN4sqyutpVB37mibUurw/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">线上投放<span style="color: black;">宣传</span>都会有后台，直接导出数据分析<span style="color: black;">就可</span>。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2）用户分析</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">RFM模型</p>

    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[<span style="color: black;">照片</span><span style="color: black;">源自</span>于赵兴峰老师的<span style="color: black;">文案</span>]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">*<span style="color: black;"><span style="color: black;">倘若</span>想<span style="color: black;">认识</span><span style="color: black;">怎样</span>对用户数据<span style="color: black;">运用</span>RFM模型分析，<span style="color: black;">举荐</span>看赵兴峰老师的<span style="color: black;">文案</span>：《案例：用Excel2007做简单的RFM分析 》。</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">3）增长预测表</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[<span style="color: black;">照片</span><span style="color: black;">源自</span>于《结网》]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[预测表用法]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">增长预测表的灵感<span style="color: black;">源自</span>于王坚老师写的《结网》，书中他说明了该表的用法：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">这个表格的<span style="color: black;">运用</span><span style="color: black;">办法</span>是，<span style="color: black;">每一个</span>月的月初将<span style="color: black;">实质</span>数字更新到它所属的一排上，<span style="color: black;">而后</span>在这一排的后面预测以后<span style="color: black;">每一个</span>月的数字。<span style="color: black;">这般</span>一排一排地进行更新，当一年结束的时候，<span style="color: black;">全部</span>表格就被<span style="color: black;">实质</span>数字填满了。<span style="color: black;">倘若</span>真实数字或预测数字<span style="color: black;">小于</span>KPI，那就<span style="color: black;">想要</span>办法去拉动这些数字。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">4）图文分析</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">a.<span style="color: black;">微X</span>图文分析</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">b.<span style="color: black;">博客</span>推文分析</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">这两项参照上图[<span style="color: black;">微X</span>图文分析]和[<span style="color: black;">微X</span>用户分析]。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">5）竞品分析</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">a.竞品<span style="color: black;">媒介</span>动向</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[知乎近期的<span style="color: black;">媒介</span>动向]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">b.平台<span style="color: black;">制品</span>改版</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">略</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">c.外网可搜集数据</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">略</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">*<span style="color: black;">举荐</span>一个网站：因果树（innotree.cn）。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">d.人工间谍</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">略</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">*竞品数据<span style="color: black;">能够</span>自建爬虫抓取，<span style="color: black;">亦</span><span style="color: black;">能够</span><span style="color: black;">经过</span>创投类网站、SEO站长、三方工具收集竞品关键词的<span style="color: black;">关联</span>搜索量和<span style="color: black;">资讯</span>栏目的<span style="color: black;">揭发</span>数量。没事的时候就去对方官网<span style="color: black;">瞧瞧</span><span style="color: black;">有没有</span>改版，学习竞品的建设思路。最后还能人肉潜入竞品的社群、社区、伪装用户套话之类。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">6）活动分析</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">a.承载平台分析（H5）</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">活动组完成活动后，<span style="color: black;">首要</span>分析活动承载平台（<span style="color: black;">通常</span>是H5）点击量之类的数据，再看从平台<span style="color: black;">转</span>到着陆页的到达率，最后出一份Word总结<span style="color: black;">就可</span>。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">这两部分内容是为了说明在<span style="color: black;">实质</span>工作中<span style="color: black;">咱们</span><span style="color: black;">能够</span>收集到<span style="color: black;">那些</span><span style="color: black;">基本</span>数据，表格<span style="color: black;">怎么样</span>设计。<span style="color: black;">因此呢</span><span style="color: black;">能够</span>看出，我设计<span style="color: black;">基本</span>表格的<span style="color: black;">过程</span>是：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">① 收集当前业务的所有可量化指标</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">② 把量化指标<span style="color: black;">根据</span>业务<span style="color: black;">规律</span><span style="color: black;">归类</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">③ <span style="color: black;">保准</span><span style="color: black;">基本</span>表格的完整真实性</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">④ <span style="color: black;">尽可能</span><span style="color: black;">运用</span><span style="color: black;">设备</span>采集或复制粘贴，减少人工</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">⑤ 分清楚「监控」数据和「统计」数据</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">（前者频繁更新，后者周期更新）</p>

    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">所有运营者在<span style="color: black;">守护</span>现有报告的<span style="color: black;">同期</span>要<span style="color: black;">持续</span>思考，我还能<span style="color: black;">经过</span><span style="color: black;">那些</span>数据<span style="color: black;">增多</span>我的分析维度，使得决策更加<span style="color: black;">精细</span>。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">3、关键指标</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">当你收集到的数据越来越多，很容易「<span style="color: black;"><strong style="color: blue;">数据迷失</strong></span>」，即面对<span style="color: black;">海量</span>PV数、UV数、阅读量等数值却找不到能促进业务增长的关键指标。虽然<span style="color: black;">区别</span><span style="color: black;">机构</span>、<span style="color: black;">分部</span>指标都<span style="color: black;">区别</span>，但我仍为此<span style="color: black;">供给</span>两个设置关键指标的思路供参考。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1）用户<span style="color: black;">行径</span>关键指标</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">设置「首页→栏目A→点赞→发起对话」类似的用户<span style="color: black;">行径</span>为转化路径，统计<span style="color: black;">周期</span>时间内达成转化的用户数。不仅分析流量，更要深入分析用户。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2）关键<span style="color: black;">目的</span>指标组合</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">好的数据指标<span style="color: black;">必定</span>通俗易懂，且是一个比率，<span style="color: black;">乃至</span>是组合。</strong></span><span style="color: black;">这句话其实<span style="color: black;">便是</span>「<span style="color: black;">目的</span>和关键成果（OKR：Objectives and Key Results）」制度的雏形。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">举例，设置<span style="color: black;">目的</span>为：<span style="color: black;">加强</span>网站A栏目的用户粘性<span style="color: black;">（粘性↑=总时间↑/总人数）</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">A栏目跳出率降低至40%</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">用户平均<span style="color: black;">拜访</span>时间达到20分钟</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">增多</span>5个栏目专题页面</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">...</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">3</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">周报/月报，用Word、Excel还是PPT</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">有了<span style="color: black;">基本</span>数据，<span style="color: black;">亦</span>设定好了关键数据，各<span style="color: black;">分部</span>成员<span style="color: black;">能够</span>随时跟踪查看，但领导不可能挨个去查，<span style="color: black;">因此</span>需要运营者<span style="color: black;">定时</span>制作<span style="color: black;">报告</span>。一<span style="color: black;">起始</span>老有人问我说：「俊杰，报告用Word还是Excel还是PPT做更好呢？」我的回答很简单：「你<span style="color: black;">善于</span>用哪种就用哪种，只要能把你要重点<span style="color: black;">明显</span>的东西展现出来就行了。」</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">当然，<span style="color: black;">倘若</span>是<span style="color: black;">有些</span>入门的新手，你最好给<span style="color: black;">她们</span><span style="color: black;">瞧瞧</span>你之前做过的模板，有个参考。<strong style="color: blue;">我的原则是:</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">重感想，文字多，用Word；</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">重数据，表格多，用Excel；</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">重美观，正式，用PPT。</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">报告<span style="color: black;">亦</span>有长短周期，<span style="color: black;">倘若</span>数据多，每周出一份PPT报告非常费时间，能<span style="color: black;">不可</span>每周出一份Excel简报，每月/半月出一份PPT报告呢？当然<span style="color: black;">能够</span>，<span style="color: black;">然则</span>你必须先弄清楚<span style="color: black;">基本</span>数据、周简报，月报间的<span style="color: black;">相关</span>和区别。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">1、演化</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">基本</span>表格<span style="color: black;">包括</span>所有数据项。简报类似所有<span style="color: black;">基本</span>报表的<span style="color: black;">第1</span>张Sheet（概况表）集合，<span style="color: black;">同期</span>用函数自动计算出最大值、最小值、平均值等峰值<span style="color: black;">状况</span>；月报则是从所有<span style="color: black;">基本</span>表格中提取关键数据块，每一个关键块新建一张Sheet，<span style="color: black;">同期</span>对应数值<span style="color: black;">插进</span>图表。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[<span style="color: black;">基本</span>数据-<span style="color: black;">微X</span>]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">↓函数提取↓</span></strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[周报-<span style="color: black;">微X</span>数据块+官网数据块]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">*周报中的P1/P2/P3...就<span style="color: black;">表率</span>从<span style="color: black;">基本</span>数据中提取的<span style="color: black;">区别</span>关键块Sheet，在每一个Sheet中<span style="color: black;">插进</span>对应图表。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">↓绘制图表↓</span></strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">[月报Excel-粉丝增长趋势折线图]</p>

    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">↓可视化处理↓</span></strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[月报PPT-粉丝增长趋势折线图]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">综上，把<span style="color: black;">基本</span>数据变成PPT的<span style="color: black;">过程</span>大致是：<strong style="color: blue;">填写<span style="color: black;">基本</span>数据→打开设定好函数的Excel简报，修改提取时间段，<span style="color: black;">同期</span>刷新所有数据块→复制图表到PPT</strong>，手动复制图表的<span style="color: black;">同期</span><span style="color: black;">检测</span>有<span style="color: black;">无</span>数据错误，循环粘贴完所有图表，PPT就做好了。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">2、我的简报</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[简报制作<span style="color: black;">办法</span>]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">我的简报内容<span style="color: black;">包括</span>：<span style="color: black;">微X</span>数据、官网数据、社群数据、APP数据、SEO数据、外链<span style="color: black;">状况</span>、<span style="color: black;">媒介</span><span style="color: black;">报告</span><span style="color: black;">状况</span>。上图Excel简报只列出了部分数据，<span style="color: black;">运用</span>了TEXT、NOW、MAX/MIN、AVERAGE、IF、VLOOKUP几个<span style="color: black;">平常</span>函数，没标明函数写法的<span style="color: black;">自动</span>百度。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">通常</span><span style="color: black;">来讲</span>内容<span style="color: black;">能够</span>直接提取<span style="color: black;">区别</span>业务<strong style="color: blue;"><span style="color: black;">基本</span>表格的<span style="color: black;">第1</span>张Sheet</strong>，但<span style="color: black;">详细</span>还是要<strong style="color: blue;">和领导沟通</strong>确定。<span style="color: black;">（别埋头干完了才沟通，<span style="color: black;">倘若</span>被批就太冤了。）</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">3、我的月报</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[月报模板]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">我的月报内容<span style="color: black;">包括</span>：<span style="color: black;">微X</span>数据明细、社群运营明细、各<span style="color: black;">分部</span>资源汇总<span style="color: black;">状况</span>、APP数据明细、各平台流量明细、外网推广<span style="color: black;">状况</span>、当月KPI完成<span style="color: black;">状况</span>等。因篇幅限制，上图PPT模板中只列出了部分数据供参考。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">月报对比周报篇幅<span style="color: black;">显著</span><span style="color: black;">增多</span>，<span style="color: black;">况且</span>进行了数据可视化，<span style="color: black;">能够</span>直接同步给领导及其他<span style="color: black;">分部</span>，<span style="color: black;">做为</span>运营成果展示。需要<span style="color: black;">重视</span>的是一份合格的月报必须<span style="color: black;">包括</span>「<span style="color: black;">数据+可视化+<strong style="color: blue;">可行<span style="color: black;">意见</span></strong></span>」，<span style="color: black;">无</span><span style="color: black;">指点</span>性<span style="color: black;">意见</span>的报告除了装B，<span style="color: black;">无</span>任何用处，<span style="color: black;">因此呢</span>制表人需要搞清楚，任何报告只是你思维的一个展示方式，核心是你的思维。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">4</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">快速制作一份简洁明了的PPT报告</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">提取关键词「<span style="color: black;">快速</span>」和「<span style="color: black;">简洁明了</span>」，这两个原则贯穿制表全程。第一次制表时，完整走一遍操作流程，在随后的<span style="color: black;">一月</span>时间里，记录操作细节难点和<span style="color: black;">重视</span>事项，设置PPT模板和规范。总的<span style="color: black;">来讲</span><span style="color: black;">过程</span><span style="color: black;">便是</span>：「<strong style="color: blue;">关键数据提取→<span style="color: black;">选取</span>对应展现形式→<span style="color: black;">插进</span>图表→确定展示规范→<strong style="color: blue;">制作母版→</strong>美化细节→<span style="color: black;">持续</span>迭代→记录操作<span style="color: black;">过程</span>，交接</strong>」。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">1、获取数据</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">不管是任何报告数据都是从<span style="color: black;">基本</span>数据提取的，只要在Excel表格中设置好数据区域，<span style="color: black;">插进</span>图表，粘贴到PPT中<span style="color: black;">就可</span>。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">2、图表类型</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[经典图表类型大全]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">*图表类型的<span style="color: black;">选择</span>最<span style="color: black;">起始</span>我准备单独写成一文，<span style="color: black;">然则</span><span style="color: black;">发掘</span>秦路（公众号：tracykanc）<span style="color: black;">已然</span>写过，<span style="color: black;">况且</span>完成度非常高。<span style="color: black;">举荐</span><span style="color: black;">大众</span>去搜索看秦路写的<a style="color: black;"><strong style="color: blue;">《数据可视化：你想<span style="color: black;">晓得</span>的经典图表全在这》</strong></a>这篇<span style="color: black;">文案</span>。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">3、PPT<span style="color: black;">形成</span></span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1）PPT结构</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[我的PPT结构]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">*<span style="color: black;">我在PPT中设置的图表区<span style="color: black;">体积</span>9.7cm*25cm，图例字12、横纵坐标轴11、主数据标签10.5，次<span style="color: black;">十、</span>图表标题18；文字区字号14，重点加粗或标红。</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">a.上下结构</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[上下]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">b.<span style="color: black;">上下</span>结构</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[<span style="color: black;">上下</span>]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">c.混合结构</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[混排]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2）PPT母版</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">a.背景</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[我用的灰色多边形色块]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">b.标题</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">略</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">c.LOGO</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">略</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">d.章节（Part）</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">略</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">e.页数</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">在母版设置，<span style="color: black;">办法</span><span style="color: black;">自动</span>百度。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">f.辅助线</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[好的辅助线是成功的一半]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">g.配色</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">理论不讲，就说最快捷的<span style="color: black;">办法</span>，<span style="color: black;">运用</span>Nordri Tools<span style="color: black;">（nordritools.com）</span>插件，安装后重启PPT，点击「色彩库」，<span style="color: black;">选取</span>「在线」，挑个商务色应用就行。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[操作截图]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">PPT的美化属于另一个范畴，<span style="color: black;">因此</span>一笔带过。不<span style="color: black;">晓得</span>怎么美化的<span style="color: black;">能够</span>多看些设计类的<span style="color: black;">文案</span><span style="color: black;">或</span>直接下载模板套用。<span style="color: black;">这里</span>，<span style="color: black;">举荐</span>两个专业的PPT公众号：<strong style="color: blue;">跟我学个P</strong>（ID：PPTlearning）和<strong style="color: blue;">旁门左道</strong>（ID：pangmenzd），谁说运营培养设计美感不重要？</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">4、<span style="color: black;">重视</span>事项</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1）横坐标边界</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">区别</span>的数据需要<span style="color: black;">运用</span>的横坐标边界<span style="color: black;">区别</span>，既然是月报，大多边界以月固定，但<span style="color: black;">亦</span>会有例外，对所有例外的边界最好注明一下。<span style="color: black;">另一</span>，<span style="color: black;">倘若</span>横坐标是时间，<span style="color: black;">运用</span>「m/d」的格式<span style="color: black;">能够</span>减少占位。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">[横坐标]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2）数据标注清晰</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">选取</span>展示的项目<span style="color: black;">太多</span>，<span style="color: black;">倘若</span><span style="color: black;">运用</span>折线图，经常会<span style="color: black;">显现</span>标注交叉、重合<span style="color: black;">引起</span>看不清数据。<span style="color: black;">举荐</span>的<span style="color: black;">办法</span>是：一，只标出重要项目数据，其他删除<span style="color: black;">（或换灰色）</span>，只看走势；二，<span style="color: black;">选取</span>更合适的图表展示类型。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">3）文字<span style="color: black;">太多</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">PPT下方有文字区，<span style="color: black;">然则</span>并不大，<span style="color: black;">因此</span>文字必须<strong style="color: blue;">精简无废话</strong>，我的格式是「<span style="color: black;"><strong style="color: blue;"><span style="color: black;">出现</span>什么事+<span style="color: black;">处理</span>办法（怎么做的）+后续<span style="color: black;">帮助</span></strong></span>」，图表中<span style="color: black;">已然</span>能看出的东西就别再描述了。拿下图举例。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">可写：<strong style="color: blue;">12.7-9<span style="color: black;">时期</span>，XX在10个活动社群中互推名片，<span style="color: black;">源自</span>增粉XX，<span style="color: black;">期盼</span>其他<span style="color: black;">分部</span>有收集到群资料共享给运营。</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">4）操作<span style="color: black;">过程</span>备忘</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">在月报Excel中，并不是所有数据都<span style="color: black;">能够</span>直接引用，部分需要加工，在加工的<span style="color: black;">同期</span><span style="color: black;">必定</span>要记录操作<span style="color: black;">过程</span>，<span style="color: black;">尤其</span>是间隔周期长的报告，绝对会忘。<span style="color: black;">因此</span>吃过一两次亏后我就养<span style="color: black;">成为了</span>有需要<span style="color: black;">重视</span>的<span style="color: black;">地区</span>就马上在Excel空白处记下操作<span style="color: black;">办法</span>，<span style="color: black;">例如</span><span style="color: black;">这般</span>。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">5</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">我踩过的坑和换来的思考</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">你看再多<span style="color: black;">文案</span>再多书，<span style="color: black;">最后</span>都要实操，不实操不会<span style="color: black;">晓得</span>什么才真正适合你，其中到底藏了多少坑。我是SEM出身，经常要和<span style="color: black;">各样</span>各样的报表周旋，后期<span style="color: black;">亦</span>养<span style="color: black;">成为了</span>习惯，不管在任何岗位都会更关注数据，<span style="color: black;">因此</span>最后我想分享<span style="color: black;">有些</span>思考，帮你从技巧中跳脱出来，关注到更深层次的问题。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">1、工具：工具帮你呈现想法，而非产生想法</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">近年我最大的感慨之一<span style="color: black;">便是</span>来自于工具「傻瓜化」的迭代。就像小时候为了学电脑重装系统，去电脑城求教，死记硬背Ghost操作，结果<span style="color: black;">此刻</span>用一键U盘装系统简直0门槛。工具在<span style="color: black;">持续</span>降低<span style="color: black;">咱们</span><span style="color: black;">办事</span>的门槛，但<span style="color: black;">同期</span>让<span style="color: black;">有些</span>人混淆了想法和工具之间的关系。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">办事</span>之前，应该是先在脑子里有想法，<span style="color: black;">而后</span>再思考用<span style="color: black;">那些</span>工具能更快更<span style="color: black;">精细</span>的把它们展示出来。工具会<span style="color: black;">持续</span>更新<span style="color: black;">乃至</span>被替代的，<span style="color: black;">然则</span>想法不会，这<span style="color: black;">便是</span>人类在<span style="color: black;">将来</span>和<span style="color: black;">设备</span>相比的最大<span style="color: black;">优良</span>。<span style="color: black;">因此</span>，千万不要本末倒置。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">[可视化工具-文图（wentu.io）]</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">[数据分析平台-大数据魔镜（moojnn.com）]</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">2、慎行：对得起自己说得话和专业能力</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">报表怎么做、数据怎么展示，全由制表人说了算，缩放坐标轴、断章取义、我不是没玩儿过花招，但没人永远是<span style="color: black;">白痴</span>。还有人没<span style="color: black;">认识</span>到，<span style="color: black;">咱们</span>接收到的所有信息都经过「过滤」，区别在于是好的过滤，还是坏的过滤，你愿意做哪一种？</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">每一件成果<span style="color: black;">便是</span>一次个人品牌的打造，配色、文风、数据<span style="color: black;">精细</span>、<span style="color: black;">乃至</span>清晰度都是你的烙印，与其说做一份合格的报告，不如说争取对得起自己。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">3、<span style="color: black;">守护</span>：<span style="color: black;">守护</span>比生产更重要</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">前几年在我写完<span style="color: black;">第1</span>份内部教程后没多久我就<span style="color: black;">认识</span>到，知识<span style="color: black;">持续</span>更新，<span style="color: black;">此刻</span>停笔，下一秒可能就有新的想法和思路，你会继续<span style="color: black;">守护</span>更新吗？我想大<span style="color: black;">都数</span>人不会，<span style="color: black;">由于</span><span style="color: black;">守护</span>相比新建，带来的成就感要少的多，工作量却一点儿不少。自己在心里<span style="color: black;">亦</span>会<span style="color: black;">一直</span>地劝自己，<span style="color: black;">文案</span>早就完结了，去做别的事吧。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">守护</span>比生产更重要，<span style="color: black;">亦</span>更难、更考验人。别不信，<span style="color: black;">守护</span><span style="color: black;">亦</span>是一种稀缺的能力。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">4、优化：<span style="color: black;">无</span>完美，<span style="color: black;">仅有</span>更完美</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">我<span style="color: black;">始终</span>以为我的报告<span style="color: black;">已然</span>优化得很好了，<span style="color: black;">然则</span>在写这篇<span style="color: black;">文案</span>的时候，又产生无数新的想法。<span style="color: black;"><strong style="color: blue;">永远不要认为事情<span style="color: black;">已然</span>足够好，总有进步的空间。</strong></span>就像我最<span style="color: black;">起始</span>学Excel<span style="color: black;">同样</span>，以为「函数天下无敌」，直到我学到透视表，再接触VBA，<span style="color: black;">乃至</span>是BI。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">工作中我乐于<span style="color: black;">持续</span>给自己泼冷水，我明白自己的视野太局限，<span style="color: black;">因此</span><span style="color: black;">始终</span>争取向外看。我<span style="color: black;">亦</span><span style="color: black;">晓得</span><span style="color: black;">此刻</span>自己认为是大麻烦的事，可能在别人看来<span style="color: black;">何足道哉</span>。别看我上面关于设计报表的内容写了这么多，真正有价值的可能只是些思路。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">怎样</span>调用关键块数据，<span style="color: black;">能够</span>自建运营数据仓库，<span style="color: black;">运用</span>SQL语句快速提取；<span style="color: black;">怎样</span>制表，<span style="color: black;">能够</span>用VBA代码实现数据自动计算并发送到PPT，<span style="color: black;">同期</span>调用Outlook邮件给同事；<span style="color: black;">怎样</span>实时<span style="color: black;">查找</span>数据，<span style="color: black;">能够</span><span style="color: black;">运用</span>Power BI，不仅美观<span style="color: black;">况且</span>能实现数据交互...</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">世界这么大，你以为呢？</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">作者其他<span style="color: black;">文案</span>，请点击阅读：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;">竞价猿不会做数据分析？<span style="color: black;">亦</span>许这篇<span style="color: black;">文案</span>能让你豁然开朗</span></a></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;">深度好文 | 学习成长过程中，</span></a><span style="color: black;">怎样</span>构建自己的笔记系统？</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><a style="color: black;">上篇 | 172个搜索引擎术语，你都<span style="color: black;">晓得</span>吗？</a></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;">下篇 | 172个搜索引擎术语，你都<span style="color: black;">晓得</span>吗？</span></a></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;">SEMer时间管理有多重要？五个<span style="color: black;">过程</span><span style="color: black;">有效</span>管理你的时间</span></a></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;">相见恨晚！这些软件能<span style="color: black;">极重</span><span style="color: black;">加强</span>工作效率！</span></a></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><a style="color: black;">你收到一份团队管理心得分享，面面俱到，毫无<span style="color: black;">保存</span></a></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;">专访 | 0<span style="color: black;">基本</span>的SEM小白，2年后<span style="color: black;">能够</span>成长到什么程</span></a>度？</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>

qzmjef 发表于 2024-10-2 11:58:44

感谢您的精彩评论，为我带来了新的思考角度。

4lqedz 发表于 2024-10-2 12:28:53

认真阅读了楼主的帖子，非常有益。

4lqedz 发表于 2024-10-8 20:39:44

“NB”（牛×的缩写，表示叹为观止）‌

m5k1umn 发表于 2024-10-26 01:07:49

论坛外链网http://www.fok120.com/

4lqedz 发表于 2024-10-27 09:36:25

外链论坛的成功举办，是与各位领导、同仁们的关怀和支持分不开的。在此，我谨代表公司向关心和支持论坛的各界人士表示最衷心的感谢！

查看完整版本: 全网推广运营数据报表设计（含日报/周报/月报/年报）