品牌搜索(搜前引流分析)

云图扩展工具

// ==UserScript==
// @name         品牌搜索(搜前引流分析)
// @namespace    http://tampermonkey.net/
// @version      1.1
// @description  云图扩展工具
// @author       siji-Xian
// @match        *://yuntu.oceanengine.com/yuntu_brand/search/brand?*
// @icon         https://lf3-static.bytednsdoc.com/obj/eden-cn/prhaeh7pxvhn/yuntu/yuntu-logo_default.svg
// @grant        none
// @license      MIT
// @require      https://lf26-cdn-tos.bytecdntp.com/cdn/expire-1-M/jquery/3.2.1/jquery.min.js
// @require      https://cdn.bootcss.com/moment.js/2.20.1/moment.min.js
// @require      https://greasyfork.org/scripts/404478-jsonexportexcel-min/code/JsonExportExcelmin.js?version=811266
// @require      https://greasyfork.org/scripts/455576-qmsg/code/Qmsg.js?version=1122361
// ==/UserScript==

(function () {
  "use strict";
  var new_element = document.createElement("link");
  new_element.setAttribute("rel", "stylesheet");
  new_element.setAttribute("href", "https://qmsg.refrain.xyz/message.min.css");
  document.body.appendChild(new_element);

  const button = document.createElement("div");
  button.textContent = "导出数据";
  Object.assign(button.style, {
    height: "34px",
    lineHeight: "var(--line-height, 34px)",
    alignItems: "center",
    color: "white",
    background: "linear-gradient(60deg, rgb(95, 240, 225), rgb(47, 132, 254))",
    borderRadius: "5px",
    marginLeft: "10px",
    fontSize: "13px",
    padding: "0 10px",
    cursor: "pointer",
    fontWeight: "500",
  });
  button.addEventListener("click", urlClick); //监听按钮点击事件

  //目标数据
  let target_data = null;

  (function listen() {
    var origin = {
      open: XMLHttpRequest.prototype.open,
      send: XMLHttpRequest.prototype.send,
    };
    XMLHttpRequest.prototype.open = function (a, b) {
      this.addEventListener("load", replaceFn);
      origin.open.apply(this, arguments);
    };
    XMLHttpRequest.prototype.send = function (a, b) {
      origin.send.apply(this, arguments);
    };
    function replaceFn(obj) {
      if (
        this?._url?.slice(0,51) ==
        "/search_node/api/search/brand/search_before/content"
      ) {
        target_data = JSON.parse(obj?.target?.response);
      }
    }
  })();

  //message.js
  let loadingMsg = null;

  function appendDoc() {
    const likeComment = document.querySelectorAll(
      ".FlowAnalysis__TitleContainer-eqYwYB.bWTvUL"
    )[0];
    if (likeComment) {
      likeComment.append(button);
      return;
    }
    setTimeout(appendDoc, 1000);
  }
  appendDoc();

  function processData(data) {
    let result = [];

    for (let i = 0; i < data.length; i++) {
        let item = data[i];

        // 处理主要信息
        let mainInfo = {
            rank: i + 1,
            content: item.contentTitle,
            id: item.contentId,
            video: item.contentUrl,
            source: '全部',
            searchKeys1: item.searchKeywords[0]?.keyword,
            searchKeys1Count: item.searchKeywords[0]?.searchCnt,
            searchKeys2: item.searchKeywords[1]?.keyword,
            searchKeys2Count: item.searchKeywords[1]?.searchCnt,
            searchKeys3: item.searchKeywords[2]?.keyword,
            searchKeys3Count: item.searchKeywords[2]?.searchCnt,
            authorName: item.authorName,
            authorType: item.authorType,
            videoCount: item.showCnt,
            searchCnt: item.searchCnt,
            searchRate: item.searchRate,
            searchUv: item.searchUv,
            totalAmount: item.totalAmount,
            orderUv: item.orderUv
        };

        result.push(mainInfo);

        // 处理子详情信息
        let subDetails = item.subDetails;
        for (let j = 0; j < subDetails.length; j++) {
            let subItem = subDetails[j];

            let subInfo = {
                rank: i + 1,
                source: subItem.source,
                searchKeys1: subItem.searchKeywords[0]?.keyword,
                searchKeys1Count: subItem.searchKeywords[0]?.searchCnt,
                searchKeys2: subItem.searchKeywords.length > 1 ? subItem.searchKeywords[1]?.keyword : '-',
                searchKeys2Count: subItem.searchKeywords.length > 1 ? subItem.searchKeywords[1]?.searchCnt : '-',
                searchKeys3: subItem.searchKeywords.length > 2 ? subItem.searchKeywords[2]?.keyword : '-',
                searchKeys3Count: subItem.searchKeywords.length > 2 ? subItem.searchKeywords[2]?.searchCnt : '-',
                videoCount: subItem.showCnt,
                searchRate: subItem.searchRate,
                searchUv: subItem.searchUv,
                totalAmount: subItem.totalAmount,
                orderUv: subItem.orderUv
            };

            result.push(subInfo);
        }
    }

    return result;
}

  async function getData(e) {
    loadingMsg = Qmsg.loading("正在导出，请勿重复点击！");
    let res = e.data
    //处理数据
    let data = processData(res)
    
    expExcel(data);
  }

  function expExcel(e) {
    let contrast = {
      排名: "rank",
      内容: "content",
      视频ID: "id",
      视频资源: "video",	
      看后搜点位:"source",
      "核心搜索词1": "searchKeys1",	
      "核心搜索次数1": "searchKeys1Count",	
      "核心搜索词2": "searchKeys2",
      "核心搜索次数2": "searchKeys2Count",
      "核心搜索词3": "searchKeys3",	
      "核心搜索次数3": "searchKeys3Count",	
      作者: "authorName",
      类型: "authorType",
      视频曝光次数: "videoCount",
      看后搜索次数:"searchCnt",
      看后搜索率:'searchRate',
      看后搜索人数:'searchUv',	
      看后搜成交人数:'totalAmount',
      看后搜成交金额:'orderUv'
    };
    let fileName = `品牌搜索(搜前引流分析)`;
    let option = {};
    option.fileName = fileName; //文件名
    option.datas = [{
      sheetName: "",
      sheetData: e,
      sheetHeader: Object.keys(contrast),
      sheetFilter: Object.values(contrast),
      columnWidths: [], // 列宽
    }]

    var toExcel = new ExportJsonExcel(option);
    toExcel.saveExcel();
    setTimeout(() => {
      loadingMsg.close();
    }, 1000);
  }

  function urlClick() {
    if (target_data) {
      getData(target_data);
    } else {
      loadingMsg = Qmsg.error("数据加载失败，请重试");
    }
  }
})();