Tracking Website Activity: Weekly Summary Using Clay Web Intent

I am using Clay Web Intent to track activity on our website. I want to do a weekly summary of the most interesting cases. I know that each row represents one company in a 30 day window, later a new row is created. How to skip all the old rows in the table (old rows mean companies that have a new row because it is older than 30 days)?