In digital marketing dashboards, metrics aren’t always ready to use as-is. Query Metrics pull data directly from a source such as Meta Ads or Google Ads, with filters applied to segment the information. Calculated Metrics, on the other hand, are derived metrics built using formulas that combine one or more existing metrics. Understanding the differences between Query Metrics and Calculated Metrics in marketing dashboards is essential for designing reports that are accurate, flexible, and useful for decision-making.
What are Query Metrics and Calculated Metrics, and what are they for?
Both types of metrics serve different purposes within a dashboard. Query Metrics connect directly to the original data source and allow information to be segmented by criteria such as country, device, campaign, or time period. Calculated Metrics go a step further: they combine data from one or several sources to generate custom indicators that platforms don’t provide natively.
These concepts are especially relevant for:
- Digital marketing agencies that manage multiple clients and platforms simultaneously.
- Performance managers who need to consolidate metrics from Meta Ads, Google Ads, and LinkedIn Ads into a single report.
- Agency directors making strategic decisions based on combined KPIs.
- Freelancers building custom dashboards for their clients without advanced BI tools.
What are Query Metrics?
A Query Metric is a metric pulled from a single data source. It’s queried directly from the source platform—Meta Ads, Google Ads, LinkedIn Ads, TikTok Ads, GA4, among others—and can include filters to segment the results.
Key features of Query Metrics
- They come from a single data source.
- They allow filters by dimensions such as country, device, campaign, or ad group.
- They reflect data exactly as reported by the platform.
- They’re the foundation on which Calculated Metrics are built.
- They have a low setup complexity.
Examples of Query Metrics
- Clicks on Meta Ads segmented by country.
- Impressions of a specific campaign in Google Ads.
- Spend on LinkedIn Ads over the last month.
- Conversions from mobile devices in TikTok Ads.
- Organic sessions recorded in GA4 by channel.
What are Calculated Metrics?
A Calculated Metric is a custom metric built from a mathematical formula. It can combine two or more Query Metrics, or even other Calculated Metrics. Its purpose is to generate indicators that no platform provides directly.
Key features of Calculated Metrics
- They’re created through mathematical operations: additions, subtractions, divisions, multiplications, or combinations of these.
- They can combine data from multiple sources into a single value.
- They allow you to build custom strategic KPIs.
- They require more elaborate initial setup.
- They’re reusable across different reports and dashboards.
Examples of Calculated Metrics
- Total spend: Meta Ads spend + Google Ads spend + LinkedIn Ads spend.
- Combined ROAS: Total revenue / Total spend across all platforms.
- Overall conversion rate: Total conversions / Total clicks × 100.
- Consolidated CPA: Total spend / Total conversions.
- Paid vs. organic impressions ratio: Paid impressions / Organic impressions.
Differences between Query Metrics and Calculated Metrics in marketing dashboards
The table below summarizes the key differences between both types of metrics to help you decide which one to use in each situation:
| Criteria | Query Metrics | Calculated Metrics |
|---|---|---|
| Data source | A single platform | One or multiple platforms |
| Retrieval method | Direct extraction with filters | Custom mathematical formula |
| Setup complexity | Low | Medium to high |
| Customization | Limited to available filters | High: any mathematical operation |
| Typical use cases | Analysis by campaign, country, or device | Global KPIs, consolidated ROAS, combined CPA |
| Dependency | Independent | Depends on prior Query Metrics |
| Native availability in platforms | Yes | No (built within the dashboard) |
How to combine Query Metrics and Calculated Metrics in a dashboard, step by step
- Identify the data sources you need to connect. Determine whether the report requires data from a single platform or from several, such as Meta Ads and Google Ads at the same time.
- Define your base Query Metrics. Set up the metrics you’ll pull directly from each platform, applying the necessary filters by campaign, period, or dimension.
- Identify the KPIs that don’t exist natively. Determine which strategic indicators you need that no platform reports on its own, such as total spend or consolidated ROAS.
- Build your Calculated Metrics with clear formulas. Write the mathematical operation that combines the Query Metrics defined in the previous step. Document each formula to make maintenance easier.
- Check the consistency of the data. Compare the values of the Calculated Metrics against the individual data from each platform to confirm the formula works correctly.
- Organize the dashboard by level of analysis. Place Query Metrics in detail sections and Calculated Metrics in the executive or overall summary view.
- Automate data updates. Use a tool like Master Metrics so connections to each platform update automatically, without manual intervention.
Query Metrics and Calculated Metrics vs. configuration alternatives in reporting tools
Not every dashboard tool implements these concepts in the same way. The table below compares how the leading options on the market approach metric customization:
| Criteria | Master Metrics | Looker Studio | Supermetrics | AgencyAnalytics |
|---|---|---|---|---|
| Query Metrics with filters | Yes, native | Yes, with connectors | Yes, via add-on | Yes, limited by plan |
| Calculated Metrics across platforms | Yes, built in | Partial (per source) | Yes, with additional setup | Limited |
| Learning curve | Low | Medium | Medium-high | Low |
| Automatic data updates | Yes | Depends on the connector | Yes | Yes |
| Agency-oriented | Yes | Not specifically | Partially | Yes |
Frequently asked questions about Query Metrics and Calculated Metrics in marketing dashboards
Can a Calculated Metric depend on another Calculated Metric?
Yes. You can build composite Calculated Metrics that use other calculated metrics as an input. For example, you might first create a “Total spend” metric and then use it within a “Consolidated ROAS” formula. This practice is useful for keeping formulas organized and easy to maintain, but it requires clearly documenting the dependency hierarchy.
Do Query Metrics affect dashboard performance?
Yes, to some extent. Each Query Metric represents a query to the original data source. If a dashboard has many active Query Metrics with complex filters, load time can increase. Well-optimized tools, like Master Metrics, manage these queries efficiently to minimize the impact on report speed.
Can I use Calculated Metrics to compare different time periods?
Yes. This is a common practice among marketing agencies. You can create calculated metrics that compare current month spend or conversions against the previous month. To do this, you first need to define Query Metrics with the corresponding date filters, and then build the formula for the variation or difference between the two.
What common mistakes are made when setting up Calculated Metrics?
The most common mistakes are: dividing by zero when a base metric has no data, mixing metrics from different attribution windows without adjusting them first, and combining data from platforms with different currencies without applying a prior conversion. Reviewing the logic of each formula before publishing the dashboard prevents most of these issues.
Do Calculated Metrics work the same way in every dashboard tool?
No. Each tool implements calculated metrics with its own syntax rules and limitations. In Looker Studio, for example, formulas are applied within a single data source, which makes it difficult to combine Meta Ads and Google Ads metrics in the same calculated field. Tools built specifically for agencies solve this limitation natively.
When is it best to use only Query Metrics without adding Calculated Metrics?
Query Metrics are enough when the analysis focuses on a single platform and the indicators you need are available natively. If a client only invests in Google Ads and needs to see clicks, impressions, and conversions by campaign, Query Metrics with filters cover that case without the need for additional formulas.
How does Master Metrics help manage Query Metrics and Calculated Metrics?
Master Metrics centralizes connections to platforms like Meta Ads, Google Ads, LinkedIn Ads, TikTok Ads, and GA4 in a single environment. From there, you can set up Query Metrics with custom filters and build Calculated Metrics that combine data from multiple sources without needing to export spreadsheets or manually program connectors. This reduces report setup time and ensures data updates automatically for all of an agency’s clients.
Conclusion
Query Metrics and Calculated Metrics are complementary, not mutually exclusive. The first provide segmented, accurate data from each platform. The second transform that data into strategic indicators that no tool provides natively. Mastering both concepts allows you to build dashboards that answer real business questions, not just display numbers.
For an agency managing multiple clients and platforms, manually setting up these metrics in spreadsheets or generic tools consumes valuable time and creates a risk of error. Automating that process with a solution like Master Metrics—where connections, filters, and formulas are configured once and update on their own—frees the team to focus on analysis and strategy, which is where real value is generated for the client.
If your agency still spends hours consolidating data from different platforms before it can analyze campaign performance, now is the time to review how you structure your metrics and which tool can support that process.
