# Google Search Console Featured Snippets Alerts Setup

**Last Updated:** 2026-01-13

Step-by-step guide to set up Google Search Console alerts for Featured Snippets and FAQ performance monitoring.

## Prerequisites

- Google Search Console account access
- Property verified for ordio.com
- Access to Performance reports
- Email address for alerts

## Setup Steps

### Step 1: Access Search Console

1. **Navigate to Google Search Console:**

   - Go to https://search.google.com/search-console
   - Select your property (ordio.com)

2. **Verify Access:**
   - Ensure you have "Owner" or "Full" access
   - Check property is verified

### Step 2: Set Up Performance Monitoring

1. **Navigate to Performance Report:**

   - Go to Performance → Search results
   - Select date range (last 28 days recommended)

2. **Filter for FAQ Pages:**

   - Click "New" button
   - Select "Page" filter
   - Enter pattern: `/insights/*/`
   - Apply filter

3. **Check Featured Snippets:**
   - Click "Search appearance" tab
   - Look for "Featured snippets" section
   - Note current count

### Step 3: Create Custom Report

1. **Export Performance Data:**

   - In Performance report
   - Click "Export" button
   - Select "Google Sheets" or "Download CSV"
   - Include columns:
     - Query
     - Page
     - Clicks
     - Impressions
     - CTR
     - Position
     - Search appearance (Featured snippets)

2. **Create Tracking Spreadsheet:**
   - Create new Google Sheet
   - Name: "FAQ Featured Snippets Tracking"
   - Columns:
     - Date
     - Query
     - Page
     - Featured Snippet Status
     - Clicks
     - Impressions
     - CTR
     - Position
     - Notes

### Step 4: Set Up Email Alerts

**Note:** Google Search Console doesn't have built-in alerts for Featured Snippets. Use these alternatives:

#### Option 1: Google Sheets + Apps Script

1. **Create Apps Script:**
   - Open tracking spreadsheet
   - Go to Extensions → Apps Script
   - Create new script:

```javascript
function checkFeaturedSnippets() {
  // This requires Search Console API setup
  // See: https://developers.google.com/webmaster-tools/search-console-api-original
  // For now, use manual export method
}
```

#### Option 2: Manual Monthly Export

1. **Set Up Monthly Reminder:**

   - Create calendar reminder
   - Frequency: Monthly (1st of each month)
   - Action: Export Featured Snippets data

2. **Export Process:**
   - Go to Performance → Search results
   - Filter by FAQ pages (`/insights/*/`)
   - Click "Search appearance" → "Featured snippets"
   - Export data
   - Update tracking spreadsheet

#### Option 3: Third-Party Tools

1. **Consider Tools:**
   - Ahrefs (has Featured Snippets tracking)
   - SEMrush (Featured Snippets reports)
   - SISTRIX (SERP features tracking)

### Step 5: Monitor FAQ Performance

1. **Weekly Check:**

   - Check Performance report weekly
   - Look for new Featured Snippets
   - Note changes in positions

2. **Monthly Review:**

   - Export full performance data
   - Update tracking spreadsheet
   - Compare month-over-month
   - Identify trends

3. **Quarterly Analysis:**
   - Review Featured Snippets growth
   - Analyze top-performing FAQs
   - Identify optimization opportunities
   - Update FAQs based on data

## Featured Snippets Tracking Spreadsheet Template

Create a Google Sheet with this structure:

| Date       | Query                | Page                                     | Featured Snippet | Clicks | Impressions | CTR   | Position | Change | Notes |
| ---------- | -------------------- | ---------------------------------------- | ---------------- | ------ | ----------- | ----- | -------- | ------ | ----- |
| 2026-01-13 | minijob 2025         | /insights/lexikon/minijob/               | Yes              | 45     | 1200        | 3.75% | 1        | New    | -     |
| 2026-01-13 | zeiterfassung gesetz | /insights/ratgeber/zeiterfassung-gesetz/ | Yes              | 32     | 890         | 3.60% | 1        | Stable | -     |

## Automated Monitoring Script

**✅ Automated script available:** `v2/scripts/blog/fetch-faq-featured-snippets.php`

This script uses the Google Search Console API to automatically fetch Featured Snippets data for FAQ pages.

