Trend Micro

I was tasked with hosting a VQL for a Trend Micro campaign, alongside creating a landing page and email series. The VQL presented a unique challenge in that we needed to capture user interactions while the VQL was in progress. I was able to accomplish this by utilizing Zapier along with the VQL platform itself, in sending those interactions to a google sheet for tracking. I then wrote formulas to compile the data and displayed it using Looker Studio as a deliverable for the client.

Landing Page & VQL

Email 2 Series