The Challenge
Marketing teams depend on accurate, timely data to make campaign decisions—but getting that data into dashboards is rarely seamless. When data pipelines require manual execution, the consequences compound quickly:
- Dashboards display yesterday’s numbers while today’s campaigns run blind
- Analysts spend hours each morning running queries and copying results rather than analysing them
- Campaign optimisation lags behind reality, costing budget and conversions
- Data inconsistencies emerge when multiple team members run the same queries at different times
The larger your data volume across platforms, the worse this problem becomes. What should be an insight-generation activity turns into a mechanical data-fetching exercise.
The Autohive Solution
Autohive’s Google BigQuery integration transforms dashboard population from a manual chore into a fully automated workflow. By connecting BigQuery’s SQL execution capabilities directly to your automation layer, your dashboards stay current without anyone lifting a finger.
Automated SQL Query Scheduling
Configure Autohive agents to execute SQL queries on any schedule—hourly, daily, or triggered by specific events. Queries aggregate impressions, clicks, conversions, and spend across all your campaign data sources in one pass.
Multi-source Data Aggregation
Write a single SQL query that joins data from multiple BigQuery tables—Google Ads, Meta, TikTok, email platforms—and return unified metrics ready for dashboard consumption. No more running separate queries per channel.
Streaming Results to Staging Tables
Rather than exporting raw query results, Autohive streams the processed output directly into BigQuery staging tables using the streaming insert API. Downstream dashboard tools connect once and always see fresh data.
Asynchronous Job Handling
For large-scale queries covering months of data, Autohive obtains a job reference and polls for completion automatically—so your workflow doesn’t time out and results are captured reliably regardless of query duration.
Benefits
- Always-fresh dashboards – Marketing stakeholders see current metrics without waiting for manual refreshes
- Hours reclaimed daily – Analysts shift from data pulling to data interpreting
- Consistent methodology – The same SQL logic runs every time, eliminating human variation
- Faster campaign decisions – Optimisation based on today’s data, not yesterday’s
- Scalable across channels – Add new data sources to existing queries without rebuilding workflows
How It Works
- Define your SQL queries – Write the aggregation queries that power your dashboards, specifying the metrics, dimensions, and date ranges you need
- Schedule your Autohive agent – Set the execution frequency (e.g., every morning at 6 AM) or trigger on a data-availability event
- Execute and retrieve results – The agent calls BigQuery’s SQL execution action; small queries return results immediately, large queries receive a job reference for async handling
- Stream into staging tables – Processed results are inserted into your BigQuery staging tables using the streaming insert API, making data immediately queryable
- Dashboards self-update – Your BI tools (Looker, Data Studio, Tableau, etc.) query the staging tables and reflect the latest data automatically
Getting Started
- Sign up at app.autohive.com
- Connect the Google BigQuery integration from the Autohive marketplace
- Configure your SQL queries and staging table targets
- Set your automation schedule and deploy your agent
