Pull Analytics in the 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.

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