Filters and Hyperlinks

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 70150000000y2OMAAYa. 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.

Base URL

https://my.calibermind.com/analytics/attribution?item=campaign-detail

Additional Filters

&campaign=70150000000y2OMAAYa

Examples

  • Looking up campaign performance by URL:
    • ?item= selects which report is being used
    • &campaign= sets a campaign id in the filter for the report
https://my.calibermind.com/analytics/attribution?item=campaign-detail&campaign=70150000000y2OMAAYa

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")


How did we do?