With Two Minute Reports, you can enable quick and easy data import from Google Search Console into Looker Studio. This allows you to bypass the time-consuming process of manually navigating the GSC native dashboard and focus directly on the SEO insights that matter. Before connecting your GSC data to Looker Studio, ensure you have the following permissions:
Required permissions
- The user must add and verify their property in the Google Search Console. Only verified properties will be available for use with TMR’s GSC connector.
- You must have either the “Owner” or “Full User” roles to access search performance data. The “Owner” can promote other users to a “Full User” role.
- Users with “Owner” or “Full User” access can authenticate through the Google Flow login. After successful authentication, the Connector will display the verified properties available to the user.
Once you have confirmed these prerequisites, you can follow the steps below to connect your Google Search Console data to Looker Studio.
Step 1: Streamline your Google Search Console account in Looker Studio
- Go to https://apps.gox.ai/ and choose Two Minute Reports for Looker Studio.
- Select Google Search Console from the list of connectors.
- Connect your Google Search Console data by clicking New connection to create your Connection in Looker Studio.
- The Adding new connection dialog box appears. Here you can connect the required Google Search Console account in two easy steps:
- Creating a Connection: Name your Connection and authorize the email associated with your Google Search Console account.
- Enable the necessary accounts to extract actionable SEO insights, as shown above. Please note that reports can only be created for the enabled accounts.
That’s it. You can now configure your Google Search Console account to track your website’s performance.
Step 2: Configure your Google Search Console account with TMR
- In the Query Configs section, click + Add New.
| The Query Config allows you to group multiple accounts, making it easier to view centralized insights in your Looker Studio dashboard. |
- The Adding New Query Configuration dialog box will appear. Name the query config, select (from the list of enabled) accounts from the dropdown, and specify the type of GSC report you need from the list of options – Analytical Report, Sitemap Report and URL inspection Report. Once done, click Save.
- You’ve successfully created a new configuration, which you can now use to extract data for your Looker Studio reports.
Step 3: Create your Google Search Console Report with TMR in Looker Studio
- After creating the Query Config, click Create Report in the top-right corner.
- Select the Query Config that you’ve created (in our case, it’s ‘GSC Website Data’) from the list of options. Click Next and choose ‘Create report from scratch’ to open the Looker Studio dashboard.
- Once the Looker Studio dashboard opens, select your team and the required Query Config from the dropdown. Click Connect in the top-right corner.
- After clicking Create Report, you’ll be directed to the Looker Studio dashboard. Here, you can select the GSC metrics and dimensions to create your website analytics report.
- Similarly, you can inspect multiple URLs on your website and review the status and processing details of your submitted XML sitemaps. Here’s how you can select your preferred report type:
- Go to Query Config tab > Select GSC Website Data and click the pencil icon > Choose your report type from the dropdown menu.
- To make your Looker Studio report compelling, use charts and visualizations. Click Add a chart and choose relevant chart types to configure your dashboard.
For instance, you can use bar charts to visualize key trends such as total clicks, impressions, and average position over time. These insights help you identify which time periods, queries, or pages are driving the most visibility and traffic to your website.
Note: We’ve also listed some common issues marketers face while running reports on Looker Studio and practical solutions to fix them. Read the full article here.
We hope you found this article helpful. If you have any questions, please contact our support team via support@twominutereports.com.