Skip to main content
All CollectionsOthersFAQ
ExtendSync Events - Usage Metrics
ExtendSync Events - Usage Metrics

General | Learn how to configure on usage metrics for Events application

Updated over 3 months ago

It is possible to report on event attach usage for both ExtendSync by creating a saved search in your NetSuite account. (We recommend emailing the saved search to yourself and leaders weekly for tracking purposes. More on that below).

Once you understand the saved search you may want to go beyond what is shown here.

Creating the search for Events

Step 1: Start by creating a saved search of the activities;

Reports > All Saved Searches > NEW > then look for Event

or

Activities > Scheduling > Activity List> Search then click Create Saved Search

Step 2: Go to the Criteria Tab and set the following:

  • Add Search Title

  • Set the Saved Search to Public

  • Enable Use Expressions

Step 3: Go to the Results Tab. Look for Celigo Calendar Attendee Record and set Assocation Type.


Schedule a weekly ExtendSync Summary email to leaders

Hold users accountable if they are not saving events into NetSuite!

Step 1: Open Events Created by ExtendSync Saved Search and name it:

Events Created by ExtendSync for Email Distribution and Save As (to create another search)

Step 2: Once saved, click Edit this Search.

Criteria Tab

Add Date Created to filter and under Description add is within 1 years ago and 0 days ago. Add an And after the ).


Results Tab

Once all the formulas have been set up, it should look like this:

See the guide below to set up your Saved Search:

πŸ”΅ Event Created By

Field ID: Event Created By (Custom)

Summary Type: Group

Custom Label: Event Created by

πŸ”΅ This Week

Field ID: Formula (Numeric)

Summary Type: Sum

Formula:

CASE WHEN {createdDate} BETWEEN TRUNC(SYSDATE,'IW')-7 AND TRUNC(SYSDATE,'IW')-1 THEN 1 ELSE 0 END

Custom Label: This Week

Summary Label: This Week

πŸ”΅ Last Week

Field ID: Formula (Numeric)

Summary Type: Sum

Formula:

CASE WHEN {createdDate} BETWEEN TRUNC(SYSDATE,'IW')-14 AND TRUNC(SYSDATE,'IW')-8 THEN 1 ELSE 0 END

Custom Label: Last Week

Summary Label: Last Week

πŸ”΅ Difference

Field ID: Formula (Numeric)

Summary Type: NONE

Formula:

CASE WHEN {createdDate} BETWEEN TRUNC(SYSDATE,'IW')-14 AND TRUNC(SYSDATE,'IW')-8 THEN 1 ELSE 0 END

Custom Label: Difference

πŸ”΅ %Difference

Field ID: Formula (Percentage)

Summary Type: Sum

Function: Round

Formula:

CASE WHEN SUM(CASE WHEN {createdDate} BETWEEN TRUNC(SYSDATE,'IW')-14 AND TRUNC(SYSDATE,'IW')-8 THEN 1 ELSE 0 END) = 0 THEN CASE WHEN SUM(CASE WHEN {createdDate} BETWEEN TRUNC(SYSDATE,'IW')-7 AND TRUNC(SYSDATE,'IW')-1 THEN 1 ELSE 0 END) > 0 THEN 1 ELSE 0 END ELSE ((SUM(CASE WHEN {createdDate} BETWEEN TRUNC(SYSDATE,'IW')-7 AND TRUNC(SYSDATE,'IW')-1 THEN 1 ELSE 0 END) - SUM(CASE WHEN {createdDate} BETWEEN TRUNC(SYSDATE,'IW')-14 AND TRUNC(SYSDATE,'IW')-8 THEN 1 ELSE 0 END)) / SUM(CASE WHEN {createdDate} BETWEEN TRUNC(SYSDATE,'IW')-14 AND TRUNC(SYSDATE,'IW')-8 THEN 1 ELSE 0 END)) END

Custom Label: % Difference

Summary Label: % Difference

πŸ”΅ Last 365 Days

Field ID: Formula (Numeric)

Summary Type: Sum

Formula:

CASE WHEN {createdDate} BETWEEN TRUNC(SYSDATE,'IW')-365 AND TRUNC(SYSDATE,'IW')-1 THEN 1 ELSE 0 END

Custom Label: Last 365 Days

Summary Label: Last 365 Days


Highlighting tab

Step 1: Click on the Highlighting tab and then Highlight if...(Summary)

click the Set Filter button (see below):

Step 2: Add the formula below.

Summary Type: Sum

Field: Formula (Percent)

Formula:

sum((CASE WHEN {createdDate} BETWEEN TRUNC(SYSDATE,'IW')-7 AND TRUNC(SYSDATE,'IW')-1 THEN 1 ELSE 0 END)-(CASE WHEN {createdDate} BETWEEN TRUNC(SYSDATE,'IW')-14 AND TRUNC(SYSDATE,'IW')-8 THEN 1 ELSE 0 END))/NULLIF(sum(CASE WHEN {createdDate} BETWEEN TRUNC(SYSDATE,'IW')-14 AND TRUNC(SYSDATE,'IW')-8 THEN 1 ELSE 0 END),0)

Formula (percent): Less than or equal to

Value: 0

Step 3: Click Add then Set.

Step 4: Click the image field then select the following:

Image: X Mark

Text Color: Black

Background color: White


Email Tab

Step 1: Click on Specific Recipients Subtab.

Step 2: Check off SEND EMAILS ACCORDING TO SCHEDULE, SUMMARIZE SCHEDULED EMAILS, AND SEND IF NO RESULTS.

Step 3: On the Specific Recipients, tab add in ALL the Leaders you want to CloudExtend Summary email.

Step 4: Click on Customize Message Subtab then add the following:

From: "CloudExtend" <your email address>

Subject: πŸ“ˆ ExtendSync Event Summary

Message:

This email summarizes the number of events saved using ExtendSync.

Red flags to πŸ‘€ watch for:

❌ If someone has an active license to CloudExtend but IS NOT included in this summary, then they have not saved any events to and from NetSuite. **To view who has a license log in to subscriptions.cloudextend.io**

❌ If the # of events saved by a particular user or users continually declines week by week.

Hold these users accountable. Remind them that the path to making NetSuite the single source of truth relies on ExtendSync.

Ensure that the View Record Link is checked off

Step 5: Click on Schedule Subtab

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

Save and run. Your saved CloudExtend Summary search will now be emailed to the leaders weekly.

Did this answer your question?