Skip to main content
FAQ: ExtendInsights for Data Management NetSuite usage metrics

ExtendInsights Data Management| Learn how to report on usage

Updated over a week ago

It is possible to report on # of records updated, # of records created and # of records deleted using ExtendInsights by creating a saved search in your NetSuite account. (We recommend also emailing the saved search to yourself and leaders weekly to hold end users accountable. More on that below).


Creating the Saved Search

Start by creating a saved search of the message record, Lists > Search> Saved Searches > New (select SOAP Web Services Operations).

Name the Search Title: ExtendInsights Data Management Usage Metrics

Criteria Tab

Step 1: Go to Criteria tab

Step 2: Check off Use Expressions

Step 3: Set the 1st search criteria filter for the field Integration description to CloudExtend Excel and CloudExtend Excel for NetSuite.

πŸ’‘ Tip

Press and hold CTRL then click the item on the list to multi-select.

Step 4: Set the 2nd search filter to the field Time description to within last business week.

When done, it should look like this:

Results Tab

Sort by Operation

Field ID: User Email

Summary Type: Group

πŸ”΅ # of times records were downloaded

Field ID: Formula (Numeric)

Summary Type: Sum

Formula:

CASE WHEN {operation} LIKE 'getList' THEN 1 ELSE 0 END

Custom Label: # of times records were downloaded

πŸ”΅ # of times records were created

Field ID: Formula (Numeric)

Summary Type: Sum

Formula:

CASE WHEN {operation} LIKE 'addList' THEN 1 ELSE 0 END

Custom Label: # of times records were created

πŸ”΅ # of times records were edited

Field ID: Formula (Numeric)

Summary Type: Sum

Formula:

CASE WHEN {operation} LIKE 'updateList' THEN 1 ELSE 0 END

Custom Label: # of times records were edited

πŸ”΅ # of times records were deleted

Field ID: Formula (Numeric)

Summary Type: Sum

Formula:

CASE WHEN {operation} LIKE 'deleteList' THEN 1 ELSE 0 END

Custom Label: # of times records were deleted

When done it should look like this:

Step 5: Save and Run!

Recommendations

We highly recommend that managers add this as a KPI to their dashboards and monitor activity by users. The KPI view will show usage for all users.

βœ… Create the Key Performance Indicator

Step 1: Click Personalize.

Step 2: Drag KPI Indicator to the desired location.

Step 3: Click Setup > Custom KPI.

Step 4: Add your newly created saved search to the KPI.

βœ… Schedule a weekly ExtendInsights Summary email to leaders

Hold users accountable if they are not using ExtendInsights!

Find your "ExtendInsights Data Management Usage Metrics" Saved Search and click Edit Search.

Email Tab

Click on Specific Recipients SubTab

Check off SEND EMAILS ACCORDING TO SCHEDULE, SUMMARIZE SCHEDULED EMAILS AND SEND IF NO RESULTS

On the Specific Recipients tab add in ALL the Leaders you want to ExtendInsights Summary email.

Click on Customize Message Subtab

Add the following:

From: "CloudExtend" <your email address>

Subject: πŸ“ˆ CloudExtend Excel for NetSuite Usage Summary

Message:

This email summarizes how many times users download NetSuite records, create NetSuite records, edit NetSuite records and delete NetSuite records using ExtendInsights Data Management.

Red flags to πŸ‘€ watch for:

❌ If someone has an active license to ExtendInsights but IS NOT included in this summary, then they have not used the application at all. **To view who has a license login to subscriptions.cloudextend.io**

❌ If usage decreases by a particular user or users continually declines week by week.

Hold these users accountable. Remind them that working with their NetSuite data in Excel will save them a substantial amount of time. If additional training is required, reach out to cloudextend-training@celigo.com.

Ensure that the View Record Link is checked off

Click on Schedule Subtab

Set your schedule. We recommend a weekly event every Thursday with no end date.

=

Save and run. Your ExtendInsights Summary saved search will now be emailed to the Leaders weekly.

Did this answer your question?