Identifying repeat low performers in the past 6 weeks

I have a daily/weekly data set of all marketing campaigns I run online. The data is at a campaign level and I will need to identify and kill campaigns that have been consistently performing low over the past 6 weeks(<2.0% views). I am unable to do this efficiently on a excel. Any tips on how can I run this on a automated excel pivot or a macro would be highly appreciated. Please note, I run weekly 1,000+ online campaigns.

Data looks something like this:

Campaign ID  |  Impressions  |    Clicks  |     Views%(Impressions/Clicks)  |   Week#