// ==UserScript==
// @namespace https://tampermonkey.myso.kr/
// @name 네이버 블로그 통계 지표 다운로드 플러스
// @description 네이버 블로그 통계의 지표 다운로드 기능을 개선하여 줍니다.
// @copyright 2021, myso (https://tampermonkey.myso.kr)
// @license Apache-2.0
// @version 1.0.13
// @author Won Choi
// @connect naver.com
// @match *://admin.blog.naver.com/*/stat/*
// @grant GM_addStyle
// @grant GM_xmlhttpRequest
// @require https://cdn.jsdelivr.net/npm/[email protected]/assets/vendor/gm-app.js
// @require https://cdn.jsdelivr.net/npm/[email protected]/assets/vendor/gm-add-style.js
// @require https://cdn.jsdelivr.net/npm/[email protected]/assets/vendor/gm-add-script.js
// @require https://cdn.jsdelivr.net/npm/[email protected]/assets/vendor/gm-xmlhttp-request-async.js
// @require https://cdn.jsdelivr.net/npm/[email protected]/assets/donation.js
// @require https://cdn.jsdelivr.net/npm/[email protected]/assets/lib/naver-blog.js
// @require https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.29.1/moment.js
// @require https://cdnjs.cloudflare.com/ajax/libs/moment-timezone/0.5.33/moment-timezone.js
// @require https://cdnjs.cloudflare.com/ajax/libs/bluebird/3.7.2/bluebird.min.js
// @require https://cdnjs.cloudflare.com/ajax/libs/lodash.js/4.17.21/lodash.min.js
// @require https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.17.0/xlsx.full.min.js
// @require https://cdnjs.cloudflare.com/ajax/libs/FileSaver.js/2.0.5/FileSaver.min.js
// @require https://cdnjs.cloudflare.com/ajax/libs/toastify-js/1.11.0/toastify.min.js
// ==/UserScript==
// ==OpenUserJS==
// @author myso
// ==/OpenUserJS==
GM_App(async function main() {
GM_donation('.l__container');
GM_addStyle("@import url('https://cdnjs.cloudflare.com/ajax/libs/toastify-js/1.11.0/toastify.min.css')");
moment.tz.setDefault("Asia/Seoul");
async function download() {
const edate = moment().day(-6).toDate();
const range = _.range(15).map(o=>moment(edate).subtract(o, 'weeks').toISOString(true));
const range_date = _.range(7 * 15).map(o=>moment(edate).subtract(o - 6, 'days').toISOString(true));
const sdate = _.minBy(range, o=>moment(o).toDate());
const xlsx = XLSX.utils.book_new();
const xlsx_name = `블로그통계분석_${user.nickname}_${user.userId}_${moment(sdate).format('YYYY-MM-DD')}~${moment(edate).format('YYYY-MM-DD')}.xlsx`
// 방문분석
{
Toastify({ text: `방문 통계 데이터 가져오는 중...`, }).showToast();
const data_view = await NB_blogStat['방문분석'](user.userId, edate, 'WEEK');
const xlsx_sheet_name = `방문`;
const xlsx_sheet_data = [];
{
xlsx_sheet_data.push(['■ 방문통계 요약']);
const cv_sum = _.sumBy(data_view['조회수']['cv'], 'total').toFixed(0);
const cv_avg = _.meanBy(data_view['조회수']['cv'], 'total').toFixed(0);
const uv_sum = _.sumBy(data_view['순방문자수']['uv'], 'total').toFixed(0);
const uv_avg = _.meanBy(data_view['순방문자수']['uv'], 'total').toFixed(0);
const rv_sum = _.sumBy(data_view['재방문율']['revisit'], 'total').toFixed(0);
const rv_avg = _.meanBy(data_view['재방문율']['revisit'], 'total').toFixed(0);
const rvp_avg = _.meanBy(data_view['재방문율']['revisit'], 'total_p').toFixed(2);
const visit_sum = _.sumBy(data_view['방문횟수']['visit'], 'visit').toFixed(0);
const visit_avg = _.meanBy(data_view['방문횟수']['visit'], 'visit').toFixed(0);
const av_avg = _.meanBy(data_view['평균방문횟수']['averageVisit'], 'total').toFixed(2);
const ad_avg = _.meanBy(data_view['평균사용시간']['averageDuration'], 'total').toFixed(2);
xlsx_sheet_data.push(['', '조회수', '순방문자수', '재방문수', '재방문율 (%)', '방문횟수', '평균방문횟수', '평균사용시간 (초)']);
xlsx_sheet_data.push(['평균', cv_avg, uv_avg, rv_avg, rvp_avg, visit_avg, av_avg, ad_avg]);
xlsx_sheet_data.push(['합계', cv_sum, uv_sum, rv_sum, '-', visit_sum, '-', '-']);
}
xlsx_sheet_data.push([]);
// 표
{
xlsx_sheet_data.push(['■ 방문통계 주차별 통계']);
xlsx_sheet_data.push(['날짜', '조회수', '순방문자수', '재방문수', '재방문율 (%)', '방문횟수', '평균방문횟수', '평균사용시간 (초)']);
xlsx_sheet_data.push(...Array.from(range).map((item) => {
const data = [];
const date = moment(item).format('YYYY-MM-DD');
data.push(date);
data.push(_.get(_.find(data_view['조회수']['cv'], { date }), 'total', 0).toFixed(0));
data.push(_.get(_.find(data_view['순방문자수']['uv'], { date }), 'total', 0).toFixed(0));
data.push(_.get(_.find(data_view['재방문율']['revisit'], { date }), 'total', 0).toFixed(0));
data.push(_.get(_.find(data_view['재방문율']['revisit'], { date }), 'total_p', 0).toFixed(2));
data.push(_.get(_.find(data_view['방문횟수']['visit'], { date }), 'visit', 0).toFixed(0));
data.push(_.get(_.find(data_view['평균방문횟수']['averageVisit'], { date }), 'total', 0).toFixed(2));
data.push(_.get(_.find(data_view['평균사용시간']['averageDuration'], { date }), 'total', 0).toFixed(2));
return data;
}));
}
const xlsx_sheet = XLSX.utils.aoa_to_sheet(xlsx_sheet_data);
XLSX.utils.book_append_sheet(xlsx, xlsx_sheet, xlsx_sheet_name);
}
// 사용자분석
{
Toastify({ text: `이웃 통계 데이터 가져오는 중...`, }).showToast();
const data_user = await NB_blogStat['사용자분석'](user.userId, edate, 'WEEK');
const xlsx_sheet_name = `이웃`;
const xlsx_sheet_data = [];
{
xlsx_sheet_data.push(['■ 이웃 증감 현황']);
xlsx_sheet_data.push(['날짜', '서로이웃', '이웃추가', '이웃삭제']);
xlsx_sheet_data.push(...Array.from(range).map((item) => {
const data = [];
const date = moment(item).format('YYYY-MM-DD');
data.push(date);
data.push(_.get(_.find(data_user['이웃증감수']['relationDelta'], { date }), 'friend', '-'));
data.push(_.get(_.find(data_user['이웃증감수']['relationDelta'], { date }), 'add', '-'));
data.push(_.get(_.find(data_user['이웃증감수']['relationDelta'], { date }), 'delete', '-'));
return data;
}));
}
xlsx_sheet_data.push([]);
{
xlsx_sheet_data.push(['■ 이웃 방문 현황']);
xlsx_sheet_data.push(['날짜', '조회수:전체', '순방문자수:전체', '조회수:서로이웃', '순방문자수:서로이웃', '조회수:이웃', '순방문자수:이웃', '조회수:기타', '순방문자수:기타']);
xlsx_sheet_data.push(...Array.from(range).map((item) => {
const data = [];
const date = moment(item).format('YYYY-MM-DD');
data.push(date);
data.push(_.get(_.find(data_user['이웃방문현황']['조회수']['relationVisit'], { date }), 'total', '-'));
data.push(_.get(_.find(data_user['이웃방문현황']['순방문자수']['relationVisit'], { date }), 'total', '-'));
data.push(_.get(_.find(data_user['이웃방문현황']['조회수']['relationVisit'], { date }), 'friend', '-'));
data.push(_.get(_.find(data_user['이웃방문현황']['순방문자수']['relationVisit'], { date }), 'friend', '-'));
data.push(_.get(_.find(data_user['이웃방문현황']['조회수']['relationVisit'], { date }), 'follow', '-'));
data.push(_.get(_.find(data_user['이웃방문현황']['순방문자수']['relationVisit'], { date }), 'follow', '-'));
data.push(_.get(_.find(data_user['이웃방문현황']['조회수']['relationVisit'], { date }), 'etc', '-'));
data.push(_.get(_.find(data_user['이웃방문현황']['순방문자수']['relationVisit'], { date }), 'etc', '-'));
return data;
}));
}
const xlsx_sheet = XLSX.utils.aoa_to_sheet(xlsx_sheet_data);
XLSX.utils.book_append_sheet(xlsx, xlsx_sheet, xlsx_sheet_name);
}
// 유입분석
{
function get_search_query(url) {
try {
const uri = new URL(url);
if(uri.searchParams.has('topReferer')) { return get_search_query(uri.searchParams.get('topReferer')) };
if(uri.searchParams.has('proxyReferer')) { return get_search_query(uri.searchParams.get('proxyReferer')) };
return uri.searchParams.get('query') || uri.searchParams.get('q');
} catch(e) {}
}
Toastify({ text: `유입 통계 데이터 가져오는 중...`, }).showToast();
const xlsx_sheet_name = `유입`;
const xlsx_sheet_data = [];
{
xlsx_sheet_data.push(['날짜', '도메인', '키워드', '경로', '유입수', '유입률 (%)']);
const data_init = await Promise.map(range_date, async (date) => await NB_blogStat['사용자분석']['유입분석']['전체'](user.userId, date, 'DATE'));
const data_view = await Promise.map(data_init, async (item) => {
const data = await Promise.map(item['refererTotal'], async (item) => {
const resp = await NB_blogStat['사용자분석']['유입분석']['전체']['상세'](user.userId, item.date, 'DATE', { searchEngine: item.referrerSearchEngine, refererDomain: item.referrerDomain }).catch(e=>null);
const data = (resp && resp['refererDetail']) || [];
return data.map((o)=>Object.assign({}, item, o)).flat();
});
return data.flat();
});
data_view.flat().map((item)=>{
if(!item.searchQuery) item.searchQuery = get_search_query(item.referrerUrl);
xlsx_sheet_data.push([item.date, item.referrerDomain, item.searchQuery, item.referrerUrl, item.cv, item.cv_p])
});
}
const xlsx_sheet = XLSX.utils.aoa_to_sheet(xlsx_sheet_data);
XLSX.utils.book_append_sheet(xlsx, xlsx_sheet, xlsx_sheet_name);
}
// 순위분석
{
Toastify({ text: `게시물 통계 데이터 가져오는 중...`, }).showToast();
const xlsx_sheet_name = `게시물`;
const xlsx_sheet_data = [];
const data_rank = await Promise.map(range, async (date) => { const resp = await NB_blogStat['순위']['조회수']['게시물'](user.userId, date, 'WEEK'); return resp.rankCv; });
const data_rank_articles_kv = _.mapValues(_.groupBy(data_rank.filter(v=>!!v).flat(), 'uri'), (items) => {
const stats = Array.from(range).map((item) => {
const date = moment(item).format('YYYY-MM-DD');
const defs = _.assign({}, items[0], { cv: 0, rank: 0, date });
const data = _.find(items, { date });
return data || defs;
});
stats.cv_avg = _.meanBy(stats, 'cv');
stats.cv_sum = _.sumBy(stats, 'cv');
stats.rank_avg = _.meanBy(stats, 'rank');
return stats;
});
const data_rank_articles = _.orderBy(_.map(data_rank_articles_kv, (items, uri)=>(items.uri = uri, items.title = _.get(items, '[0].title', '-'), items)), ['cv_sum', 'rank_avg'], ['desc', 'asc']);
data_rank_articles.cv_avg = _.meanBy(data_rank_articles, 'cv_avg').toFixed(2);
data_rank_articles.cv_sum = _.sumBy(data_rank_articles, 'cv_sum').toFixed(0);
xlsx_sheet_data.push(['날짜', '주소', '제목', '순위', '전체 누적 조회수', '주간 평균 조회수', '주간 누적 조회수']);
data_rank_articles.map((item) => {
item.map((data) => xlsx_sheet_data.push([data.date, item.uri, item.title, data.rank, item.cv_sum, item.cv_avg, data.cv]));
});
const xlsx_sheet = XLSX.utils.aoa_to_sheet(xlsx_sheet_data);
XLSX.utils.book_append_sheet(xlsx, xlsx_sheet, xlsx_sheet_name);
};
//XLSX 저장
const xlsx_opts = { bookType:'xlsx', bookSST:false, type:'array' };
const xlsx_blob = XLSX.write(xlsx, xlsx_opts);
saveAs(new Blob([xlsx_blob],{type:"application/octet-stream"}), xlsx_name);
Toastify({ text: `저장 완료`, }).showToast();
}
const user = await NB_blogInfo('', 'BlogUserInfo'); if(!user) return;
const wrap = document.querySelector('#nav.lnb__local-menu'); if(!wrap) return;
const cont = wrap.querySelector('.lnb__download') || document.createElement('div'); cont.classList.add('lnb__depth1', 'lnb__download'); wrap.append(cont);
const link = cont.querySelector('.lnb__title') || document.createElement('a'); link.classList.add('lnb__title'); link.textContent = '지표 다운로드 플러스'; cont.append(link);
cont.addEventListener('click', (event)=>{
event.preventDefault();
event.stopPropagation();
download();
});
});
