SEO Professionals are always under pressure as they work for months and wait for the results.
Measuring their SEO project performance is mandatory. Unfortunately, there are different metrics to look at when you are tracking SEO performance i.e. rankings, traffic, leads, conversions etc.
In this article, I am going to talk about only one important metric i.e. page level organic traffic growth month over month.
To create a month over month traffic report for all pages of your website from Google Analytics will take a lot of time.
Here I am going to share a simple Google Analytics Custom Report which can be done in 10 Minutes.
How will you get benefit from this report?
- You will know which pages are performing well – ( can be created more like these pages for good traffic growth.)
- You will know which pages are lost traffic – ( you can work on those pages to improve traffic)
- You will know which pages dead i.e. not giving any traffic – ( you can delete or rebuild those pages from scratch)
Let’s start the implementation:
Step 1: Login to your Google Analytics account and Select the Website to create Performance Report of it.
Step 2: In Analytics, Now Create a Custom Report to get Performance Report Data.
Select > CUSTOMIZATION > Click on “Custom Reports” then Select “+New Custom Report”
Step 3: Create the custom report by filling and selecting the following fields, Dimensions, and Metrics.
- Title – Name of the Report
- Name – Name of the Report Content
- Type – Flat Table
- Dimensions – Landing Page, Month of Year (Not “Month of the Year”).
- Metrics: Organic Searches.
- Save.
Step 4: Select the Date Range of the site and Click on “Apply”. For example, I usually prefer 1-year data to measure.
Step 5: Now, Click on “Show More” at the bottom and select the maximum value and Click on “Export” to download the data.
Step 6: Lets, Create the Website Performance Report
Open Downloaded Data in Excel.
- Now, Go to “Insert” tab and Select “Pivot table”.
- Select the Complete data table range and arrange the Fields as per below image.
- In Columns – month of year, In Rows – Landing page, and In Values – Organic Searches.
Note: In values box, it should be “Sum of Organic Searches” not “Count of Organic Searches ”
Step 7: Now Calculate “Max traffic” and “Drop” to measure your website Performance.
After Creating Pivot Table, Copy All Data and Paste in New Sheet (Note: Paste as Values). Modify the Row Labels into Readable (like this 201611 to Jan-16).
Formulas:
- MaxTraffic – =Max(Row Range) Except Grand Total
- Drop – =Max Traffic – Recent Month Traffic (Comparision of Max traffic and Present Traffic)
Rajan says
Those were some good tips to measure seo. Keep them coming!
Kamran says
Waiting for more articles from you Sankar.
Sankar Datti says
Sure Kamran 🙂
shanid says
You are great . I am still following traditional SEO with Link Directory and some blogs and focused on technical only
Sankar Datti says
Please do move to white hat SEO.
Shailendra Singh says
This was beyond my expectations in terms of value. I hope you will keep enlightening us with these Gyan shots 🙂
Sankar Datti says
Thank you so much Shailendra. My Pleasure.
Naresh says
Hi very informative post .keep posting useful for all SEO beginners
Sankar Datti says
Thanks Naresh
Lokesh says
How to identify, spam or bad backlinks?
Sankar Datti says
Hi Lokesh,
We manually check following metrics for each backlink to know spam or not
1. Domain Authority
2. Backlinks
3. Content quality
4. Similarweb Traffic
5. Site Design
6. Spam Ads and Popups etc.
Hope that helps
Sankar Datti says
Hi Lokesh,
I follow below methods to identify spam links manually.
1. Download all root domain links from ahrefs.com
2. Sort out based on domain authority and page authority
3. Add similarweb search traffic in one column
4. Now sort out based traffic.
In this sheet you have to check manually low authority and zero traffic links first. Then all other manually. Even though it’s time taking, I strongly recommend to do it.
Regards
Sankar Datti
Gurvinder Kaur says
I’m amazed that there can be never be a saturation point when we talk about content related to a topic! Great piece of content. Thanks
Ashish says
That’s a really very informative article, Thanks for sharing this info.
Suresh says
With this article, I just realised there is a serious drop in Organic searches for one year. I’m in a shock now. Help me out with the necessary plan to make things right. Please!
Sankar Datti says
Hi Suresh,
I am getting lot of requests for some serious SEO help, It’s really difficult to help everyone individually. This is main reason behind my course creation, so that I can share with you all.
Thanks
Kumar Manickam says
HI Sankar,
i tried. but i am failed to make excel report(pivot table). I have 19935 rows(pages there). so could you share the video tutorial for this pivot table section
Sankar Datti says
Hi Kumar,
I have included Pivot table section in the Video clearly. Following the video, you can easily make the report. Can you be more specific where exactly you are getting the problem.
karthik reddy says
Very very useful tips that you’re giving sir… Waiting for upcoming articles and classes
My request to you is- Please make an article on “how to rank a single webpage to multiple keywords”