using keyword data to crush your competition
TRANSCRIPT
![Page 1: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/1.jpg)
Tom Whittam
SEO Consultant, Ayima
Using Keyword DataTo Crush Your Competition
![Page 2: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/2.jpg)
Tom Whittam
SEO Consultant, Ayima
Cyclist (the Lycra kind)
@Tom_Perignon
![Page 3: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/3.jpg)
Tweet us! @Ayima
Ayima began in 2007
Headquartered in London & NYC
SEO partner to Fortune 20 & FTSE clients
![Page 4: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/4.jpg)
Identifying Competitor
Growth
![Page 5: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/5.jpg)
Identifying Competitor Growth
• Enter your URL into SEMrush
• Export competitor data for the last 6/12 months
Please Note: Ayima are not affiliated with Confused, they were selected as a site within a highly competitive industry that have seen no natural growth between July 2014 and December 2014 according to SEMrush data
![Page 6: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/6.jpg)
Identifying Competitor Growth
• Export competitor data – Last complete month and 6/12 months
prior
![Page 7: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/7.jpg)
Identifying Competitor Growth
• Using Excel, de-dupe domains & vlookup data
• Set thresholds to identify the key winners/losers
![Page 8: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/8.jpg)
Identifying Competitor Growth
• Who’s seen the most growth
• Who’s seen the biggest drops
• How can we use this to our advantage?
![Page 9: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/9.jpg)
“Using data to identify your competitors strengths,
can help you address your own weaknesses”
![Page 10: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/10.jpg)
Use Your Competitor’s
Keywords Against Them
![Page 11: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/11.jpg)
Use Your Competitor’s Keywords Against Them
• Enter your URL into SEMrush
• Export non-brand positions keyword data and search volumes into Excel
• Do the same for top competitors & de-dupe
– Go Compare
– Compare The Market
– Money Supermarket
![Page 12: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/12.jpg)
Use Your Competitor’s Keywords Against Them
• Removing any search terms that have a low traffic percentage, will ensure you’re only reviewing the content that drives your competitors significant traffic
![Page 13: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/13.jpg)
Use Your Competitor’s Keywords Against Them
• It’s important to categorise & subcategorise your keywords - this will help you quickly and easily visualise the data using pivot tables
![Page 14: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/14.jpg)
Use Your Competitor’s Keywords Against Them
• Cross-check the keywords against your client’s to give you an easy way to identify new opportunities
![Page 15: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/15.jpg)
“Using data is essential, but it quickly becomes
useless, if your client doesn’t understand it”
![Page 16: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/16.jpg)
Visualising Keyword Data
![Page 17: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/17.jpg)
Visualising Keyword Data
• Total Landscape (top level)
![Page 18: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/18.jpg)
Visualising Keyword Data
Landscape
20,044,080
Communications
5,327,950
Mobile Phones
4,188,700
Broadband
1,047,050
TV
92,200
Finance
5,005,530
Banking
3,417,560
Loans
697,470
Mortgages
467,500
Investing
244,500
Credit Score
157,400
Business
11,200
Income
9,900
Discount Codes
3,166,100
Insurance
3,076,990
Car
1,562,270
Travel
651,800
Home
216,420
Health
39,400
Life
24,800
Other
582,300
Tools
1,749,600
Finance
1,003,400
Communications
673,000
Energy
55,600
Insurance
17,600
Energy
825,970
Suppliers
306,580
Gas/Electric
285,790
Electric
227,710
Gas
2,900
Fuel
2,900
Travel
717,200
Currency
347,900
Car Hire
217,000
Holidays
72,300
Flights
50,800
Hotels
18,700
Airport Parking
10,500
Breakdown
152,540
Car
124,950
Home
13,400
Travel
12,300
Motor Bike
1,890
Help/Support
22,200
Please Note: These figures are combined search volumes for any keywords that fall into its respective category
![Page 19: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/19.jpg)
Visualising Keyword Data
• Opportunities Landscape (top level)
![Page 20: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/20.jpg)
Visualising Keyword Data
Opportunities Landscape
14,886,270
Communications
4,987,600
Mobile Phones
4,003,400
Broadband
894,400
TV
89,800
Finance
3,554,690
Banking
2,143,100
Loans
613,590
Mortgages
375,000
Investing
244,500
Credit Score
157,400
Business
11,200
Income
9,900
Discount Codes
3,166,100
Tools
1,715,400
Finance
1,002,100
Communications
673,000
Energy
40,300
Energy
643,700
Suppliers266,300
Electric209,500
Gas/Electric167,900
Travel
601,100
Currency342,500
Car Hire206,000
Holidays42,900
Airport Parking8,100
Flights1,600
Insurance
165,580
Car155,400
Life6,800
Home2,900
Other480
Breakdown
29,900
Car17,800
Home12,100
Help/Support
22,200
![Page 21: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/21.jpg)
Visualising Keyword Data
Opportunities Landscape
14,886,270
Communications
4,987,600
Mobile Phones
4,003,400
Broadband
894,400
TV
89,800
Finance
3,554,690
Banking
2,143,100
Loans
613,590
Mortgages
375,000
Investing
244,500
Credit Score
157,400
Business
11,200
Income
9,900
Discount Codes
3,166,100
Tools
1,715,400
Finance
1,002,100
Communications
673,000
Energy
40,300
Energy
643,700
Suppliers266,300
Electric209,500
Gas/Electric167,900
Travel
601,100
Currency342,500
Car Hire206,000
Holidays42,900
Airport Parking8,100
Flights1,600
Insurance
165,580
Car155,400
Life6,800
Home2,900
Other480
Breakdown
29,900
Car17,800
Home12,100
Help/Support
22,200
In December 2014 Confused didn’t rank in the
Top 20 SERP positions for 455 keywords that
drove traffic to a competitor with a combined
search volume of over 14 million
![Page 22: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/22.jpg)
“Content creation doesn’t need to be sexy or cost
millions in order to work for you”
![Page 23: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/23.jpg)
Creating Content That Works
![Page 24: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/24.jpg)
Creating Content That Works
• Identify product pillars where you can make a difference
Opportunities Landscape
14,886,270
Communications
4,987,600
Mobile Phones
4,003,400
Broadband
894,400
TV
89,800
Finance
3,554,690
Banking
2,143,100
Loans
613,590
Mortgages
375,000
Investing
244,500
Credit Score
157,400
Business
11,200
Income
9,900
Discount Codes
3,166,100
Tools
1,715,400
Finance
1,002,100
Communications
673,000
Energy
40,300
Energy
643,700
Suppliers266,300
Electric209,500
Gas/Electric167,900
Travel
601,100
Currency342,500
Car Hire206,000
Holidays42,900
Airport Parking8,100
Flights1,600
Insurance
165,580
Car155,400
Life6,800
Home2,900
Other480
Breakdown
29,900
Car17,800
Home12,100
Help/Support
22,200
![Page 25: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/25.jpg)
Creating Content That Works
Problem first
![Page 26: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/26.jpg)
Creating Content That Works
Problem first
“I’ve just been made redundant”
![Page 27: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/27.jpg)
Creating Content That Works
Problem first
“I’ve just been made redundant”Finance
3,554,690
![Page 28: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/28.jpg)
Creating Content That Works
Problem first
“I’ve just been made redundant”
“3 things to do within 24 hours of
receiving a redundancy letter”
Finance3,554,690
![Page 29: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/29.jpg)
Creating Content That Works
Problem first
“I’ve just been made redundant”
“3 things to do within 24 hours of
receiving a redundancy letter”Income9,900
Finance3,554,690
![Page 30: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/30.jpg)
Creating Content That Works
Product first
![Page 31: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/31.jpg)
Creating Content That Works
Product first
“Mortgages”
![Page 32: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/32.jpg)
Creating Content That Works
Product first
Finance3,554,690 “Mortgages”
![Page 33: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/33.jpg)
Creating Content That Works
Product first
“Mortgages”
“How to increase your
credit score to get the ideal
mortgage”
Finance3,554,690
![Page 34: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/34.jpg)
Creating Content That Works
Product first
“Mortgages”
“How to increase your
credit score to get the ideal mortgage”
Finance3,554,690
Mortgages375,000
![Page 35: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/35.jpg)
Creating Content That Works
Product first
“Mortgages”
“How to increase your
credit score to get the ideal mortgage”
Finance3,554,690
Mortgages375,000
Credit Score157,400
![Page 36: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/36.jpg)
Creating Content That Works
Linking Opportunities
![Page 37: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/37.jpg)
Creating Content That Works
“How to save yourself £100 in your lunch hour”
Linking Opportunities
![Page 38: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/38.jpg)
Creating Content That Works
“How to save yourself £100 in your lunch hour”
Linking Opportunities
Communications
4,987,600
Finance3,554,690
Energy643,700
Insurance165,580
![Page 39: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/39.jpg)
Creating Content That Works
“How to save yourself £100 in your lunch hour”
Linking Opportunities
Communications
4,987,600
Finance3,554,690
Energy643,700
Insurance165,580
Broadband
894,400
Banking2,143,100
Gas/Electric167,900
Car155,400
![Page 40: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/40.jpg)
Creating Content That Works
Things to consider:
• Appearing for a broad range of searches is valuable for Brand visibility
• Users will be at a different stage in the conversion funnel
• Different content will have varying conversion lengths - mortgages vs. mobiles
• Keep your content semantic
– Relevant to voice searches (Google Now)
– Appeals to Hummingbird
– Doesn’t conflict with key product pages
![Page 41: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/41.jpg)
“You can create the best content imaginable, but
if the market isn’t there, it will fail”
![Page 42: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/42.jpg)
Analysing Your Demographic
![Page 43: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/43.jpg)
Analysing Your Demographic
“Fresh out of university and can’t get a job”
Is a different demographic to…
“My retirement fund has collapsed”
![Page 44: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/44.jpg)
Analysing Your Demographic
“Man going on holiday with his mates”
Is a different demographic to…
“Man going on holiday with his family”
![Page 45: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/45.jpg)
Analysing Your Demographic
• Using the YouGov Profiler you can see how different they really are:
Source: https://yougov.co.uk/profiler
![Page 46: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/46.jpg)
Analysing Your Demographic
• Using the YouGov Profiler you can see how different they really are:
Source: https://yougov.co.uk/profiler
![Page 47: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/47.jpg)
Analysing Your Demographic
• Drill down and find out where they buy:
Source: https://yougov.co.uk/profiler
![Page 48: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/48.jpg)
Analysing Your Demographic
• One customer type may not be the demographic you should focus on:
Source: https://yougov.co.uk/profiler
![Page 49: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/49.jpg)
Analysing Your Demographic
Source: https://yougov.co.uk/profiler
• One customer type may not be the demographic you should focus on:
![Page 50: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/50.jpg)
“Content must be created with the same detail as
any SEO task for it to truly be called quality”
![Page 51: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/51.jpg)
Keys for Success
![Page 52: Using Keyword Data to Crush Your Competition](https://reader030.vdocuments.us/reader030/viewer/2022032422/55a8e3001a28ab446a8b4731/html5/thumbnails/52.jpg)
Keys for Success
1. Identify key competitor growth
2. Analyse why they’re growing
3. Visualise where you’re falling short
4. Create ideas to target key areas
5. Research your audience to exhaustion