ãGoogle Analytics API掻çšè¡ðãGA4ãPythonã§èªåååŸãåæ/CSVåºåãŸã§å¹çå
GA4ã®ç®¡çç»é¢ãæ¯åéããå¿
èŠãªããŒã¿ãæäœæ¥ã§éèšããäœæ¥ã«ãæéãããããããã£ãšèªååãããããšæããŠããŸãããã
ããŒã¿åæã¯éèŠã§ãããåçŽãªéèšãã¬ããŒãäœæã«æéãåãããŠããŸãã®ã¯å€§ããªè² æ
ã§ãã
ð Google Analytics APIãæŽ»çšããã°ãGA4ã®ããŒã¿ãããã°ã©ã ããååŸããåæãã¬ããŒãäœæãå¹çåã§ããŸãã
ð Pythonãšçµã¿åãããããšã§ãããŒãžå¥ããŒã¿ã®ååŸãCSVåºåãŸã§èªååã§ããŸãã
ãã®èšäºã§ã¯ãGoogleå
¬åŒã®Google Analytics Data APIã䜿ããGCPã®æºåããAPIæå¹åãèªèšŒèšå®ãå®éã®ããŒã¿ååŸãŸã§é çªã«è§£èª¬ããŸãã
ããã«ãData API/Admin APIã®éãããµãŒãã¹ã¢ã«ãŠã³ãã®äœ¿ãæ¹ãã¯ã©ãŒã¿ããšã©ãŒå¯ŸçãŸã§ããããããæŽçããŠããŸãã
â Google Analytics APIã§ã§ããããšãããã
â GA4ããŒã¿ãPythonã§èªåååŸããæµããããã
â ãµãŒãã¹ã¢ã«ãŠã³ãã䜿ã£ãèªèšŒæ¹æ³ãçè§£ã§ãã
â CSVåºåã宿ã¬ããŒãèªååã®æ¹æ³ãããã
â APIãå®å®éçšããããã®åºæ¬çãªæ³šæç¹ã確èªã§ãã
é£ãããã«èŠããGA4 APIããå¿
èŠãªèšå®ã1ã€ãã€é²ããã°åå¿è
ã§ã掻çšã§ããŸãã
äžåºŠä»çµã¿ãäœãã°ãæ¯åã®æäœæ¥ãæžãããããªãã¯ããŒã¿ã®ç¢ºèªã§ã¯ãªãåæãæ¹åã«æéã䜿ããããã«ãªããŸãð

ãGA4 APIæŠèŠðãã§ããããšãšSEOåæã«å¹ã掻çšã¡ãªããã®å šäœå
äžèšã®èšäºã§ã説æãããšãããGoogle Seach Console APIã®å©çšã«ææŠããŸããã
Googleæ€çŽ¢ã®åæã¯ã§ããã®ã§ãããèªåã®ããŒã ããŒãžã®åæã«Google Analyticsã®APIã䜿ããããªããŸããã

å ã«èªãã§æ¬²ããGoogle Seach Console APIã®å©çšæé

äžèšã®èšäºãšéè€ããç®æãå€ããããä»åã®èšäºã§ã¯éè€ç®æã¯äžéšæé ãé£ã°ããŠèª¬æããŸãã
Google Analytics APIã¯ãGoogle Analyticsã®ããŒã¿ã«å¯ŸããŠããã°ã©ã ããã¢ã¯ã»ã¹ã»æäœã§ããä»çµã¿ã§ãã
ç¹ã«GA4察å¿ã®Data APIã䜿ãã°ãã¬ããŒãç»é¢ã«é Œãããèªç±ã«ããŒã¿ãååŸã»å å·¥ã»é£æºã§ããŸãã
æäœæ¥ã§ã¯å®çŸãé£ããé«åºŠãªåæãã宿ã¬ããŒãã®èªååãéããŠãããŒã±ãã£ã³ã°ãããŒã¿æŽ»çšã®å¯èœæ§ã倧ããåºãããŸãã
以äžã¯ãGoogle Analytics APIã®äž»ãªæŽ»çšäŸã§ãð
âGA4ã®æšæºã¬ããŒãã§ã¯é£ããæè»ãªããŒã¿æœåºãã§ãã
âèªåã¬ããŒããããã·ã¥ããŒãæ§ç¯ã§åæã®æéãšæéã倧å¹
ã«åæž
âBIããŒã«ãCRMãšããŒã¿é£æºããããé«åºŠãªçµ±ååæãå¯èœ
âPythonãBigQueryãšçµã¿åãããŠæ©æ¢°åŠç¿ã»äºæž¬åæã«ã掻çšã§ãã
Search ConsoleãšAnalyticsã®äœ¿ãåãã§ãããæ®æ®µããWEBçãã©ã䜿ã£ãŠãããæ¬¡ç¬¬ã§ãã
Google Analyticsã§ã¯ããŒãžã®çŽåž°çãæ»åšæéãGoogle以å€ã®æµå
¥ãªã©ãç§ã¯ç¢ºèªããŠããŸãã
ãData/Adminéãð§ãåå¿è ãè¿·ããªãGA4 APIéžã³ã®å€æåºæº
Google Analytics APIã«ã¯ããã€ãã®çš®é¡ããããŸãããç¹ã«GA4ã«å¯Ÿå¿ããAPIãšããŠéèŠãªã®ããData APIãšAdmin APIã®2ã€ã§ãã
ããããã®åœ¹å²ãæ£ããçè§£ããããšã§ãç®çã«åã£ã掻çšãå¯èœã«ãªããŸãã

