Filters and Hyperlinks
All reports in CaliberMind can be filtered dynamically by modifying the URL in your web browser. Reports have default filters, but filters can be overridden by the URL. This is useful for creating hyperlinks in Slack or from your CRM.
What are Report Filters?
Each reporting category in CaliberMind focuses on different parts of your database. If you're looking at on Opportunity Report, for instance, you eventually may wish to filter your report by "Opportunity Type", such as 'New Business' and 'Renewal'. Report filters are designed to do just that! As you can see in the report below, we're looking at a specific campaign id 70150000000y2OMAAY. Since this report is inspecting a campaign's performance over a certain date range -- we may wish to share or hyperlink to versions of this report looking at different campaigns over different date ranges.Filters can also be modified in line, saved as a default, or saved in a setting in a new report.
Report URLs & Hyperlinks
- Looking up campaign performance by URL:
- ?item= selects which report is being used
- &campaign= sets a campaign id in the filter for the report
Formula fields in Salesforce
Include formulas on Accounts, Leads, Contacts, Campaigns, and more!
- The example below would open up the [CaliberMind ABM - Activity Overview Report] in a new window from an account record and display a hyperlink "View in CaliberMind":
This example looks an account up by web domain:
HYPERLINK("https://my.calibermind.com/analytics/abm?item=activity-overview&company_domain=" & substitute( substitute( substitute(Website,"https://","") ,"http://","") ,"www.","") ,"View in CaliberMind")
This example looks an account up by Account Id:
HYPERLINK("https://my.calibermind.com/analytics/abm?item=activity-overview&company_id="&Id,"View in CaliberMind")