Extract Estimated Organic Traffic from Ahrefs for List of 15k URLs

Support
#1

Curious if this is possible and how I could extract estimated organic traffic for 15K URLs within Google Sheets and Excel.

#2

Hi, you would need access to a connector that supplies these metrics. Some of the SEO services like Ahrefs and SEMrush:
https://seotoolsforexcel.com/connectors/

Then you can insert a formula from the connector and expand the formula to your list of URLs.

#3

I have access to both, I need the formula. Do you mind providing an example based on 3 URLs?

#4

Example with one URL in cell A2 (apply same formula for additional URLs):

=Connector("Ahrefs.TrafficPositions";A2;"exact";;;"Traffic";TRUE)

You may need to change semi-colons to commas depending on regional setttings.