--- title: Federated Audience Composition: Lapsed Customer Likely to Churn slug: nrg-rtcdp-hands-on-lab/federated-audience-composition-lapsed-customer-likely-to-churn docTags: createdAt: 2024-02-21T16:49:24.548Z --- In this section we will use the data points from Luma's Snowflake table to build the following audience condition 1. **LASTORDERDATE **on or before** last year** 2. **CHURNPREDICTION** is greater than or equal to .60 # Building a Federated Audience 1. In the **Customer** > **Audiences** portal, click the **Federated compositions** tab. 2\. Click **Create composition**. ![](https://api.archbee.com/api/optimize/2QtaDNQUOaQJJ0ppk7Fjc-5fXFAw858y-oTN_0WiI7w-20240814-164440.png) 3\. Label your composition **Lapsed Customers Likely to Churn** ***+ ******your lab user ID******. ***Click** Create**. 4\. Click the **+** button in the canvas and select **Build audience**. The right-hand rail should appear. 5\. Click **Select a schema** and select the **RETAIL****\_CRM** schema then click **Confirm** 6\. Click **Continue**. In the query builder window, click the **+** button and then **Custom Condition. **Create the following condition :::BlockQuote **LASTORDERDATE** *on or before* **last year****** ::: **AND** :::BlockQuote ******CHURNPREDICTION** *greater than or equal to* **0.6** ::: Your query should now look as follows ![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/jP3Rhj-hYeTQkLkfI1vw3_screenshot-2026-05-05-at-14239apm.png) 7\. Click the next **+** button then click **Save audience**. Label this step **Lapsed Customers Likely to Churn** ***+ ******your lab user ID.*** Use the same value as the audience label. Add the following audience mappings: :::BlockQuote **`Source Audience Field`**`: EMAIL` ::: :::BlockQuote **`Source Audience Field:`**` FIRST NAME` ::: :::BlockQuote `Select the primary identity and namespace to use for profiles:` ::: :::BlockQuote **`Primary identity field:`**` Email` ::: :::BlockQuote **`Identity namespace`**`: Email` ::: 8\. Click **Save** and then click **Start**, to run the query of the composition you just built. **Note: **We used order and propensity data in the data warehouse to build our audience without moving these attributes into Adobe Experience Platform. **Exp League**: [https://experienceleague.adobe.com/en/docs/federated-audience-composition/using/compositions/create-composition/create-composition](https://experienceleague.adobe.com/en/docs/federated-audience-composition/using/compositions/create-composition/create-composition)