{"id":6412,"date":"2025-04-08T10:54:53","date_gmt":"2025-04-08T01:54:53","guid":{"rendered":"https:\/\/blog.since2020.jp\/?p=6412"},"modified":"2025-04-10T12:40:07","modified_gmt":"2025-04-10T03:40:07","slug":"lookerstudio_gas","status":"publish","type":"post","link":"https:\/\/since2020.jp\/media\/lookerstudio_gas\/","title":{"rendered":"\u3010LookerStudio\u00d7GAS\u00d7\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3011\u8a08\u7b97\u30d5\u30a3\u30fc\u30eb\u30c9\u4e0d\u8981\uff01Looker Studio\u306e\u8868\u793a\u306e\u9045\u3055\u3092\u8efd\u6e1b"},"content":{"rendered":"\n<p>Looker Studio\u306e\u8868\u793a\u901f\u5ea6\u3092\u6539\u5584\uff01Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3068GAS\u3092\u6d3b\u7528\u3057\u3001\u8a08\u7b97\u30d5\u30a3\u30fc\u30eb\u30c9\u306a\u3057\u3067\u30c7\u30fc\u30bf\u3092\u53ef\u8996\u5316\u3059\u308b\u65b9\u6cd5\u3092\u8a73\u3057\u304f\u753b\u50cf\u3092\u7528\u3044\u3066\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n<h2>Looker Studio\u306e\u8a08\u7b97\u30d5\u30a3\u30fc\u30eb\u30c9\u304c\u9045\u304f\u306a\u308b\u539f\u56e0<\/h2>\n<p>Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09\u306f\u3001\u624b\u8efd\u306b\u30c7\u30fc\u30bf\u3092\u53ef\u8996\u5316\u3067\u304d\u308b\u4fbf\u5229\u306a\u30c4\u30fc\u30eb\u3067\u3059\u304c\u3001<strong>\u8a08\u7b97\u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u591a\u7528\u3059\u308b\u3068\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u304c\u4f4e\u4e0b<\/strong>\u3059\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002\u7279\u306b\u3001\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u6271\u3046\u5834\u5408\u3084\u8907\u96d1\u306a\u8a08\u7b97\u3092\u884c\u3046\u5834\u5408\u3001\u30ec\u30dd\u30fc\u30c8\u306e\u8868\u793a\u306b\u6642\u9593\u304c\u304b\u304b\u308b\u3053\u3068\u304c\u554f\u984c\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\r\n<p>\u307e\u305f\u3001\u96e3\u3057\u3044\u30bf\u30b9\u30af\u3067LookerStudio\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u4eba\u306f\u611f\u3058\u305f\u3053\u3068\u304c\u3042\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u304c\u8a08\u7b97\u30d5\u30a3\u30fc\u30eb\u30c9\u3067\u306f\u3067\u304d\u308b\u3053\u3068\u3067\u304d\u306a\u3044\u3053\u3068\u306e\u9650\u754c\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\r\n<p>\u3067\u306f\u3001\u3069\u306e\u3088\u3046\u306b\u3059\u308c\u3070Looker Studio\u306e\u8868\u793a\u3092\u901f\u304f\u78ba\u5b9f\u306b\u3067\u304d\u308b\u306e\u3067\u3057\u3087\u3046\u304b\uff1f\u7b54\u3048\u306f\u3001<strong>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u5074\u3067\u4e8b\u524d\u306b\u8a08\u7b97\u3092\u6e08\u307e\u305b\u3066\u304a\u304f\u3053\u3068<\/strong>\u3067\u3059\u3002<\/p>\r\n<p><!-- notionvc: 908ab1bc-edd4-4a41-ac86-e8e7ad6e5e03 --><\/p>\n\n<h2>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u4e8b\u524d\u306b\u8a08\u7b97\u3092\u6e08\u307e\u305b\u308b\u30e1\u30ea\u30c3\u30c8<\/h2>\n<p>Looker Studio\u306e\u8a08\u7b97\u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u4f7f\u308f\u305a\u306b\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u4e8b\u524d\u306b\u8a08\u7b97\u3057\u3066\u304a\u304f\u3053\u3068\u3067\u3001\u6b21\u306e\u3088\u3046\u306a\u30e1\u30ea\u30c3\u30c8\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\r\n<p>\u2705 <strong>\u8868\u793a\u901f\u5ea6\u306e\u5411\u4e0a<\/strong>\uff1a\u8a08\u7b97\u3092\u4e8b\u524d\u306b\u5b8c\u4e86\u3055\u305b\u308b\u3053\u3068\u3067\u3001Looker Studio\u306e\u8ca0\u62c5\u3092\u8efd\u6e1b\u3057\u3001\u30ec\u30dd\u30fc\u30c8\u8868\u793a\u3092\u9ad8\u901f\u5316\u3067\u304d\u307e\u3059\u3002<\/p>\r\n<p>\u2705 <strong>Looker Studio\u306e\u51e6\u7406\u8ca0\u8377\u524a\u6e1b<\/strong>\uff1a\u8a08\u7b97\u6e08\u307f\u306e\u30c7\u30fc\u30bf\u3092\u305d\u306e\u307e\u307e\u53d6\u5f97\u3067\u304d\u308b\u305f\u3081\u3001Looker Studio\u306e\u5185\u90e8\u51e6\u7406\u304c\u30b7\u30f3\u30d7\u30eb\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\r\n<p>\u2705 <strong>GAS\uff08Google Apps Script\uff09\u3092\u4f7f\u3048\u3070\u3088\u308a\u67d4\u8edf\u306a\u51e6\u7406\u304c\u53ef\u80fd<\/strong>\uff1a\u95a2\u6570\u3067\u306f\u5bfe\u5fdc\u3067\u304d\u306a\u3044\u8907\u96d1\u306a\u51e6\u7406\u3082GAS\u3092\u4f7f\u3046\u3053\u3068\u3067\u5b9f\u88c5\u3067\u304d\u307e\u3059\u3002<\/p>\r\n<p>\u3067\u306f\u3001\u5177\u4f53\u7684\u306bGAS\u3092\u4f7f\u3063\u3066\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u30c7\u30fc\u30bf\u3092\u51e6\u7406\u3057\u3001\u305d\u308c\u3092Looker Studio\u306b\u53d6\u308a\u8fbc\u3080\u65b9\u6cd5\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\r\n<p><!-- notionvc: df044fcd-fb31-45a4-b3c8-944a81f2d9b0 --><\/p>\n\n<h2>GAS\u3067\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u30c7\u30fc\u30bf\u3092\u51e6\u7406\u3059\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u4f5c\u6210<\/h2>\n<p><strong>1\ufe0f\u20e3 \u624b\u9806\u2460\uff1a\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u6e96\u5099<\/strong><\/p>\r\n<p>\u307e\u305a\u3001Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u7528\u610f\u3057\u3001\u30c7\u30fc\u30bf\u3092\u8a18\u9332\u3057\u307e\u3059\u3002\u4f8b\u3048\u3070\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u58f2\u4e0a\u30c7\u30fc\u30bf\u304c\u3042\u308b\u3068\u3057\u307e\u3059\u3002<!-- notionvc: 197b41b0-ecbb-4d01-83d9-f41493c66677 --><\/p>\r\n<p><img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/02\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-07-11.13.13.png\" alt=\"\" width=\"1022\" height=\"317\" class=\"alignnone size-full wp-image-6315\" srcset=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/02\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-07-11.13.13.png 1022w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/02\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-07-11.13.13-300x93.png 300w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/02\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-07-11.13.13-768x238.png 768w\" sizes=\"(max-width: 1022px) 100vw, 1022px\" \/><\/p>\r\n<p>\u307e\u305f\u3001\u58f2\u4e0a\u30c7\u30fc\u30bf\u306e\u4ed6\u306bGAS\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u56de\u3057\u305f\u5f8c\u306e\u96c6\u8a08\u30c7\u30fc\u30bf\u306e\u30b7\u30fc\u30c8\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<!-- notionvc: 68e3a291-bc2a-485f-b9d5-8f53e5206dd0 --><\/p>\r\n<p><img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-14.13.27.png\" alt=\"\" width=\"660\" height=\"82\" class=\"alignnone size-full wp-image-6464\" srcset=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-14.13.27.png 660w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-14.13.27-300x37.png 300w\" sizes=\"(max-width: 660px) 100vw, 660px\" \/><\/p>\r\n<p>2\ufe0f\u20e3\u624b\u9806\u2461\uff1aGAS\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u4f5c\u6210<\/p>\r\n<ol>\r\n\t<li><strong>Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u958b\u304d\u3001<code>\u62e1\u5f35\u6a5f\u80fd &gt; Apps Script<\/code> \u3092\u30af\u30ea\u30c3\u30af<br \/>\r\n<img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-13.51.52.png\" alt=\"\" width=\"712\" height=\"290\" class=\"alignnone size-full wp-image-6465\" srcset=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-13.51.52.png 712w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-13.51.52-300x122.png 300w\" sizes=\"(max-width: 712px) 100vw, 712px\" \/><br \/>\r\n<\/strong><\/li>\r\n\t<li><strong><span data-token-index=\"0\" class=\"notion-enable-hover\">\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u66f8\u304f(JavaScript)<\/span><\/strong> <br \/>\r\n\u4ee5\u4e0b\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u306f\u6708\u3054\u3068\u306e\u58f2\u4e0a\u3001\u8cfc\u5165\u56de\u6570\u3001\u8cfc\u5165\u5358\u4fa1\u3092\u8a08\u7b97\u3057\u307e\u3059\u3002 \u307e\u305fLookerStudio\u3067\u306f\u5b9f\u88c5\u304c\u96e3\u3057\u3044\u300c\u524d\u5e74\u540c\u6708\u300d\u30c7\u30fc\u30bf\u3084\u3001\u8a08\u7b97\u30d5\u30a3\u30fc\u30eb\u30c9\u3067\u3067\u304d\u308b\u3088\u3046\u306a\u5e74\u5ea6\u306e\u8a08\u7b97(2024\u5e742\u6708\u306f2023\u5e74\u5ea6)\u3084\u7d4c\u904e\u6708(\u4f8b\u3048\u307010\u6708\u3060\u3063\u305f\u30894\u6708\u304b\u30897\u30f6\u6708\u76ee)\u306a\u3069\u3001LookerStudio\u3067\u5fc5\u8981\u306a\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u3084\u30e1\u30b8\u30e3\u30fc\u3092\u5168\u3066\u4f5c\u6210\u3057\u3066\u3057\u307e\u3044\u307e\u3059\u3002<br \/>\r\n<div class=\"hcb_wrap\">\r\n<pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>function aggregateSalesData() {\r\n    const ss = SpreadsheetApp.getActiveSpreadsheet();\r\n    const sourceSheet = ss.getSheetByName('\u5143\u30c7\u30fc\u30bf'); \/\/ \u30c7\u30fc\u30bf\u3092\u53d6\u308b\u30b7\u30fc\u30c8\r\n    const targetSheet = ss.getSheetByName('\u96c6\u8a08\u30c7\u30fc\u30bf'); \/\/ \u51fa\u529b\u5148\u30b7\u30fc\u30c8\r\n\r\n    const data = sourceSheet.getDataRange().getValues();\r\n    const headers = [\r\n       \"\u5e74\u6708\", \"\u58f2\u4e0a\", \"\u8cfc\u5165\u56de\u6570\", \"\u8cfc\u5165\u5358\u4fa1\", \"\u524d\u5e74\u540c\u6708\u58f2\u4e0a\", \"\u524d\u5e74\u540c\u6708\u8cfc\u5165\u56de\u6570\", \"\u524d\u5e74\u540c\u6708\u8cfc\u5165\u5358\u4fa1\",\r\n       \"\u5e74\", \"\u6708\", \"\u5e74\u5ea6\", \"\u7d4c\u904e\u6708\"\r\n    ];\r\n\r\n    const aggregatedData = {};\r\n    const fiscalYearSummary = {};\r\n    const outputData = [headers];\r\n\r\n    \/\/ \u30c7\u30fc\u30bf\u96c6\u8a08\r\n    for (let i = 1; i &lt; data.length; i++) {\r\n        const [orderDate, , , , orderCode, , , , sales] = data[i]; \/\/ \u6b63\u3057\u3044\u30ab\u30e9\u30e0\u306e\u9806\u756a\u3067\u53d6\u5f97\r\n        if (!orderDate || !sales || isNaN(sales)) continue; \/\/ \u58f2\u4e0a\u304cNaN\u306a\u3089\u30b9\u30ad\u30c3\u30d7\r\n\r\n        const date = new Date(orderDate);\r\n        const year = date.getFullYear();\r\n        const month = date.getMonth() + 1;\r\n        const yearMonth = `${year}-${String(month).padStart(2, '0')}`;\r\n        const fiscalYear = (month &gt;= 4) ? year : year - 1;\r\n\r\n        if (!aggregatedData[yearMonth]) {\r\n          aggregatedData[yearMonth] = { sales: 0, uniqueOrders: new Set(), year, month, fiscalYear };\r\n        }\r\n        if (!fiscalYearSummary[fiscalYear]) {\r\n          fiscalYearSummary[fiscalYear] = { salesByMonth: {}, uniqueOrdersByMonth: {} };\r\n        }\r\n\r\n        aggregatedData[yearMonth].sales += sales;\r\n        aggregatedData[yearMonth].uniqueOrders.add(orderCode);\r\n\r\n        if (!fiscalYearSummary[fiscalYear].salesByMonth[month]) {\r\n          fiscalYearSummary[fiscalYear].salesByMonth[month] = 0;\r\n          fiscalYearSummary[fiscalYear].uniqueOrdersByMonth[month] = new Set();\r\n        }\r\n\r\n        fiscalYearSummary[fiscalYear].salesByMonth[month] += sales;\r\n        fiscalYearSummary[fiscalYear].uniqueOrdersByMonth[month].add(orderCode);\r\n    }\r\n\r\n    \/\/ \u51fa\u529b\u30c7\u30fc\u30bf\u306e\u751f\u6210\r\n    for (const yearMonth in aggregatedData) {\r\n        const entry = aggregatedData[yearMonth];\r\n        const purchaseCount = entry.uniqueOrders.size;\r\n        const averageUnitPrice = purchaseCount &gt; 0 ? Math.floor(entry.sales \/ purchaseCount) : 0;\r\n\r\n        const lastYearMonth = `${entry.year - 1}-${String(entry.month).padStart(2, '0')}`;\r\n        const lastYearEntry = aggregatedData[lastYearMonth] || { sales: 0, uniqueOrders: new Set() };\r\n        const lastYearSales = lastYearEntry.sales;\r\n        const lastYearPurchaseCount = lastYearEntry.uniqueOrders.size;\r\n        const lastYearAverageUnitPrice = lastYearPurchaseCount &gt; 0 ? Math.floor(lastYearSales \/ lastYearPurchaseCount) : 0;\r\n\r\n        const elapsedMonth = entry.month &gt;= 4 ? entry.month - 3 : entry.month + 9;\r\n\r\n        outputData.push([\r\n          yearMonth, \/\/ \u5e74\u6708\r\n          entry.sales, \/\/ \u58f2\u4e0a\r\n          purchaseCount, \/\/ \u8cfc\u5165\u56de\u6570\r\n          averageUnitPrice, \/\/ \u8cfc\u5165\u5358\u4fa1\r\n          lastYearSales, \/\/ \u524d\u5e74\u540c\u6708\u58f2\u4e0a\r\n          lastYearPurchaseCount, \/\/ \u524d\u5e74\u540c\u6708\u8cfc\u5165\u56de\u6570\r\n          lastYearAverageUnitPrice,\/\/ \u524d\u5e74\u540c\u6708\u8cfc\u5165\u5358\u4fa1\r\n          entry.year, \/\/ \u5e74\r\n          entry.month, \/\/ \u6708\r\n          entry.fiscalYear, \/\/ \u5e74\u5ea6\r\n          elapsedMonth \/\/ \u7d4c\u904e\u6708\r\n         ]);\r\n    }\r\n\r\n    \/\/ \u30c7\u30fc\u30bf\u306e\u66f8\u304d\u8fbc\u307f\r\n    targetSheet.clear();\r\n    targetSheet.getRange(1, 1, outputData.length, outputData[0].length).setValues(outputData);\r\n}<\/code><\/pre>\r\n<\/div>\r\n<!-- notionvc: a78ec205-9425-4b65-b7d9-46a9195397dc --><\/li>\r\n\t<li><strong><span data-token-index=\"0\" class=\"notion-enable-hover\">aggregateSales()<\/span><span data-token-index=\"1\" class=\"notion-enable-hover\"> \u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u300c\u96c6\u8a08\u7d50\u679c\u300d\u30b7\u30fc\u30c8\u306b\u65e5\u5225\u58f2\u4e0a\u5408\u8a08\u304c\u8868\u793a\u3055\u308c\u308b<br \/>\r\n<img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.10.48.png\" alt=\"\" width=\"1756\" height=\"558\" class=\"alignnone size-full wp-image-6466\" srcset=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.10.48.png 1756w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.10.48-300x95.png 300w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.10.48-1024x325.png 1024w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.10.48-768x244.png 768w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.10.48-1536x488.png 1536w\" sizes=\"(max-width: 1756px) 100vw, 1756px\" \/><br \/>\r\n<\/span><\/strong><!-- notionvc: 1d948a86-261d-429b-9ec8-41b596b58bd4 -->\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u300c\u96c6\u8a08\u30c7\u30fc\u30bf\u300d\u30b7\u30fc\u30c8\u306b\u96c6\u8a08\u3055\u308c\u307e\u3059\u3002<br \/>\r\n<img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.12.05.png\" alt=\"\" width=\"2230\" height=\"1228\" class=\"alignnone size-full wp-image-6467\" srcset=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.12.05.png 2230w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.12.05-300x165.png 300w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.12.05-1024x564.png 1024w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.12.05-768x423.png 768w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.12.05-1536x846.png 1536w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.12.05-2048x1128.png 2048w\" sizes=\"(max-width: 2230px) 100vw, 2230px\" \/><\/li>\r\n<\/ol>\r\n<p><!-- notionvc: af4a075b-6759-4acc-94b9-113af6349f04 --><\/p>\n\n<h2>Looker Studio\u3067\u30c7\u30fc\u30bf\u3092\u53ef\u8996\u5316\u3059\u308b<\/h2>\n<p><strong>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092Looker Studio\u306b\u63a5\u7d9a<\/strong><!-- notionvc: 9e950c78-b33f-4984-9172-44364167f24b --><\/p>\r\n<ol>\r\n\t<li>\u300c\u96c6\u8a08\u30c7\u30fc\u30bf\u300d\u30b7\u30fc\u30c8\u3092\u9078\u629e\u3057\u305f\u72b6\u614b\u3067\u3001\u300c\u62e1\u5f35\u6a5f\u80fd\u300d\u304b\u3089LookerStudio\u306e\u30ec\u30dd\u30fc\u30c8\u3092\u4f5c\u6210\u3059\u308b<br \/>\r\n<img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.23.08.jpg\" alt=\"\" width=\"1730\" height=\"1148\" class=\"alignnone size-full wp-image-6468\" srcset=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.23.08.jpg 1730w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.23.08-300x199.jpg 300w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.23.08-1024x680.jpg 1024w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.23.08-768x510.jpg 768w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.23.08-1536x1019.jpg 1536w\" sizes=\"(max-width: 1730px) 100vw, 1730px\" \/><!-- notionvc: d7ef73fe-6f78-4f45-b781-dfaa5055b1d4 --><\/li>\r\n\t<li>\u4f5c\u6210\u3059\u308b\u3068\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304c\u3067\u304d\u308b\u3002\u5148\u307b\u3069\u8a08\u7b97\u3057\u3066\u96c6\u8a08\u3055\u308c\u305f\u30ab\u30e9\u30e0\u306f\u3001\u305d\u306e\u307e\u307e\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u3084\u30e1\u30b8\u30e3\u30fc\u3068\u3057\u3066\u30c7\u30fc\u30bf\u306b\u8ffd\u52a0\u3055\u308c\u3066\u3044\u307e\u3059\u3002<br \/>\r\n<br \/>\r\n<img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.24.25.jpg\" alt=\"\" width=\"2508\" height=\"1510\" class=\"alignnone size-full wp-image-6469\" srcset=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.24.25.jpg 2508w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.24.25-300x181.jpg 300w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.24.25-1024x617.jpg 1024w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.24.25-768x462.jpg 768w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.24.25-1536x925.jpg 1536w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2025\/04\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2025-02-06-15.24.25-2048x1233.jpg 2048w\" sizes=\"(max-width: 2508px) 100vw, 2508px\" \/><!-- notionvc: de78ee6c-de8e-4f69-8628-ecd6a0fd53c9 --><\/li>\r\n<\/ol>\n\n<h2>\u307e\u3068\u3081\uff1a\u3053\u306e\u65b9\u6cd5\u3092\u6d3b\u7528\u3057\u3066\u5feb\u9069\u306a\u30c7\u30fc\u30bf\u5206\u6790\u3092\u5b9f\u73fe<\/h2>\n<p>Looker Studio\u306e\u8a08\u7b97\u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u6e1b\u3089\u3059\u3053\u3068\u3067\u3001\u30ec\u30dd\u30fc\u30c8\u306e\u8868\u793a\u901f\u5ea6\u3092\u5927\u5e45\u306b\u5411\u4e0a\u3067\u304d\u307e\u3059\u3002\u305d\u306e\u305f\u3081\u306b\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3068GAS\u3092\u6d3b\u7528\u3057\u3001\u30c7\u30fc\u30bf\u3092\u4e8b\u524d\u306b\u8a08\u7b97\u3057\u3066\u304a\u304f\u65b9\u6cd5\u304c\u6709\u52b9\u3067\u3059\u3002<\/p>\r\n<p>\u2705 <strong>\u30dd\u30a4\u30f3\u30c8\u306e\u304a\u3055\u3089\u3044<\/strong><\/p>\r\n<p>\u30fbLooker Studio\u306e\u8a08\u7b97\u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u6e1b\u3089\u3059\u3053\u3068\u3067\u3001\u8868\u793a\u901f\u5ea6\u3092\u6539\u5584<\/p>\r\n<p>\u30fb\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u30c7\u30fc\u30bf\u3092\u4e8b\u524d\u306b\u8a08\u7b97\u3057\u3001\u8ca0\u8377\u3092\u8efd\u6e1b<\/p>\r\n<p>\u30fbGAS\u3092\u6d3b\u7528\u3057\u3066\u81ea\u52d5\u8a08\u7b97\u3057\u3001\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u96c6\u8a08\u3092\u5b9f\u73fe<\/p>\r\n<p>\u3053\u306e\u65b9\u6cd5\u3092\u53d6\u308a\u5165\u308c\u308c\u3070\u3001Looker Studio\u306e\u30b9\u30c8\u30ec\u30b9\u30d5\u30ea\u30fc\u306a\u30c7\u30fc\u30bf\u53ef\u8996\u5316\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\uff01\u305c\u3072\u8a66\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\r\n<p><!-- notionvc: 8ba7bea2-e025-43d3-890c-a2d0601f8b79 --><\/p>","protected":false},"excerpt":{"rendered":"<p>Looker Studio\u306e\u8868\u793a\u901f\u5ea6\u3092\u6539\u5584\uff01Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3068GAS\u3092\u6d3b\u7528\u3057\u3001\u8a08\u7b97\u30d5\u30a3\u30fc\u30eb\u30c9\u306a\u3057\u3067\u30c7\u30fc\u30bf\u3092\u53ef\u8996\u5316\u3059\u308b\u65b9\u6cd5\u3092\u8a73\u3057\u304f\u753b\u50cf\u3092\u7528\u3044\u3066\u89e3\u8aac\u3057\u307e\u3059\u3002 Looker Studio\u306e\u8a08\u7b97\u30d5\u30a3\u30fc\u30eb\u30c9\u304c\u9045\u304f\u306a\u308b\u539f [&hellip;]<\/p>\n","protected":false},"author":62,"featured_media":6314,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","swell_btn_cv_data":"","footnotes":"","_wp_rev_ctl_limit":""},"categories":[1246],"tags":[258,900,260,371],"class_list":["post-6412","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-infrastructure","tag-bi","tag-google-app-script","tag-looker-studio","tag-371"],"_links":{"self":[{"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/posts\/6412","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/users\/62"}],"replies":[{"embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/comments?post=6412"}],"version-history":[{"count":0,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/posts\/6412\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/media\/6314"}],"wp:attachment":[{"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/media?parent=6412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/categories?post=6412"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/tags?post=6412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}