### Usage

```bash
# Fetch last 28 days
php v2/scripts/blog/fetch-faq-featured-snippets.php

# Fetch specific date range
php v2/scripts/blog/fetch-faq-featured-snippets.php --start-date=2025-12-01 --end-date=2026-01-13

# Fetch and email results
php v2/scripts/blog/fetch-faq-featured-snippets.php --email
```

### Output Files

The script creates three files in `v2/data/blog/gsc-featured-snippets/`:

1. **`faq-featured-snippets.json`** - Current Featured Snippets data for FAQ pages
2. **`summary.json`** - Summary statistics
3. **`snapshot-YYYY-MM.json`** - Monthly snapshot for historical tracking

### Monthly Cron Job

Set up a monthly cron job to run automatically:

```bash
# Add to crontab (crontab -e)
# Run on 1st of each month at 9 AM
0 9 1 * * cd /path/to/landingpage && php v2/scripts/blog/fetch-faq-featured-snippets.php --email
```

### Script Features

- ✅ Automatically filters for FAQ pages (`/insights/*/`)
- ✅ Fetches Featured Snippets data via Search Console API
- ✅ Generates summary statistics
- ✅ Creates monthly snapshots for historical tracking
- ✅ Optional email reports
- ✅ Handles rate limiting and retries
- ✅ Logs all operations

### Data Structure

Each Featured Snippet record includes:

- `page` - Page URL
- `query` - Search query
- `clicks` - Number of clicks
- `impressions` - Number of impressions
- `ctr` - Click-through rate (%)
- `position` - Average position
- `search_appearance` - Always "FEATURED_SNIPPET"

## Monthly Checklist

- [ ] Export Featured Snippets data from GSC
- [ ] Update tracking spreadsheet
- [ ] Compare month-over-month metrics
- [ ] Identify new Featured Snippets
- [ ] Note position changes
- [ ] Review top-performing FAQs
- [ ] Identify optimization opportunities
- [ ] Update FAQs if needed

## Quarterly Review Process

1. **Data Collection:**

   - Export 3 months of Featured Snippets data
   - Calculate growth metrics
   - Identify trends

2. **Analysis:**

   - Which FAQs have Featured Snippets?
   - Which FAQs are close to Featured Snippets?
   - What queries drive Featured Snippets?
   - What's the CTR for Featured Snippets?

3. **Optimization:**

   - Update FAQs based on data
   - Add missing FAQs
   - Improve answer quality
   - Optimize for Featured Snippets

4. **Documentation:**
   - Update tracking spreadsheet
   - Document findings
   - Create action items

## Troubleshooting

### Can't Access Search Console

**Issue:** No access to Search Console

**Solutions:**

1. Request access from property owner
2. Verify email has correct permissions
3. Check property verification status

### No Featured Snippets Data

**Issue:** Featured Snippets section empty

**Solutions:**

1. Check date range (may need longer period)
2. Verify FAQ schema is valid
3. Check if pages are indexed
4. Wait for data to populate (can take time)

### Export Not Working

**Issue:** Can't export data

**Solutions:**

1. Try different date range
2. Reduce data volume (filter more)
3. Use CSV export instead of Sheets
4. Export in smaller chunks

## Best Practices

1. **Regular Monitoring:**

   - Check weekly for new Featured Snippets
   - Export monthly for tracking
   - Review quarterly for optimization

2. **Data Consistency:**

   - Use same date ranges for comparisons
   - Track same metrics consistently
   - Document changes and notes

3. **Action-Oriented:**
   - Use data to inform FAQ updates
   - Optimize FAQs based on performance
   - Test and iterate

## Related Documentation

- `FAQ_MONITORING_CHECKLIST.md` - Complete monitoring checklist
- `FAQ_QUARTERLY_REVIEW_PROCESS.md` - Quarterly review process
- `FAQ_PERFORMANCE.md` - Performance dashboard
- `FAQ_MONITORING_QUICK_START.md` - Quick start guide

## Next Steps

After setup:

1. Export initial Featured Snippets data
2. Set up tracking spreadsheet
3. Create monthly calendar reminder
4. Begin weekly monitoring
5. Schedule quarterly review