GA4 Magic Reports は、GA4のデータを Google スプレッドシートで表示できるアドオン



  • 無料
  • フィルターに正規表現が使える
  • フィルターをAND、ORが使える

GA4 Magic Reports の概要

GA4 Magic Reports は、Google アナリティクス 4 データを Google スプレッドシートでより簡単に表示および編集できるようにする Google スプレッドシート アドオンです。

GA4 Magic Reportsアドオンを使用するには、まずそれをスプレッドシートに追加する必要があります。
Google Workspace Marketplace のアドオンに直接アクセスして、アドオンをインストールできます: 

GA4 Magic Reports - Google Workspace Marketplace
Access all of your Google Analytics™ 4 data in Google Spreadsheets™.

アドオンは、「拡張機能」メニューの下のすべての Google スプレッドシートで利用できます。


GA4 Magic Reports をスケジュール通りに動かす

Schedule reports を設定することで、定期的にレポートを作成することができます。


GA4 Magic Reportsはとても素晴らしいツールで、私たち、ウェブ解析の仕事を行う者は、開発者のあなたに、とても感謝しております。
Schedule reports

GA4 Reports Configurationに複数の設定を行い、
Schedule reports




GA4 Reports Configuration に設定が1カラムから20カラムまでのスプレッドシートを作成。3つの時間帯に分けて3回のテストを行いました。


2023-04-30 1:00am – 2:00am のスケジュール

  • フォルダ名:GA4 Magic Reports – test- 001
    -> GA4 Reports Configuration に設定が19カラムあるスプレッドシート
    GA4 Magic Reports – test001 – Configurations_Set_19

2023-04-30 9:00am – 10:00am のスケジュール

  • フォルダ名:GA4 Magic Reports – test- 002
    -> 更新に成功したスプレッドシート無し

2023-04-30 10:00am – 11:00am のスケジュール

  • フォルダ名:GA4 Magic Reports – test- 003
    -> GA4 Reports Configuration に設定が20カラムあるスプレッドシート
    GA4 Magic Reports – test003- Configurations_Set_20



Subject: Question about GA4 Magic Reports Schedule Reports Feature

Dear GA4 Magic Reports Developer,

I hope this message finds you well. First and foremost, I would like to express my sincerest gratitude for providing the GA4 Magic Reports add-on for free. It is a fantastic tool that greatly assists those of us in the web analytics field, and we truly appreciate your efforts in developing it.

Please accept my apologies for reaching out to you amidst your busy schedule, but I have a question about the Schedule Reports feature. Specifically, it pertains to the automatic report updating function in Schedule Reports after configuring multiple settings in GA4 Reports Configuration.

I performed several tests, but unfortunately, only a few of them succeeded in updating the reports according to the schedule, with most of them failing. If you could shed some light on the cause of these update failures and provide any advice, I would be truly grateful.

Here is an overview of the tests I conducted:

I created spreadsheets with 1 to 20 columns of settings in GA4 Reports Configuration and conducted three tests across different time slots.

(The sheets used for the tests can be found at the URL below.)

Schedule for 2023-04-30 1:00am – 2:00am
Folder name: GA4 Magic Reports – test- 001
-> Only the spreadsheet with 19 columns of settings in GA4 Reports Configuration, titled “GA4 Magic Reports – test001 – Configurations_Set_19,” succeeded in updating.

Schedule for 2023-04-30 9:00am – 10:00am
Folder name: GA4 Magic Reports – test- 002
-> No spreadsheets succeeded in updating.

Schedule for 2023-04-30 10:00am – 11:00am
Folder name: GA4 Magic Reports – test- 003
-> Only the spreadsheet with 20 columns of settings in GA4 Reports Configuration, titled “GA4 Magic Reports – test003- Configurations_Set_20,” succeeded in updating.

These were the results of my tests. I apologize for any inconvenience this may cause you during your busy schedule, and I appreciate your assistance in this matter.

Thank you and best regards.


Sono un fan giapponese del GA4 Magic Reports che hai sviluppato.
Grazie per il fantastico add-on.
Permettimi di farti una domanda.

Configurazione dei report GA4

Vorrei impostare i report su GA4 Reports Configuration e aggiornarli automaticamente secondo una programmazione, ma
c’è un limite al numero di report che posso impostare?

Inoltre, questo limite dipende anche dalla complessità dei filtri, dal numero di metriche e dimensioni?

Grazie in anticipo.

私はあなたが開発した GA4 Magic Reports の日本のファンです。

GA4 Reports Configuration