Last updated: August 2, 2025

​
What are Query Templates

Query templates are pre-built Queries that enable you to quickly import data by simply selecting a topic (like Campaign Overview or Ad Performance) based on your chosen data source. These templates come with metrics, dimensions, and time frames already configured - it’s completely plug and play. This saves you significant time by eliminating the need to manually select metrics and dimensions, and prevents running into compatibility issues between different data fields.

​
Benefits of Using Query Templates

The main benefit is saving significant time. How?

No Manual Selection

Skip selecting individual metrics and dimensions. Everything is pre-configured and ready to use.

Zero Compatibility Issues

No more trial and error with incompatible field combinations. Templates are pre-tested to work perfectly.

Instant Data Import

Just pick your topic and run. What normally takes 5-10 minutes now takes seconds.

​
Using Query Templates

​
Step-by-Step Guide to Create a Query with Detrics Templates

1

Open Detrics Sidebar

In Google Sheets, go to Extensions → Detrics → Open sidebar
2

Choose Start from Template

Instead of clicking “New Query”, select Start from Template to access pre-built configurations
3

Select Your Data Source

Choose which platform you want to import data from: - Google Ads - Meta Ads - Google Analytics - And more…
4

Browse Available Templates

View templates available for your selected data source: - Campaign Performance - Track key campaign metrics - Budget Tracker - Monitor spending and ROI - Conversion Analysis - Deep dive into conversion data - Creative Performance - Analyze ad creative effectiveness
5

Select and Apply Template

Click on the template that matches your needs. The template will automatically configure: - All necessary metrics - Compatible dimensions - Appropriate date ranges - Relevant filters
6

Customize if Needed

While templates work great out of the box, you can still: - Adjust the date range to your needs - Add additional metrics or dimensions if desired - Modify filters to focus on specific data - Change the output location in your sheet
7

Run the Query

Click Run Query to import your data. The template ensures everything works smoothly without compatibility issues.

​
Customizing Templates

​
Editing Template Settings

While templates come pre-configured, you have flexibility to customize them:
  1. Date Range: Adjust to any period you need
  2. Additional Metrics: Add extra metrics to the pre-selected ones
  3. Extra Dimensions: Include additional breakdown dimensions
  4. Filters: Apply filters to focus on specific campaigns, ad groups, etc.
  5. Output Location: Choose where in your sheet the data appears

​
Template Names

Each template has a descriptive name that tells you:
  • What type of report it creates
  • Which metrics it focuses on
  • The intended use case
Templates typically focus on:
  • Campaign Overview - High-level campaign metrics and performance
  • Ad Performance - Detailed analysis of individual ad effectiveness
  • Traffic Sources - Breakdown of where your traffic comes from
  • Conversion Analysis - Deep dive into conversion metrics and funnel performance
  • Budget & Spend - Track spending patterns and budget utilization
  • Audience Demographics - Understand who your ads are reaching

​
Go the Extra Mile

Take your Query templates to the next level:

Import/Export Queries

Export Queries to other sheets so you don’t have to recreate Queries from scratch. Learn about importing/exporting →

Scheduled Queries

Set up automatic data updates for your template Queries. Keep your reports fresh without lifting a finger. Set up scheduled queries →
Need help? If you encounter issues with templates or have questions about available options, please reach out to support@detrics.io