Skip to main content
Every Detrics query is built from the same two ingredients, regardless of the destination you use:
  • Dimensions are text attributes that group your data: campaign name, country, device, date
  • Metrics are the numbers measured for each group: spend, impressions, clicks, conversions

​
How They Shape Your Results

Each row in your results is one unique combination of your selected dimensions, with the metrics calculated for that combination.
  • Query Campaign Name + Spend: one row per campaign
  • Query Campaign Name + Country + Spend: one row per campaign and country pair
  • Query Spend with no dimensions: a single totals row
Adding a dimension multiplies the level of detail. Removing dimensions rolls the numbers up.

​
Not Every Combination Is Available

Detrics exposes what each platform’s API supports, and platforms restrict which fields can be combined. For example, some Meta Ads breakdowns can’t be mixed with each other, and some TikTok metrics aren’t available with hourly aggregation. When a combination isn’t supported, Detrics tells you at query time instead of returning misleading data. Each platform’s page in the Fields Catalog lists the available fields, and the per-platform troubleshooting pages cover the most common incompatibilities.

​
Split a Dimension into Columns

In the Google Sheets sidebar you can mark a dimension as a split dimension. Instead of adding rows, its values become column groups. For example, splitting by Device turns a long table into one row per campaign with metric columns for Mobile, Desktop, and Tablet side by side. This is a layout feature for spreadsheets: the underlying data is the same as the row-based version, just pivoted for readability.

​
Next Steps

Date Ranges & Time Aggregation

Control the period your query covers and how it’s broken down over time

Filters

Keep only the rows you care about