Create Reports and Track Metrics

In the Grid Edit module, select the database and record type. 

When you're looking to export or report on specific records, use the filter to work only with an appropriate subset of your data. You can filter your data using any field in your database.

Under the Filter tab, select the Field to work with. Use the Condition to set the rule that the data in the selected field must meet.

In this example, the filter will look for records with no data in the First Name field. 

Click the Search button, and a preview of the records that match this filter will load in the Record Viewer at the bottom of the page.

To select individual records for export, use the checkboxes next to each record.

Click the Layout tab to modify the fields that will be part of your export.

In the right column, you can search for fields to add to the layout and drag them into the left Visible Fields column. Remove fields by dragging from the Visible Fields column into the right column.

With your filters and layout set, Insycle can now export the segment of data that you have selected.

On the Filter tab, click the Export button.

In the Export popup, select New File and click Next.

On the Email tab, enter additional email addresses (hit Enter after each), a Subject, and a Description.

On the When tab, click Run Now and select which records to apply the change to (in most cases this will be All), then click the Run Now button.

Open the CSV file from your email in a spreadsheet application and review the results.

If you are satisfied with the data in your CSV, return to Insycle and save all of the configurations as a template. This will save you time and provide consistent reports in the future.

Return to the Template menu at the top of the page and click the + to give the new template an informative name and then click the Save button.

To set up automated exports for reporting, click the Export button.

On the Email tab, add recipients who should receive the CSV each time the template runs.

Then, on the When tab under Automate, set up the frequency your CSV should automatically be exported--hourly, daily, weekly, or monthly.

Once scheduled, data that matches your filter will be automatically exported and emailed to you or your team, improving data collaboration and allowing you to keep an eye on the most critical metrics.

You can view all scheduled automation on the Automations page on your dashboard.

In the Group & Update module, select the database and record type. Then explore the templates for an existing solution that may be close to what you need.

Under Step 1, select the Field you want to group by and analyze. In this example, we've chosen the Industry field.

Click the Analyze button, and a preview of the value groups that match this filter will load in the Record Viewer at the bottom of the page.

The Record Viewer lists all of the unique values contained in the field with a count of how many times each value is found. The below example shows that the most common Industry among our company records is Home Services.

If the selected field was a numeric field type, there would also be statistical data.

Once your field is selected, click the Analyze button. A preview of your data will be generated at the bottom of the screen in the Record Viewer.

Click the checkbox by a value to expand the group. This opens up a secondary Viewer below the first, where you can review the individual records that have the selected value.

To explore a second grouping–a subset of the first–you can add an additional field under Step 1.

When you click Analyze all of the different values for the first field are broken out into groups based on the second field.

A secondary field where the Field Meta is INT (integers) will display additional, quantitative metrics. For example, if you chose to group by Deal Owner and Deal Amount (an integer field) in Step 1, information such as the minimum, maximum, average, and total deal amounts generated by each Deal Owner would display.

Click the checkbox for a row to drill down into the individual records contained within each group.

If you'd like to see more information for each of the resulting records within each variation group, you can alter the fields in the secondary Record Viewer by using the Layout tab in Step 1.

Yes, the pre-existing data in the record will be overwritten by the bulk update. If you need this data for reference or restoration, it will be available in the CSV in the Activity Tracker.

Yes, but not directly. You can access the deleted data in the Activity Tracker and re-import the partial records if needed.