Automate SEO Audit Report Creation for Your SEO Agency for Free (n8n SEO Automation)

Website Performance Analysis Workflow

Overview of the Workflow

• The speaker introduces a workflow designed to analyze website performance, highlighting its output as an HTML file that incorporates HTML for structure, CSS for styling, and JavaScript for added functionalities.

Key Functionalities

• The workflow includes features such as data filtering and exporting capabilities, enhancing user interaction with the analysis results.

• It provides an overall traffic analysis comparing two periods, similar to Google Search Console metrics but with customizable configurations.

Traffic Insights

• The report shows a decrease in clicks from approximately 18,000 to 15,000 over the analyzed periods, indicating a 15% drop in performance.

• Device-specific performance is highlighted; users can assess how their site performs across different devices (desktop vs. mobile), revealing potential technical issues affecting traffic.

Geographic Performance Analysis

• Users can filter traffic data by country and device type; for example, analyzing desktop performance specifically for Germany reveals a 9% change in clicks.

• The ability to view all devices allows users to identify trends in impressions and clicks across platforms.

Keyword Position Distribution

Understanding Keyword Rankings

• The tool assesses keyword rankings based on click-through rates and impressions across various thresholds (top three, positions four to ten, etc.), providing immediate visibility into ranking status.

Movement Tracking

• It tracks keyword movements over time; users can see if they have entered or dropped out of top rankings with specific keywords.

Performance by Pages

Identifying Top Performers

• A crucial feature of the analysis is identifying which pages are performing well or poorly. For instance, one article saw a significant increase in clicks from 175 to 240—a growth of about 37%.

Optimization Opportunities

Understanding Performance Metrics in SEO

Categorization of Page Performance

• The categorization of page performance includes identifying top performers, which indicates an increase in clicks and improved click-through rates (CTR).

• Declining pages are characterized by a significant loss of impressions and a decrease in CTR, marking them as low performers.

Workflow Configuration

• The workflow can be triggered either manually or on a schedule, starting with data retrieval from the website.

• A Google Sheet is utilized for report configuration, requiring inputs such as domain, BigQuery tables, and email details for report distribution.

Data Collection Process

• Key parameters include minimum impression thresholds and click-through rate thresholds to analyze keyword position distributions across devices.

• The workflow supports multiple websites; users can duplicate entries while adjusting domain-specific data.

Execution Tracking

• Each execution saves data into a run history to track performance over time. This allows for dynamic date calculations when generating reports.

• Users can set analysis periods dynamically to avoid gaps in data collection during manual executions based on observed performance changes.

Keyword Analysis

• The workflow checks keyword rankings across various countries (e.g., Germany, USA, England), providing insights into ranking movements.

• It helps identify potential keyword cannibalization by showing if multiple pages rank for the same keywords, which could impact conversion strategies.

Data Merging and Analysis

• After merging collected data, the analysis focuses on search metrics like impressions and clicks per query across different devices.

Data Analysis Workflow Overview

Key Metrics and Data Insights

• The analysis includes current clicks, previous clicks, impressions, click rates, and deltas to assess performance.

• Performance metrics are segmented by devices, countries, pages, and keyword movements for comprehensive insights.

Data Merging and HTML Generation

• The process involves merging data from various sources before generating the HTML report.

• Code nodes are utilized to create KPI cards and variables that populate the bottom of the HTML file.

Pagination and Data Management

• Pagination is implemented to load only 10 rows into the DOM at a time for efficient data handling.

• Loading all data at once can lead to large HTML files that may cause browser lag or crashes due to disk space limitations.

Finalizing the Report

• After merging data, elements like icons, charts, and company information are integrated into an HTML template.

• The workflow treats the HTML template as a skeleton where each part is filled with code containing appropriate CSS classes.

Sending Reports Securely

• The final output is converted into a base64 string and zipped for secure email transmission to avoid being flagged as spam.