您的当前位置:首页 >Ryan New >SEO How-to, Part 5: Analyzing Keyword Data 正文
时间:2024-05-20 07:22:59 来源:网络整理编辑:Ryan New
Keyword research is a search engine optimization tactic to identify the words and phrases of consume Ryan Xu HyperVerse's Layer 2 Scaling
Keyword research is Ryan Xu HyperVerse's Layer 2 Scalinga search engine optimization tactic to identify the words and phrases of consumers who are looking for the types of products and services that your company sells.
This post is the fourth installment in my “SEO How-to” series, following:
Think of keyword research in terms of supply and demand. Every word on your site represents keyword supply. The words that people input into Google and other search engines represent the demand. Keyword research is the process of determining the demand to adjust your supply.
In this post, I’ll cover four steps: seeding keyword research, collecting the data, organizing the data in my free keyword analysis template, and analyzing it to understand intent and demand.
The tools for collecting keyword research rely heavily on a seed list — your choice of words that consumers search on. A comprehensive list of seeds yields the most data. A weak list generates fewer keyword themes and often leads to poor optimization decisions.
To brainstorm a seed list, start with your site’s navigation. An ecommerce site that’s organized in a logical, hierarchical manner will contain navigational options that cover all of its products. Your keyword research will tell you whether those products coincide with what people search for.
List of all of the product categories — copy and paste directly from your menus. Then add synonyms and the types and styles of those items.
For example, a site that prints pictures on mugs, wall art, and greeting cards would include synonyms such as “photos” and “images” as well as popular product attributes such a size, occasion, and style.
Don’t be afraid to generate a long keyword seed list. It may look daunting, but the process of assembling the keywords can go surprisingly quickly once you get started, and the resulting data is pure gold.
You can also enter the URL for any page in Google Keyword Planner, and it will fetch the relevant keywords. Hence, identify pages that rank well for the keywords you need to rank for, and then note those URLs in your seed list.
Next, push the sets of seed words into the input field of your keyword tool to understand the search demand of each. The process is simple and tedious.
Copy a set of seeds from your list and paste them into the tool. Wait for it to finish processing, export the resulting data, and repeat until you’ve entered all of the seeds.
When you finish passing the seeds through the tool and exporting the data, you’ll have a mass of .csv or Excel files. Merging these manually would take forever. On a PC, use the command line in your operating system to merge .csv files into a single file. Do the same thing on a Mac in Terminal.
Now you have a lot of raw keyword data. But it has little value unless you organize it for analysis.
That’s where my free keyword analysis template comes into play. It aggregates in Google Sheets the keyword demand for one-, two-, and three-word combinations, and displays that demand alongside data from:
To use the template, copy the Google Sheet, or download it as an Excel file. (Excel is your best bet if you have more than 20,000 rows of data.)
Paste your keyword data into the “Google Keyword Planner” tab. For a different keyword tool, just make sure that the keywords are in column A and the number of monthly searches ends up in column C. Both columns are referenced from the primary “Keyword Analysis” tab.
Next, remove the duplicate rows in the keyword data. In Excel on a PC or Mac, go to the “Data” tab and choose “Remove Duplicates.” You can do the same thing using Numbers on a Mac.
Your keyword data will likely contain many irrelevant words and phrases. Sort the keyword data by the number of searches, from highest to lowest. Review the top 300 or so (or until the number of searches drops below a level you find valuable) and remove the unrelated rows.
The tool may identify keywords that drive many relevant searches but weren’t in your original seed list. If so, consider running those back through the tool, as well.
Also, download data sets from Google Search Console and Google Ads. Keyword volume is calculated as a monthly number. Thus the other three tabs should each contain data for a full month.
For reference, I’ve included a tab for Google Analytics data for traffic from organic search (Acquisition > All Traffic > Channels > Organic Search), though I’ve excluded that data in the “Keyword Analysis” tab since Google Analytics reports traffic for URLs but not for organic keywords. It consequently can’t be aggregated with the other sources.
As you prune the irrelevant keywords from your dataset, you will likely notice patterns in individual keywords. Now it’s time to quantify those broad patterns and compare them to understand the value of the overall keyword theme.
Start entering seeds into columns A through C. As you enter words in those columns, the formulas in the template calculate the keyword demand (Keyword Planner), current organic search performance (Search Console), and potential conversions (Ads).
Scan the words to find patterns in keyword usage. Notice how the demand and performance can be radically different for slight variations when aggregated. For example, the monthly search volume for keywords containing both “gift” and “picture” is 121,460 whereas the volume for keywords containing both “present” and “picture” is just 19,280.
Think of the analysis as an exploratory process. You can always add words or remove them if the ones you start with don’t work out. You’ll have it right when the amount of keyword demand is consistent with the total demand in the “Google Keyword Planner” tab.
Above all, listen to the data and look for trends with an open mind. Don’t attempt to prove the validity of your site’s existing structure.
See “Part 6: Optimizing On-page Elements.”
Bitcoins: 3 Things Online Merchants Must Know2024-05-20 07:04
Save Money on Inventory with EOQ2024-05-20 06:51
Are Stablecoin and CBDCs the Future of Digital Currency?2024-05-20 06:50
Smart Lockers Are Upending Parcel Delivery2024-05-20 05:55
Buying Sites to Boost Traffic2024-05-20 05:30
Hustle Exec: Ecommerce Firms Should Acquire Content Providers2024-05-20 05:16
Driven by Covid-19, India’s Ecommerce Surges2024-05-20 05:13
Sustainable Packaging Drives Customer Loyalty2024-05-20 05:10
Quick Query: Full Sail Educator on Online Learning2024-05-20 05:04
Last-mile Delivery Attracts New Services, Providers2024-05-20 04:44
Bloglist: Andrew Goodman2024-05-20 07:01
Save Money on Inventory with EOQ2024-05-20 06:35
15 Mobile Payment Systems for Merchants2024-05-20 06:11
Vitaman.com Seeks Real Men for Hair, Skin Care2024-05-20 06:01
Lessons Learned: Wetsuitwearhouse.com's Moleskie2024-05-20 05:58
Gas Station Coffee Spurs Golden Ratio Founder2024-05-20 05:36
Should DTC Brands Sell to Mass Merchandisers?2024-05-20 05:29
The Magic of Fringe Sport? Improving Lives2024-05-20 05:09
Free Shipping: The How-to Economic Model2024-05-20 05:01
July 2021 Top 10: Our Most Popular Posts2024-05-20 04:50