Daily business totals
Return dated counts such as accepted inquiries or completed onboarding events. The query determines which records qualify, so agree the business rule with the client before making it a report headline.
Google BigQuery + Monthwrap
Databases & warehouses reporting
Bring the client’s own definition of a result into the report.
Use a saved BigQuery query to bring dated business metrics into Monthwrap, alongside advertising, website results and the agency’s work.
AvailableService-account key and saved query
Inside the monthly reportSample data
Harbour Software · fictional example
Qualified inquiries, as the client defines them
Qualified inquiries138Total across the four sample dates
Previous comparison112An equivalent four-day sample
Change+26Same query definition
Query resultsMonthly report
| Record | Reported numbers |
|---|---|
| 2026-10-01 | 24 inquiries |
| 2026-10-02 | 38 inquiries |
| 2026-10-03 | 31 inquiries |
| 2026-10-04 | 45 inquiries |
The agency’s query defines qualification. These sample totals are custom numbers, not an automatic BigQuery lead-quality assessment.
Google BigQuery, at a glance.
- Connect with
- Service-account key and saved queryUses a service-account JSON key with read and query-job permissions. Preview and save a dated numeric query for the client. Google Cloud query costs apply.
- Updates
- Daily sync, with a manual refresh in Sources. Platform reporting delays still apply.
- Earlier months
- Run the saved reporting query for an earlier month, using the history retained in your database.
- In your report
- Business metrics defined by the client’s warehouse query.
Built around your client’s questions
Keep the definition your client already trusts.
For agencies whose clients already organise marketing and business data in Google BigQuery.
A client may already combine advertising, CRM and operational data in BigQuery. The number they use internally could be qualified inquiries, activated accounts or accepted orders, with rules that a standard platform conversion does not capture. Bring that agreed measure into the monthly report instead of recreating it in a spreadsheet.
Monthwrap’s BigQuery path uses a saved query to return a date and numeric columns. Those columns become custom report metrics that can sit beside connected platform results and your work log. The agency supplies the query and explains the definition; Monthwrap does not guess how the client’s warehouse tables relate.
Choose the numbers that matter
What Google BigQuery
brings to the report.
Business metrics defined by the client’s warehouse query. Choose the relevant figures, add comparisons where the data supports them, and explain what changed.
Values with a defined meaning
Return a numeric amount when the client has a trusted value measure. Give the column a clear label and money setting, preserving its currency and meaning rather than calling every amount revenue.
Comparable periods
Use the reporting start and end parameters to query the relevant dates. Keep the definition consistent across months so a change in SQL logic is not mistaken for a change in performance.
Custom report metrics
Each numeric result column becomes an agency-defined number for metric widgets. Names should describe the measure clearly; the connection does not automatically import a full warehouse schema or customer record view.
For your next client report
Report the agreed quality measure
Place the client’s qualified-inquiry count beside advertising conversions. Explain the qualification rules and why the totals differ, instead of treating every platform action as an accepted sales lead.
Arrange the report in your own layoutRead it from the client’s side
See the complete
paid advertising report.
A full fictional agency report, with the work delivered, the numbers behind it and the plan for next month. Use its structure to plan your own mix of sources and client results.
Open the sample reportMake the connection
From Google BigQuery
to the right client.
Uses a service-account JSON key with read and query-job permissions. Preview and save a dated numeric query for the client. Google Cloud query costs apply.
Connection methodService-account key and saved queryAvailabilityAvailableYour connected account’s API permissions and plan apply.
- 01
Prepare read access with the client
The client prepares a service-account JSON key with BigQuery Data Viewer access to the required data and BigQuery Job User permission to run queries. Limit access to the reporting data the agency needs.
- 02
Choose the query project and location
An owner or admin enters the service-account key and, where needed, the project and dataset location. This is a service-account connection, separate from Monthwrap’s Google sign-in routes.
- 03
Preview and save a dated numeric query
Write one SELECT, optionally using WITH, with a date first and numeric columns after it. Use {start} and {end}, review the preview and resolve format problems, then save the query on the client’s source before syncing.
Know what each
number means.
Bring aggregates, not entire customer tables
The supported output is daily numeric results. Text dimensions, customer records and label-and-value top lists are not supported report imports. Aggregate the relevant records before returning the result.
Query execution uses the client’s project
BigQuery usage belongs to the selected project. Queries are capped at 10 GB and 30 seconds with at most 5,000 returned rows; review query scope and cloud usage with the client.
Before you connect
A few useful
answers.
Do I connect BigQuery with Google sign-in?
No. This route uses the client’s service-account JSON key and reporting permissions. It is separate from Google sign-in used by sources such as Analytics or Search Console.
Does Monthwrap write the business logic for us?
The agency or client supplies the SQL and agrees the metric definitions. A query preview helps check the returned dates and numbers before the query is saved.
Does a query preview import the numbers?
No. Preview checks the query for the selected dates and shows sample rows, metric names and format problems without saving or syncing. Save the checked query on the client source, then sync its results before adding them to a report.
Start with your next client report
The data has a source.
The story has your name.
Bring your sources together, choose your layout and add the context your client needs.
Start free trial14-day free trial. No card needed.