Greasy Fork is available in English.
云图扩展工具
// ==UserScript==
// @name 5A关系资产_5A人群资产渗透分析
// @namespace http://tampermonkey.net/
// @version 1.5.1
// @description 云图扩展工具
// @author siji-Xian
// @match *://yuntu.oceanengine.com/yuntu_brand/assets/crowd/distribution?*
// @grant none
// @icon https://lf3-static.bytednsdoc.com/obj/eden-cn/prhaeh7pxvhn/yuntu/yuntu-logo_default.svg
// @license MIT
// @require https://lf26-cdn-tos.bytecdntp.com/cdn/expire-1-M/jquery/3.2.1/jquery.min.js
// @require https://update.greasyfork.org/scripts/7223/29866/Momentjs.js
// @require https://greasyfork.org/scripts/404478-jsonexportexcel-min/code/JsonExportExcelmin.js?version=811266
// @require https://greasyfork.org/scripts/463728-lodash-js/code/lodashjs.js?version=1174104
// @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);
var button = document.createElement("button"); //创建一个按钮
button.textContent = "导出数据"; //按钮内容
button.style.height = "32px"; //高
button.style.lineHeight = "32px"; //行高
button.style.align = "center"; //文本居中
button.style.color = "white"; //按钮文字颜色
button.style.background = "#1f4bd9"; //按钮底色
button.style.border = "0px"; //边框属性
button.style.borderRadius = "0px"; //按钮四个角弧度
button.style.marginLeft = "10px";
button.style.fontSize = "14px";
button.style.padding = "0 15px";
button.addEventListener("click", urlClick); //监听按钮点击事件
var button1 = document.createElement("button"); //创建一个按钮
button1.textContent = "资产渗透分析"; //按钮内容
button1.style.height = "32px"; //高
button1.style.lineHeight = "32px"; //行高
button1.style.align = "center"; //文本居中
button1.style.color = "white"; //按钮文字颜色
button1.style.background = "#1f4bd9"; //按钮底色
button1.style.border = "0px"; //边框属性
button1.style.borderRadius = "0px"; //按钮四个角弧度
button1.style.marginLeft = "10px";
button1.style.fontSize = "14px";
button1.style.padding = "0 15px";
button1.addEventListener("click", urlClick1); //监听按钮点击事件
//message.js
let loadingMsg = null;
let loadingMsg1 = null;
//导出文件名
let fileName = "";
//默认GET请求
const getRequestOptions = {
method: "GET",
redirect: "follow",
};
function appendDoc() {
setTimeout(() => {
var like_comment = document.getElementsByClassName(
"assets-form-container-content"
)[0];
if (like_comment) {
like_comment.append(button); //把按钮加入到 x 的子节点中
like_comment.append(button1); //把按钮加入到 x 的子节点中
return;
}
appendDoc();
}, 1000);
}
appendDoc();
//query参数获取
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;
}
//获取行业id
async function getIndustryId(){
let industry_id_url = `https://yuntu.oceanengine.com/yuntu_ng/api/v1/get_user_info`
let res = await fetchFun2(industry_id_url,{aadvid:getQueryVariable('aadvid')})
let industryValue = document.querySelectorAll('.assets-input.assets-input-size-md')[0].value.split('/')[document.querySelectorAll('.assets-input.assets-input-size-md')[0].value.split('/').length - 1]
let data = res
let a = data?.data?.brandMetadata?.filter((e)=>{
let contentData = e?.industry_name.split('/')
return contentData[contentData.length - 1] == industryValue
})[0]
return a.industry_id
}
//获取brand信息
let brand = localStorage.getItem("__Garfish__platform__yuntu_user") || "";
let brands = JSON.parse(brand);
//封装网络请求
function fetchFun2(url, data = {}, requestOptions = getRequestOptions) {
const urlData = Object.keys(data)
.map((v) => `${v}=${data[v]}`)
.join("&");
return fetch(`${url}?${urlData}`, requestOptions)
.then((response) => response.text())
.then((result) => {
return JSON.parse(result);
})
.catch((error) => console.log("error:", error));
}
//获取用户筛选条件
async function getUseData() {
let benchmark = {
对比品牌均值: 1,
行业TOP5品牌均值: 2,
行业TOP20品牌均值: 3,
行业TOP50品牌均值: 4,
行业TOP100品牌均值: 5,
};
let industryValue1 = document.querySelectorAll
(
".assets-input.assets-input-size-md"
)[2].value;
let industryValue2 = document.querySelectorAll(
".assets-input.assets-input-size-md"
)[3].value;
return {
date: industryValue2,
benchmark: benchmark[industryValue1],
benchmark_str: industryValue1,
};
}
//An人群item获取
async function getAnItem(date, benchmark_str) {
let industry_id = await getIndustryId();
let data = {
aadvid: getQueryVariable("aadvid"),
industry_id,
brand_id: brands.brand_id,
date: moment(date).format("YYYYMMDD"),
};
let requestData = await fetchFun2(
"https://yuntu.oceanengine.com/yuntu_ng/api/v1/get_audience_asset_profile",
data
);
let anData = {
date: moment(date).format("YYYY-MM-DD"),
benchmark: benchmark_str,
};
let res = requestData?.data.profile;
res.forEach((v, i) => {
Object.keys(v).forEach((k) => {
anData["A" + i + "_" + k] = v[k];
});
});
return anData;
}
//5A人群资产结构分析
async function get5Aassets(date, benchmark_str, benchmark) {
let industry_id = await getIndustryId();
let data = {
aadvid: getQueryVariable("aadvid"),
industry_id,
brand_id: brands.brand_id,
date: moment(date).format("YYYYMMDD"),
card: 0,
benchmark,
};
let requestData = await fetchFun2(
"https://yuntu.oceanengine.com/yuntu_ng/api/v1/GetAudienceAssetStructure",
data
);
let res = [
...requestData?.data?.structure_list,
...requestData?.data?.a3_list,
];
let expData = { date: moment(date).format("YYYY-MM-DD") };
res.map((v) => {
expData[v.name + "_value"] = v.value;
expData[v.name + "_rate"] = v.rate;
});
return expData;
}
let index_5A = 0
//5A人群资产渗透分析
async function get5Apenetration(date, benchmark_str, benchmark) {
let industry_id = await getIndustryId();
let data = {
aadvid: getQueryVariable("aadvid"),
industry_id,
brand_id: brands.brand_id,
date: moment(date).format("YYYYMMDD"),
};
let requestData = await fetchFun2(
"https://yuntu.oceanengine.com/yuntu_ng/api/v1/GetAudienceAssetBig8Profile",
data
);
console.log(requestData,'requestData');
let res = requestData?.data?.ax_big8_profile[index_5A];
let contrast = {
name: "big8_name",
规模: "big8_cnt",
占比: "big8_percent",
渗透率趋势: "big8_permeab",
};
let arr = [];
fileName = `${moment(date).format("YYYY-MM-DD")}A${index_5A}人群资产渗透分析`;
Object.keys(res).map((v) => {
arr.push({
sheetName:
v == "compete_profile"
? "对比品牌"
: v == "top5_profile"
? "行业TOP5品牌"
: v == "top20_profile"
? "行业TOP20品牌"
: v == "top50_profile"
? "行业TOP50品牌"
: v == "top100_profile"
? "行业TOP100品牌"
: "本品牌",
sheetData: res[v].length ? res[v] : [{}],
sheetHeader: Object.keys(contrast),
sheetFilter: Object.values(contrast),
columnWidths: [], // 列宽
});
});
expExcel(arr);
}
function expExcel(e) {
let option = {};
option.fileName = fileName; //文件名
option.datas = e;
var toExcel = new ExportJsonExcel(option);
toExcel.saveExcel();
if (loadingMsg1) loadingMsg1.close();
loadingMsg.close();
}
async function urlClick() {
let useData = await getUseData();
let res = prompt("导出天数（合法值 1～30）", 1);
let contrast = {
Benchmark: "benchmark",
日期: "date",
人群总资产: "A0_cover_num",
人群总资产超同行: "A0_position_of_industry",
A1了解: "A1_cover_num",
A1了解超同行: "A1_position_of_industry",
A2吸引: "A2_cover_num",
A2吸引超同行: "A2_position_of_industry",
A3问询: "A3_cover_num",
A3问询超同行: "A3_position_of_industry",
A4行动: "A4_cover_num",
A4行动超同行: "A4_position_of_industry",
A5拥护: "A5_cover_num",
A5拥护超同行: "A5_position_of_industry",
};
let contrast1 = (e) => {
return {
日期: "date",
本品牌A1: "a1_value",
[e + "A1"]: "a1_compare_value",
本品牌A2: "a2_value",
[e + "A2"]: "a2_compare_value",
本品牌A3: "a3_value",
[e + "A3"]: "a3_compare_value",
本品牌A4: "a4_value",
[e + "A4"]: "a4_compare_value",
本品牌A5: "a5_value",
[e + "A5"]: "a5_compare_value",
本品牌A1占比: "a1_rate",
[e + "A1占比"]: "a1_compare_rate",
本品牌A2占比: "a2_rate",
[e + "A2占比"]: "a2_compare_rate",
本品牌A3占比: "a3_rate",
[e + "A3占比"]: "a3_compare_rate",
本品牌A4占比: "a4_rate",
[e + "A4占比"]: "a4_compare_rate",
本品牌A5占比: "a5_rate",
[e + "A5占比"]: "a5_compare_rate",
};
};
if (res >= 1 && res <= 30) {
loadingMsg = Qmsg.loading("正在导出，请勿重复点击！");
let arr = new Array(+res);
let datas = [];
let datas_5A = [];
let end_date = "";
for (let i = 0; i < arr.length; i++) {
let data = await getAnItem(
moment(useData.date).add(-i, "days"),
useData.benchmark_str
);
let get5Adata = await get5Aassets(
moment(useData.date).add(-i, "days"),
useData.benchmark_str,
useData.benchmark
);
let get5Aenetration = await get5Apenetration(
moment(useData.date).add(-i, "days"),
useData.benchmark_str,
useData.benchmark
);
end_date = moment(useData.date).add(-i, "days");
datas.push(data);
datas_5A.push(get5Adata);
document.getElementsByClassName(
"qmsg-content-loading"
)[0].childNodes[2].innerHTML = `导出进度：${Math.round(
(datas.length / arr.length) * 100
)}%`;
}
if (datas.length === +res) {
fileName = `${moment(end_date).format("YYYYMMDD")}_${moment(
useData.date
).format("YYYYMMDD")}5A关系资产`;
let expData = [
{
sheetName: `5A关系资产`,
sheetData: datas.length ? datas : [{}],
sheetHeader: Object.keys(contrast),
sheetFilter: Object.values(contrast),
columnWidths: [], // 列宽
},
{
sheetName: `5A人群资产结构分析`,
sheetData: datas_5A.length ? datas_5A : [{}],
sheetHeader: Object.keys(contrast1(useData.benchmark_str)),
sheetFilter: Object.values(contrast1(useData.benchmark_str)),
columnWidths: [], // 列宽
},
];
expExcel(expData);
datas = [];
}
} else if (res === null) {
return;
} else {
alert("输入值有误");
return;
}
}
async function urlClick1() {
try {
let res = prompt(`
O人群输入:0
A1人群输入:1
A2人群输入:2
A3人群输入:3
A4人群输入:4
A5人群输入:5
`);
if (res) {
index_5A = parseInt(res);
let useData = await getUseData();
loadingMsg = Qmsg.loading("正在导出，请勿重复点击！");
await get5Apenetration(
moment(useData.date),
useData.benchmark_str,
useData.benchmark
);
}
} catch (err) {
Qmsg.error(err.message+'请刷新页面后重试。');
}
}
})();