ãData APIå ¥éðãGA4ã¬ããŒãååŸãèªååããåºæ¬èšèšã¬ã€ã
Data APIã¯ãGA4ã®ã¬ããŒãããŒã¿ãååŸããããã®APIã§ãã
ãŠãŒã¶ãŒæ°ãããŒãžãã¥ãŒãã€ãã³ãæ°ãªã©ã®ææšãããã°ã©ã ããèªç±ã«ååŸã»å å·¥ã§ããŸãã
PythonãBIããŒã«ãšé£æºããããšã§ãã«ã¹ã¿ã ã¬ããŒããèªååæã®åå°ãšããŠæŽ»èºããŸãã
GA4ã®ã€ãã³ãããŒã¹ã®ããŒã¿ã¢ãã«ã«æé©åãããŠããããã詳现ãªè¡ååæã«ã察å¿ããŠããŸãã
ãAdmin API掻çšð§ãGA4èšå®ãšæš©é管çãå¹çåããéçšããŠããŠ
Admin APIã¯ãGA4ã®èšå®æ å ±ã管çã»æäœããããã®APIã§ããããããã£ã®äœæããŠãŒã¶ãŒæš©éã®ç®¡çã飿ºèšå®ïŒGoogle AdsãBigQueryïŒãªã©ãèªåã§äžæ¬èšå®ããããšãã§ããŸãã
ãæåã®äžæ©ð±ãåå¿è ã¯Data APIããå§ããGA4èªååã«ãŒã
æåã«APIãè§ŠããªããData APIããå§ããã®ãçéã§ããã¬ããŒãã®èªååãããŒã¿ã®æœåºãªã©ãããŒãºã«çŽçµããäœæ¥ã«ããå¿çšã§ããŸãã
以äžã®è¡šã¯ãData APIãšAdmin APIã®äž»ãªéãããŸãšãããã®ã§ãð
| é ç® | Data API | Admin API |
|---|---|---|
| äž»ãªçšé | ã¬ããŒãããŒã¿ã®ååŸ | ã¢ã«ãŠã³ãã»ããããã£ã®èšå®ç®¡ç |
| 掻çšã·ãŒã³ | èªåã¬ããŒãäœæãããã·ã¥ããŒã飿º | ãŠãŒã¶ãŒæš©éã®ç®¡çãããããã£ã®äžæ¬èšå® |
| å©çšå¯Ÿè±¡ | GA4ã®ææšããã£ã¡ã³ã·ã§ã³ | GA4ã®æ§æèšå®é ç®å šè¬ |
| åå¿è ã«ããããã | â ã¯ã | â³ æ £ããŠããæšå¥š |
åºæ¬çã«Data APIã®æ¹ã䜿ãããæ©èœãæã£ãŠããŸãã
ãAPIéžæã®èŠç¹ðãåæãšèšå®ç®¡çã䜿ãåãã倿ãã€ã³ã
âData APIã¯åæã»èªåã¬ããŒãã®äžå¿çååš
âAdmin APIã¯æ§æç®¡çãèšå®ã®èªååã«æé©
âãŸãã¯Data APIã䜿ã£ãŠGA4ããŒã¿ã®ååŸã«æ
£ããã
ãGCPæºåâ ãGA4 APIçšãããžã§ã¯ãäœæãšèª²éèšå®ã®åºæ¬æé
Google Analytics APIãå©çšããã«ã¯ããŸãGoogle Cloud PlatformïŒGCPïŒã§ã®ç°å¢æ§ç¯ãå¿
èŠã§ãã
GCPã¯GoogleãæäŸããéçºè
åãã®ã¯ã©ãŠããµãŒãã¹ã§ãåçš®APIã®å©çšç®¡çãããã§è¡ããŸãã
æåã«è¡ãã®ã¯ããããžã§ã¯ããã®äœæã§ãã
ãã®ãããžã§ã¯ããAPIèšå®ãèªèšŒç®¡çã®ããŒã¹ãšãªããŸãã
APIã䜿ããã³ã«ãã®ãããžã§ã¯ãã«çŽã¥ãã圢ã«ãªããããååã¯çšéãæç¢ºã«äŒãããã®ã«ããŸããã
ïŒäŸïŒGA4 Reporting Projectãªã©ïŒã
ç¶ããŠã課éã¢ã«ãŠã³ãã®çŽä»ããæ±ããããŸãã
ç¡ææ ã®ç¯å²å
ã§ããAPIå©çšã«ã¯ãã®èšå®ãå¿
èŠã§ãã
ãã ããå®éã«æéãçºçããã®ã¯å©çšéãç¡ææ ãè¶
ããå Žåã®ã¿ãªã®ã§å®å¿ããŠå§ããããŸãã

GCPæºåã§æŒãããã¹ããã€ã³ãã¯ãã¡ãð
âGCPãããžã§ã¯ããäœæããAPIå©çšã®ããŒã¹ãæŽãã
â課éã¢ã«ãŠã³ãã®æå¹åã¯å¿
é ïŒç¡æãã©ã€ã¢ã«ã¯ã¬ãžãããããå ŽåãïŒ
âãããžã§ã¯ãåã¯åŸããèŠãŠãããããããã®ã«ïŒäŸïŒGA4 API DashboardïŒ
Google Search Consoleã®APIã䜿ã£ãŠããã°Google Cloud Platformã¯éèšæžã¿ïŒãããžã§ã¯ãäœææžã¿ã
éåžžã«äœ¿ã£ãŠããGoogleã¢ã«ãŠã³ãã飿ºããã°èª²éã¢ã«ãŠã³ãã®çŽã¥ããå®äºã§ãã
ãAPIæå¹åð§©ãGoogle Analytics Data APIç»é²ã®è¿·ããªãé²ãæ¹
Google Analytics APIãå©çšããã«ã¯ãGCPãããžã§ã¯ãäžã§å¯Ÿè±¡ã®APIãæç€ºçã«æå¹åããå¿
èŠããããŸãã
ãã®ã¹ããããçµããããšã§ãããã°ã©ã ããGA4ããŒã¿ã«ã¢ã¯ã»ã¹ããæºåãæŽããŸãã
ãŸãã¯ãGoogle Cloud Consoleã«ã¢ã¯ã»ã¹ãããAPIãšãµãŒãã¹ãâãã©ã€ãã©ãªããéããŸãããã
æ€çŽ¢ããã¯ã¹ã«ãGoogle Analytics Data APIããšå
¥åãã察象ã®APIãèŠã€ããŠãæå¹ã«ããããã¯ãªãã¯ããŸãã
ãã®ãData APIãããGA4ã®ã¬ããŒãããŒã¿ãååŸããããã®äž»èŠAPIã«ãªããŸãã
ããå°æ¥çã«ãGA4ããããã£ã®äœæããŠãŒã¶ãŒæš©éã®ç®¡çãªã©ãèªååãããå Žåã¯ããAdmin APIãã®æå¹åãããããŠè¡ã£ãŠãããšäŸ¿å©ã§ãã

ãData APIæå¹åâ ãã©ã€ãã©ãªæ€çŽ¢ããæå¹ç¢ºèªãŸã§ã®å®è·µæé
1ïžâ£ Google Cloud Consoleã®ãããžã§ã¯ãã§ãAPIãšãµãŒãã¹ããéžã³ãŸã

2ïžâ£ APIãšãµãŒãã¹ã®å·ŠåŽã®ã¡ãã¥ãŒã§ãã©ã€ãã©ãªããéžã³ãŸãã

3ïžâ£ æ€çŽ¢ãŠã£ã³ããŠã«ãgoogle analytics data apiããšå ¥åãããGoogle Analytics data APIããéžã³ãŸãã

4ïžâ£ Google Analytics Data APIã衚瀺ãããã®ã§ãæå¹ã«ããããéžã³ãŸãã

5ïžâ£ Google Analytics Data APIã®ç»é¢ã§ã¹ããŒã¿ã¹ããæå¹ãã«ãªã£ãŠããã°æåã§ãã

æŒãããŠãããããã€ã³ãã¯ä»¥äžã®éãã§ãð
âGoogle Analytics Data APIãã©ã€ãã©ãªããæ€çŽ¢ããŠæå¹å
âAdmin APIã¯èšå®ç®¡çãå¿
èŠãªãšãã«è¿œå ã§æå¹åãã
âAPIã®æå¹åã¯ãããžã§ã¯ãããšã«è¡ãå¿
èŠãããã®ã§å¿ããã«
ãèªèšŒæ¹åŒðãOAuth2.0ãšãµãŒãã¹ã¢ã«ãŠã³ãã®éãã®æŽçè¡
Google Analytics APIã«ã¢ã¯ã»ã¹ããã«ã¯ãæ£åœãªæš©éã蚌æããããã®ãèªèšŒèšå®ããå¿
èŠã§ãã
ããã§ã¯ãOAuth 2.0ãšãµãŒãã¹ã¢ã«ãŠã³ããšãã2ã€ã®äž»èŠãªèªèšŒæ¹åŒãããçšéã«åã£ãæ¹æ³ãéžã³ãŸãã

ãOAuth2.0éçšð§âð»ããŠãŒã¶ãŒåæã§GA4飿ºããä»çµã¿ãšçšé
OAuth 2.0ã¯ãã¢ããªã±ãŒã·ã§ã³ããŠãŒã¶ãŒã®ä»£çãšããŠGA4ããŒã¿ã«ã¢ã¯ã»ã¹ããããã®èªèšŒæ¹åŒã§ãã
ãŠãŒã¶ãŒã¯ãã°ã€ã³ããã¢ã¯ã»ã¹ãèš±å¯ããæç€ºçãªåææäœãå¿
èŠã§ãã
ãèªåèªèšŒâ±ïžã宿ååŸãšãããåŠçã«åŒ·ããµãŒãã¹ã¢ã«ãŠã³ãèšèš
ãµãŒãã¹ã¢ã«ãŠã³ãã¯ããŠãŒã¶ãŒã®æäœãªãã§ãµãŒããŒãèªåçã«ããŒã¿ååŸã§ããèªèšŒæ¹æ³ã§ãã
ããšãã°ã宿ãããåŠçã§ã¬ããŒããçæãããã±ãŒã¹ãã瀟å
ããŒã«ã§å®æçã«GA4ããŒã¿ãååŸãããå Žåã«äœ¿ããŸãã
äžåç»é²ããŠããŸãã°åŸã楜ãªã®ã§ãèªåã®ã¿å©çšã§ããã°ããµãŒãã¹ã¢ã«ãŠã³ãããªã¹ã¹ã¡ã§ãã
ãèªèšŒéžã³ð§ ãçšé/人æ°/éçšã§æé©æ¹åŒã決ããæ¯èŒãã€ã³ã
以äžã®è¡šã¯ã2ã€ã®èªèšŒæ¹åŒã®éããããããããæŽçãããã®ã§ãð
| æ¯èŒé ç® | OAuth 2.0 | ãµãŒãã¹ã¢ã«ãŠã³ã |
|---|---|---|
| äž»ãªçšé | ãŠãŒã¶ãŒã®åæãå¿ èŠãšããWebãµãŒãã¹ | èªç€Ÿå ã§ã®èªåååŠçããããåŠç |
| èªèšŒãã㌠| æ¯åãŠãŒã¶ãŒã«ãããã°ã€ã³ã»åæãå¿ èŠ | äºåèšå®ã ãã§èªåã§èªèšŒå¯èœ |
| æ³å®ã·ãŒã³ | è€æ°ãŠãŒã¶ãŒãå©çšããSaaSãããã·ã¥ããŒã | 瀟å ããŒã«ã宿ã¬ããŒãçæã¹ã¯ãªãããªã© |
| åæèšå®ã®æé | OAuthåæç»é¢ã®äœæããªãã€ã¬ã¯ãURIèšå®ãªã© | ãµãŒãã¹ã¢ã«ãŠã³ãäœæãæš©éä»äžã®ã¿ |
ãã±ãŒã¹å¥å€æðã瀟å èªååãšå€éšæäŸã§å€ããèªèšŒèšèš
â瀟å
ã§èªåçã«ããŒã¿ãååŸããã â ãµãŒãã¹ã¢ã«ãŠã³ã
âè€æ°ã®ãŠãŒã¶ãŒã䜿ãWebã¢ããªãéçºäž â OAuth 2.0
âéçºåæã§ãã¹ãçã«åãããã â ãµãŒãã¹ã¢ã«ãŠã³ããæè»œ
ãæ¥ç¶èšå®ðããµãŒãã¹ã¢ã«ãŠã³ãäœæãšGA4æš©éä»äžã®å šäœæé
ãµãŒãã¹ã¢ã«ãŠã³ãã䜿ãã°ããŠãŒã¶ãŒã®æãä»ããã«Google Analytics APIãžèªåçã«ã¢ã¯ã»ã¹ã§ããŸãã
ããã§ã¯ãGA4ããããã£ãšå®å
šã«é£æºãããããã®å
·äœçãªèšå®æé ã解説ããŸãã

ãGCPäœæð ïžããµãŒãã¹ã¢ã«ãŠã³ããšæå°æš©éããŒã«ã®èšå®èŠç¹
ãŸãã¯ãGoogle Cloud Platform (GCP) ã«ãã°ã€ã³ãã該åœã®ãããžã§ã¯ããéžæããŸãã
å·ŠåŽã®ã¡ãã¥ãŒãããIAMãšç®¡çãâããµãŒãã¹ã¢ã«ãŠã³ããã«é²ã¿ãããµãŒãã¹ã¢ã«ãŠã³ããäœæããã¯ãªãã¯ããŸãããã
ãµãŒãã¹ã¢ã«ãŠã³ãã®è¿œå æé ã¯ãäžèšã®ããŒãžð»
â
ãµãŒãã¹ã¢ã«ãŠã³ãã®è¿œå ã¹ããã
ãéµç®¡çã«ãŒã«ðãJSONããŒçæãšå®å šä¿ç®¡ã§æŒãããé²ãå®è·µç
ãµãŒãã¹ã¢ã«ãŠã³ãäœæåŸããããŒã管çãããæ°ããããŒã远å ããããŒã¿ã€ãã«ãJSONããéžã³ãŸãã
ãã®æäœã«ãããèªèšŒã«å¿
èŠãªç§å¯éµïŒJSONãã¡ã€ã«ïŒãããŠã³ããŒããããŸãã
ãã®ãã¡ã€ã«ã¯èªèšŒããŒã¯ã³ã®ãããªãã®ã§ãããäžãäžæŒæŽ©ãããšå€éšããäžæ£ã¢ã¯ã»ã¹ãããå±éºããããŸãã
ã¯ã©ãŠãã¹ãã¬ãŒãžã«ã¢ãããããããŒã«ã«ã®å®å
šãªå Žæã«ä¿ç®¡ããŸãããã
éµ(ããŒ)ã®è¿œå æé ã¯ãäžèšã®ããŒãžð»
â
éµ(ããŒ)ã®è¿œå ã¹ããã
ãGA4æš©éä»äžðãããããã£ã¢ã¯ã»ã¹ç®¡çã§é²èŠ§æš©éã远å ããæé
æåŸã«ãGoogle Analyticsã®ç®¡çç»é¢ã§ãã®ãµãŒãã¹ã¢ã«ãŠã³ãã«GA4ããããã£ã®é²èŠ§æš©éãä»äžããŸãã
GA4ã®ã管çãã¡ãã¥ãŒãããããããã£ã®ã¢ã¯ã»ã¹ç®¡çããéžã³ã
ã+ããã¿ã³ âããŠãŒã¶ãŒã远å ããã¯ãªãã¯ããŠããµãŒãã¹ã¢ã«ãŠã³ãã®ã¡ãŒã«ã¢ãã¬ã¹ãå
¥åããŸãã
ã¢ã¯ã»ã¹æš©éã¯ã衚瀺ãšåæïŒé²èЧè
ïŒããéžã¹ã°OKã§ãã
ããŠãŒã¶ãŒè¿œå â ãã¡ãŒã«ç»é²ãšåœ¹å²èšå®ã確èªããå ·äœæé
1ïžâ£ ã¢ããªãã£ã¯ã¹ã®å·Šã®ã¡ãã¥ãŒããã管çããéžã³ãŸãã

2ïžâ£ 管çã¡ãã¥ãŒãããããããã£ããéžãã åŸã§ããããããã£ã®ã¢ã¯ã»ã¹ç®¡çããéžã³ãŸãã

3ïžâ£ ããããã£ã®ã¢ã¯ã»ã¹ç®¡çã§å³äžã«è¡šç€ºããããïŒããéžã³ãŸãã

4ïžâ£ ãããã¢ããã¡ãã¥ãŒã衚瀺ãããã®ã§ããŠãŒã¶ãŒã远å ããéžã³ãŸãã

5ïžâ£ 圹å²ãšããŒã¿å¶éã®è¿œå ã§ãã¡ãŒã«ã¢ãã¬ã¹ã(IAMãµãŒãã¹ã¢ã«ãŠã³ã)ãå ¥åããã圹å²ããéžæãã远å ããã¿ã³ãæŒããŸãã

6ïžâ£ ããããã£ã®ã¢ã¯ã»ã¹ç®¡çäžèЧã«ãIAMãµãŒãã¹ã¢ã«ãŠã³ãã®ã¡ãŒã«ã¢ãã¬ã¹ãã远å ãããŠããã°æåã§ãã

ãèšå®æ³šæç¹â ïžãæå°æš©é/éµç®¡ç/ç£æ»ãã°ã§å®ãå®å šéçš
âGCPã§ãµãŒãã¹ã¢ã«ãŠã³ããäœæããæå°éã®æš©éãå²ãåœãŠã
âJSONããŒã¯éåžžã«éèŠã誀ã£ãŠå
¬éãªããžããªã«ã¢ããããªãããš
âGA4åŽã§ãµãŒãã¹ã¢ã«ãŠã³ãã«ã衚瀺ãšåæãæš©éãå¿
ãä»äžãã
ãPythonæ¥ç¶ðãå ¬åŒã©ã€ãã©ãªå°å ¥ããGA4å®è¡ãŸã§ã®æºåæé
Google Analytics Data APIãæŽ»çšããã«ã¯ãPythonç°å¢ã«å°çšã®ã¯ã©ã€ã¢ã³ãã©ã€ãã©ãªãå°å
¥ããã®ãæãå¹ççã§ãã
Googleå
¬åŒãæäŸããã©ã€ãã©ãªã䜿ãã°ãèªèšŒããªã¯ãšã¹ãåŠçãã·ã³ãã«ãã€å
ç¢ã«ãªããŸãã

ãã©ã€ãã©ãªå°å ¥ðœãpipã§GA4 Data APIãšpandasãæºåããæé
Pythonã§Google Analytics Data APIãæ±ãã«ã¯ããŸã次ã®ã³ãã³ãã§ã©ã€ãã©ãªãã€ã³ã¹ããŒã«ããŸãã
pip install google-analytics-data

Admin APIãå¿ èŠã§ããã°ã以äžã远å ã§ã€ã³ã¹ããŒã«ã§ããŸãã
pip install google-analytics-admin

ãèªèšŒæå®ð§©ãç°å¢å€æ°ã§JSONããŒãå®å šã«èªã¿èŸŒãèšå®æ¹æ³
èªèšŒã«ã¯ãã¹ãããâ£ã§ååŸããJSONããŒãç°å¢å€æ°ãšããŠèšå®ããŸãã
ããã«ãããã¹ã¯ãªããåŽã§èªèšŒãã¡ã€ã«ãããŒãã³ãŒãã£ã³ã°ããã«å®å
šã«æ±ãããšãå¯èœã«ãªããŸãã
ç§ã¯é¢åãªã®ã§ãPythonãã¡ã€ã«ãšjsonãã¡ã€ã«ãåããã©ã«ãã«çœ®ããŠãããã°ã©ã ã®äžã§JSONããŒãã¡ã€ã«åãæå®ããŠãŸãã
Linux/macOSã®ã¿ãŒããã«ã§ã¯ä»¥äžã®ããã«å ¥åããŸãã
export GOOGLE_APPLICATION_CREDENTIALS="/Users/user_name/your_service_account.json"

WindowsïŒPowerShellïŒã®å Žåã¯æ¬¡ã®ããã«ãªããŸãã
$env:GOOGLE_APPLICATION_CREDENTIALS="C:¥Users¥user_name¥your_service_account.json"
ãå ¬åŒã©ã€ãã©ãªð ãèªèšŒç°¡çŽ åãšãªãã©ã€å¯Ÿå¿ã§å®å®éçšããå©ç¹
Googleã®å ¬åŒã¯ã©ã€ã¢ã³ãã©ã€ãã©ãªã䜿ãããšã§ã以äžã®ãããªå©ç¹ããããŸãð
âHTTPãªã¯ãšã¹ãåŠçããšã©ãŒå¶åŸ¡ãèªååãããŠãã
âèªèšŒããã»ã¹ãç°¡åã§å®å
šã«å®è£
ã§ãã
âãªãã©ã€åŠçãªã©ãçµã¿èŸŒãŸããŠããå
ç¢ãªæ§é
âgRPCããŒã¹ã§é«éãªéä¿¡ãå¯èœïŒäžéšç°å¢ïŒ
ã飿ºã®ã³ãâšãåœå/äŸå€åŠç/ã¯ã©ãŒã¿é æ ®ã§å€±æãæžãã工倫
âgoogle-analytics-dataã©ã€ãã©ãªã¯æåã«ã€ã³ã¹ããŒã«ããŠãã
âJSONèªèšŒãã¡ã€ã«ã¯ç°å¢å€æ°ã§æå®ããã³ãŒãã«å«ããªã
âå
¬åŒã©ã€ãã©ãªã䜿ããšãAPI飿ºã®å®å®æ§ãã°ããšåäžãã
ãCSVåºåð§ªãGA4鱿¬¡éèšãèªåçæããPythonå®è£ ã¬ã€ã
Google Analytics Data APIïŒGA4ïŒ ã䜿ãã°ãããŒãžããšã®ãè¡šç€ºåæ°ããã¢ã¯ãã£ããŠãŒã¶ãŒããæ»åšæéããçŽåž°çãããé±åäœã§èªåçã«CSVåºåã§ããŸãð
ããŒã±ã¿ãŒãWebæ
åœè
ã«ãšã£ãŠã鱿¬¡ã§ã®ãã¬ã³ãææ¡ãã¬ããŒãäœæãäžæ°ã«å¹çåã§ãã匷åãªæŠåšã§ãã

