Help Center/Reports & marketplace imports
Filter and query a report
Narrow a report with search, facets and quick views, add conditions with the guided builder or the Advanced syntax query language, ask Poppy to refine a query, pick columns and save views.
Every report in Dashboard → Reports has a filter bar above its metrics. Search and facets work on every plan. Conditions, the Advanced syntax query language and saved views come with the Extended reports add-on.
Whatever you filter applies to the Overview metrics, the worksheets and the downloads at once. Changes take effect when you click Apply.
Search, facets and quick views
- Open Dashboard → Reports and pick a report under Your reports.
- Type in the search box. Each report says what it searches, for example product, slug or brand.
- Add a facet filter, such as Brand, Store, Affiliate tag, Incoming tag, Link domain or Destination domain on the link reports. Pick a value; click the chip to change it or its x to remove it.
- Dated reports have a date range. They open on the Last 30 days.
- Click Apply. When nothing has changed, the same button reads Refresh.
Quick views sets several filters at once:
- All dates and Last 30 days on dated reports,
- Active links on Link performance,
- Links with conversions on Link performance (Extended reports).
Clear returns the report to its defaults.
Only this link
On Link performance, Links by affiliate tag and Traffic by date & audience, each row has Only this link. It narrows the whole report, including metrics, worksheets and downloads, to that one link.
Add conditions (Extended reports)
Click Conditions in the filter bar to open Build your report. It has two modes.
Guided
- Pick a Field, a condition (contains, is, is not, is greater than, is at least, is less than, is at most) and a Value. Yes/No fields offer Yes or No.
- Add it. Conditions appear as chips; remove one with its x.
- Click Apply.
All conditions must match (there is no OR). A report takes up to 12 conditions.
Advanced syntax
Advanced syntax is a small query language, close to ShopifyQL, for totals, breakdowns and charts. Press / anywhere on the page to jump into the editor. The editor highlights and completes field names, explains each keyword on hover, and has Insert field, Tidy layout, Undo and Redo.
Clauses are optional, each appears once, and they go in this order:
FROM links
SHOW count(), sum(tracked_clicks_lifetime)
GROUP BY store
WHERE status = "active" AND tracked_clicks_lifetime >= 10
ORDER BY sum(tracked_clicks_lifetime) DESC
LIMIT 10
VISUALIZE sum(tracked_clicks_lifetime) TYPE horizontal_bar
- FROM: the report you have open.
- SHOW: up to 8 metrics:
count(),distinct(field),sum(field),avg(field),min(field),max(field). Without GROUP BY you get one totals row. - GROUP BY: up to 3 fields. Date fields group per UTC day.
- WHERE … AND …: conditions, as in the guided mode. Text in quotes.
:means contains,=is,!=is not, and>,>=,<,<=compare numbers. - ORDER BY: up to 3 keys, a grouped field or a shown metric, ASC (default) or DESC.
- LIMIT: 1 to 1,000 rows.
- VISUALIZE … TYPE: the metric to chart and the chart type:
table,bar,horizontal_bar,line(the first GROUP BY must be a date) ornumber(no GROUP BY).
A query can be up to 2,000 characters. A bare list of conditions, such as store="amazon" tracked_clicks_lifetime>=1, still works and is read as WHERE.
Field names come from the report's columns, in lowercase with underscores (for example Tracked clicks (lifetime) becomes tracked_clicks_lifetime). Use Insert field to see the exact names for the open report.
Queries run on your workspace's own rows, after Pointerly has loaded them with your permissions. A query can filter and total your data; it can't reach anything else.
Ask Poppy to refine a query
Under the editor, type what you want in Ask Poppy to refine, for example only Amazon links with at least 10 clicks, and send it. Poppy rewrites the query; Pointerly checks it before putting it in the editor, so you always get a valid query. Review it, then click Apply.
Pick columns
Above the worksheet table, open the columns menu (Visible and exported columns) to hide or show columns, or Show all columns. The table and the downloads use your selection; the Overview metrics keep counting every matching record.
Click a column header to sort by it.
Save a view (Extended reports)
A saved view keeps the report, its filters, its query and your column selection.
- Apply the filters you want.
- Type a View name and click Save view.
- Open it later from Saved views. To remove one, type its name and click Delete named view.
Views are stored in this browser, up to 20 per workspace. They don't follow you to another browser or device, and teammates don't see them.
Customize the dashboard (Extended reports)
On a wide screen, Customize dashboard above the Overview metrics lets you rearrange the metric cards. Done keeps the layout; Reset goes back to the default. The layout is saved in this browser.
Troubleshooting
- "Correct the query syntax before applying filters.": the editor underlines the problem. A common cause is a clause out of order; the message names the expected order (FROM, SHOW, GROUP BY, WHERE, ORDER BY, LIMIT, VISUALIZE).
- "Add or cancel the unfinished condition first.": a guided condition is half filled. Finish it or cancel it.
- "Extended reports requires an active monthly add-on.": queries and the Traffic report need the add-on. See Reports overview.
- A
linechart doesn't draw: the first GROUP BY field must be a date. - My saved views are gone: views live in one browser. Clearing site data or switching browsers loses them.