---
schema_version: "1"
id: 2dfa6b30aa6ceaae18cc02a2a02997eaa665a0884051cbe6b0fc1b3df5ed5248
title: CRM Analytics Recipes
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/platform-pkg-exchange/managed_packaging/guides/second-generation/appexchange/app-analytics/app-analytics-cookbook/app-analytics-cookbook-tcrm-intro.md
canonical_url: https://developer.salesforce.com/docs/platform/pkg2-dev/guide/app-analytics-cookbook-tcrm-intro.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 22cde6c9b2dc951a3d6f51acd83042978a1a3e42d213739f329fcc83c134715c
products:
  - Second-Generation Managed Packaging Developer Guide
  - merged-docs
---

# CRM Analytics Recipes

Set up your org to create AgentExchange App Analytics recipes by building your CRM Analytics environment. You first create a country-codes dataset. Then you create two CRM Analytics recipes to produce a dataset of your subscriber info, and an aggregate dataset of all of your daily data.

| Required Editions                                                                        |
| ---------------------------------------------------------------------------------------- |
| Available in: both Salesforce Classic and Lightning Experience                           |
| Available in: **Enterprise**, **Performance**, **Unlimited**, and **Developer** Editions |

- The first CRM Analytics recipe, LMAJoin, combines package and license data from your LMA with your accounts and leads. It produces a dataset of your subscribers.
- The second CRM Analytics recipe, DailyAggregation, joins the LMAJoin dataset with your App Analytics data. It produces the DailyAggregation dataset. All your App Analytics recipes are built on top of your DailyAggregation dataset.

1.  [Create the Country-Codes Dataset](https://developer.salesforce.com/docs/platform/pkg2-dev/guide/app-analytics-cookbook-tcrm-country-codes.md)


    To create visualizations of your country-based data in map format, you normalize the LMA country-code data to CRM Analytics country-code format.

2.  [Connect to Your License Management App Data](https://developer.salesforce.com/docs/platform/pkg2-dev/guide/app-analytics-cookbook-tcrm-lma-data.md)


    Create an SFDC_Local connection to your License Management App (LMA) data.

3.  [Create the LMAJoin CRM Analytics Recipe](https://developer.salesforce.com/docs/platform/pkg2-dev/guide/app-analytics-cookbook-tcrm-lmajoin.md)


    Create a CRM Analytics recipe that contains your License Management App (LMA) data.

4.  [Create Your App Analytics Dataset](https://developer.salesforce.com/docs/platform/pkg2-dev/guide/app-analytics-cookbook-tcrm-da-prepare.md)


    Create a RawPackageLogFile App Analytics dataset using your `RawPackageLogFile.csv` file.

5.  [Create Your DailyAggregation CRM Analytics Recipe](https://developer.salesforce.com/docs/platform/pkg2-dev/guide/app-analytics-cookbook-tcrm-da-recipe-detail.md)


    You join your raw package log file data with your License Management App (LMA) data to create the DailyAggregation CRM Analytics recipe. The recipe produces a dataset called DailyAggregation that you use to create App Analytics recipes.

**See Also**

**Previous topic:** [Before You Begin](https://developer.salesforce.com/docs/platform/pkg2-dev/guide/app-analytics-cookbook-prework.md)

**Next topic:** [App Analytics Recipes](https://developer.salesforce.com/docs/platform/pkg2-dev/guide/app-analytics-cookbook-recipe-intro.md)

- [Explore Data and Take Action with CRM Analytics](https://help.salesforce.com/articleView?id=analytics.bi.htm&type=5)