Case Study: Sightly achieves 300% increase in ad engagement and saves 80 hours/month with Google Cloud Platform (BigQuery)

Video Producer Makes AdWords Sizzle with Google BigQuery

Sightly, a video production company that also manages Google AdWords campaigns for clients, needed a more powerful analytics solution to combine AdWords performance data with client information (location, business type, etc.). Their existing Excel/SQL Server setup required two full-time staff and about 80 hours per month to compile and analyze data, limiting their ability to target campaigns quickly and effectively.

Sightly implemented Google BigQuery (with Metric Insights software) to load AdWords API data alongside customer records and run near–real-time analyses. The change let the team pinpoint factors driving success and apply insights immediately—tripling viewer engagement (300% increase), saving roughly 80 hours per month, and eliminating ongoing system-scaling and maintenance tasks.

Sightly

John Zdanowski

Co-Founder and Chief Financial Officer