Greasy Fork

Greasy Fork is available in English.

流量分析

云图扩展工具

当前为 2023-05-08 提交的版本，查看 最新版本。

// ==UserScript==
// @name         流量分析
// @namespace    http://tampermonkey.net/
// @version      0.1
// @description  云图扩展工具
// @author       siji-Xian
// @match        *://yuntu.oceanengine.com/yuntu_ng/evaluation_brand/report/flow?*
// @icon         https://www.google.com/s2/favicons?domain=oceanengine.com
// @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      http://greasyfork.icu/scripts/404478-jsonexportexcel-min/code/JsonExportExcelmin.js?version=811266
// @require      http://greasyfork.icu/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(90deg, rgba(0, 239, 253), rgba(64, 166, 254))",
    borderRadius: "5px",
    marginLeft: "10px",
    fontSize: "13px",
    padding: "0 10px",
    cursor: "pointer",
    fontWeight: "500"
  });
  button.addEventListener("click", urlClick);

  function getQueryVariable(variable) {
    var query = window.location.search.substring(1);
    var vars = query.split("&");
    for (var i = 0; i < vars.length; i++) {
      var pair = vars[i].split("=");
      if (pair[0] == variable) {
        return pair[1];
      }
    }
    return false;
  }

  //message.js
  let loadingMsg = null;

  setTimeout(() => {
    var like_comment = document.getElementsByClassName(
      "byted-tab-bar-items-inner"
    )[0];
    like_comment.append(button); //把按钮加入到 x 的子节点中
  }, 2000);

  function appendDoc() {
    const likeComment = document.querySelector(".byted-tab-bar-items-inner");
    if (likeComment) {
      likeComment.append(button);
      return;
    }
    setTimeout(appendDoc, 1000);
  }
  appendDoc();

  async function fetchFun(url, data, requestOptions = getRequestOptions()) {
    const params = new URLSearchParams(data).toString();
    try {
      const response = await fetch(`${url}?${params}`, requestOptions);
      if (response.ok) {
        const result = await response.json();
        return result;
      } else {
        throw new Error(`Fetch failed: ${response.status}`);
      }
    } catch (error) {
      loadingMsg.close();
      Qmsg.error({
        content: `网络请求错误: ${error.message}`,
        timeout: 5000
      });
      throw error;
    }
  }

  //活动总览tabs数据获取
  async function getTabs1Data(e) {
    let sheetName = e == "130000" ? "抖音" : "跨端";

    var myHeaders = new Headers();
    myHeaders.append("content-type", "application/json;charset=UTF-8");

    let bodyData = {
      task_id: getQueryVariable("task_id"),
      benchmark_type: 2,
      stat_types: [1, 2, 7],
      if_level_3_trigger_point: true,
      trigger_point: {
        level_1_trigger_point: { query_type_point_id: e },
      },
    };
    let postRequestOptions = {
      method: "POST",
      headers: myHeaders,
      body: JSON.stringify(bodyData),
      redirect: "follow",
    };
    let data = {
      aadvid: getQueryVariable("aadvid"),
    };
    let title = {
      "触点/日期": "point_name",
    };
    let contrast = {};
    //
    let requestData = await fetchFun(
      "https://yuntu.oceanengine.com/measurement/api/v2/get_evaluation_flow_by_day_result",
      data,
      postRequestOptions
    );
    Object.keys(requestData?.data?.item_list[0]?.by_day_list).map((v) => {
      contrast[moment(v).format("YYYY-MM-DD")] = v;
    });
    let expData = requestData?.data?.item_list?.map((v, i) => {
      let data = {};
      Object.keys(v.by_day_list).map((r) => {
        //pv：曝光次数  uv：曝光人数  cost：消耗金额
        data[r] = v.by_day_list[r]?.cost;
      });
      let a = Object.values(v.trigger_point).map((v) => {
        return v.query_type_point_name_zh;
      });
      data["point_name"] = a.join("/");
      return {
        data,
      };
    });

    let datas = {
      sheetName,
      sheetData: expData.map((v) => v.data),
      sheetHeader: Object.keys({ ...title, ...contrast }),
      sheetFilter: Object.values({ ...title, ...contrast }),
      columnWidths: [], // 列宽
    };
    return datas;
  }

  function expExcel(e) {
    let option = {};
    option.fileName = "流量分析_byDay"; //文件名
    option.datas = e;
    var toExcel = new ExportJsonExcel(option);
    toExcel.saveExcel();
    loadingMsg.close();
  }

  async function urlClick() {
    let pointId = ["130000", "150000"];
    loadingMsg = Qmsg.loading("正在导出，请勿重复点击！");
    let promiseData = await Promise.all(
      pointId.map(async (v) => {
        let data = await getTabs1Data(v);
        return data;
      })
    );
    expExcel(promiseData)

  }
})();