Salesforce Docs Portal

Create a Daily Unique Users Recipe

This recipe produces a unique count of users by day.

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-Day.

  9. Click Save.

  10. Name your lens Daily Unique Users.

  11. Select your PartnerIntelligence app.

  12. Click Save.

Example

A sample Daily Unique Users CRM Analytics lens

SAQL:

q = load "DailyAggregation";
q = group q by ('timestamp_derived_DAY_formula_Year', 'timestamp_derived_DAY_formula_Month', 'timestamp_derived_DAY_formula_Day');
q = foreach q generate 'timestamp_derived_DAY_formula_Year' + "~~~" + 'timestamp_derived_DAY_formula_Month' + "~~~" + 'timestamp_derived_DAY_formula_Day' as 'timestamp_derived_DAY_formula_Year~~~timestamp_derived_DAY_formula_Month~~~timestamp_derived_DAY_formula_Day', unique('user_id_token') as 'unique_user_id_token';
q = order q by 'timestamp_derived_DAY_formula_Year~~~timestamp_derived_DAY_formula_Month~~~timestamp_derived_DAY_formula_Day' asc;
q = limit q 2000;