Table of Contents

• How do I connect to Highrise?
• What fields are available for reporting?
• How do I build a report on deals?
• How do I build a report on cases?
• How do I build a report on tasks?
• How do I build a report on activities?
• How can I add custom fields?
• How much does Easy Insight reporting on Highrise cost?
• How do I report on tagged data in my Highrise system?

How do I connect to Highrise?

First, you need an Easy Insight account! If you don't already have an account, you can create one by clicking here. Once you've created an account, you'll either be taken directly to the Highrise connection page or to the standard application landing page. From the standard application landing page, you can install a connection to Highrise by clicking over to the Connections page, clicking on the Highrise button, and clicking on Get Started Now.

You'll need to enable API access to your Highrise account. You can enable this access from the Account (Upgrade/Invoice) page of your Highrise account. If this option is unavailable, you may need to contact your Highrise administrator.

At this point, you'll be prompted for your Highrise path and your API token. You can find your API token under the My Info page on your Highrise interface. Once you click Create, Easy Insight will begin synchronizing key aggregate data from your Highrise account into the Easy Insight data warehouse. Depending on the size of your Highrise instance, this process may take a while--if you have hundreds of deals and thousands of contacts,, it might be several minutes to copy all of the necessary data across. Once synchronization is complete, a wizard will walk you through an initial scorecard and next steps with the data source.

What Highrise data is available for reporting?

You can report on Cases, Companies, Contacts, Deals, Emails, and Tasks, and Notes.

How do I build a report on deals?

First, click on Create New Report from the Home page. This will take you to the Easy Insight report editor.

For any report on your Highrise data, we recommend that you take advantage of the suggested actions. You can find these actions in the upper right corner of your screen. You should see "Help Me Set up a Deal Report", as an option. Click on that option and confirm the suggestion action.

Once you've applied this suggestion, the report will show you the set of all Deals in your Highrise system. From this basic report, you can drag other fields into the report to build out whatever other data you need to see. For example, open up the Deals folder in the left hand list and drag Total Deal Value into the report to see the value of each deal. Next, you can add the contacts and companies matching with deal by opening up the Company folder and adding Company Name to the report and opening up the Contact folder and adding Contact Name to the report.

Now that you have basic information in the report, you can add a filter to only show those deals which are in a pending state. Open up the Filters tab in the top section of the editor. Click on New Filter and choose Status from the dropdown box. Click Create Filter. You'll be asked what type of filter you want to create. Choose a single value filter so that you can restrict the data to a single value. The result of this action is that you'll have a dropdown box showing the various possible status values of deals. Select Pending and the report filters down to only show pending deals.

How do I build a report on cases?

Follow the same approach as you used in creating a report on deals, just selecting "Help Me Set up a Case Report" instead.

How do I build a report on tasks?

Follow the same approach as you used in creating a report on deals, just selecting "Help Me Set up a Task Report" instead.

How do I build a report on activities?

Activities span tasks, notes, and emails. Follow the same approach as you used in creating a report on deals, just selecting "Help Me Set up an Activity Report" instead. You may need to click on "More Suggestions" to find this option.

How can I add custom fields?

You can add any custom field to your Highrise data inside of Easy Insight. One common scenario is deal probability--how likely is this deal to close?

As the first step, you'll add some custom notation to the fields in Highrise. The notation is:

[Field Name: Value]

So for our deal probability, we'll add this notation to our Deal names in Highrise, so that a deal with the name of "Pro Services to Customer XYZ" would become "Pro Services to Customer XYZ [Prob:50]". You can see in the screenshot to the right a sample of how this looks in the Highrise interface. Prob is an arbitrary name we've chosen to represent Probability--you could do [Probability: 50] or [P:50], just up to what you feel will be the best fit for your sales team. You can add multiple fields in this way as well--if you wanted to add Channel as well, you could do something along the lines of "Pro Services to Customer XYZ [Prob: 50] [Channel:Direct Marketing]".

Next, open up the report editor in Easy Insight. You'll be creating a Calculated field, so click to the Data tab, then click on Create Calculation. This action opens up the window for defining a new calculation. For this particular scenario, you'll be using the "namedbracketvalue" function. This function has the signature of:

namedbracketvalue(Field Name, Custom Field Name)

So for our earlier examples of [Prob:50], we would do the following as our calculation:

The calculation of namedbracketvalue(Deal Name, "Prob") defined in the Calculation input is stating that the calculation will look for bracketed values in the Deal Name field where the name of the custom field is Prob. If you wanted to do the aforementioned Channel instead, it would just be namedbracketvalue(Deal Name, "Channel"). If you wanted to apply the same functionality to some other Highrise field, you'd just use the appropriate field name as the first parameter to namedbracketvalue.

Setting the Formatting to Percentage will ensure that the value is displayed in % form. Row Level can be a little confusing at first, but it simply states that the calculation will be applied for each row of data, rather than after the data has been aggregated.

If you drag Deal Name and the newly defined Deal Probability field into the report, you'll see the deal probabilities as matching with your data in Highrise, as shown in this example to the right.

The next step is to create a further calculated field representing probability adjusted deal value. We'll create a second calculation. For this one, the value will be:

Total Deal Value * Deal Probability / 100

Set the value to a Currency, drag it into the report, and just like that, you have a full view of deals with their values, probabilities, and probability adjusted values! You can watch this screencast for a video walkthrough of this process.

How much does Easy Insight reporting on Highrise cost?

The Basic package for Easy Insight reporting on Highrise costs $25/month. This package gives you support for five users. The Plus package costs $75/month and gives you unlimited users.

How do I report on tagged data in my Highrise system?

Please look at http://www.easy-insight.com/documentation/tags.html for more information on this topic.