Skip Navigation

Newer Version Available

This content describes an older version of this product. View Latest

Create a Custom Object Creates Per Day Recipe

This recipe produces a unique count of how many times per day a custom object was created.

In your org in Analytics Studio in CRM Analytics:

In All items on the Datasets tab, select your DailyAggregation dataset.
Select Charts.
Click Column and leave Bar Length as Count of Rows.
Under Bars, click + and search for timestamp_DMY.
Select Year-Month-Day.
Click Filters.
Click +.
Select custom_entity_type equals CustomObject.
Click Apply.
Click +.
Select operation_type Equals INSERT.
Click Apply.
Click Data.
Under Trellis, click +.
Select custom_entity.
Click Save.
Name your lens Custom Object Creates Per Day.
Select your PartnerIntelligence app.
Click Save.

Example

A sample Custom Object Creates Per Day CRM Analytics lens

SAQL: