Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340

Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/laplaceman/laplace-ec-man.com/public_html/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340
Googleアナリティクスでブログの全ページのアクセス数(ページビュー数)を一括確認から、エクセル、CSVに出力する方法をご紹介します! | OMameLoG

Googleアナリティクスでブログの全ページのアクセス数(ページビュー数)を一括確認から、エクセル、CSVに出力する方法をご紹介します!

Googleアナリティクスでブログの全ページのアクセス数(ページビュー数)を一括確認から、エクセル、CSVに出力する方法をご紹介します!

はじめに

こんにちは!

ブログを書く頻度を増やしてから、ブログを書かないとソワソワするようになりました!

omame-img
OMame

継続は力なりですね!一緒に頑張っていただける方、応援していただける方、ぜひともTwitterのフォローをお願いします!

本日に関しては

Googleアナリティクスを用いたアクセス数の確認方法
に関してになります!

ブログのアクセス数を確認している時に

一括で全てのページURLのアクセスを月別で確認したい
全てのページビューを一括でだしたい
全ページのアクセス推移を見たい

と思うことはないでしょうか?

今回はそういった疑問を解消できるようにGoogaleアナリティクスを用いた
分析方法をご紹介できればと思います!

こんな方向け

・全てのページのアクセス数を一括でみたい
・全てのページのページビューをエクセル、CSVで出力したい
・全てのページのアクセス数の推移を出したい

Googleアナリティクスを用いて全てのページビューを確認

ページビューの確認

Googleアナリティクスのページいきましたら、

行動→サイトコンテンツ→全てのページをクリックしましょう。

すると右側に全てのページビューが表示されます。

google-analytics-page-view1

全ページをエクセル、CSVに出力をする

このまま出力をしてしまうと、ページが10ページ分しか出力がされません。

ですので、右下の表示する行数を変更して全ページ表示しましょう。

google-analytics-page-view2

その後、右上にあるエクスポートから、CSV、Googleスプレッド、エクセルを選択して出力で完成になります。

google-analytics-page-view3

こちらで完了になります!

あとはこちらのデータを月ごとにダウンロードしていただき、

エクセルなどを用いると推移などが見れるようになります!

月別の推移を見るエクセル

自分用につくったものがありますので、もし自分でつくるのがめんどくさいという方は、

ご自由にご利用ください!

エクセルの使い方

まずはエクセルをダウンロードしましょう。

必ずエクセルファイルでのダウンロードをお願いいたします。

Googleスプレッドシートでは動きません。

1.上記で説明させていただいた、全ページのダウンロード【1ヶ月単位】

まずは月ごとにデータをエクスポートしましょう。最初のみ、推移を見たい月のデータを全てダウンロードしないといけないのでご注意ください。

例)2020年10月からの推移がみたい方は

2020/10/1-10/30
2020/11/1-11/31
2020/12/1-12/31

のファイルをダウンロードする必要があります。

2.①でダウンロードしたファイルをシートに貼付け

同じ月のところに先程のデータを貼り付けましょう。

もし、該当のシートがない場合は新しく●●●●年●月という名前でシートを作成しましょう。

google-analytics-page-view4

3.次にサマリをひらいていただいて,自分のブログのURLを貼りましょう

URLを貼る時に注意ですが、必ずパーマリンクを/で囲ったものを入れるようにお願いいたします。

例)https://laplace-ec-man.com/chrome-bookmark-backup-import-export

であれば→ /chrome-bookmark-backpu-import-export/

を”サマリ”シートの一番左に貼付けましょう。

すると右側に各月のアクセス推移がでますので、全ページURLを貼ることで

全ページのアクセス推移がみれるようになります!

ちなみにですが、上部には合計のアクセス数と、アクセスが月間1以上あるページの数(アクティブページ)をのせております。

ちなみに、自分のブログの全ページURLを取得する方法は下記で紹介しております。

WordPressでブログの記事URL(投稿URL)の一覧を取得する方法、カテゴリー一覧を取得する方法を徹底解説!
WordPressでブログの記事URL(投稿URL)の一覧を取得する方法、カテゴリー一覧を取得する方法を徹底解説!
目次 1. はじめに2. プラグインを使わないでWordPressの記事URL一覧を取得する方法3. […]

google-analytics-page-view5

分析関係カテゴリの最新記事