Handling established campaigns across multiple countries can quickly become a case of handling overwhelming quantities of data interspersed with never-ending menial jobs, preventing the SEO from developing their strategy to squeeze yet more value from their campaign ROI.

Here is part one of a two-part guide to some of the key automations our team uses to keep on top of the game internationally.

Segmented ‘Micro’ Reports

Based on the effectiveness of simple spark-line graphs and minimal data points in relevant context, micro reports should give you a quick, visual view of the campaign state of play within the context of the preceding week and the same period last year.

Result: Fast, flexible reports on key metrics with no clutter and no analysis(!).Multinational Micro Reports

Regardless of the metrics measured however, the report should be comprehensive in covering all areas of the campaign – so include things like click data from the last email campaign, for example – and should not include any dialogue: save that for monthly review reports.

Here’s my absolute minimum weekly KPIs for keeping an eye on just SEO & PPC multinational campaign ROI (I’ve left out Affiliates, Social, Display, etc for simplicity’s sake but can revisit if there’s enough interest).

For all reports, run for the total campaign, and for each target country in your campaign.

1.  Total Organic / PPC / Total Visits

  • For each channel and country: 12 month sparkline; last week’s timeline with previous week and YOY comparison lines; percentage non-brand in the week and average for month vs. same month last year.

What you’re looking out for here: sudden slips, particularly in the year on year numbers. Most verticals have a distinct annual trend. Are you outperforming it when it counts? Are you simply seeing a rise because there’s always a rise?

Also, you should always look to increase your non-brand percentage because it will drive a higher proportion of new visits, growing overall sales rather than cannibalising traffic sales initially driven by another channel.

2.  Top 25 Non-Brand Organic / PPC Keyphrases Driving Visits

  • For each channel & country: table w/ term, 12 month sparkline, visits, +/- week, +/- month, +/- YOY month.What you’re looking out for here: new breakthrough terms, and high value performance terms slipping.

Again, take seasonality into account, especially for organic. PPC YOY comparisons should be further investigated if dramatically different: has budget allocated to the term changed: why? Is it intentional, and if so was it based on CPC or CPA? Was it a valid decision or should it be reviewed?

3.  Top 25 Non-Brand Organic / PPC Keyphrases Driving Converting Visits

  • Similar to the above point, only this time also pull in revenue generated +/- week, +/- month, +/- YOY month for converting traffic fitting the criteria.

4.  Top 25 SEO ‘Opportunity Keyphrases’

  • For each country: term, rank, impressions, clicks, ranking URL, URL <title>, URL Meta Description.I define an ‘Opportunity Keyphrase’ as a relevant search term which has high potential traffic associated with it, that my site is currently ranking outside of the top three search result terms, but within the top 10 (inclusive).

Why are these terms worth giving special attention to?

Simply because we know that SERP clickthrough rates go up exponentially as you approach position one in the SERPs, therefore for high traffic terms, moving from position 4-10 to 1-3 will have a significant bottom line impact to your traffic.

Every URL flagged in this report should be scheduled for onpage auditing of its SEO around the highlighted term, and should have an internal and external linkbuilding strategy executed over the following week.

Of all the micro reports, this is the most useful to also send to the local country teams to act as a guide to upcoming optimisation work, but also as a reminder of the importance of core areas of optimisation (after they implement the recommended work, inevitably you’ll see the terms switch up into top three rankings on a well set-up domain).

5.  Top 25 SERP Conversion ‘Opportunity Keyphrases’

Similar to the above report, except this time our focus is on SERP results where we are performing in the top three, but are not converting impressions to clicks well enough. This time, we should be scheduling a local copywriter to review the <title> and meta description for suitability in converting searchers on the highlighted search term in their country.

  • Conversion Funnel ‘Points of Failure’
    • I call this report the ‘Points of Failure’ because a well set up conversion funnel should strive to achieve 100% conversion (although this is of course impossible!). For each country, a straightforward recreation of a funnel (a la Google Analytics’ Goal Funnel) for new site visitors with +/- week on week, and +/- year on year is sufficient to get a good feel for where progress is being made (or not!).If you’re running major funnel optimisation then include page load speed info for your funnel URLs.
  • Site Speed

