Create a Monthly Unique Users Recipe

This recipe produces a unique count of users by month.

In your org in Analytics Studio in CRM Analytics:

  1. In All items on the Datasets tab, select your DailyAggregation dataset.

  2. Under Bar Length, click Count of Rows.

  3. Click Unique.

  4. Select user_id_token.

  5. Select Charts.

  6. Click Column.

  7. Under Bars, click + and search for timestamp_DMY.

  8. Select Year-Month.

  9. Click Save.

  10. Name your lens Monthly Unique Users.

  11. Select your PartnerIntelligence app.

  12. Click Save.

A sample Monthly Unique Users CRM Analytics lens

SAQL: