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.