How to filter on tags in the Reports module?

In Spotler CRM, you can select records in a report based on their tags, for example all accounts with a specific account tag. You do this with a rule on the Tags field in the criteria of a report, in the Segmentation step or under Report Criteria when you edit a saved report. You can select one tag or several tags in the same rule.

To filter a report on tags, add a rule in the criteria of the report, choose the object the tag belongs to, select the field Tags, choose an operator such as Is one of, and select one or more tags as the value.

How do you filter a report on tags?

A tag always belongs to one object, such as Account or Contact. In the rule, you first choose that object and then its Tags field.

  1. Open the Segmentation step of a new report, or Report Criteria on the Edit Report page of a saved report.
  2. Add a rule.
  3. Under Object, choose the object the tag belongs to, for example Account for an account tag or Contact for a contact tag.
  4. Under Field, select Tags.
  5. Under Operator, choose Is one of to select records with one of the selected tags, or Is not one of to leave them out.
  6. Under Value, select one or more tags.

The report then shows the records that match the tag, together with any other rules you set.

Report Criteria with a rule on Account, Tags, Is one of and a selected tag

How do you show tags as a column in a report?

Besides filtering on tags, you can show the tags of each record as a column in the report. In the Objects & Fields step, search for Tags under Choose Fields and select the tags field of the object you want, for example Account.Tags.

Choose the tag when you run the report

Select the Runtime checkbox in a rule on tags to choose the tag each time you run the report. This way, one report works for several tags. Runtime criteria are explained in How do I use runtime criteria?

A rule on tags works like any other rule, so you can combine it with other rules, groups and exclusions. How to build criteria is explained in How do I build criteria with groups, rules and exclusions? More information about reports is available in Reports.