Working with data tables
Every data table in Explore and Reports supports a consistent set of features. Once familiar with them, the same patterns apply across every dashboard in the product.
Features at a glance
Section titled “Features at a glance”| Feature | Action |
|---|---|
| Sort | Click a column header. Click again to reverse the sort. |
| Filter | Filters appear above the table; they apply to the entire dashboard, not just the table. |
| Search | Search box (above the table) matches against the primary item column — product name, campaign name, customer name. |
| Pagination | Tables paginate for large catalogs. Page controls appear at the bottom. |
| Tabs | Switch between breakdown levels (e.g. Products vs Variants) without changing controls. |
| Export | Downloads the current view as a CSV file. |
Sorting and search
Section titled “Sorting and search”Click any column header to sort by that column. Click again to reverse the sort. Sort order is preserved across pagination but resets when switching tabs.
Search matches against the primary item column. Use it to find a specific product, campaign, or customer without paging through the table.
Filters
Section titled “Filters”Filters live above the table and apply to the entire dashboard — headers, trend chart, drilldown, and the table itself all recompute when a filter is applied. This makes filters a more powerful tool than search: they constrain the population every metric reads from.
Common filter dimensions: channel (DTC, Marketplaces), product type, campaign tag, customer segment. The exact set varies per dashboard.
Tabs above a data table switch between breakdown levels of the same dashboard. Date range, comparison, group-by, filters, and headline tiles remain unchanged when switching tabs — only the table contents change.
| Dashboard | Tabs |
|---|---|
| DTC dashboard | Products · Variants · Product Type · Vendor |
| Amazon dashboard | Parent ASIN · Child ASIN |
| Paid Media dashboard | Platforms · Campaigns |
When to use which tab
Section titled “When to use which tab”- Start at the most aggregated level (Products, Parent ASIN, Platforms). It loads fastest and surfaces top contributors.
- Drop to the more detailed level (Variants, Child ASIN, Campaigns) when investigating a specific item or to confirm parent-level aggregations.
Exporting to CSV
Section titled “Exporting to CSV”Data tables include an export action that downloads the current view as a CSV file. The download is a plain-text .csv (comma-separated) — not an Excel workbook — but both Excel and Google Sheets can open it directly.
- Set the view first: date range, comparison, filters, tab.
- Scroll to the table. The export action is near the top-right.
- Click export. The file downloads.
- Spot-check the file: column headers present, row count plausible, sample values correct.
What the export contains
Section titled “What the export contains”The export reflects the current view — the active date range, comparison, filters, and tab. Sort order is preserved.
Common destinations
Section titled “Common destinations”| Destination | Notes |
|---|---|
| Spreadsheet (Google Sheets, Excel) | Direct import — the CSV is standard |
| Data warehouse | Manual ingest, or use the warehouse export feature (Enterprise) |
| Internal scripts | Standard CSV; pandas, polars, and similar libraries handle it |
For format details (delimiter, encoding, date format) and a deeper look at CSV exports across the product, see CSV exports.
Limits
Section titled “Limits”- Tables show the workspace’s full data within the selected date range. Pagination and search are the way to navigate — there’s no separate “load more” action.
- Filters affecting the entire dashboard (date range, segment) apply to the table too.
Common questions
Section titled “Common questions”A row I expect to see isn’t there. Check filters first. Widen the date range if the filter is time-based.
Sort order looks wrong. Columns sort either alphabetically (product name) or numerically (revenue). Numeric sort places text and null values consistently — usually at the end.
Totals don’t reconcile between tabs. Confirm the same date range and filters apply. Tab-specific filters sometimes carry over from a previous session.
Expected tab is missing. The underlying datasource may not provide that breakdown — Amazon’s Parent / Child ASIN distinction only appears when the catalog hierarchy is set up; Pinterest Ads’ Ad Group tab only appears when ad-group-level data is enabled.
Troubleshooting
Section titled “Troubleshooting”- Download doesn’t start — check browser download permissions; try another browser.
- File is empty — widen the date range or remove restrictive filters.
- Values look like
#####in Excel — column width too narrow; widen the column. - Numbers in the CSV don’t match the dashboard — the dashboard may have refreshed since export. Re-open and re-export.