# SEO Report
------------------------------------------------------------------------
source
### sync_articles_to_db
``` python
def sync_articles_to_db(
session:Session, # Active database session
website_id:int, # Parent website ID
url_file_mapping:dict, # URL → file path mapping
)->None:
```
*Insert articles into the database, skipping already existing ones.*
## Delete Articles in wrong Website
------------------------------------------------------------------------
source
### find_duplicate_metadata
``` python
def find_duplicate_metadata(
session:Session, # Active database session
field:str, # Metadata field to check
website_id:int, # Parent website ID
similarity_threshold:float=0.9, # Minimum similarity to flag
)->list:
```
*Find articles with duplicate or very similar metadata field values.*
## Make FocusKeyword to be Top query from GSC
------------------------------------------------------------------------
source
### analyze_links
``` python
def analyze_links(
content:str, # Page content
domain:str, # Site domain to classify links
)->dict:
```
*Analyze internal and external links in content.*
------------------------------------------------------------------------
source
### check_heading_structure
``` python
def check_heading_structure(
headers:list, # Headers from [`extract_headers`](https://abdelkareemkobo.github.io/seo_rat/content_parser.html#extract_headers)
)->dict:
```
*Check heading structure for H2 presence and skipped levels.*
------------------------------------------------------------------------
source
### analyze_article
``` python
def analyze_article(
article:Article, # Article to analyze
domain:str, # Site domain
is_quarto:bool, # Whether content is Quarto
title_is_h1:bool=False, # Whether title counts as H1
desc_field:str='description', # Frontmatter description field
title_field:str='title', # Frontmatter title field
date_field:str='date', # Frontmatter date field
)->dict:
```
*Run all SEO checks for a single article and return its report dict.*
------------------------------------------------------------------------
source
### generate_seo_report
``` python
def generate_seo_report(
session:Session, website_id:int, domain:str, is_quarto:bool, title_is_h1:bool=False,
desc_field:str='description', title_field:str='title', date_field:str='date',
include_insights:bool=False, # Include query intents, trends, green keywords
days:int=90, # Days for insights lookback
query_limit:int=100, # Max queries for insights
)->dict:
```
*Generate a comprehensive SEO report for all articles in a website.*
------------------------------------------------------------------------
source
### print_issues_report
``` python
def print_issues_report(
report:dict, # Result from [`generate_seo_report`](https://abdelkareemkobo.github.io/seo_rat/seo_report.html#generate_seo_report)
)->None:
```
*Print SEO issues sorted from most issues to fewest.*