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

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

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

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

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

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


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