For each country: run for sitewide, and top 25 slowest URLs, avg. page load time, +/- week on week, and +/- year on year. Watch out for erratic results week on week as well as any sudden drops. Both are indicative of a struggling server and require further investigation into server capacity and tolerance.

Obviously, you’re striving to ensure you get as fast as possible page load times – certainly for the DOM execution to improve user experience. But remember, Google uses ‘Headless’ page execution to incorporate JavaScript execution into page rendering times so pay particular attention to parallelising your static assets and ensure you follow every best-practice piece of advice out there (page speed is nothing new!).

You may find it useful to build testing tools using PhantomJS for more robust Page Speed reporting tools.

Until Next Time, Happy Micro Reporting

So that’s my bare minimum micro-report suite recommendation. Everything in here can be automated and the data can be largely gathered from Google Analytics and Webmaster Tools for that purpose.

Hopefully you’ll find the micro-report useful to spot sudden changes in activity across a range of data points, and come to appreciate its use as a bellweather for the campaign. It should, of course, not replace more considered monthly reporting containing insightful commentary and action points.

Part two of this post (next month) will cover Alert Triggered Reports, and how we can use automation to save us at critical campaign moments of crisis.

Opinions expressed in the article are those of the guest author and not necessarily Search Engine Land.

Related Topics: Channel: Analytics | How To | How To: Analytics | Intermediate | Multinational Search | Search Marketing: Multinational

Sponsored


About The Author: has over twelve years web development experience & is the founder of QueryClick Search Marketing, a UK agency specialising in SEO, PPC and Conversion Rate Optimisation strategies that deliver industry-leading ROI.

Connect with the author via: Email | Twitter | Google+ | LinkedIn



SearchCap:

Get all the top search stories emailed daily!  

Share

Other ways to share:

Read before commenting! We welcome constructive comments and allow any that meet our common sense criteria. This means being respectful and polite to others. It means providing helpful information that contributes to a story or discussion. It means leaving links only that substantially add further to a discussion. Comments using foul language, being disrespectful to others or otherwise violating what we believe are common sense standards of discussion will be deleted. Comments may also be removed if they are posted from anonymous accounts. You can read more about our comments policy here.
  • http://babypickel.com/vincenzo.html Chenzo

    Do you ever use any automated script platforms to help crawl your sites to find on site SEO issues, or are you using manual methods?

    Enjoyed the musings

    Chenzo

  • http://twitter.com/liversidge Chris Liversidge

     Hi Chenzo – I’m a fan of @JohnMu:twitter ‘s old crawler, Gsite. But I tend to avoid their use day to day in favour of getting Google’s opinion of a site by using site: operator commands chained with intitle: & inurl: operators (and their negative variants) to analyse  competitor sites, and Webmaster Tools data for sites we control. I’ve posted about this process in a previous blog here: http://searchengineland.com/identifying-in-site-duplicate-content-using-chained-search-operators-88679

 

Get Our News, Everywhere!

Daily Email:

Follow Search Engine Land on Twitter @sengineland Like Search Engine Land on Facebook Follow Search Engine Land on Google+ Get the Search Engine Land Feed Connect with Search Engine Land on LinkedIn Check out our Tumblr! See us on Pinterest

 
 

Click to watch SMX conference video

Join us at one of our SMX or MarTech events:

United States

Europe

Australia & China

Learn more about: SMX | MarTech


Free Daily Search News Recap!

SearchCap is a once-per-day newsletter update - sign up below and get the news delivered to you!

 


 

Search Engine Land Periodic Table of SEO Success Factors

Get Your Copy
Read The Full SEO Guide