ãCSVæ§é â ãåºåã«ã©ã ãšé±å¥æšªå±éã®å®æã€ã¡ãŒãžç¢ºèª
以äžã®ããã«ãåã¡ããªã¯ã¹ãé±å¥ã«æšªå±éããã圢ã§åºåãããŸãã
| ããŒãž | 01_è¡šç€ºåæ° | 02_è¡šç€ºåæ° | ⊠| 24_è¡šç€ºåæ° | 01_ã¢ã¯ãã£ããŠãŒã¶ãŒ | ⊠| 24_çŽåž°ç |
|---|---|---|---|---|---|---|---|
| /top | 1240 | 1190 | ⊠| 1103 | 840 | ⊠| 35.6 |
| /contact | 230 | 212 | ⊠| 198 | 160 | ⊠| 68.4 |
| /blog/article1 | 310 | 295 | ⊠| 280 | 220 | ⊠| 42.1 |
ð ææšã¯ä»¥äžã®4çš®é¡ã§ã
âé±çªå·_è¡šç€ºåæ°
âé±çªå·_ã¢ã¯ãã£ããŠãŒã¶ãŒ
âé±çªå·_æ»åšæéïŒç§ïŒ
âé±çªå·_çŽåž°çïŒ%ïŒ
pandasãæªå°å ¥ã®äººã¯ãã¿ãŒããã«ã¢ããªã§äžèšã®ã³ãã³ãã«ããäºåã«pandasãå°å ¥ããŠãããŸãããã
pip install google-analytics-data pandasãPythonã³ãŒãð§ŸãGA4 Data APIã§é±æ¬¡CSVãèªååºåããå®è£ äŸ
éµjsonãã¡ã€ã«ãYOUR-GA4-PROPERTY-IDã¯ãèªåã®ç°å¢ã«å¿ããå€ãèšèŒããå¿
èŠããããŸãã
éµjsonãã¡ã€ã«ã¯Pythonãã¡ã€ã«ãšåããã©ã«ãã«çœ®ããŠããjsonãã¡ã€ã«åãèšèŒããã ãã§OKãªã®ã§æ¥œã§ãã
from google.analytics.data_v1beta import BetaAnalyticsDataClient
from google.analytics.data_v1beta.types import RunReportRequest, DateRange, Dimension, Metric
import pandas as pd
import datetime
import os
# â
èšå®é
ç®
WEEK_COUNT = 23 # â çŽè¿äœé±åãååŸããã
PROPERTY_ID = "YOUR-GA4-PROPERTY-ID"
os.environ["GOOGLE_APPLICATION_CREDENTIALS"] = "your_service_account.json"
# æ¥ä»èšç®
end_date = datetime.date.today()
start_date = end_date - datetime.timedelta(days=WEEK_COUNT * 7)
# ã¯ã©ã€ã¢ã³ãåæå
client = BetaAnalyticsDataClient()
# ãªã¯ãšã¹ãå®çŸ©
request = RunReportRequest(
property=f"properties/{PROPERTY_ID}",
dimensions=[
Dimension(name="pagePath"),
Dimension(name="week")
],
metrics=[
Metric(name="screenPageViews"),
Metric(name="activeUsers"),
Metric(name="userEngagementDuration"),
Metric(name="sessions"),
Metric(name="engagedSessions")
],
date_ranges=[DateRange(start_date=str(start_date), end_date=str(end_date))]
)
# ã¬ããŒãååŸ
response = client.run_report(request)
# ã¬ã³ãŒãæ§ç¯
records = []
for row in response.rows:
page = row.dimension_values[0].value
week_label = row.dimension_values[1].value
views = int(row.metric_values[0].value)
users = int(row.metric_values[1].value)
duration = float(row.metric_values[2].value)
sessions = int(row.metric_values[3].value)
engaged = int(row.metric_values[4].value)
avg_time = duration / sessions if sessions else 0
bounce_rate = (1 - engaged / sessions) * 100 if sessions else 0
records.append({
"ããŒãž": page,
"é±": week_label,
"è¡šç€ºåæ°": views,
"ã¢ã¯ãã£ããŠãŒã¶ãŒ": users,
"å¹³åæ»åšæéïŒç§ïŒ": round(avg_time, 2),
"çŽåž°çïŒ%ïŒ": round(bounce_rate, 2)
})
# DataFrameãžå€æ
df = pd.DataFrame(records)
# ããããããŠé±ãåã«å€æïŒæšªæã¡ïŒ
df_views = df.pivot(index="ããŒãž", columns="é±", values="è¡šç€ºåæ°").add_suffix("_è¡šç€ºåæ°")
df_users = df.pivot(index="ããŒãž", columns="é±", values="ã¢ã¯ãã£ããŠãŒã¶ãŒ").add_suffix("_ã¢ã¯ãã£ããŠãŒã¶ãŒ")
df_time = df.pivot(index="ããŒãž", columns="é±", values="å¹³åæ»åšæéïŒç§ïŒ").add_suffix("_æ»åšæé")
df_bounce = df.pivot(index="ããŒãž", columns="é±", values="çŽåž°çïŒ%ïŒ").add_suffix("_çŽåž°ç")
# çµåããŠæçµããŒã¿ãã¬ãŒã
df_final = pd.concat([df_views, df_users, df_time, df_bounce], axis=1).reset_index()
# CSVã«ä¿å
df_final.to_csv("ga4_weekly_metrics.csv", index=False, encoding="utf-8-sig")
print("â
ga4_weekly_metrics.csv ãåºåããŸããã")
ã管çãâãããããã£ãâãããããã£ã®è©³çްããéžã³ãå³äžã®ãããããã£IDãã確èªãã

ãåºå確èªð§ ãååœå/é±çªå·/ææšã®èŠæ¹ãæŽçãã確èªãã€ã³ã
âååã¯ãé±çªå·_ææšåãã®åœ¢åŒïŒäŸïŒé±202418_æ»åšæéïŒ
âããŒãžããšã®æšªæã¡ããŒã¿ã§ãé±ããšã®æšç§»ãã²ãšç®ã§ããã
âé±çªå·ã¯GA4ã®weekãã£ã¡ã³ã·ã§ã³ã§ååŸïŒäŸïŒ202418ïŒ2024幎 第18é±ïŒ
âãæ»åšæéãã¯userEngagementDuration ÷ sessionsã§èšç®
âãçŽåž°çãã¯1 – engagedSessions ÷ sessionsã§ç®åº
ãã¬ã¹ãã³ã¹çè§£ðŠããã£ã¡ã³ã·ã§ã³ãšã¡ããªã¯ã¹æ§é ã®åºæ¬æŽç
APIããè¿ã£ãŠããã¬ã¹ãã³ã¹ã«ã¯ãæå®ãããã£ã¡ã³ã·ã§ã³ãšã¡ããªã¯ã¹ã®å€ãè¡ããšã«æ ŒçŽãããŠããŸãã
ä»åã®äŸã§ã¯ãresponse.rows ã«åæ¥ä»ãšãã®æ¥ã®ãŠãŒã¶ãŒæ°ã1è¡ãã€æ ŒçŽãããŠããã€ã¡ãŒãžã§ãã
ãå®è¡å確èªðãããããã£ID/éµ/äŸåé¢ä¿ãåç¹æ€ãããã§ãã¯é ç®
âproperty_idã«æ£ããGA4ããããã£IDãèšå®ããŠããã
âç°å¢å€æ°ïŒGOOGLE_APPLICATION_CREDENTIALSïŒãæ£ããèšå®ãããŠããã
âã©ã€ãã©ãªã®ã€ã³ããŒããšã€ã³ã¹ããŒã«ãå®äºããŠããã
ãåå®è¡äœéšâšãGA4ããŒã¿ååŸã«æåããç¬éã確èªããæé
âã³ãŒãããGA4ããŒã¿ãååŸã§ããç¬éãäœéšã§ãã
âæåã§ã®ããŒã¿æœåºããè§£æŸãããå¯èœæ§ã宿ã§ãã
âä»åŸã®ã¬ããŒãèªååã»å¯èŠåã«ã€ãªãã倧ããªç¬¬äžæ©
ãææšäžèЧðãåå¿è ãè¿·ããªããã£ã¡ã³ã·ã§ã³/ææšã®æ©èŠè¡š
Google Analytics Data APIã§ããŒã¿ãååŸããã«ã¯ããã£ã¡ã³ã·ã§ã³ïŒåãå£ïŒãšã¡ããªã¯ã¹ïŒæ°å€ææšïŒãé©åã«çµã¿åãããŠæå®ããå¿
èŠããããŸãã
ããã¯GA4ã®ç®¡çç»é¢ã§ã¬ããŒããäœæããéãšåãèãæ¹ã§ãã

ãå®çªäžèЧðïžããã䜿ããã£ã¡ã³ã·ã§ã³ãšææšãäžæ¬æŽç
| çš®é¡ | APIå | UIäžã®åç§°ïŒæ¥æ¬èªïŒ | 説æå 容 |
|---|---|---|---|
| ãã£ã¡ã³ã·ã§ã³ | date | æ¥ä» | ã€ãã³ãçºçã®æ¥ä»ïŒYYYYMMDD圢åŒïŒ |
| ãã£ã¡ã³ã·ã§ã³ | eventName | ã€ãã³ãå | ãŠãŒã¶ãŒãå®è¡ããã€ãã³ãã®åç§° |
| ãã£ã¡ã³ã·ã§ã³ | pagePath | ããŒãžãã¹ | 衚瀺ãããããŒãžã®ãã¹ïŒäŸïŒ/products/aïŒ |
| ãã£ã¡ã³ã·ã§ã³ | city | åžåºçºæ | ãŠãŒã¶ãŒã®ã¢ã¯ã»ã¹å ã®åžåºçºæ |
| ãã£ã¡ã³ã·ã§ã³ | sourceMedium | åç §å / ã¡ãã£ã¢ | ãã©ãã£ãã¯ã®æµå ¥å ãšåªäœã®çµã¿åãã |
| ãã£ã¡ã³ã·ã§ã³ | defaultChannelGroup | ããã©ã«ããã£ãã«ã°ã«ãŒã | èªååé¡ãããæµå ¥ãã£ãã«ã®ã«ããŽãª |
| ã¡ããªã¯ã¹ | activeUsers | ã¢ã¯ãã£ããŠãŒã¶ãŒæ° | ç¹å®æéäžã«èšªåããäžæã®ãŠãŒã¶ãŒæ° |
| ã¡ããªã¯ã¹ | screenPageViews | è¡šç€ºåæ°ïŒããŒãžãã¥ãŒïŒ | 衚瀺ãããããŒãžãŸãã¯ã¹ã¯ãªãŒã³ã®ç·æ° |
| ã¡ããªã¯ã¹ | sessions | ã»ãã·ã§ã³æ° | ãŠãŒã¶ãŒã®èšªååæ° |
| ã¡ããªã¯ã¹ | eventCount | ã€ãã³ãæ° | å®è¡ãããã€ãã³ãã®ç·åæ° |
| ã¡ããªã¯ã¹ | conversions | ã³ã³ããŒãžã§ã³æ° | èšæž¬ãããã³ã³ããŒãžã§ã³ã€ãã³ãã®åæ° |
ãç®çå¥ã»ããð¯ãæµå ¥/è¡å/ææãåæããå®çªçµã¿åãã
ãèšªåæ°ãæ¥å¥ã«ææ¡ãããã
â ãã£ã¡ã³ã·ã§ã³ïŒdate à ã¡ããªã¯ã¹ïŒactiveUsers, sessions
ãã©ã®ããŒãžãäžçªèŠãããŠããããåæãããã
â ãã£ã¡ã³ã·ã§ã³ïŒpagePath à ã¡ããªã¯ã¹ïŒscreenPageViews, activeUsers
ãã©ã®ã€ãã³ããå€ãçºçããŠããããç¥ãããã
â ãã£ã¡ã³ã·ã§ã³ïŒeventName à ã¡ããªã¯ã¹ïŒeventCount, conversions
ããŠãŒã¶ãŒã®æµå
¥çµè·¯ãåæãããã
â ãã£ã¡ã³ã·ã§ã³ïŒsourceMedium, defaultChannelGroup à ã¡ããªã¯ã¹ïŒactiveUsers, sessions
ãèšèšã®ã³ãð§©ãçžæ§ãã§ãã¯ãšå°æ°æå®ã§APIãšã©ãŒãé²ãæ¹æ³
âUIã§èŠæ
£ããææšãAPIäžã®åç§°ã«çœ®ãæããŠäœ¿ããšè¿·ããªã
â1ã€ã®ã¯ãšãªã«å«ãããã£ã¡ã³ã·ã§ã³ã»ã¡ããªã¯ã¹ã¯å°æ°ããå§ããŠèª¿æŽ
âçžæ§ã®æªãçµã¿åããã ãšãšã©ãŒã«ãªãããšãããããæ³šæ
ãã¯ã©ãŒã¿å¯Ÿçâ ïžãGA4 APIãå®å®ååŸããããã®åºæ¬æé
Google Analytics Data APIãå®å®çã«éçšããããã«ã¯ãå©çšå¶éïŒã¯ã©ãŒã¿ïŒãšãšã©ãŒãã³ããªã³ã°ã®ä»çµã¿ããã£ããçè§£ããŠããããšãéèŠã§ãã
APIã¯äŸ¿å©ãªåé¢ãç¡å¶éã«ã¢ã¯ã»ã¹ã§ããããã§ã¯ãªããé©åãªå¶åŸ¡ãšé
æ
®ãæ±ããããŸãã

ãã¯ã©ãŒã¿åºç€ðãæ¥æ¬¡/æé/åæå®è¡ã®äžéãæ£ããææ¡ããèŠç¹
ã¯ã©ãŒã¿ïŒQuotaïŒãšã¯ãAPIã«å¯ŸããŠ1æ¥ã1æéãããã«éä¿¡ã§ãããªã¯ãšã¹ãæ°ãåŠçéã®å¶éã®ããšã§ãã
ãªã¯ãšã¹ãå
容ã®è€éããååŸä»¶æ°ã«ãã£ãŠãããŒã¯ã³ããšããåäœã§æ¶è²»éãæ±ºãŸãä»çµã¿ã«ãªã£ãŠããŸãã
äž»ãªå¶éé ç®ã«ã¯ä»¥äžã®ãããªãã®ããããŸãã
| ã¯ã©ãŒã¿é ç® | 説æ |
|---|---|
| ããããã£ããšã®1æ¥ãããã®ããŒã¯ã³æ° | åäžGA4ããããã£ãžã®ãªã¯ãšã¹ãç·éå¶é |
| ããããã£ããšã®1æéãããã®ããŒã¯ã³æ° | çæéã§ã®é£ç¶ã¢ã¯ã»ã¹å¶é |
| åæãªã¯ãšã¹ãæ°ã®äžé | è€æ°ãªã¯ãšã¹ãã®äžŠååŠçå¶é |
| ãããžã§ã¯ãããšã®å šäœå¶é | åäžGCPãããžã§ã¯ãããã®éäžçãªã¢ã¯ã»ã¹å¶é |
éåžžã®çšéã§ã¯äžéã«éããããšã¯å°ãªãã§ãããé »ç¹ãªèªåååŸã倧éããŒã¿ã®ååŸã§ã¯æ³šæãå¿ èŠã§ãã
ããšã©ãŒå¯Ÿçð¡ïžã400/401/403/500/503ã®åå ãšå¯ŸåŠæ³
APIã®äœ¿çšäžã«ééãããã代衚çãªãšã©ãŒã³ãŒããšå¯Ÿçã以äžã«ãŸãšããŸãð
| ãšã©ãŒã³ãŒã | æå³ | å¯ŸåŠæ³ |
|---|---|---|
| 400 | ãªã¯ãšã¹ãã®æ§æãšã©ãŒ | ãã©ã¡ãŒã¿ãæ§é ãå確èªïŒç¶Žããåãªã©ïŒ |
| 401 | èªèšŒå€±æ | ãµãŒãã¹ã¢ã«ãŠã³ããããŒã¯ã³èšå®ãåç¢ºèª |
| 403 | æš©éäžè¶³ ãŸã㯠ã¯ã©ãŒã¿è¶ é | GA4åŽã®æš©éä»äžã»ããŒã¯ã³å¶éã®ç¶æ³ãç¢ºèª |
| 500 | ãµãŒããŒå éšãšã©ãŒ | äžæçãªåé¡ãæéã眮ããŠãªãã©ã€ãã |
| 503 | ãµãŒãã¹å©çšäžå¯ïŒéè² è·ãªã©ïŒ | ãªãã©ã€ééã空ããããšã¯ã¹ããã³ã·ã£ã«ããã¯ãªããå®è£ ãã |
ããªãã©ã€æŠç¥ðãææ°ããã¯ãªããšäžéèšå®ã§å®å®ååŸããæ¹æ³
ãšã©ãŒãåºããšãã«éèŠãªã®ããé©åãªãªãã©ã€åŠçã§ãã
ãã®ä»£è¡šçãªææ³ãããšã¯ã¹ããã³ã·ã£ã«ããã¯ãªãïŒææ°çé
å»¶å詊è¡ïŒãã§ãã
ããã¯ããªãã©ã€ééãåŸã ã«é·ãããŠå詊è¡ãè¡ãä»çµã¿ã§ããµãŒããŒãžã®éè² è·ãé²ãã€ã€ãæåçãé«ããŸãã
âååã¯æ°ç§ééã§ãªãã©ã€ãã倱æãç¶ãå Žåã¯10ç§â30ç§âŠãšäŒžã°ããŠãã
âæå€§ãªãã©ã€åæ°ãåŸ
æ©æéã®äžéãæ±ºããŠãããšå®å
š
ãå®å®éçšðãæš©éæå°å/ç£èŠ/ãã°ã§éå®³ãæªç¶ã«é²ã管çè¡
â1æ¥ã»1æéãããã®ããŒã¯ã³å¶éãè¶
ããªãããæèãã
â403ã503ãªã©ã®ãšã©ãŒã¯é©åã«ãªãã©ã€åŠçãå®è£
ãã
âã¯ã©ãŒã¿ç¶æ³ãææ¡ããŠããããšã§ãäºæãã¬åæ¢ãé²ãã
ãå¿çšåŠç¿ðãGA4 API掻çšã䌞ã°ãå®è·µãªãœãŒã¹ãŸãšã
Google Analytics APIã䜿ãå§ããã°ããã®æ¹ã§ããåºæ¬ãæŒãããåŸã¯ããã«äŸ¿å©ãªäœ¿ãæ¹ãæ·±ãåŠç¿ãªãœãŒã¹ã«ç®ãåããããšã§ã掻çšã®å¹ ãäžæ°ã«åºããããšãã§ããŸãã

ãã®ã»ã¯ã·ã§ã³ã§ã¯ãå®åã«åœ¹ç«ã€å¿çšãã¯ããã¯ãããããã®åŠç¿çŽ æã玹ä»ããŸãã
ã©ããçŸå Žã§ã®åæã»èªååã«çŽçµããããŠããŠã°ããã§ãã
ãBigQuery飿ºðãGA4ããŒã¿å¯èŠåãšåæéçšãå éããæ¹æ³
Google BigQueryãšé£æºããã°ãGA4ã®çããŒã¿ãSQLã§çŽæ¥åæã§ããŸãã
Data APIã§ã¯ååŸã§ããªãè¡ã¬ãã«ã®è©³çްããŒã¿ã倧éããŒã¿ã®åŠçãå¯èœã«ãªããããå€§èŠæš¡åæãæ©æ¢°åŠç¿ã«ãé©ããŠããŸãã
ãŸããLooker StudioïŒæ§Data PortalïŒãTableauãªã©ã®BIããŒã«ãšçµã¿åãããããšã§ãããã·ã¥ããŒãåãKPIã®å¯èŠåãå¯èœã«ã
APIçµç±ã§ååŸããããŒã¿ããªã¢ã«ã¿ã€ã æŽæ°ãããã°ãæææ±ºå®ã®ã¹ããŒããæ Œæ®µã«äžãããŸãã
ãGitHub掻çšð¡ãå ¬åŒãµã³ãã«ã§GA4 APIå®è£ ãæçç¿åŸããéç
Googleã¯GitHubäžã«å
¬åŒã®ãµã³ãã«ã³ãŒãéã倿°å
¬éããŠããŸãã
äžã«ã¯ãPythonãNode.jsãªã©è€æ°èšèªã®äŸãæã£ãŠãããåå¿è
ã§ããã®ãŸãŸåãããŠä»çµã¿ãçè§£ã§ããããã«ãªã£ãŠããŸãã
âãã䜿ãããã¯ãšãªãã¿ãŒã³ã®ãã³ãã¬ãŒãã倿°
âBigQueryãFirebaseãªã©ãšã®çµ±åäŸãå
å®
âã©ã€ãã©ãªã®ããŒãžã§ã³ã¢ããã«ãå³å¯Ÿå¿ããŠãã
ãããã¥ã¡ã³ã掻çšð£ïžãçåè§£æ¶ãšææ°æ å ±ãå¹çãã远ãåŠç¿è¡
Googleã®å
¬åŒããã¥ã¡ã³ãã¯ãData APIãAdmin APIã®ãªãã¡ã¬ã³ã¹ã ãã§ãªããå°å
¥ã¬ã€ãããã¹ããã©ã¯ãã£ã¹ãå
å®ããŠããŸãã
äžéãç®ãéããŠããããšã§ããã©ãã«æã«ãå®å¿ããŠå¯ŸåŠã§ããããã«ãªããŸãã
ããã«ãStack OverflowãGoogle Analyticså ¬åŒãã©ãŒã©ã ã«ã¯ãåãæ©ã¿ãæã€ãŠãŒã¶ãŒã®è³ªåã»è§£æ±ºäŸã倿°æ²èŒãããŠããŸãã
âå°ã£ããšãã¯æ€çŽ¢ããã°å€§äœè§£æ±ºã§ãã
âæ°æ©èœãAPI倿Žã®æ
å ±ããã¡æ©ããã£ããå¯èœ
âæçš¿ããããšã§èªåã®çè§£ãæ·±ãŸã
ãäžéã®ã³ãðãå°ããå®è£ ãæ¯ãè¿ãèªååã§ç¿çããé²ãæ¹
âBigQueryãLooker Studioãšã®é£æºã§å®åã«æŽ»ããåã䌞ã°ã
âGitHubã®ã³ãŒãããåŠã³ãå®äŸãèªåã®çšéã«èœãšã蟌ã
âå
¬åŒããã¥ã¡ã³ããšãŠãŒã¶ãŒã³ãã¥ããã£ã§ææ°æ
å ±ãåžžã«è£åŒ·ãã
ãæ¬¡ã®ã¹ããŒãžðãGA4 APIã§èªååãšå¯èŠåãæ¬æ Œå éããæ¹æ³
Google Analytics APIã䜿ãã°ãGA4ã®ããŒã¿ãããèªç±ãã€å¹ççã«æŽ»çšã§ããŸãã
æäœæ¥ã§ã¯é£ããã£ãéèšãå¯èŠåããAPIçµç±ã®èªååãå€éšããŒã«é£æºã«ããäžæ°ã«ã¹ããŒãåã§ããŸãã
æè¡çãªèšå®ã¯ããè€éã§ãããäžåºŠä»çµã¿ãæ§ç¯ããã°å§åçãªæéççž®ãšç²ŸåºŠã®é«ãåæãå®çŸã§ããŸãã
âæåã®äžæ©ã¯ãGoogle Analytics Data APIãÃãPythonãããããããã
âèªç€Ÿã®ç®çã«åãããããŒã¿æœåºãšèªåã¬ããŒããå¯èœã«
âBigQueryãBIããŒã«ãšé£æºããã°ãçµå¶å€æã«çŽçµããåæãã§ãã
âæšæºã¬ããŒãã«ãšãããããèªç±ãªåæç°å¢ãæ§ç¯ã§ãã
âAPIã®äœ¿ãããªãããããGA4ãæå€§é掻çšããè¿éïŒ

ããŸãšãðãGoogle Analytics APIã§GA4åæãèªååããèŠç¹
Google Analytics APIã䜿ãã°ãGA4ã®ããŒã¿ãèªç±ã«ååŸããåæãã¬ããŒãäœæãèªååã§ããŸãã
ç»é¢æäœã«é Œããªãããšã§ãPythonãBIããŒã«ãšé£æºããæ¬æ ŒçãªããŒã¿æŽ»çšãå¯èœã«ãªããŸãã

ãæ¬èšäºã®æ¯ãè¿ãðãGA4 APIå°å ¥ã®å šäœåãå確èªããæŽç
ãã®èšäºã§ã¯ãGoogle Analytics APIã®åºæ¬ããå®åã§äœ¿ããã¬ãã«ãŸã§ã段éçã«è§£èª¬ããŸããã
åå¿è
ã§ãè¿·ããé²ãããããããç°å¢æ§ç¯ããå®è£
ãŸã§ãæŽçããŠããŸãã
â GA4 Data APIãšAdmin APIã®éããšäœ¿ãåã
â GCPã§ã®ãããžã§ã¯ãäœæãšAPIæå¹åã®æµã
â ãµãŒãã¹ã¢ã«ãŠã³ãã䜿ã£ãå®å
šã§å¹ççãªèªèšŒæ¹æ³
â Pythonã§ã®GA4ããŒã¿ååŸãšCSVèªååºåã®å®è£
äŸ
ãData API䟡å€ðãæšæºã¬ããŒããè¶ ããèªç±ãªåæäœéš
GA4 Data APIã䜿ãæå€§ã®ã¡ãªããã¯ãåæã®èªç±åºŠã倧ããåºããç¹ã§ãã
鱿¬¡ãããŒãžå¥ãªã©ãç®çã«åãããæè»ãªããŒã¿æœåºãå¯èœã«ãªããŸãã
â æäœæ¥ã§ã¯é£ããåãå£ã§ã®GA4åæãã§ãã
â 宿ã¬ããŒããèªååããäœæ¥æéã倧å¹
ã«åæž
â æ°å€ã®å€åã«æ©ãæ°ã¥ããæ¹åã¹ããŒããé«ãããã
ãåå¿è ã®æ§æð±ãData APIãšãµãŒãã¹ã¢ã«ãŠã³ãã§å§ããå®è·µå
å人éçšã瀟å
åæã§ããã°ããµãŒãã¹ã¢ã«ãŠã³ãã䜿ã£ãData API飿ºãæãã·ã³ãã«ã§ãã
äžåºŠèšå®ããã°ãæ¯åã®èªèšŒæäœãªãã§å®å®ããããŒã¿ååŸãã§ããŸãã
â å人å©çšã宿ãããåŠçã«ã¯ãµãŒãã¹ã¢ã«ãŠã³ããæé©
â å€éšãŠãŒã¶ãŒåããµãŒãã¹ã§ã¯OAuth2.0ãæ€èš
â æåã¯å°ããªèªååããå§ããã®ãæåã®è¿é
ãèŠç¹æŽçðïžãGA4 APIå°å ¥ãããŒãšæŽ»çšå¹æã®å šäœå
| é ç® | å 容 |
|---|---|
| APIã®çš®é¡ | Data APIã§ã¬ããŒãããŒã¿ååŸ |
| èªèšŒæ¹åŒ | ãµãŒãã¹ã¢ã«ãŠã³ãã§èªåå |
| éçºç°å¢ | GCPãšPython |
| åºååœ¢åŒ | CSVã§é±æ¬¡ã¬ããŒãçæ |
| 掻çšå¹æ | åæç²ŸåºŠåäžãšäœæ¥æéåæž |
ãæ¬¡ã®ã¢ã¯ã·ã§ã³ð¥ãGA4 APIãå®åã§æŽ»ããæ¹åã¹ããã
ãã®èšäºã®æé ããã®ãŸãŸå®è¡ããã°ãGA4 APIã¯ç¢ºå®ã«äœ¿ããããã«ãªããŸãã
ããšã¯å®ããŒã¿ã§è©Šããªãããèªåã®æ¥åã«åãããŠã«ã¹ã¿ãã€ãºããŠããã ãã§ãã
â GA4 APIã§ããŒã¿ååŸãèªååãã
â Pythonã§åæãšå å·¥ãå¹çåãã
â BIããŒã«ãBigQuery飿ºã§å¯èŠåãé²ãã
ãã£ã¡ãèªãã§æ¬²ãããGoogle Seach Console APIãã®å©çšæé ïŒ




ã³ã¡ã³ã