How To Create Year-Over-Year Reports

Owned by Kyle Sharrer
Sept 14, 2023
2 min read

This SOP is a work in progress. If you notice anything that is out of date, could be more clear or could be more efficient please update the SOP or add a comment to start a conversation.

Purpose

This outlines the process for creating a year-over-year NinjaCat report for clients that have surpassed a year in their SEO campaign.

These reports can be used in escalations for visual presentation purposes of long-term SEO results.

Procedure

  1. Navigate to your client’s account in NinjaCat and click the Add Report button

  2. Select the Year Over Year SEO Report template

  3. Set Email to Do Not Email - ALL YoY reports will be manually sent. Because these are only created once a year, we don’t want clients receiving these every month. 

Tasks for SEO reps

Export year’s worth of keyword rankings from SEO monitor

  1. Open up the client in SEO monitor 

  2. Change rankings from desktop to mobile (arrow 1)

  3. Change date range to the entire year: beginning of 1st month to the end of 13th month (arrow 2)

  4. Download keyword list (arrow 3) and paste keyword list in DS import tab of client sheet

  5. Once this is done - you can generate your YoY report.

Organic KPI Improvement

  • The Organic KPI Improvement slide has the same information as traditional monthly reports

  • The stats comparison compare the entirety of the most recent year vs. the entirety of last year (ex: December 2017 - November 2018 vs. December 20118 - November 2019)

  • The top landing pages compare Month 12 vs. Month 1 (ex: November 2019 vs December 2018)

Most Improved & Best Performing Keywords

  • This slide has the same stats as traditional reports

  • MIK shows keywords that had the best improvement from Month 1 to Month 12 (ex: December 2018 to November 2019)

  • BPK shows keywords that have consistently done well over the entirety of the year (ex: November 2018 - November 2019)

Organic Leads

  • The organic leads slide has the same stats as traditional reports

  • Each lead type and the total at the bottom compares the current month of the current year vs. the current month of the previous year (ex: November 2019 vs. November 2018)

Top Clicked Organic Searches

  • The Top Clicked Organic Searches show the same stats as traditional reports

  • The Queries compare the entirety of the most recent year vs. the entirety of last year (ex: December 2017 - November 2018 vs. December 20118 - November 2019)

  • Sessions by Device compare the current month of the current year vs. the current month of the previous year (ex: November 2019 vs. November 2018) 

  • Device Breakdown shows stats for the entirety of the year (ex: November 2018 - November 2019)

Reviews & Business Listing Management

  • This slide shows reputation management and directory management stats

  •  Average Rating Reviews Last Year shows the entirety of the year (ex: November 2018 - November 2019)

Google Business Listing Customer Actions shows customer actions for the entirety of the year (ex: November 2018 - November 2019)