Crawling Tools, Audit Tools, Keyword Research, Content Analysis, Crawlability, Indexability, Rank Tracking, Web Analytics, Social Listening, Backlink Analysis, etc. • Analysis of Data • Data often ends up in a spreadsheet. • You sort, filter, join with Vlookups, summarize with Pivot tables, visualize with charts and graphs • Recommended Action Items • Update content • Update code • Update server setting • Try to get other sites to update their sites • Implementation • SEO / Marketers / Content Managers / Writers with CMS Access • Developers with Backend Code Access • IT / Network Admin / Server Admin with Server Access
Crawling Tools, Audit Tools, Keyword Research, Content Analysis, Crawlability, Indexability, Rank Tracking, Web Analytics, Social Listening, Backlink Analysis, etc. • Analysis of Data • Data often ends up in a spreadsheet. • You sort, filter, join with Vlookups, summarize with Pivot tables, visualize with charts and graphs • Recommended Action Items • Update content • Update code • Update server setting • Try to get other sites to update their sites • Implementation • SEO / Marketers / Content Managers / Writers with CMS Access • Developers with Backend Code Access • IT / Network Admin / Server Admin with Server Access Export as Spreadsheets, or Use APIs Export Results of Analysis Integrate with CMS for Automated Updates Converting your manual analysis into steps your Python script will do Typically, the biggest challenge is: (1) converting your manual analysis into distinct steps and (2) turning these steps into Python instructions. Python Analysis of Data and Integration with CMS’ for Automated Updates may take time to setup, but once completed, everything will be faster
Similarity • Gender and Role Relationships • Tense and Parts of Speech • Polarity and Sentiment • Formal vs. Informal Language • Topical Relevance • Lexical Hierarchy • Contextual Dependency • Sentential Structure • Emotional Tone or Connotation • SEO Tools Known to Use Vector Embedding • Screaming Frog • inLinks • WordLift • MarketMuse • MarketBrew
• Determining Revenue Per Keyword • Quantifying the Effect of Pagespeed Updates on Traffic and Revenue • Keyword Research • Targeting the Best Keywords • Vector Embedding • Finding Duplicate Content • Identifying Internal Linking Opportunities • Updating Image Alt Text as Scale • Writing Title Tags and Meta Descriptions for Thousands or Millions of Pages
keywords to target and optimize • General Process • Start with some initial seed words • Use keyword research tools to get more keyword ideas • Analyze the data to determine which keywords to target • Finalize the primary target keywords Seed Words Keyword Exploration Keyword Analysis Primary Target Keywords
steps your Python script will do • More popular industries • More competitors • More current ranking keywords • More website pages • More product lines / services More Keywords to Analyze Breakdown into steps to narrow down hundreds or millions of keywords to a smaller number of keywords to target.
A good balance of long tail and head terms • Why? Get the low hanging fruit and monitor the journey to the general head terms • A balance of transactional, informational, navigational • Why? • Transactional for more sales • Informational, for new customer discovery and link bait purposes • Navigational, for customer support, ORM • Balance of high KEI and high Search Volume • Why? Low-hanging fruit to gain benefits, more sales quicker, while working on the higher search volume in the process • Common keywords between competitors • Why? • Quicker way to narrow down industry-relevant keywords. • Quicker to exclude competitor brands. • A good balance of different topics • Why? High search volume or high KEI can make keywords too focused on 1 thing. It might be 1 product, 1 service, 1 product trend, • Include and exclude list filter • Long tail keyword pattern analysis Whether this is 1,000 keywords, or 1,000,000 keywords, the Python Script will run all rules and narrow down to whatever number of keywords you set this out to. Different SEOs may have a different process, as long as this process can be articulated into distinct steps, then it can be transformed into Python code.
for keyword research. • Implementation: • Use keywords in key areas of a page. • Title Tag • Meta Description • Heading Tags • Main Content • Image Alt Text • URLs • Schema Markup • Etc.
API • Cost for running this for 100 keywords OpenAI's pricing for the GPT-4 model is $0.03 per 1,000 prompt tokens and $0.06 per 1,000 completion tokens. • Prompt Cost: (150 tokens / 1,000) * $0.03 = $0.0045 • Completion Cost: (500 tokens / 1,000) * $0.06 = $0.03 • Total Cost: $0.0045 + $0.03 = $0.0345
keyword is not used • For each category and subcategory, find the highest search volume keyword. • If the keyword is not used in the title tag, use the ChatGPT API to rewrite the title and use the keyword. • Similar rules can be done for the meta description • Doing a manual QA check would be a smart thing to do in the initial runs
at the same pace • The Technical SEO team does it for the rest of the team • Great internal training program • Create an application with a user- friendly interface (Streamlit, Dash, Flask, Django) • Hire people • Partner with other companies • Tool Ownership • You or your employer?