# Google Search Console Analytics in Grid

## Google Search Console

AirOps makes it easy to append page-level, real-time Google Search Console analytics directly in your Grid, helping you identify top-performing content and optimization opportunities.

{% @arcade/embed url="<https://app.arcade.software/share/ZqW7Km3R3QoJ5FGBRwT2>" flowId="ZqW7Km3R3QoJ5FGBRwT2" %}

### How to Add Google Search Console Analytics to your Grid

1. Click the **Add Column** button in your Grid
2. Select **Google** **Search Console** from the Analytics section of the dropdown menu
3. Connect to your Google Search Console account:
   * Select an existing Google Search Console authentication from the dropdown
   * If this is your first time, you'll need to authenticate with your Google account
4. Configure the data mapping:
   * Under "Map URL column," select the column in your Grid that contains the URLs you want to analyze
   * Click **Save Configuration**
5. Your Grid will now display new Search Console analytics columns:
   * **Search Analytics**: Data pull status indicator
   * **Clicks 30D**: Number of clicks in the last 30 days with % change period on period
   * **Impressions 30D**: Number of impressions in the last 30 days with % change period on period
   * **CTR 30D (%)**: Click-through rate percentage with % change period on period
   * **Position 30D**: Average ranking position with % change period on period
6. To fetch the latest data, click the **Play button** in the Search Analytics column
   * The status will update to show when the data was retrieved
   * Performance metrics will display with percentage changes to indicate trends
7. Review the analytics data directly in your Grid:
   * Green percentages indicate positive trends
   * Red percentages indicate negative trends
   * Use these insights to identify underperforming content for optimization

### Scheduling Google Search Console Updates

The Google Search Console column can be scheduled to automatically refresh your analytics data:

1. Click the **Google** **Search Analytics column header**
2. Select **"Schedule Workflow"**
3. Set your refresh schedule (e.g., daily at 9 AM, weekly on Mondays)
4. Configure row filters if needed to update specific URLs only

**Common scheduling patterns:**

* **Daily updates** for high-traffic pages
* **Weekly refreshes** for content monitoring
* **Before optimization workflows** to ensure decisions are based on latest data