Brand keyword dashboard for AEO metrics

This tool pulls your branded query data from Search Console automatically and pairs it with Google Trends data you paste in, so you can see whether branded demand is actually moving and by how much. Setup takes about ten minutes, most of it waiting for Google to ask you to click “Allow.”

Before you start

You’ll need a Google account with access to the Search Console property you want to track, and Editor access to Google Drive to upload a file. Nothing here requires a paid Google Workspace plan. The whole thing runs on a free Google account.

Step 1: Convert the file to Google Sheets

Upload the Brand_Search_Trends_Tracker.xlsx (linked below) to Google Drive. Double-click it, then in the preview screen, choose Open with > Google Sheets. This creates an editable Sheets copy. Apps Script, which powers the automated Search Console pull, only runs inside native Google Sheets, not inside an Excel file sitting in Drive unconverted.