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

# Understanding the 6-Minute Limit in Looker Studio

> Learn why data requests fail and how to work with large datasets effectively

<Info>**Last updated:** December 5, 2025</Info>

If you're seeing an error in Looker Studio due to a request taking too long, you've hit a platform limitation. This guide explains why it happens and how to work around it.

## Why Does This Happen?

Looker Studio uses Google Apps Script to fetch data from connectors. Google enforces a **strict 6-minute execution limit** on all Apps Script functions. This is a Google platform limitation, not a Detrics limitation.

When your data request takes longer than 6 minutes to process, Google terminates the request and Looker Studio displays an error.

<Note>
  This limit applies to **all** community connectors in Looker Studio, not just Detrics.
</Note>

## What Causes Requests to Exceed the Limit?

Several factors can cause your requests to approach or exceed the 6-minute limit:

| Factor                   | Impact    | Example                                                      |
| ------------------------ | --------- | ------------------------------------------------------------ |
| **Large time frames**    | High      | Requesting 12 months of daily data vs. 30 days               |
| **Multiple accounts**    | High      | Pulling data from 20+ ad accounts in one chart               |
| **Ad-level granularity** | Very High | Requesting individual ad data instead of campaign-level      |
| **Complex platforms**    | Medium    | Meta Ads and TikTok Ads typically have more data per request |
| **No filters applied**   | Medium    | Fetching all campaigns vs. only active ones                  |

<Warning>
  **Meta Ads** and **TikTok Ads** are particularly prone to exceeding this limit due to their data volume and API response times. If you're working with these platforms and large accounts, consider the solutions below.
</Warning>

## Quick Fixes

Try these adjustments to reduce request time:

<Steps>
  <Step title="Reduce your time frame">
    Instead of "Last 12 months", try "Last 30 days" or "Last 7 days". You can always create separate charts for historical comparisons.
  </Step>

  <Step title="Reduce the number of accounts">
    If you're pulling data from multiple accounts, split them across separate data sources or pages.
  </Step>

  <Step title="Avoid ad-level data">
    Use campaign or ad set level granularity instead of individual ads. Ad-level data significantly increases response times.
  </Step>

  <Step title="Apply filters">
    Filter by campaign status (active only), specific campaign names, or other criteria to reduce the data volume.
  </Step>
</Steps>

## The Best Solution for Large Data Volumes

For large accounts, many accounts, or when you need historical data, the most reliable approach is to use **Google Sheets as an intermediary layer** between your data sources and Looker Studio.

<Steps>
  <Step title="Data Sources" icon="database">
    Facebook Ads, Google Ads, TikTok Ads, etc.
  </Step>

  <Step title="Detrics for Google Sheets" icon="arrow-right">
    Pull data with scheduled queries (no time limits)
  </Step>

  <Step title="Google Sheets" icon="table">
    Data stored and refreshed automatically
  </Step>

  <Step title="Looker Studio" icon="chart-line">
    Instant data loading from Sheets
  </Step>
</Steps>

### Why This Works Better

| Direct Connector                     | Sheets → Looker                               |
| ------------------------------------ | --------------------------------------------- |
| 6-minute limit per request           | No time limit - queries run in background     |
| Data fetched on every dashboard load | Data cached in Sheets, Looker reads instantly |
| Fails with large datasets            | Handles any data volume                       |
| One account per data source          | Combine multiple accounts in one sheet        |

### How to Set It Up

<Steps>
  <Step title="Get your data into Google Sheets">
    Use [Detrics for Google Sheets](/quickstart/google-sheets) to create queries that pull your marketing data. Set them to refresh automatically on a schedule.
  </Step>

  <Step title="Connect Sheets to Looker Studio">
    In Looker Studio, add a new data source and select "Google Sheets". Choose the spreadsheet containing your Detrics data.

    <Frame>
      <img src="https://mintcdn.com/detrics-4688583d/sJEpkiQHalBhsdVn/images/looker-studio/sheets-as-source.png?fit=max&auto=format&n=sJEpkiQHalBhsdVn&q=85&s=4293bae7b942dc9ec8f7f7981ef19b02" alt="Connect Google Sheets as a data source in Looker Studio" width="641" height="510" data-path="images/looker-studio/sheets-as-source.png" />
    </Frame>
  </Step>

  <Step title="Build your dashboard">
    Create your visualizations using the Sheets data source. Since the data is already in Sheets, Looker loads it instantly.
  </Step>
</Steps>

<Tip>
  **Pro tip**: Schedule your Sheets queries to refresh overnight. Your Looker Studio dashboards will have fresh data every morning with zero wait time.
</Tip>

## Benefits of the Sheets Approach

<CardGroup cols={2}>
  <Card title="No Time Limits" icon="clock">
    Sheets queries run in the background without the 6-minute limit. Large historical pulls complete successfully.
  </Card>

  <Card title="Faster Dashboards" icon="bolt">
    Looker reads from Sheets instantly. No waiting for API calls every time you view the dashboard.
  </Card>

  <Card title="Combine Data Sources" icon="layer-group">
    Merge data from multiple platforms and accounts in a single sheet, then visualize in Looker.
  </Card>

  <Card title="Custom Calculations" icon="calculator">
    Add formulas in Sheets to create custom metrics before they reach Looker Studio.
  </Card>
</CardGroup>

## When to Use Each Approach

| Scenario                          | Recommended Approach    |
| --------------------------------- | ----------------------- |
| Small accounts, short date ranges | Direct Looker connector |
| Real-time data needed (hourly)    | Direct Looker connector |
| Large accounts (Meta, TikTok)     | Sheets → Looker         |
| Historical data (3+ months)       | Sheets → Looker         |
| Multiple accounts combined        | Sheets → Looker         |
| 50+ accounts                      | Sheets → Looker         |

## Still Experiencing Issues?

If you've tried these solutions and still encounter problems:

1. Check your internet connection stability
2. Try refreshing during off-peak hours
3. Contact [support@detrics.io](mailto:support@detrics.io) with details about your setup

<Tip>
  **Need help setting up the Sheets workflow?** Our support team can guide you through the process. Reach out at [support@detrics.io](mailto:support@detrics.io)
</Tip>