- Positions 1-3
- Positions 3-10
- Positions 10-20
- Positions 20-100
Using the power of the Analytics Edge Core Add-in and the Google Search connector, the workbook includes the macros to download the data and refresh the tables and charts.
Setup: enter the account and website in cells Q1 and Q2 on the Summary worksheet. Enter a regular expression to identify branded queries in cell Q3. Click Refresh All and the report refreshes with the last 15 months of your data.
Download the workbook:
15 month branded vs nonbranded-1-1.xlsx