GEO效果KPI体系
指标设计与落地执行指南

# GEO核心KPI计算示例

def calculate_ai_mention_rate(query_results):
    '''计算AI引用率
    query_results: [{keyword, platform, queries, mentions}, ...]
    '''
    total_queries = sum(r['queries'] for r in query_results)
    total_mentions = sum(r['mentions'] for r in query_results)
    rate = total_mentions / total_queries * 100
    return round(rate, 1)

def calculate_brand_accuracy(accuracy_scores):
    '''计算品牌信息准确率
    accuracy_scores: [100, 70, 100, 40, 70, ...]
    '''
    avg = sum(accuracy_scores) / len(accuracy_scores)
    return round(avg, 1)

def calculate_geo_conversion(ai_traffic, landing_conversion_rate):
    '''计算GEO转化数
    ai_traffic: AI搜索引荐月流量
    landing_conversion_rate: 着陆页转化率(0-1)
    '''
    conversions = int(ai_traffic * landing_conversion_rate)
    return conversions

# 示例数据
data = [
    {'keyword': '企业CRM推荐', 'platform': 'ChatGPT', 'queries': 5, 'mentions': 3},
    {'keyword': '企业CRM推荐', 'platform': '文心一言', 'queries': 5, 'mentions': 4},
    {'keyword': '最好的项目管理软件', 'platform': 'ChatGPT', 'queries': 5, 'mentions': 2},
    {'keyword': '最好的项目管理软件', 'platform': '文心一言', 'queries': 5, 'mentions': 3},
]

print(f'AI引用率: {calculate_ai_mention_rate(data)}%')
print(f'品牌信息准确率: {calculate_brand_accuracy([100, 70, 100, 40, 70, 100, 70, 100])}')
print(f'GEO月转化数: {calculate_geo_conversion(1200, 0.05)}')

# KPI数据采集记录模板
import csv
from datetime import datetime

# AI引用率采集模板
def create_tracking_template(keywords, platforms):
    records = []
    for kw in keywords:
        for plat in platforms:
            for i in range(3):  # 每个关键词查3次
                records.append({
                    'date': datetime.now().strftime('%Y-%m-%d'),
                    'week': datetime.now().isocalendar()[1],
                    'keyword': kw,
                    'platform': plat,
                    'query_round': i + 1,
                    'brand_mentioned': '',  # Yes/No
                    'mention_position': '',  # 前1/3, 中1/3, 后1/3
                    'sentiment': '',  # positive/neutral/negative
                    'competitor_mentions': '',  # 竞品名称
                    'notes': ''
                })
    return records

keywords = ['企业CRM推荐', '最好的项目管理软件', 'SaaS工具对比']
platforms = ['ChatGPT', 'Perplexity', '文心一言', 'Kimi', 'Google AI']

data = create_tracking_template(keywords, platforms)
with open('geo_kpi_tracking.csv', 'w', newline='', encoding='utf-8') as f:
    writer = csv.DictWriter(f, fieldnames=data[0].keys())
    writer.writeheader()
    writer.writerows(data)
print(f'已生成{len(data)}条采集记录模板')