Google Analytics: GA4 Report, Create Custom<\/div>
Creates a TSV report for any Metric from Google Analytics 4 property. One Dimension and one Metric can be specified arbitrarily. Extraction filter is also available. (exact match of the Dimension value).<\/div><\/div>\n\n\n
<\/span>Configs<\/div>
\n
- \n
- U: Select HTTP_Authz Setting *<\/span><\/li>\n
- <\/i><\/span> A1: Set Property-ID in Google Analytics *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> A2: Set Metric (eg “sessions”) *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> A3: Set Dimension (eg “city”) *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> B1: Set StartDate of DateRange (Default #yesterday)#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> B2: Set EndDate of DateRange (Default #today)#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> B3: To filter, Set Name of Filter Dimension (eg “country”)#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> B4: To filter, Set Match List in CSV (eg. “Japan,United States”)#{EL}<\/sup><\/span><\/li>\n
- C1: Select NUM that stores Total (update)<\/li>\n
- <\/i><\/span> D1: Set Number of Ranking Size (Default “20”)#{EL}<\/sup><\/span><\/li>\n
- D2: Select STRING that stores Ranking TSV (update)<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n
<\/span>Script (click to open)<\/div>\n\n\n\n\/\/ GraalJS Script (engine type: 2)\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nmain();\nfunction main(){ \n\n\/\/\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strAuthzSetting = configs.get ( "AuthzConfU" ); \/\/\/ REQUIRED\n engine.log( " AutomatedTask Config: Authz Setting: " + strAuthzSetting );\nconst strPropertyId = configs.get ( "StrConfA1" ); \/\/\/ REQUIRED\n if( strPropertyId === "" ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {A1: PropertyId} must be non-empty \\n" );\n }\nconst strMetric = configs.get ( "StrConfA2" ); \/\/\/ REQUIRED\n if( strMetric === "" ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {A2: Metric} must be non-empty \\n" );\n }\nconst strDimension = configs.get ( "StrConfA3" ); \/\/\/ REQUIRED\n if( strDimension === "" ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {A3: Dimension} must be non-empty \\n" );\n }\nlet strStartDate = configs.get ( "StrConfB1" ); \/\/ NotRequired\n if( strStartDate === "" ){\n strStartDate = "yesterday";\n }else{\n strStartDate = formatToBpmsDateStr( strStartDate );\n }\nlet strEndDate = configs.get ( "StrConfB2" ); \/\/ NotRequired\n if( strEndDate === "" ){\n strEndDate = "today";\n }else{\n strEndDate = formatToBpmsDateStr( strEndDate );\n }\nlet strDimFilter = configs.get ( "StrConfB3" ); \/\/ NotRequired\nlet strDimFilterValues = configs.get ( "StrConfB4" ); \/\/ NotRequired\n if( strDimFilter === "" && strDimFilterValues === "" ){\n engine.log( " AutomatedTask Config:" +\n " DimensionFilter not applied" );\n }else if( strDimFilter !== "" && strDimFilterValues !== "" ){\n engine.log( " AutomatedTask Config:" +\n " DimensionFilter: " + strDimFilter + " " + strDimFilterValues );\n }else if( strDimFilter === "" ){\n engine.log( " AutomatedTask ConfigWarning:" +\n " DimensionFilter ignored, Config {B3: DimensionName} required" );\n }else if( strDimFilterValues === "" ){\n engine.log( " AutomatedTask ConfigWarning:" +\n " DimensionFilter ignored, Config {B4: MatchList} required" );\n }else{\n throw new Error( "\\n AutomatedTask Unexpected Error \\n" );\n }\nconst numPocketTotal = configs.getObject( "SelectConfC1" ); \/\/ NotRequired\nlet strRankSize = configs.get ( "StrConfD1" ); \/\/ NotRequired\n if( strRankSize === "" ){\n strRankSize = "20";\n }\n let numRankSize = strRankSize - 0;\nconst strPocketRankTsv = configs.getObject( "SelectConfD2" ); \/\/ NotRequired\n\n\n\n\/\/\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (Nothing. Retrieved via Expression Language in Config Retrieving)\n\n\n\n\/\/\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\n\/\/\/ request1, prepare body\n\/\/ Google Analytics > Reporting > Google Analytics Data API (GA4) > runReport\n\/\/ https:\/\/developers.google.com\/analytics\/devguides\/reporting\/data\/v1\/rest\/v1beta\/properties\/runReport\nlet request1Obj = {};\n request1Obj.dimensions = [];\n request1Obj.dimensions[0] = {};\n request1Obj.dimensions[0].name = strDimension;\n request1Obj.metrics = [];\n request1Obj.metrics[0] = {};\n request1Obj.metrics[0].name = strMetric;\n request1Obj.dateRanges = [];\n request1Obj.dateRanges[0] = {};\n request1Obj.dateRanges[0].startDate = strStartDate;\n request1Obj.dateRanges[0].endDate = strEndDate;\n request1Obj.limit = numRankSize;\n if( strDimFilter !== "" && strDimFilterValues !== "" ){\n request1Obj.dimensionFilter = {};\n request1Obj.dimensionFilter.filter = {};\n request1Obj.dimensionFilter.filter.fieldName = strDimFilter;\n request1Obj.dimensionFilter.filter.inListFilter = {};\n request1Obj.dimensionFilter.filter.inListFilter.caseSensitive = true;\n request1Obj.dimensionFilter.filter.inListFilter.values =\n strDimFilterValues.split(",");\n }\n request1Obj.orderBys = [];\n request1Obj.orderBys[0] = {};\n request1Obj.orderBys[0].metric = {};\n request1Obj.orderBys[0].metric.metricName = strMetric;\n request1Obj.orderBys[0].desc = true;\n request1Obj.metricAggregations = [];\n request1Obj.metricAggregations[0] = "TOTAL";\n\n\/\/\/ request1, prepare header\nlet request1Uri = "https:\/\/analyticsdata.googleapis.com\/v1beta\/properties\/" +\n strPropertyId + ":runReport";\nlet request1 = httpClient.begin(); \/\/ HttpRequestWrapper\n request1 = request1.authSetting( strAuthzSetting ); \/\/ with "Authorization: Bearer XX"\n \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300#HttpRequestWrapper\n request1 = request1.body( JSON.stringify( request1Obj ), "application\/json" );\n\n\/\/\/ request1, try\nconst response1 = request1.post( request1Uri ); \/\/ HttpResponseWrapper\nengine.log( " AutomatedTask ApiRequest1 Start: " + request1Uri );\nconst response1Code = response1.getStatusCode() + "";\nconst response1Body = response1.getResponseAsString() + "";\nengine.log( " AutomatedTask ApiResponse Status: " + response1Code );\nif( response1Code !== "200"){\n throw new Error( "\\n AutomatedTask UnexpectedResponseError: " +\n response1Code + "\\n" + response1Body + "\\n" );\n}\n\n\/\/\/ response1, parse\nconst response1Obj = JSON.parse( response1Body );\n\n\/* \nengine.log( response1Body ); \/\/ debug\n{\n "dimensionHeaders": [\n {\n "name": "city"\n }\n ],\n "metricHeaders": [\n {\n "name": "sessions",\n "type": "TYPE_INTEGER"\n }\n ],\n "totals": [\n {}\n ],\n "metadata": {\n "currencyCode": "JPY",\n "timeZone": "Asia\/Tokyo"\n },\n "kind": "analyticsData#runReport"\n}\n*\/\n\n\/*\n{\n "dimensionHeaders": [\n {\n "name": "city"\n }\n ],\n "metricHeaders": [\n {\n "name": "sessions",\n "type": "TYPE_INTEGER"\n }\n ],\n "rows": [\n {\n "dimensionValues": [\n {\n "value": "Chiyoda City"\n }\n ],\n "metricValues": [\n {\n "value": "4137"\n }\n ]\n },\n { ... }\n ],\n "totals": [\n {\n "dimensionValues": [\n {\n "value": "RESERVED_TOTAL"\n }\n ],\n "metricValues": [\n {\n "value": "13899"\n }\n ]\n }\n ],\n "rowCount": 248,\n "metadata": {\n "currencyCode": "JPY",\n "timeZone": "Asia\/Tokyo"\n },\n "kind": "analyticsData#runReport"\n}\n*\/\n\n\nlet strRankTsv = "";\nlet numTotal = 0;\n\nif( response1Obj.hasOwnProperty("rows") ){\n \/\/\/ Create TSV by rows\n strRankTsv += strMetric + "\\t" + strDimension + "\\n";\n for( let i = 0; i < response1Obj.rows.length; i++ ){\n strRankTsv += response1Obj.rows[i].metricValues[0].value + "\\t";\n strRankTsv += response1Obj.rows[i].dimensionValues[0].value;\n if( i !== response1Obj.rows.length - 1 ){\n strRankTsv += "\\n";\n }\n }\n\n \/\/\/ Get TOTAL\n numTotal = response1Obj.totals[0].metricValues[0].value;\n}\n\n\n\/\/\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( numPocketTotal !== null ){\n engine.setData( numPocketTotal, new java.math.BigDecimal( numTotal ) );\n}\nif( strPocketRankTsv !== null ){\n engine.setData( strPocketRankTsv, strRankTsv );\n}\n\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\nfunction formatToBpmsDateStr( str ) { \/\/ Format from DateStr to "DateStr for Bpms"\n if( str === "" ){\n throw new Error( "\\n AutomatedTask ParseDateError:" +\n " String is empty \\n" );\n }\n var arrNumParts = str.match( \/\\d+\/g );\n if( arrNumParts === null ){\n throw new Error( "\\n AutomatedTask ParseDateError:" +\n " No numeric characters in: " + str + "\\n" );\n }\n if( arrNumParts.length < 3){\n throw new Error( "\\n AutomatedTask ParseDateError:" +\n " 3 Parts of numeric characters are needed in: " + str + "\\n" );\n }\n let strNew = arrNumParts[0] + "-" +\n ( '0' + arrNumParts[1] ).slice(-2) + "-" +\n ( '0' + arrNumParts[2] ).slice(-2);\n return strNew;\n}\n\n\n\/*\nNotes:\n- Requests to the property (data storage) of Google Analytics when the process reaches the Automated Step.\n - You can automate the extraction work of Google Analytics Data. Analytics Reports\n- Extracts via "Google Analytics Data API" for GA4 properties.\n - Data API can only be used to access GA4 properties and is not compatible with Universal Analytics.\n - As of 202204, it is a "Beta version", although "no breaking changes are expected".\n - https:\/\/developers.google.com\/analytics\/devguides\/reporting\/data\/v1\n - Make sure that the Mesurement ID to be extracted is `G-XXXXXXXXXX` (GA4 property).\n - GA4 Properties is the latest version of Google Analytics released in October 2020.\n - The Mesurement ID of the UA property is `UA-XXXXXXXX-X`.\n - https:\/\/support.google.com\/analytics\/answer\/10089681\n- For GA4 properties with "Google Signals" enabled\n - "Threshold" may be applied in "Report including number of users" etc., and some data may be excluded.\n - From the viewpoint of privacy protection, it is applied when the amount of data is small. "(not set)"\n - "Do not include user attribute information" and "Extend the specified period" are effective.\n - Official Document: GA4 - Data thresholds\n - https:\/\/support.google.com\/analytics\/answer\/9383630\n- Refer to "GA4 Dimensions & Metrics Explorer" for "API Name" of metrics and dimensions.\n - https:\/\/ga-dev-tools.web.app\/ga4\/dimensions-metrics-explorer\/\n - e.g., `sessions` by `city`\n - e.g., `screenPageViews` by `browser`\n - e.g., `conversions` by `pagePath`\n - e.g., `activeUsers` by `hostName`\n - e.g., `userEngagementDuration` by `dayOfWeek`\n - Official Document: GA4 - Dimensions and metrics\n - https:\/\/support.google.com\/analytics\/answer\/9143382\n\nAPPENDIX\n- To place this "Add-on Automated Step" on the design screen of the workflow diagram\n - Import Addon-XML (definition file of this automated step) to Workflow App in advance.\n - The system admins can also make it available in all Workflow Apps. (App-shared Add-on)\n - Manual M415: Adding an Auto-Step to be Used in a Business Process Definition\n - https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360002247792-M415\n- To activate the Workflow App including this "Add-on automated Step"\n - Authorize API communications by an authorized user in advance.\n - Enable "Google Analytics Data API" on the Google Cloud Platform\n - APIs and Services: `Google Analytics Data API`\n - https:\/\/console.cloud.google.com\/project\/_\/apis\/library\n - OFFICIAL DOCUMENT\n - https:\/\/cloud.google.com\/service-usage\/docs\/enable-disable\n - Create an "OAuth2.0 client ID" on the Google Cloud Platform\n - Creating credentials:\n - `OAuth Client ID`\n - Application type:\n - `Web application`\n - Name:\n - `Questetra to GA4`\n - Authorized JavaScript origins:\n - `https:\/\/your-subdomain.questetra.net`\n - Authorized redirect URI:\n - `https:\/\/s.questetra.net\/oauth2callback`\n - OFFICIAL DOCUMENT\n - https:\/\/cloud.google.com\/endpoints\/docs\/frameworks\/java\/javascript-client\n - Set "HTTP authentication (OAuth2)" on the Questetra Workflow-App\n - Name:\n - `Questetra-GA4`\n - Authorization Endpoint URL:\n - `https:\/\/accounts.google.com\/o\/oauth2\/v2\/auth?access_type=offline&prompt=consent`\n - Token Endpoint URL:\n - `https:\/\/oauth2.googleapis.com\/token`\n - Scope:\n - `https:\/\/www.googleapis.com\/auth\/analytics.readonly`\n - Client ID \/ Consumer Secret:\n - (see above "OAuth 2.0 client ID")\n - OFFICIAL DOCUMENT\n - https:\/\/developers.google.com\/identity\/protocols\/oauth2\/web-server#httprest\n- In this Add-on Automated Step, "Data API (GA4)" is used to acquire data from Google Analytics.\n - Not "Reporting API V4".\n - Not "Core Reporting API V3".\n - Requests with a response longer than 30 seconds may result in an error.\n - Detailed specifications of "Google Analytics Data API (GA4)"\n - GUIDE: Creating a Report\n - https:\/\/developers.google.com\/analytics\/devguides\/reporting\/data\/v1\/basics\n - REFERENCE: Method: properties.runReport\n - https:\/\/developers.google.com\/analytics\/devguides\/reporting\/data\/v1\/rest\/v1beta\/properties\/runReport\n- Can also filter the ranking list by Dimension Filter (inListFilter).\n - Only data which dimension values\u200bexactly match any of the values will be extracted. (Case Sensitive)\n - `country`: `Canada,Japan`\n - `customEvent:locale`: `ja`\n- DATE type data or DATETIME type data are also available to specify the date range.\n - `YYYY-MM-DD`, `YYYY\/MM\/DD`, `YYYY-MM-DD hh:mm` etc\n - Must be written in the order of Year Month Date with a delimiter.\n\n\nNotes-ja:\n- \u6848\u4ef6\u304c\u81ea\u52d5\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u969b\u3001Google \u30a2\u30ca\u30ea\u30c6\u30a3\u30af\u30b9\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\uff08\u30c7\u30fc\u30bf\u683c\u7d0d\u5eab\uff09\u306b\u30ea\u30af\u30a8\u30b9\u30c8\u3057\u307e\u3059\u3002\n - Google\u30a2\u30ca\u30ea\u30c6\u30a3\u30af\u30b9Data\u306e\u62bd\u51fa\u696d\u52d9\u3092\u81ea\u52d5\u5316\u3067\u304d\u307e\u3059\u3002 AnalyticsReports\n- GA4\u30d7\u30ed\u30d1\u30c6\u30a3\u7528\u306e "Google Analytics Data API" \u3092\u7d4c\u7531\u3057\u3066\u62bd\u51fa\u3057\u307e\u3059\u3002\n - GA4\u30d7\u30ed\u30d1\u30c6\u30a3\u3078\u306e\u30a2\u30af\u30bb\u30b9\u306b\u306e\u307f\u4f7f\u7528\u3067\u304d\u3001UniversalAnalytics\u3068\u306f\u4e92\u63db\u6027\u304c\u3042\u308a\u307e\u305b\u3093\u3002\n - \u307e\u305f\u3001202204\u6642\u70b9\u306b\u304a\u3044\u3066\u3001\u300c\u91cd\u5927\u306a\u5909\u66f4\u306f\u4e88\u60f3\u3055\u308c\u3066\u3044\u306a\u3044\u300d\u3082\u306e\u306e\u3001"Beta version" \u3067\u3059\u3002\n - https:\/\/developers.google.com\/analytics\/devguides\/reporting\/data\/v1\n - GA4\u306e\u8a08\u6e2cID\u306f `G-XXXXXXXXXX` \u306e\u66f8\u5f0f\u306b\u306a\u308a\u307e\u3059\u3002\n - GA4\u30d7\u30ed\u30d1\u30c6\u30a3\u306f\u30012020\u5e7410\u6708\u306b\u30ea\u30ea\u30fc\u30b9\u3055\u308c\u305f\u6700\u65b0\u7248\u306e Google \u30a2\u30ca\u30ea\u30c6\u30a3\u30af\u30b9\u30d7\u30ed\u30d1\u30c6\u30a3\u3067\u3059\u3002\n - UA\u30d7\u30ed\u30d1\u30c6\u30a3\u306e\u8a08\u6e2cID\u306f `UA-XXXXXXXX-X` \u3068\u306a\u308a\u307e\u3059\u3002\n - https:\/\/support.google.com\/analytics\/answer\/10089681\n- "Google\u30b7\u30b0\u30ca\u30eb" \u304c\u6709\u52b9\u3068\u306a\u3063\u3066\u3044\u308bGA4\u30d7\u30ed\u30d1\u30c6\u30a3\u306e\u5834\u5408\u3001\n - \u300c\u30e6\u30fc\u30b6\u30fc\u6570\u3092\u542b\u3080\u30ec\u30dd\u30fc\u30c8\u300d\u7b49\u3067 "\u3057\u304d\u3044\u5024" \u304c\u9069\u7528\u3055\u308c\u3001\u4e00\u90e8\u30c7\u30fc\u30bf\u304c\u9664\u5916\u3055\u308c\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\n - \u4e3b\u306b\u30d7\u30e9\u30a4\u30d0\u30b7\u30fc\u4fdd\u8b77\u306e\u89b3\u70b9\u304b\u3089\u3001\u30c7\u30fc\u30bf\u91cf\u304c\u5c11\u306a\u3044\u5834\u5408\u306b\u9069\u7528\u3055\u308c\u307e\u3059\u3002"(not set)"\n - \u300c\u30e6\u30fc\u30b6\u30fc\u5c5e\u6027\u60c5\u5831\u3092\u7d44\u307f\u8fbc\u307e\u306a\u3044\u300d\u3084\u300c\u6307\u5b9a\u671f\u9593\u3092\u9577\u304f\u3059\u308b\u300d\u3068\u3044\u3063\u305f\u65b9\u6cd5\u304c\u6709\u52b9\u3067\u3059\u3002\n - \u516c\u5f0f\u30de\u30cb\u30e5\u30a2\u30eb: \uff3bGA4\uff3d\u30c7\u30fc\u30bf\u3057\u304d\u3044\u5024\n - https:\/\/support.google.com\/analytics\/answer\/9383630\n- \u6307\u6a19\u3084\u30c7\u30a3\u30e1\u30f3\u30b8\u30e7\u30f3\u306e "API Name" \u306f\u300cGA4 Dimensions & Metrics Explorer\u300d\u3092\u53c2\u7167\u3057\u307e\u3059\u3002\n - https:\/\/ga-dev-tools.web.app\/ga4\/dimensions-metrics-explorer\/\n - \u4f8b\uff09 `city` \u3054\u3068\u306e `sessions` (\u30bb\u30c3\u30b7\u30e7\u30f3\u6570)\n - \u4f8b\uff09 `browser` \u3054\u3068\u306e `screenPageViews` (\u8868\u793a\u56de\u6570)\n - \u4f8b\uff09 `pagePath` \u3054\u3068\u306e `conversions` (\u30b3\u30f3\u30d0\u30fc\u30b8\u30e7\u30f3)\n - \u4f8b\uff09 `hostName` \u3054\u3068\u306e `activeUsers` (\u30a2\u30af\u30c6\u30a3\u30d6\u30e6\u30fc\u30b6\u6570)\n - \u4f8b\uff09 `dayOfWeek` (\u66dc\u65e5) \u3054\u3068\u306e `userEngagementDuration` (\u30d5\u30a9\u30a2\u30b0\u30e9\u30a6\u30f3\u30c9\u79d2\u6570)\n - \u516c\u5f0f\u30de\u30cb\u30e5\u30a2\u30eb: \uff3bGA4\uff3d\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u3068\u6307\u6a19\n - https:\/\/support.google.com\/analytics\/answer\/9143382?hl=ja\n\nAPPENDIX-ja\n- \u3053\u306e\uff3b\u30a2\u30c9\u30aa\u30f3\u81ea\u52d5\u5de5\u7a0b\uff3d\u3092\u3001\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u56f3\u306e\u8a2d\u8a08\u753b\u9762\u3067\u914d\u7f6e\uff08\u5229\u7528\uff09\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308b\u306b\u306f\n - \u4e88\u3081\u30a2\u30c9\u30aa\u30f3XML\uff08\u3053\u306e\u81ea\u52d5\u5de5\u7a0b\u306e\u5b9a\u7fa9\u30d5\u30a1\u30a4\u30eb\uff09\u3092\u3001\uff3bWorkflow\u30a2\u30d7\u30ea\uff3d\u306b\u8ffd\u52a0\uff08\u30a2\u30c9\u30aa\u30f3\uff09\u3057\u307e\u3059\u3002\n - \u30b7\u30b9\u30c6\u30e0\u7ba1\u7406\u8005\u306f\u3001Workflow\u57fa\u76e4\u306e\u5168\u30a2\u30d7\u30ea\u3067\u914d\u7f6e\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002\uff08\u30a2\u30d7\u30ea\u5171\u6709\u30a2\u30c9\u30aa\u30f3\uff09\n - \u30de\u30cb\u30e5\u30a2\u30eb M415: \u696d\u52d9\u30d7\u30ed\u30bb\u30b9\u5b9a\u7fa9\u3067\u5229\u7528\u53ef\u80fd\u306a\u81ea\u52d5\u5de5\u7a0b\u3092\u8ffd\u52a0\u3059\u308b (Professional edition)\n - https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360002247792-M415\n- \u3053\u306e\uff3b\u30a2\u30c9\u30aa\u30f3\u81ea\u52d5\u5de5\u7a0b\uff3d\u3092\u542b\u3080\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30a2\u30d7\u30ea\u3092\u3001\u904b\u7528\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308b\u306b\u306f\n - \u3042\u3089\u304b\u3058\u3081\u3001\u6a29\u9650\u30e6\u30fc\u30b6\u306b\u3088\u308b\u8a8d\u53ef\uff08API\u901a\u4fe1\u306e\u8a31\u53ef\uff09\u304c\u5fc5\u8981\u3067\u3059\u3002\n - Google Cloud Platform \u5074\u3067\u300eGoogle Analytics Data API\u300f\u3092\u6709\u52b9\u5316\u3059\u308b\n - API\u3068\u30b5\u30fc\u30d3\u30b9\u306e\u6709\u52b9\u5316: `Google Analytics Data API`\n - https:\/\/console.cloud.google.com\/project\/_\/apis\/library\n - \u516c\u5f0f\u30de\u30cb\u30e5\u30a2\u30eb: \u30b5\u30fc\u30d3\u30b9\u306e\u6709\u52b9\u5316\u3068\u7121\u52b9\u5316\n - https:\/\/cloud.google.com\/service-usage\/docs\/enable-disable\n - Google Cloud Platform \u5074\u3067\u300eOAuth2.0\u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID\u300f\u3092\u4f5c\u6210\u3059\u308b\n - \u8a8d\u8a3c\u60c5\u5831\u306e\u4f5c\u6210\uff1a\n - `OAuth\u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID`\n \u3000\u3000- \u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u7a2e\u985e\uff1a\n - `\u30a6\u30a7\u30d6 \u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3`\n \u3000\u3000- \u540d\u524d\uff1a\n - `Questetra to GA4`\n \u3000\u3000- \u627f\u8a8d\u6e08\u307f\u306eJavaScript\u751f\u6210\u5143\uff1a\n - `https:\/\/your-subdomain.questetra.net`\n \u3000\u3000- \u627f\u8a8d\u6e08\u307f\u306e\u30ea\u30c0\u30a4\u30ec\u30af\u30c8 URI:\n - `https:\/\/s.questetra.net\/oauth2callback`\n - \u516c\u5f0f\u30de\u30cb\u30e5\u30a2\u30eb: https:\/\/cloud.google.com\/endpoints\/docs\/frameworks\/java\/javascript-client\n - Questetra \u5074\u3067\u300e"HTTP\u8a8d\u8a3c"\uff08OAuth2\uff09\u300f\u3092\u8a2d\u5b9a\u3059\u308b\n - \u540d\u524d:\n - `Questetra-GA4`\n - \u8a8d\u53ef\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8URL:\n - `https:\/\/accounts.google.com\/o\/oauth2\/v2\/auth?access_type=offline&prompt=consent`\n - \u30c8\u30fc\u30af\u30f3\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8URL:\n - `https:\/\/oauth2.googleapis.com\/token`\n - \u30b9\u30b3\u30fc\u30d7:\n - `https:\/\/www.googleapis.com\/auth\/analytics.readonly`\n - \u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID \/ \u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u30b7\u30fc\u30af\u30ec\u30c3\u30c8:\n - ( see above "OAuth 2.0 client ID" )\n - \u516c\u5f0f\u30de\u30cb\u30e5\u30a2\u30eb: https:\/\/developers.google.com\/identity\/protocols\/oauth2\/web-server#httprest\n- \u3053\u306e\uff3b\u30a2\u30c9\u30aa\u30f3\u81ea\u52d5\u5de5\u7a0b\uff3d\u3067\u306f\u3001Google\u30a2\u30ca\u30ea\u30c6\u30a3\u30af\u30b9\u304b\u3089\u306e\u30c7\u30fc\u30bf\u53d6\u5f97\u306b "Data API" \u304c\u5229\u7528\u3055\u308c\u3066\u3044\u307e\u3059\u3002\n - "Reporting API V4" \u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002\n - "Core Reporting API V3" \u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002\n - \u30ec\u30b9\u30dd\u30f3\u30b9\u304c30\u79d2\u3092\u8d85\u3048\u308b\u3088\u3046\u306a\u30ea\u30af\u30a8\u30b9\u30c8\u306f\u3001\u30a8\u30e9\u30fc\u306b\u306a\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\n - "Google Analytics Data API (GA4)" \u306e\u8a73\u7d30\u4ed5\u69d8\n - GUIDE: Creating a Report\n - https:\/\/developers.google.com\/analytics\/devguides\/reporting\/data\/v1\/basics\n - \u516c\u5f0f\u30de\u30cb\u30e5\u30a2\u30eb: Method: properties.runReport\n - https:\/\/developers.google.com\/analytics\/devguides\/reporting\/data\/v1\/rest\/v1beta\/properties\/runReport\n- \u5b8c\u5168\u4e00\u81f4\u30ea\u30b9\u30c8\uff08inListFilter\uff09\u3092\u8a2d\u5b9a\u3059\u308c\u3070\u3001\u30e9\u30f3\u30ad\u30f3\u30b0\u30ea\u30b9\u30c8\u306e\u7d5e\u308a\u8fbc\u307f\u304c\u53ef\u80fd\u3067\u3059\u3002\n - \u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u306e\u5024\u304c\u3044\u305a\u308c\u304b\u306e\u5024\u3068\u5b8c\u5168\u4e00\u81f4\u3059\u308b\u30c7\u30fc\u30bf\u3060\u3051\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\u3002\uff08Case Sensitive\uff09\n - `country`: `Canada,Japan`\n - `customEvent:locale`: `ja`\n- \u65e5\u4ed8\u7bc4\u56f2\u306e\u6307\u5b9a\u306b\u306f\u3001\u65e5\u4ed8\u578b\u30c7\u30fc\u30bf\u3084\u65e5\u6642\u578b\u30c7\u30fc\u30bf\u306a\u3069\u304c\u5229\u7528\u3067\u304d\u307e\u3059\u3002\n - `YYYY-MM-DD`, `YYYY\/MM\/DD`, `YYYY-MM-DD hh:mm` etc\n - \u533a\u5207\u308a\u6587\u5b57\u306e\u3042\u308b\u6587\u5b57\u5217\u3067 Year Month Date \u306e\u9806\u3067\u8868\u8a18\u3055\u308c\u3066\u3044\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\n*\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<\/a><\/figure>\n\n\n\n
<\/i> Download<\/h3>\n\n\n\n
- \n
- google-analytics-ga4-report-create-custom-2022.xml<\/a><\/li>\n\n\n\n
- google-analytics-ga4-report-create-custom-2023.xml<\/a>\n
- \n
- 2023-08-17 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n
- for “GraalJS standard (engine-type 3)” on v15.0 or above<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
2022-06-09 (C) Questetra, Inc. (MIT License)
https:\/\/support.questetra.com\/addons\/google-analytics-ga4-report-create-custom-2022\/<\/a>
<\/i> The Addon-import feature is available with Professional<\/strong><\/span> edition.
Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.<\/p>\n\n\n<\/div>\n\n\n\n<\/i> Notes<\/h3>\n\n\n\n
- \n
- Requests to the property (data storage) of Google Analytics when the process reaches the Automated Step.\n
- \n
- You can automate the extraction work of Google Analytics Data. Analytics Reports<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Extracts via “Google Analytics Data API” for GA4 properties.\n
- \n
- Data API can only be used to access GA4 properties and is not compatible with Universal Analytics.\n
- \n
- As of 202204, it is a “Beta version”, although “no breaking changes are expected”.<\/li>\n\n\n\n
- https:\/\/developers.google.com\/analytics\/devguides\/reporting\/data\/v1<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Make sure that the Mesurement ID to be extracted is
G-XXXXXXXXXX<\/code> (GA4 property).\n- \n
- GA4 Properties is the latest version of Google Analytics released in October 2020.<\/li>\n\n\n\n
- The Mesurement ID of the UA property is
UA-XXXXXXXX-X<\/code>.<\/li>\n\n\n\n- https:\/\/support.google.com\/analytics\/answer\/10089681<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- For GA4 properties with “Google Signals” enabled\n
- \n
- “Threshold” may be applied in “Report including number of users” etc., and some data may be excluded.\n
- \n
- From the viewpoint of privacy protection, it is applied when the amount of data is small. “(not set)”<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- “Do not include user attribute information” and “Extend the specified period” are effective.<\/li>\n\n\n\n
- Official Document: GA4 – Data thresholds\n
- \n
- https:\/\/support.google.com\/analytics\/answer\/9383630<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Refer to “GA4 Dimensions & Metrics Explorer” for “API Name” of metrics and dimensions.\n
- \n
- https:\/\/ga-dev-tools.web.app\/ga4\/dimensions-metrics-explorer\/<\/a><\/li>\n\n\n\n
- e.g.,
sessions<\/code> bycity<\/code><\/li>\n\n\n\n- e.g.,
screenPageViews<\/code> bybrowser<\/code><\/li>\n\n\n\n- e.g.,
conversions<\/code> bypagePath<\/code><\/li>\n\n\n\n- e.g.,
activeUsers<\/code> byhostName<\/code><\/li>\n\n\n\n- e.g.,
userEngagementDuration<\/code> bydayOfWeek<\/code><\/li>\n\n\n\n- Official Document: GA4 – Dimensions and metrics\n
- \n
- https:\/\/support.google.com\/analytics\/answer\/9143382<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
<\/i> Capture<\/h3>\n\n\n\n
![\"Create](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-analytics-ga4-report-create-custom-2022-capture-en.png?fit=1200%2C675&ssl=1\")
<\/a><\/figure>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-analytics-ga4-report-create-custom-2022-config-en-557x630.png?resize=557%2C630&ssl=1\")
<\/figure>\n\n\n\n<\/i> Appendix<\/h3>\n\n\n\n
- \n
- To place this “Add-on Automated Step” on the design screen of the workflow diagram\n
- \n
- Import Addon-XML (definition file of this automated step) to Workflow App in advance.<\/li>\n\n\n\n
- The system admins can also make it available in all Workflow Apps. (App-shared Add-on)<\/li>\n\n\n\n
- Manual M415: Adding an Auto-Step to be Used in a Business Process Definition\n
- \n
- https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360002247792-M415<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- To activate the Workflow App including this “Add-on automated Step”\n
- \n
- Authorize API communications by an authorized user in advance.<\/li>\n\n\n\n
- Enable “Google Analytics Data API” on the Google Cloud Platform\n
- \n
- APIs and Services:
Google Analytics Data API<\/code>\n- \n
- https:\/\/console.cloud.google.com\/project\/_\/apis\/library<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- OFFICIAL DOCUMENT\n
- \n
- https:\/\/cloud.google.com\/service-usage\/docs\/enable-disable<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Create an “OAuth2.0 client ID” on the Google Cloud Platform\n
- \n
- Creating credentials:\n
- \n
OAuth Client ID<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n- Application type:\n
- \n
Web application<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n- Name:\n
- \n
Questetra to GA4<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n- Authorized JavaScript origins:\n
- \n
https:\/\/your-subdomain.questetra.net<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n- Authorized redirect URI:\n
- \n
https:\/\/s.questetra.net\/oauth2callback<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n- OFFICIAL DOCUMENT\n
- \n
- https:\/\/cloud.google.com\/endpoints\/docs\/frameworks\/java\/javascript-client<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Set “HTTP authentication (OAuth2)” on the Questetra Workflow-App\n
- \n
- Name:\n
- \n
Questetra-GA4<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n- Authorization Endpoint URL:\n
- \n
https:\/\/accounts.google.com\/o\/oauth2\/v2\/auth?access_type=offline&prompt=consent<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n- Token Endpoint URL:\n
- \n
https:\/\/oauth2.googleapis.com\/token<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n- Scope:\n
- \n
https:\/\/www.googleapis.com\/auth\/analytics.readonly<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n- Client ID \/ Consumer Secret:\n
- \n
- (see above “OAuth 2.0 client ID”)<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- OFFICIAL DOCUMENT\n
- \n
- https:\/\/developers.google.com\/identity\/protocols\/oauth2\/web-server#httprest<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- In this Add-on Automated Step, “Data API (GA4)” is used to acquire data from Google Analytics.\n
- \n
- Not “Reporting API V4”.<\/li>\n\n\n\n
- Not “Core Reporting API V3”.<\/li>\n\n\n\n
- Requests with a response longer than 30 seconds may result in an error.<\/li>\n\n\n\n
- Detailed specifications of “Google Analytics Data API (GA4)”\n
- In this Add-on Automated Step, “Data API (GA4)” is used to acquire data from Google Analytics.\n
- https:\/\/developers.google.com\/identity\/protocols\/oauth2\/web-server#httprest<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Client ID \/ Consumer Secret:\n
- Scope:\n
- Token Endpoint URL:\n
- Authorization Endpoint URL:\n
- Set “HTTP authentication (OAuth2)” on the Questetra Workflow-App\n
- OFFICIAL DOCUMENT\n
- Authorized redirect URI:\n
- Authorized JavaScript origins:\n
- Name:\n
- Application type:\n
- Create an “OAuth2.0 client ID” on the Google Cloud Platform\n
- OFFICIAL DOCUMENT\n
- https:\/\/console.cloud.google.com\/project\/_\/apis\/library<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- APIs and Services:
- To activate the Workflow App including this “Add-on automated Step”\n
- https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360002247792-M415<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- To place this “Add-on Automated Step” on the design screen of the workflow diagram\n
- e.g.,
- Refer to “GA4 Dimensions & Metrics Explorer” for “API Name” of metrics and dimensions.\n
- https:\/\/support.google.com\/analytics\/answer\/9383630<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- https:\/\/support.google.com\/analytics\/answer\/10089681<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Make sure that the Mesurement ID to be extracted is
- Data API can only be used to access GA4 properties and is not compatible with Universal Analytics.\n
- Requests to the property (data storage) of Google Analytics when the process reaches the Automated Step.\n
- google-analytics-ga4-report-create-custom-2023.xml<\/a>\n
- <\/i><\/span> A1: Set Property-ID in Google Analytics *<\/span>#{EL}<\/sup><\/span><\/li>\n