> ## Documentation Index
> Fetch the complete documentation index at: https://support.detrics.io/llms.txt
> Use this file to discover all available pages before exploring further.

# How to Use Query Templates

> Save time with pre-built query templates that eliminate the need to manually select metrics and dimensions

<Info>**Last updated:** August 2, 2025</Info>

# 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?

<CardGroup cols={3}>
  <Card title="No Manual Selection" icon="hand-pointer">
    Skip selecting individual metrics and dimensions. Everything is
    pre-configured and ready to use.
  </Card>

  <Card title="Zero Compatibility Issues" icon="shield-check">
    No more trial and error with incompatible field combinations. Templates are
    pre-tested to work perfectly.
  </Card>

  <Card title="Instant Data Import" icon="bolt">
    Just pick your topic and run. What normally takes 5-10 minutes now takes
    seconds.
  </Card>
</CardGroup>

## Using Query Templates

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

<Steps>
  <Step title="Open Detrics Sidebar">
    In Google Sheets, go to **Extensions → Detrics → Open sidebar**
  </Step>

  <Step title="Choose Start from Template">
    Instead of clicking "New Query", select **Start from Template** to access
    pre-built configurations
  </Step>

  <Step title="Select Your Data Source">
    Choose which platform you want to import data from:

    * Google Ads
    * Meta Ads
    * Google Analytics
    * And more...
  </Step>

  <Step title="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
  </Step>

  <Step title="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
  </Step>

  <Step title="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
  </Step>

  <Step title="Run the Query">
    Click **Run Query** to import your data. The template ensures everything
    works smoothly without compatibility issues.
  </Step>
</Steps>

## 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

<CardGroup cols={2}>
  <Card title="Import/Export Queries" icon="arrow-right-arrow-left" href="/data-destination/google-sheets/how-to-import-export-queries">
    Export Queries to other sheets so you don't have to recreate Queries from
    scratch.
  </Card>

  <Card title="Troubleshooting Guide" icon="clock" href="/data-destination/google-sheets/how-to-automate-a-query">
    Set up automatic data updates for your template Queries. Keep your reports
    fresh without lifting a finger.
  </Card>
</CardGroup>

<Tip>
  **Need help?** If you encounter issues with templates or have questions about
  available options, please reach out to [support@detrics.io](mailto:support@detrics.io)
</Tip>