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:

  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 search for timestamp_DMY.

  5. Select Year-Month-Day.

  6. Click Filters.

  7. Click +.

  8. Select custom_entity_type equals CustomObject.

  9. Click Apply.

  10. Click +.

  11. Select operation_type Equals INSERT.

  12. Click Apply.

  13. Click Data.

  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.

A sample Custom Object Creates Per Day CRM Analytics lens

SAQL: