Structure of SEO Keyword Analysis (Search Console) Reports

Report Structure

KOBIT SEO Keyword Analysis (Search Console) Report consists of two Excel files:

  1. List of keywords report
  2. Keyword daily fluctuation chart

List of keywords report

The list of keyword report consists of the following sheets:

  1. List of keywords (PC)
  2. Improvement Priority (PC)
  3. List of keywords (Mobile )
  4. Improvement Priority (Mobile)
  5. How to read the charts
  6. Average CTR versus order of appearance (PC)
  7. Average CTR versus order of appearance (Mobile)

List of keywords (PC)

From the Search Console, this section will extract the top 1000 keywords that result in the highest number of clicks by PC users. Also, the cells will be colored depending on whether the CTR is higher or lower than the average. For details, please see here .

Improvement Priority (PC)

From the list of keywords (PC), this section will extract the ones with low CTR and need improvement, and rearrange them in order of priority. For details, please see here .

List of keywords (Mobile)

From the Search Console, this section will extract the top 1000 keywords that result in the highest number of clicks by mobile users. Also, the cells will be colored depending on whether the CTR is higher or lower than the average. For details, please see here .

Improvement Priority (Mobile)

From the list of keywords (Mobile), this section will extract the ones with low CTR and need improvement, and rearrange them in order of priority. For details, please see here .

How to read the charts

This section will explain how to read the report, as well as the coloring rules. We have created this document so that there will be no need for any additional documents of explanation when submitting the report to a client.

Average CTR versus order of appearance

In the CTR Study, we research nearly 1,750,000 keywords and 50,000 websites of the Google search results, and calculate the average CTR of PC and mobile users against the order of appearance. This sheet contains the numbers that were calculated.

In the previous sections where we mentioned “depending on whether the CTR is higher or lower than the average”, the calculations were based on the numbers from this CTR study.

Keyword Daily Fluctuation Chart

Keyword daily fluctuation chart consists of the following sheets:

  1. Daily fluctuation chart (PC)
  2. Daily fluctuation chart (Mobile)
  3. How to read the charts

Daily fluctuation chart (PC)

From the Search Console, we will extract the daily data of the main keywords of the PC users. Also, the cells will be colored depending on whether there has been any improvement compared to the previous month’s data. For details, please see here.

Daily fluctuation chart (Mobile)

From the Search Console, we will extract the daily data of the main keywords of the Mobile users. Also, the cells will be colored depending on whether there has been any improvement compared to the previous month’s data. For details, please see here.

For any other inquiries, contact us by filling out the form here.

0 Comments

Please sign in to leave a comment.