GEO Reporting Dashboard Setup

What You'll Need

You'll need active accounts for Otterly AI (Pro plan minimum for API access), PEEC AI (Business plan for bulk citation tracking), Google Analytics 4 with enhanced ecommerce enabled, and Semrush's AI Toolkit. Set up a new Google Looker Studio project before starting. Have your brand's primary keywords list ready — at least 50 terms covering product, service, and informational queries. Export your existing SEO dashboard metrics for baseline comparison.

Step 1: Configure Otterly AI Data Sources

Time: 25 minutes | Tool: Otterly AI Start in Otterly's Dashboard Settings and enable API data export under "Advanced Integrations." Set your tracking frequency to daily for your top 20 keywords, weekly for your remaining keyword list. The platform crashes if you try to track more than 500 keywords simultaneously — learned this the hard way during a client audit. Navigate to Query Performance and configure custom tracking for each AI engine. Enable detailed response analysis for ChatGPT-4, Perplexity, Claude, and Google AI Overviews. Under "Mention Types," select Brand Mentions, Direct Citations, and Contextual References. Otterly's sentiment scoring works best when you exclude obvious competitor mentions — add your top 5 competitors to the negative filter list. Create three custom audiences: "Decision Stage Queries" (terms with buy, compare, best), "Information Queries" (how-to, what is, guide), and "Brand Defense" (your company name variations). Export the initial dataset as JSON — you'll import this directly into Looker Studio in step 4.

Step 2: Set Up PEEC AI Citation Monitoring

Time: 30 minutes | Tool: PEEC AI Access PEEC's Citation Tracker and input your domain plus all branded URLs. Add your Google Business Profile URL, LinkedIn company page, and any authority sites where you regularly contribute content. PEEC's strength lies in tracking indirect citations where your brand gets mentioned without a direct link. Configure sentiment analysis parameters under "Advanced Settings." Set the confidence threshold to 75% — anything lower returns too many false positives. Enable real-time alerts for negative sentiment spikes above -0.3 on their scale. I usually run this step twice because PEEC's initial crawl sometimes misses recent citations. Set up automated exports to Google Sheets. Under "Export Configuration," select weekly summaries with detailed citation sources, sentiment scores, and context snippets. The spreadsheet auto-updates every Tuesday at 6 AM EST. Connect this sheet to your Looker Studio project through the Google Sheets connector.

Step 3: Extract SEO Context from Google Analytics

Time: 20 minutes | Tool: Google Analytics 4 Navigate to Explore > Free Form and create a custom report combining organic traffic data with user engagement metrics. Add these dimensions: Source/Medium, Landing Page, City, and Device Category. Include these metrics: Sessions, Engaged Sessions, Average Engagement Time, and Conversions. Set up a secondary dimension for "First User Campaign" to capture organic search intent. Create a custom filter excluding direct traffic and referral spam — use the regex pattern "^(?!.(\bdirect\b|\bmypage\.com\b)).$" in the traffic source filter. Export this data as a CSV with date ranges matching your Otterly AI tracking period. Google Analytics 4's export sometimes truncates at 1,000 rows, so segment your data by month if you're pulling more than six months of history. Save these exports to a dedicated Google Drive folder for easy Looker Studio integration.

Step 4: Configure Semrush AI Toolkit Integration

Time: 35 minutes | Tool: Semrush AI Toolkit Open the Position Tracking tool and add your keyword list from step 1. Enable "AI Features Tracking" under Advanced Settings — this monitors when your URLs appear in AI-generated answer boxes, featured snippets, and People Also Ask sections. Semrush updated this feature in November 2024, and it now tracks Bing Chat and Bard results too. Navigate to Brand Monitoring and create alerts for AI-generated content mentioning your brand. Set up three monitoring queries: "[Brand Name] + recommendation," "[Brand Name] + review," and "[Brand Name] + alternative." The AI Toolkit flags when language models reference your brand in response to these query types. Export competitive intelligence data showing which competitors appear most frequently in AI search results for your target keywords. Under "Competitors Analysis," filter for "AI Visibility Score" — this proprietary metric shows share of voice across AI platforms. Download this as an Excel file; you'll upload it to Looker Studio as a data blend.

Step 5: Build the Unified Looker Studio Dashboard

Time: 45 minutes | Tool: Looker Studio Create a new Looker Studio report and add four data sources: Otterly AI JSON export, PEEC Google Sheet, Google Analytics 4 custom report, and Semrush Excel file. Set up data blending relationships using date and keyword as common dimensions. Design the main dashboard with five sections. Top section: AI visibility scorecard showing mention volume, sentiment trend, and competitive share. Second section: Citation quality metrics with source authority scores and geographic distribution. Third section: Traditional SEO performance correlation — bounce rate and conversion data for pages mentioned in AI results. Add a fourth section tracking "AI Attribution" — pages that receive traffic spikes after appearing in AI search results. Use calculated fields to show percentage change in organic traffic 7 days before and after AI mentions. The bottom section displays competitor intelligence with side-by-side AI visibility comparisons. Configure automated email delivery for every Monday morning. Recipients get a PDF summary plus interactive dashboard access. Set up data refresh schedules: Otterly (daily at midnight), PEEC (weekly Tuesday 7 AM), Google Analytics (daily 6 AM), Semrush (weekly Sunday 11 PM).

Common Pitfalls

• Tracking too many keywords initially overwhelms the AI monitoring tools and creates data gaps
• Setting sentiment thresholds too low floods dashboards with irrelevant mentions about industry terms
• Forgetting to exclude competitor brand names from your monitoring creates false positive spikes
• Not accounting for AI platform response delays — some tools show 24-48 hour lag times for new mentions

Expected Results

Your dashboard will show clear correlation between AI mention volume and organic traffic increases, typically 15-30% traffic lift within a week of positive AI citations. Sentiment scores should trend between 0.2 and 0.8 on most platforms, with outliers flagged for manual review. You'll identify which content types generate the most AI citations — usually FAQ pages, comparison guides, and how-to articles perform best. Schedule your first client presentation for next Friday and prepare to explain why traditional ranking reports miss half the story now.