Second-Generation Managed Packaging Developer Guide
j
No Results
Search Tips:
- Please consider misspellings
- Try different search keywords
Create a Weekly Unique Users Recipe
This recipe produces a unique count of users by week.
In your org in Analytics Studio in CRM Analytics:
- In All items on the Datasets tab, select your DailyAggregation dataset.
- Under Bar Length, click Count of Rows.
- Click Unique.
- Select user_id_token.
- Select Charts.
- Click Column.
- Under Bars, click + and search for timestamp_DMY.
- Select Year-Week.
- Click Save.
- Name your lens Weekly Unique Users.
- Select your PartnerIntelligence app.
- Click Save.
Example
SAQL:
q = load "DailyAggregation";
q = group q by ('timestamp_derived_DAY_formula_Year', 'timestamp_derived_DAY_formula_Week');
q = foreach q generate 'timestamp_derived_DAY_formula_Year' + "~~~" + 'timestamp_derived_DAY_formula_Week' as 'timestamp_derived_DAY_formula_Year~~~timestamp_derived_DAY_formula_Week', unique('user_id_token') as 'unique_user_id_token';
q = order q by 'timestamp_derived_DAY_formula_Year~~~timestamp_derived_DAY_formula_Week' asc;
q = limit q 2000;