Row filters let you keep only the rows that match every rule you set on a tab. They are optional, work the same across most data sources, and leave existing exporters unchanged when left empty.
What row filters do
After SyncRange fetches data and maps your selected columns, row filters decide which rows are written to Google Sheets, BigQuery, or Excel. Each rule picks a column, an operator, and (when needed) a value. A row is kept only if it matches all rules on that tab.
Empty filters export every row for that tab (same as before filters existed).
Filters are saved per tab. Orders can use different rules than Products on the same exporter.
Text comparisons are case insensitive (for example, Paid matches paid).
Filtering does not change your date range, append vs replace, or schedule.
How to add filters
Open an exporter to create or edit it, then select the tab you want to filter.
Under the column picker, find Row filters.
Click Add filter.
Choose a column, an operator, and a value if the operator needs one.
Click Done (or press Enter) to lock the rule. Use the pencil to edit later, or ✕ to remove it.
Save the exporter. The next run (scheduled or Run now) applies the rules.
Rules show as a short summary when locked so you do not edit them by accident. Add stays at the top of the block.
Operators
Operator
Keeps a row when…
Value
Equals
The cell matches the value exactly (case insensitive)
Required
Does not equal
The cell does not match the value
Required
Contains
The cell includes the text
Required
Does not contain
The cell does not include the text
Required
Is empty
The cell is blank
Not used
Is not empty
The cell has any value
Not used
Is any of
The cell matches one of the listed values
Comma-separated list (for example paid, pending)
Multiple rules are combined with and. For example, Status Equals paid and Country Equals US keeps only paid US rows.
Row filters vs Shopify filters
On Shopify Orders and Line Items, SyncRange also offers Shopify filters. Those are different from row filters:
Shopify filters run first, at fetch time, against Shopify’s order search (status, tags, location, and similar). They reduce which orders are pulled from Shopify.
Row filters run second, after fetch, on the mapped export columns. They further trim which of those rows are written to your destination.
You can use both on the same tab. SyncRange applies Shopify filters first, then row filters on that result. The sheet or table only gets rows that pass both. See
Configure Shopify
for Shopify filter details.
Google Ads and Bing Ads
For Ads reports that export multiple dimensions (for example Campaign and Device), the same filter rules are saved once for the report. On each sheet, SyncRange only applies rules whose column exists on that sheet. A Campaign filter runs on the Campaign sheet; it does not empty the Device sheet.
Metric filters (for example Impressions is not empty) apply on every dimension sheet that includes that metric.
Tips
Prefer a specific column from that tab’s column list. Operators compare against the value that would appear in the export for that column.
Use Is any of instead of many Equals rules when you need several allowed values.
Start with one rule, run the export once, then add more rules if needed.
Filters reduce rows written to your destination. That can lower sheet size and monthly row usage when you only need a subset of data.
Source-specific options (campaign pickers, platform checkboxes, date presets) still apply before or alongside row filters. See each integration’s configure guide for those controls.
Install on Shopify