{"id":171,"date":"2016-03-29T11:19:00","date_gmt":"2016-03-29T04:19:00","guid":{"rendered":"https:\/\/www.vietanalytics.com\/?p=171"},"modified":"2025-09-29T14:19:39","modified_gmt":"2025-09-29T14:19:39","slug":"theo-doi-luot-xem-bang-tinh-google-voi-google-analytics","status":"publish","type":"post","link":"https:\/\/tiendathoang.com\/vietanalytics\/2016\/03\/29\/theo-doi-luot-xem-bang-tinh-google-voi-google-analytics\/","title":{"rendered":"Theo d\u00f5i l\u01b0\u1ee3t xem b\u1ea3ng t\u00ednh Google v\u1edbi Google Analytics"},"content":{"rendered":"

B\u1ea1n \u0111\u00e3 s\u1eed d\u1ee5ng Google Analytics \u0111\u1ec3 theo d\u00f5i kh\u00e1ch truy c\u1eadp (ho\u1eb7c l\u01b0\u1ee3t xem trang) tr\u00ean trang web c\u1ee7a b\u1ea1n, nh\u01b0ng b\u1ea1n c\u00f3 th\u1ec3 kh\u00f4ng bi\u1ebft r\u1eb1ng b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00f4ng c\u1ee5 n\u00e0y \u0111\u1ec3 theo d\u00f5i l\u01b0\u1ee3t xem trong Google Spreadsheets. B\u1ea1n ch\u00e8n m\u1ed9t \u0111o\u1ea1n m\u00e3 nh\u1ecf theo d\u00f5i b\u00ean trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n v\u00e0 khi ai \u0111\u00f3 m\u1edf file \u0111\u00f3 th\u00ec th\u00f4ng tin \u0111\u00f3 s\u1ebd \u0111\u01b0\u1ee3c l\u01b0u l\u1ea1i \u1edf trong t\u00e0i kho\u1ea3n Google Analytics c\u1ee7a b\u1ea1n.<\/p>\n

Gi\u1edbi thi\u1ec7u<\/h2>\n

Google Analytics cung c\u1ea5p m\u1ed9t \u0111o\u1ea1n m\u00e3 JavaScript \u0111\u1ec3 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o c\u00e1c trang web \u0111\u1ec3 theo d\u00f5i. B\u1ea1n kh\u00f4ng th\u1ec3 ch\u00e8n JavaScript v\u00e0o trong c\u00e1c \u00f4 c\u1ee7a m\u1ed9t b\u1ea3ng t\u00ednh Google nh\u01b0ng ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IMAGE k\u1ebft h\u1ee3p v\u1edbi m\u1ed9t s\u1ed1 Apps Script \u0111\u1ec3 cho ph\u00e9p theo d\u00f5i b\u00ean trong b\u1ea3ng t\u00ednh. L\u01b0\u1ee3t gh\u00e9 th\u0103m \u0111\u01b0\u1ee3c ghi nh\u1eadn l\u00e0 m\u1ed9t “s\u1ef1 ki\u1ec7n” v\u00e0 kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t “l\u01b0\u1ee3t xem trang” v\u00e0 do \u0111\u00f3 b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n m\u1edf ra s\u1ebd kh\u00f4ng sai l\u1ec7ch b\u00e1o c\u00e1o c\u1ee7a Google Analytics c\u1ee7a b\u1ea1n.<\/p>\n

\"track-google-spreadsheets\"<\/p>\n

Ti\u1ebfn h\u00e0nh<\/h2>\n

\u0110\u1ec3 b\u1eaft \u0111\u1ea7u, b\u1ea1n h\u00e3y v\u00e0o b\u1ea3ng \u0111i\u1ec1u khi\u1ec3n Google Analytics c\u1ee7a b\u1ea1n v\u00e0 l\u01b0u \u00fd r\u1eb1ng n\u00e3 Google Analytics l\u00e0 m\u1ed9t chu\u1ed7i d\u1ea1ng UA-12345-67.<\/p>\n

\"google-formula\"<\/p>\n

M\u1edf b\u1ea5t k\u1ef3 b\u1ea3ng t\u00ednh c\u1ee7a Google m\u00e0 b\u1ea1n mu\u1ed1n theo d\u00f5i v\u00e0 v\u00e0o menu Tools, Script Editor v\u00e0 copy-paste \u0111o\u1ea1n m\u00e3 sau. \u0110\u00e2y l\u00e0 m\u1ed9t h\u00e0m t\u00f9y ch\u1ec9nh trong b\u1ea3ng t\u00ednh c\u1ee7a Google, n\u00f3 s\u1ebd nh\u00fang file h\u00ecnh \u1ea3nh GIF 1 \u00d7 1 \u0111\u1ec3 theo d\u00f5i trong b\u1ea3ng t\u00ednh c\u1ee7a ch\u00fang ta.<\/p>\n

<\u0110o\u1ea1n code><\/p>\n

\/**\n * Track Spreadsheet views with Google Analytics\n *\n * @param {string} gaaccount Google Analytics Account like UA-1234-56.\n * @param {string} spreadsheet Name of the Google Spreadsheet.\n * @param {string} sheetname Name of individual Google Sheet.\n * @return The 1x1 tracking GIF image\n * @customfunction\n *\/\n\nfunction GOOGLEANALYTICS(gaaccount, spreadsheet, sheetname) {\n  \n  \/** \n  * Written by Amit Agarwal \n  * Web: www.ctrlq.org \n  * Email: amit@labnol.org \n  *\/\n  \n  var imageURL = [\n    \"https:\/\/ssl.google-analytics.com\/collect?v=1&t=event\",\n    \"&tid=\" + gaaccount,\n    \"&cid=\" + Utilities.getUuid(),\n    \"&z=\"   + Math.round(Date.now() \/ 1000).toString(),\n    \"&ec=\"  + encodeURIComponent(\"Google Spreadsheets\"),\n    \"&ea=\"  + encodeURIComponent(spreadsheet || \"Spreadsheet\"),\n    \"&el=\"  + encodeURIComponent(sheetname || \"Sheet\")\n  ].join(\"\");\n  \n  return imageURL;\n\n}<\/pre>\n
L\u01b0u \u0111o\u1ea1n m\u00e3, \u0111\u00f3ng c\u1eeda s\u1ed5 so\u1ea1n th\u1ea3o Apps Script v\u00e0 tr\u1edf v\u1ec1 b\u1ea3ng t\u00ednh.<\/p>\n
Nh\u1ea5n v\u00e0o m\u1ed9t \u00f4 tr\u1ed1ng v\u00e0 ch\u00e8n c\u00e1c c\u00f4ng th\u1ee9c sau \u0111\u00e2y. \u00d4 \u0111\u00f3 s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ec3 tr\u1ed1ng nh\u01b0ng n\u00f3 c\u00f3 ch\u1ee9a m\u1ed9t h\u00ecnh \u1ea3nh nh\u00fang. B\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n thay \u0111\u1ed5i m\u00e0u n\u1ec1n \u0111\u1ec3 d\u1ec5 d\u00e0ng t\u00ecm ra nh\u1eefng \u00f4 trong b\u1ea3ng t\u00ednh c\u00f3 ch\u1ee9a c\u00f4ng th\u1ee9c theo d\u00f5i.<\/p>\n
H\u00e0m GOOGLEANALYTICS() c\u00f3 3 tham s\u1ed1 – Google Analytics ID, t\u00ean b\u1ea3ng v\u00e0 t\u00ean sheet. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n theo d\u00f5i ri\u00eang t\u1eebng sheet b\u00ean trong m\u1ed9t b\u1ea3ng t\u00ednh.<\/p>\n
\"google-analytics-report\"<\/p>\n
B\u00e2y gi\u1edd m\u1edf b\u1ea3ng t\u00ednh trong m\u1ed9t c\u1eeda s\u1ed5 tr\u00ecnh duy\u1ec7t m\u1edbi v\u00e0 \u0111i \u0111\u1ebfn Google Analytics, Real Time, Overview \u0111\u1ec3 n\u1ebfu theo d\u00f5i xem h\u00e0m theo d\u00f5i n\u00e0y c\u00f3 \u0111ang l\u00e0m vi\u1ec7c hay kh\u00f4ng. Th\u1ec9nh tho\u1ea3ng n\u00f3 c\u00f3 th\u1ec3 m\u1ea5t m\u1ed9t ph\u00fat \u0111\u1ec3 ghi l\u1ea1i c\u00e1c l\u01b0\u1ee3t vi\u1ebfng th\u0103m. N\u1ebfu b\u1ea1n mu\u1ed1n xem t\u1ea5t c\u1ea3 c\u00e1c l\u1ea7n xem, \u0111i \u0111\u1ebfn Behavior \u2013 Events \u2013 Overview v\u00e0 nh\u1ea5p v\u00e0o danh m\u1ee5c Google Spreadsheets.<\/p>\n
\u01afu nh\u01b0\u1ee3c \u0111i\u1ec3m<\/h2>\n
M\u00e3 theo d\u00f5i n\u00e0y s\u1ebd l\u00e0m vi\u1ec7c ngay c\u1ea3 khi ng\u01b0\u1eddi d\u00f9ng \u0111\u00e3 k\u00edch ho\u1ea1t c\u00e1c ch\u01b0\u01a1ng tr\u00ecnh ch\u1eb7n qu\u1ea3ng c\u00e1o. B\u1edfi v\u00ec Google Spreadsheets, c\u0169ng nh\u01b0 Gmail, t\u1ea3i h\u00ecnh \u1ea3nh th\u00f4ng qua m\u1ed9t m\u00e1y ch\u1ee7 c\u1ee7a Google. Nh\u01b0\u1ee3c \u0111i\u1ec3m l\u00e0 b\u1ea1n s\u1ebd kh\u00f4ng bao gi\u1edd bi\u1ebft v\u1ecb tr\u00ed c\u1ee7a kh\u00e1ch truy c\u1eadp, t\u1ea5t c\u1ea3 c\u00e1c l\u01b0\u1ee3t xem s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb \u1edf M\u1ef9 (v\u1ecb tr\u00ed c\u1ee7a c\u00e1c m\u00e1y ch\u1ee7 c\u1ee7a Google).<\/p>\n
Ngu\u1ed3n v\u00e0 h\u00ecnh \u1ea3nh:\u00a0How to Track Google Spreadsheet Views with Google Analytics –\u00a0labnol.org.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"
B\u1ea1n \u0111\u00e3 s\u1eed d\u1ee5ng Google Analytics \u0111\u1ec3 theo d\u00f5i kh\u00e1ch truy c\u1eadp (ho\u1eb7c l\u01b0\u1ee3t xem trang) tr\u00ean trang web c\u1ee7a b\u1ea1n, nh\u01b0ng b\u1ea1n c\u00f3 th\u1ec3 kh\u00f4ng bi\u1ebft r\u1eb1ng b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00f4ng c\u1ee5 n\u00e0y \u0111\u1ec3 theo d\u00f5i l\u01b0\u1ee3t xem trong Google Spreadsheets.  Continue Reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":173,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[11,13,15],"class_list":["post-171","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tracking","tag-intermediate","tag-google-analytics","tag-google-spreadsheets"],"jetpack_featured_media_url":"https:\/\/tiendathoang.com\/vietanalytics\/wp-content\/my-uploads\/sites\/5\/2016\/03\/google-analytics-report.png","_links":{"self":[{"href":"https:\/\/tiendathoang.com\/vietanalytics\/wp-json\/wp\/v2\/posts\/171","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tiendathoang.com\/vietanalytics\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tiendathoang.com\/vietanalytics\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tiendathoang.com\/vietanalytics\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tiendathoang.com\/vietanalytics\/wp-json\/wp\/v2\/comments?post=171"}],"version-history":[{"count":1,"href":"https:\/\/tiendathoang.com\/vietanalytics\/wp-json\/wp\/v2\/posts\/171\/revisions"}],"predecessor-version":[{"id":239,"href":"https:\/\/tiendathoang.com\/vietanalytics\/wp-json\/wp\/v2\/posts\/171\/revisions\/239"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tiendathoang.com\/vietanalytics\/wp-json\/wp\/v2\/media\/173"}],"wp:attachment":[{"href":"https:\/\/tiendathoang.com\/vietanalytics\/wp-json\/wp\/v2\/media?parent=171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tiendathoang.com\/vietanalytics\/wp-json\/wp\/v2\/categories?post=171"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tiendathoang.com\/vietanalytics\/wp-json\/wp\/v2\/tags?post=171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}