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:
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.