Hi Guys,
I am trying to extract the linked domains of a website through ahrefs connector where only dofollow linked domains that has been first seen within the past 30 days would show up.
I looked into the ahrefs API documentation. From there I was able to include the only do follow link part. Here is the formula:
=@Dump(Connector("Ahrefs.LinkedDomainsByType",Sheet3!A1,"subdomains","dofollow>=1","domain_to_rating<30","first_seen","desc","DomainFrom,DomainTo,Links,Text,Image,NoFollow,DoFollow,Redirect,Canonical,Gov,Edu,RSS,Alternate,FirstSeen,LastVisited,DomainToRating,DomainToAhrefsTop,DomainToLinkedDomains,DomainToTraffic,DomainToRefdomains",FALSE,50))
However, I don't understand how to add a filter of first seen of last 30 days in the where or having filter. Since it returns a date column I am not sure what argument to use for the desired filter. Can anyone help?
I tried the following filter in the having section: first_seen>44743
44743 is the numeric version of 1st July, 2022. but it returns also data with June.