Hey Ciaran! 😊
If you like the data you get from Ahrefs, you can connect it directly to Clay using our HTTP API. Here’s a helpful guide to get started: HTTP API Integration Guide. And here are the Ahrefs API docs for reference: Ahrefs API Documentation.
Alberto’s suggestion is also a great option—using Semrush to gather historical traffic data year over year (e.g., August 2024 vs. August 2023 vs. August 2022). This involves duplicating the Semrush enrichment to get the data for each year.
For Semrush in Clay, you can retrieve estimated monthly traffic metrics for a domain. This includes key data like visits, unique visitors, and pageviews. If you don’t specify a month, it will give you the most recent complete month’s data. To look at data over the last 12 months, you would need to run this process separately for each month.
Feel free to reach out if you need further assistance with this! 🚀