This Google Search Console Report template helps you to visualize your Search Console (formerly known as Google Webmaster Tools) into Power BI in a few clicks. Dimensions and metrics available are
- Average position
It queries the data through our connector and makes it available in real-time. Follow the steps outlined below to get your data connected. In case you are interested in the Power BI desktop file used to create the report, simply scroll down further.
To get started
- Connect your Google Search Console Data to Windsor.ai here. Register or login if you already have an account.
Make sure to head to Search Console and authenticate with a Google account
- Select at least one Website Property from the dropdown and remember to grant access. Copy your API Key from the top right corner.
- Install the Power BI Web App here
- Click on Connect in the Connect your data section
- Enter your API key which you got in Step 1
- On the next screen click on Sign In
- Your data should be loading now. Depending on your data size this may take a minute or two.
Alternative: Power BI Desktop
If you would like to explore how the template is built on the Power BI desktop you can also download the latest version of the dashboard template in .PBIX format here. Please note that the source data are in US regional settings format (1234.56 and 2020-12-16), and if you are using the different locale settings, you might need to transform numerical and date data. This will allow you to change the visuals and join the data with other data sets you might already have in your data setup.
In the template on the start screen, paste your API Key from step 2 like here
You can watch this “How to visualize your marketing data in Power BI using WindsorAI” video to help you start.
You might also be interested in…
- Microsoft Power BI Multichannel Marketing Attribution Dashboard Template