Skip to content

Python script to take a ahrefs keyword download an enrich it with sentiment data via Google Language API

Notifications You must be signed in to change notification settings

Williams-Media/Ahrefs-Sentmiment-Analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 

Repository files navigation

Ahrefs Keyword Sentiment Analysis Tool

This Python-based tool automates sentiment analysis on keyword exports from Ahrefs, providing valuable insights for SEO and marketing strategies. It leverages the Google Natural Language API to evaluate the emotional tone behind keywords, offering an innovative angle to traditional SEO practices.

Description

The Ahrefs Keyword Sentiment Analysis Tool is designed to enrich your SEO keyword data by adding a layer of sentiment analysis. By processing a CSV file exported from Ahrefs, the tool appends two insightful metrics to each keyword: 'Sentiment Score' and 'Sentiment Magnitude'. Additionally, it categorizes each keyword with an 'Emotional Leaning' label (Positive, Negative, Neutral) and a 'Strength of Emotion' label (Low, Moderate, High), which can be instrumental in understanding user intent and emotional responses.

Benefits for SEO

  • User Intent Understanding: By analyzing the sentiment of keywords, you can gain insights into the searcher's emotional state, helping to tailor content that aligns with user intent.
  • Content Strategy Development: Positive and strong sentiments can inform content strategies to target enthusiastic audiences, potentially increasing engagement and conversions.
  • Brand Monitoring: Track how brand-related keywords are perceived, allowing for proactive reputation management.
  • Competitive Analysis: Assess the emotional appeal of keywords your competitors rank for and adjust your strategy accordingly.
  • Market Trends: Spot shifts in sentiment over time, which may indicate changing consumer attitudes or market trends.

Features

  • Batch Processing: Efficiently processes large numbers of keywords by batching API requests to comply with rate limits.
  • Progress Tracking: Visual progress bar and incremental CSV updating to ensure no data loss in case of interruptions.
  • Rate Limiting: Adjustable request delay to prevent hitting API rate limits.
  • Easy Integration: Designed to work seamlessly with keyword reports exported directly from Ahrefs.

Getting Started

  1. Clone the repository.
  2. Ensure you have a valid Google Cloud Platform account and the Natural Language API enabled.
  3. Install the required Python libraries as listed in requirements.txt.
  4. Place your Ahrefs keyword export CSV and Google Cloud credentials JSON in the root directory.
  5. Run the script and let it enrich your keyword data with sentiment analysis.

Williams Media SEO Team

About

Python script to take a ahrefs keyword download an enrich it with sentiment data via Google Language API

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages