Google Sheets

Running Queries

Define and execute queries to pull data from your connected sources into Google Sheets.

Data Queries are the core of Two Minute Reports. They define exactly what data to pull from your connected sources and where to place it in your Google Sheets.

Before You Start

Make sure you have:

Installed the TMR add-on in your Google Sheets
Connected at least one data source through the Connections section
Set up any accounts or credentials your data sources require

Creating a New Query

Open Data Queries

In the TMR sidebar, click Menu at the top left and navigate to Data Queries. Click Add to create a new query.

Name Your Query

Give your query a descriptive name (for example, "Facebook Ads - November 2024" or "Google Analytics - Traffic Report"). This helps you organize and identify your queries later.

Select Data Source and Account

Choose which connector and account you want to pull data from. If you've connected multiple accounts with a single connector, you can select one or more accounts for your query.

Choose Metrics and Dimensions

Metrics are the numbers you want to measure (clicks, impressions, revenue, conversions, etc.)
Dimensions are how you want to segment that data (by campaign, date, platform, etc.)

Select the metrics and dimensions relevant to your report. Different data sources offer different options.

Set Your Date Range

Choose the time period for your data. You can select:

Predefined ranges (Last 7 days, Last 30 days, Last 90 days, etc.)
Custom date ranges
Dynamic ranges that automatically adjust

Data appears in a formatted table in your sheet
You can customize the presentation using Google Sheets formatting (colors, fonts, charts)
Each time you re-run the query, it refreshes with the latest data

Tips for Effective Queries

Keep queries focused - Pull only the metrics and dimensions you need to avoid large, slow-loading sheets
Use descriptive names - Make it easy to understand what each query does months later
Test your filters - Verify that filters produce the expected results before setting up automated schedules
Combine queries strategically - Multiple focused queries are often better than one large query for performance and readability

Reusing and Duplicating Queries

You can duplicate an existing query to create variations quickly:

In the My Reports section, find the query you want to duplicate
Click the duplicate option to create a copy with the same configuration
Modify the copy as needed (different date range, metrics, etc.)

This is especially useful for creating reports for multiple clients or campaigns with similar data structures.

Common Issues

If your query returns no data or unexpected results, check:

That your data source account has data for the selected date range
That all required permissions are granted to your data source account
That your filters aren't too restrictive
That your date range is valid for your data source

Contact support if issues persist.

Next Steps

Schedule auto-refresh — keep your data updated automatically
Manage your reports — organize and duplicate queries across spreadsheets

Installation Guide

Install Two Minute Reports add-on in Google Sheets in a few simple steps.

Scheduling Auto-Refresh

Set up automated data refreshes and email reports to keep your dashboards current.