云图扩展工具
// ==UserScript== // @name 品牌形象洞察_偏爱度 // @namespace http://tampermonkey.net/ // @version 1.2 // @description 云图扩展工具 // @author siji-Xian // @match *://yuntu.oceanengine.com/yuntu_brand/image/insight/brand?indicator=4* // @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(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); //message.js let loadingMsg = null; //目标数据 let target_data = null; let target_data1 = 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, 48) == "/measurement/api/v2/image/get_preference_insight" ) { target_data = JSON.parse(obj?.target?.response); } if ( this?._url?.slice(0, 45) == "/measurement/api/v2/image/get_preference_tags" ) { target_data1 = JSON.parse(obj?.target?.response); } } })(); function appendDoc() { const likeComment = document.querySelector(".brand-image-tab-bar-extra"); if (likeComment) { likeComment.append(button); return; } setTimeout(appendDoc, 1000); } appendDoc(); function expExcel() { let res = target_data.data.preference_insight.competition_analysis.voice_distribution let resData = res.map((v) => { return { ...v, brandCnt:v.positive_coappear_voice_cnt / v.coappear_voice_cnt, brandMakeCon:v.other_positive_coappear_voice_cnt / v.coappear_voice_cnt } } ) let data = [ { sheetName:"竞争局势分析", sheetData:resData, contrast :{ "brand_name": "品牌名称", "coappear_voice_cnt": "共现量级", "cover_cnt": "共现覆盖人数", "brandCnt": "本品牌偏爱占比", "brandMakeCon": "共现品牌偏爱占比", } }, { sheetName:"品牌形象分析", sheetData:target_data1.data.tags, contrast :{ "tag_name": "标签名称", "total_coappear_voice_cnt": "共现量级", "positive_coappear_voice_cnt": "本品牌偏爱量级", "coappear_brand_positive_voice_cnt": "共现品牌偏爱量级", "self_preference_rate": "本品牌偏爱占比", "coappear_brand_preference_rate": "共现品牌偏爱占比", "coappear_brand_top3": "主要共现品牌" } } ] let option = {}; option.fileName = "品牌形象洞察_偏爱度"; //文件名 option.datas = data.map((v,i)=>{ return { sheetName: v.sheetName, sheetData: v.sheetData, sheetHeader: Object.values(v.contrast), sheetFilter: Object.keys(v.contrast), columnWidths: [], // 列宽 } }) var toExcel = new ExportJsonExcel(option); toExcel.saveExcel(); loadingMsg.close(); } function urlClick() { if (target_data) { loadingMsg = Qmsg.loading("正在导出,请勿重复点击!"); expExcel(); } else { loadingMsg = Qmsg.error("数据加载失败,请重试"); } } })();