GEO数据看板搭建
数据源到可视化全流程指南

# GEO数据采集管道示例
import json
import csv
import requests
from datetime import datetime
from google.oauth2 import service_account
from google.analytics.data_v1beta import BetaAnalyticsDataClient

# 1. 采集AI引用率数据（从Playwright脚本输出）
def collect_mention_data():
    with open('mention_tracking_results.json', 'r', encoding='utf-8') as f:
        data = json.load(f)
    # 按平台和关键词汇总
    summary = {}
    for r in data:
        key = f'{r['platform']}_{r['keyword']}'
        if key not in summary:
            summary[key] = {'total': 0, 'mentioned': 0, 'positive': 0}
        summary[key]['total'] += 1
        if r['mentioned']:
            summary[key]['mentioned'] += 1
            if r['sentiment'] == 'positive':
                summary[key]['positive'] += 1
    return summary

# 2. 采集GA4流量数据
def collect_ga4_traffic(property_id, credentials_path):
    credentials = service_account.Credentials.from_service_account_file(
        credentials_path,
        scopes=['https://www.googleapis.com/auth/analytics.readonly']
    )
    client = BetaAnalyticsDataClient(credentials=credentials)
    
    # 查询AI搜索引荐流量
    request = {
        'property': f'properties/{property_id}',
        'date_ranges': [{'start_date': '7daysAgo', 'end_date': 'today'}],
        'dimensions': [{'name': 'sessionSource'}],
        'metrics': [{'name': 'sessions'}, {'name': 'conversions'}],
        'dimension_filter': {
            'filter': {
                'field_name': 'sessionSource',
                'string_filter': {
                    'match_type': 'CONTAINS',
                    'value': 'chatgpt'
                }
            }
        }
    }
    response = client.run_report(request)
    return response

# 3. 采集内容产出数据（从CMS或Excel）
def collect_content_data(csv_path):
    content = []
    with open(csv_path, 'r', encoding='utf-8') as f:
        reader = csv.DictReader(f)
        for row in reader:
            content.append({
                'title': row['title'],
                'publish_date': row['publish_date'],
                'keyword': row['keyword'],
                'platform': row['platform'],
                'ai_cited': row.get('ai_cited', 'unknown')
            })
    return content

# 4. 统一数据格式并存储
def merge_and_store(mention_data, traffic_data, content_data, output_path):
    merged = {
        'update_time': datetime.now().isoformat(),
        'mention_data': mention_data,
        'traffic_data': str(traffic_data),  # GA4 response需要进一步解析
        'content_data': content_data
    }
    with open(output_path, 'w', encoding='utf-8') as f:
        json.dump(merged, f, ensure_ascii=False, indent=2)
    print(f'数据已合并存储到 {output_path}')

# 执行数据采集管道
mention = collect_mention_data()
content = collect_content_data('content_tracking.csv')
merge_and_store(mention, None, content, 'geo_dashboard_data.json')

<!-- GEO数据看板布局模板 (HTML) -->
<div class='geo-dashboard'>
  <!-- 第一层：KPI汇总区 -->
  <div class='kpi-summary-row'>
    <div class='kpi-card'>
      <span class='kpi-label'>AI引用率</span>
      <span class='kpi-value'>35.2%</span>
      <span class='kpi-trend up'>+5.3%</span>
      <span class='kpi-target'>目标: 45%</span>
    </div>
    <div class='kpi-card'>
      <span class='kpi-label'>品牌准确率</span>
      <span class='kpi-value'>82分</span>
      <span class='kpi-trend up'>+8分</span>
      <span class='kpi-target'>目标: 85分</span>
    </div>
    <div class='kpi-card'>
      <span class='kpi-label'>AI搜索流量</span>
      <span class='kpi-value'>1,240</span>
      <span class='kpi-trend up'>+15%</span>
      <span class='kpi-target'>目标: 2,000</span>
    </div>
    <div class='kpi-card'>
      <span class='kpi-label'>正面提及比例</span>
      <span class='kpi-value'>76%</span>
      <span class='kpi-trend up'>+4%</span>
      <span class='kpi-target'>目标: 80%</span>
    </div>
    <div class='kpi-card'>
      <span class='kpi-label'>竞品差距</span>
      <span class='kpi-value'>-12%</span>
      <span class='kpi-trend up'>缩小3%</span>
      <span class='kpi-target'>目标: <-5%</span>
    </div>
  </div>
  
  <!-- 第二层：趋势分析区 -->
  <div class='trend-charts-row'>
    <div class='chart-container' id='mention-trend-chart'></div>
    <div class='chart-container' id='traffic-trend-chart'></div>
    <div class='chart-container' id='sentiment-chart'></div>
  </div>
  
  <!-- 第三层：明细分析区 -->
  <div class='detail-charts-row'>
    <div class='chart-container' id='competitor-comparison'></div>
    <div class='chart-container' id='keyword-ranking'></div>
    <div class='chart-container' id='platform-distribution'></div>
  </div>
</div>