Once you’ve authenticated your connection to Ahrefs, you’re ready to create your first query.
This guide will walk you through how to create your first Ahrefs query in Google Sheets, Looker Studio (formerly Data Studio), or Excel.
Ahrefs metrics and dimensions
We’re happy to offer a wide range of Ahrefs fields in Supermetrics. You can review a full list of these in our technical documentation.
Instructions
- Authenticate Ahrefs in Google Sheets.
- In the Supermetrics sidebar, select a date range for your query. If you need to query a lot of historical data, consider using the “Combine new results with old” feature.
- Select your query’s metrics and dimensions. If you’d like some inspiration or a starting point, take a look at our Google Sheets templates.
- Click Get Data to Table to create your query and pull your data.
When you’re ready, further refine and enhance your Google Sheets queries with advanced settings.
You can also optimize your queries to keep them running as quickly and smoothly as possible, and set up scheduled refreshes so your queries update automatically. These refreshes also deliver reports directly to your inbox on a schedule that works for you.
- Authenticate Ahrefs in Looker Studio.
- Select your query’s metrics and dimensions. If you’d like some inspiration or a starting point, take a look at our Looker Studio templates.
- Your data will fill out the charts you select automatically.
When you’re ready, learn how to use filters and data blending to further refine your reporting. You can also optimize your Looker Studio reports to keep them running quickly and smoothly.
- Authenticate Ahrefs in Excel.
- In the Supermetrics sidebar, select a date range for your query.
- Select your query’s metrics and dimensions. If you’d like some inspiration or a starting point, take a look at our Excel templates.
- Click Get data to create your query and pull your data.
When you’re ready, learn how to use Excel’s advanced settings to further refine your reporting.
You can also set up scheduled refreshes so your queries update automatically. These refreshes also deliver reports directly to your inbox on a schedule that works for you.
Troubleshooting
- If you see an error about metrics and dimensions not fetching together, or fields being incompatible, follow these steps to fix the issue.
- If you see errors relating to quotas or daily query quotas, learn more in our quotas and usage guide.