Web Page Effectiveness Measurement Process

Web Page Effectiveness Measurement Process 20211022

Web page creators register the date of publication and PagePath. One month after the publication date, the results (PV/session count/overall evaluation) are automatically obtained via Google Analytics API and automatically evaluated on a 5-point scale. The creator can check the objective evaluation and obtain opportunities for improvement.

Worker (#of Swimlane: 1)

Page Creator

Business Flow (Complexity of Workflow: 16)

11. Page Registration for Effectiveness Measurement
- The page creator will start measuring the effectiveness.
121x. Re-registration of pages targeted for effect measurement
- Page creator changes measurement target data
8Effect measurement
- The workflow platform measures effectiveness from standard values + Google Analytics aggregated data.
7Measurement end date set
- The workflow platform stores the date one month after the publication date as the measurement end date.
5Obtain Google Analytics Data
- The workflow platform uses Google Analytics API to obtain the PV, number of sessions, and page title based on the specified period and PagePath.
15Obtain PV/Session evaluation criteria
- The workflow platform obtains the PV/Session evaluation criteria (Google Sheet).
16Obtain comprehensive evaluation criteria
- The workflow platform obtains the comprehensive evaluation criteria (Google Sheet).
17Set Title
- The workflow platform stores the subject line.

Workflow Diagram (click to open)

BPMN Icons
- Start Event
- End Event
- Join Gateway
- XOR Gateway
- Throwing Message Intermediate Event (email)
- Human Task
- Update Data
- Timer Intermediate Event
- Google Sheets: ValueRanges, Export as TSV
- Google Analytics: Reports, Pageviews by Hostname-PagePath
- Script Task

Business Process Variables (#of Data Item: 21)

◆ Measurement Target Page Information (first time) 17
◆ Measurement Target Page Information (re-registration) 20
Web Page Publication Dateq_measurement_start_date0
- The web page publication date (measurement start date) is stored.
- processInstanceStartDatetime
Measurement End Dateq_measurement_end_date1
- The measurement end date is stored. (Next day after 1 month from start date)
Measurement Target pagePathq_pagePath4
- Contains the PagePath to be measured.
◆ Collection Performance Data 18
Page Titleq_page_title14
- The page title of the target PagePath is stored.
Analytics Aggregate Dataq_analytics_data2
- The acquired Google Analytics aggregate information is stored. (Assuming 2 lines of 1st line title)
PV Number Actual Valueq_pv15
- Target PagePath The number of PVs for the specified period is stored.
PV Number Evaluation Results (5 levels)q_pv_evaluation_result8
- The evaluation score of the number of PV is stored.
PV Number Evaluation Result: Star Display (5 levels)q_pv_evaluation_result_star11
- The PV number evaluation score expressed in ★ is stored.
Actual Number of Sessionsq_session16
- Target PagePath Stores the number of sessions for the specified period.
Session Number Evaluation Results (5 levels)q_session_evaluation_result9
- The evaluation score for the number of sessions is stored.
Session Count Evaluation Result: Star Display (5 levels)q_session_evaluation_result_star12
- The number of sessions evaluation score expressed in ★ is stored.
Comprehensive Evaluation Result (5 levels)q_judgement_result10
- The overall evaluation score is stored.
Overall Evaluation Result: Star Display (5 levels)q_judgement_result_star13
- The overall evaluation score expressed in ★ is stored.
Communication Logq_communication_log3
- Google Analytics API access results are stored.
◆ Evaluation Criteria Data 19
PV Evaluation Tableq_pv_evaluation_table5
- PV number evaluation criteria is stored. (Retrieved from Google Sheets)
  ＜Format＞
  {PV number range corresponding to this evaluation point min}\t{PV number range corresponding to this evaluation point max}\t{Evaluation score}
Session Count Evaluation Tableq_session_evaluation_table6
- Contains session count evaluation criteria. (Retrieved from Google Sheets)
  ＜Format＞
  {Range of number of sessions that correspond to this evaluation score min}\t{Range of number of sessions that correspond to this evaluation score max}\t{Evaluation score}
Comprehensive Evaluation Tableq_effect_judgement_table7
- Stores the final evaluation criteria. (Retrieved from Google Sheets)
  ＜Format＞
  {PV score for this evaluation point + session evaluation score min}\t{PV score for this evaluation point + session evaluation score max}\t{Evaluation score}

Field Name, num, Initial Value

Download

Web_Page_Effectiveness_Measurement_Process.qar (Latest)
web-page-effect-measurement-process-20211022-en.qar
- web-page-effect-measurement-process-20211022-en.xml.csv (for Importing Data Item Definitions)

This archive contains the BPMN icon, which is only available in the Professional edition.

Notes

You need to associate the Swimlane settings according to your organizational structure upon import

Arrangement Tips

Effect Measurement Automatic Process Script (click to open)

const actualValue = engine.findDataByVarName("q_analytics_data");
const pvTable = engine.findDataByVarName("q_pv_evaluation_table");
const sessionTable = engine.findDataByVarName("q_session_evaluation_table");
const judgementTable = engine.findDataByVarName("q_effect_judgement_table");
let pv;
let session;
let pagePath;
let pageTitle
let pvEvaluation;
let sessionEvaluation;
let pvResult;
let sessionResult;
let judgementResult;

main();

function main(){
    // Get Actual Value
    let actualValueRows; // [0]: Title Row [1]: Value Row
    let actualValueCols; // [0]: pageview [1]: session [2]: pagePath [3]: page title
    if (actualValue === null){
        throw new Error( "\n AutomatedTask AnalyticsDataError:" +
                   " Data Not Exist \n" );
    }else{
        actualValueRows = actualValue.split('\n');
	engine.log("actualValueRows.length:" + actualValueRows.length);
	if (actualValueRows.length === 1){
            throw new Error( "\n AutomatedTask AnalyticsDataError:" +
                       " Count of Data Rows is invalid \n" );
	}else{
            actualValueCols = actualValueRows[1].split('\t');
	    pv = Number(actualValueCols[0]);
	    session = Number(actualValueCols[1]);
	    pagePath = actualValueCols[2];
	    pageTitle = actualValueCols[3];
	    engine.log("pv:" + pv + " session:" + session + " pagePath:" + pagePath + " pageTitle:" + pageTitle);
	}
    }
    // Get score
    pvResult = calcEvaluation(pvTable.split('\n'),pv);
    sessionResult = calcEvaluation(sessionTable.split('\n'),session);
    judgementResult = calcEvaluation(judgementTable.split('\n'),pvResult+sessionResult);
    // Store workflow data
    engine.log("pvResult:" + pvResult + " sessionResult:" + sessionResult + " judgementResult:" + judgementResult);
    engine.setDataByVarName("q_pv", new java.math.BigDecimal(pv));
    engine.setDataByVarName("q_session", new java.math.BigDecimal(session));
    engine.setDataByVarName("q_page_title", pageTitle);
    engine.setDataByVarName("q_pv_evaluation_result", new java.math.BigDecimal(pvResult));
    engine.setDataByVarName("q_session_evaluation_result", new java.math.BigDecimal(sessionResult));
    engine.setDataByVarName("q_judgement_result", new java.math.BigDecimal(judgementResult));
    engine.setDataByVarName("q_pv_evaluation_result_star", getStarsForShow(pvResult));
    engine.setDataByVarName("q_session_evaluation_result_star", getStarsForShow(sessionResult));
    engine.setDataByVarName("q_judgement_result_star", getStarsForShow(judgementResult));
}
// Evaluation point calculation
// param1: Evaluation table (Array) param2: Numerical value to be evaluated
// return: Evaluation points
function calcEvaluation(tableRows,target){
    let tableCols;
    let result = 0;
    for (var i=0; i < tableRows.length; i++){
        tableCols = tableRows[i].split('\t');
	if (((target >= tableCols[0])&&(target <= tableCols[1]))||((target >= tableCols[0])&&(tableCols[1] === "0"))){
	    engine.log("target:" + target + " tableCols[0]:" + tableCols[0] + " tableCols[1]:" + tableCols[1]);
	    result = tableCols[2];
	    return Number(result);
	}
    }
    return result;
}
// Convert evaluation points to 5-star star display string
// param: Evaluation score (1~5)
// return: 5 stage star display string
function getStarsForShow(point){
    let strStar;
    switch (point){
        case 1:
	    strStar = "★☆☆☆☆";
	    break;
        case 2:
	    strStar = "★★☆☆☆";
	    break;
        case 3:
	    strStar = "★★★☆☆";
	    break;
        case 4:
	    strStar = "★★★★☆";
	    break;
        case 5:
	    strStar = "★★★★★";
	    break;
    }
    return strStar;
}