Newer Version Available

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

Create a Custom Object Updates 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:

  1. In All items on the Datasets tab, select your DailyAggregation dataset.
  2. Select Charts.
  3. Click Column and leave Bar Length as Count of Rows.
  4. Under Bars, click + and select timestamp_DMY.
  5. Select Year-Month-Day.
  6. Click the Filters tab.
  7. Click +.
  8. Select custom_entity_type Equals CustomObject
  9. Click Apply.
  10. Click +.
  11. Select operation_type Equals UPDATE.
  12. Click Apply.
  13. Click the Data tab.
  14. Under Trellis, click +.
  15. Select custom_entity.
  16. Click Save.
  17. Name your lens Custom Object Creates Per Day.
  18. Select your PartnerIntelligence app.
  19. Click Save.

Example

A sample Custom Object Updates Per Day CRM Analytics lens

SAQL: