--- title: Audience Composition slug: ikea-summer-2025-hol/audience-composition docTags: createdAt: 2025-06-27T08:03:21.753Z --- ### Overview This section describes the steps to create an audience of high value past purchasers leveraging historical transaction data in the warehouse, without copying those transactions into Adobe Experience Platform ### Create an audience In the menu on the left side: - Click on **Audiences **to see a dashboard overview with information on a specific audience. - Click on **Federated compositions** at the tab bar to see an overview of all existing federated compositions. The goal is to create an audience of customers who have made many purchase in the past quarter. - Click on **Create composition** - Set Label = `[your name] - High value past purchasers` ![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/dYoUqC7DJntMK4szS7Y51_image.png) - Click on **Create **to land to this screen: ![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/Lb9IW0Tn9rwXUAmekv-Go_image.png) - Click on the **+ **icon to add the activity named **Build audience** ::Image[]{src="https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/743hAp34ZyZ3kwJYfZeox_image.png" size="40" width="290" height="309" position="center" showCaption="false"} - Set the activity properties this way: - Select the schema named **LUMAORDER** - Click on the **Create audience** button in order to define the condition to filter records - Add these 3 conditions - TSORDER on or after Last quarter - **AND (** - SPRODUCTCATEGORY contains ORANGE - **OR **SPRODUCTCATEGORY contains BLUE**)** - Click on **Calculate** ![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/xTxgkQsyokMhwMVG5wMHM_image.png) - Click on **Confirm** and **Start **the composition flow: ![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/Os0k1XvLNZA-hUrAML-15_image.png) - Click on the transition (the green line after the card) and click on the **Preview results** to look at the data: - The temporary table contains the primary key of the records - It's possible to view other data by clicking on the **Configure columns** button in the top right corner The next step step is to calculate aggregate data in order to select the high value customers - Click on the **+** icon and select the **Enrichment **command ![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/-54nl9PZkkkDYpMHAE4rD_image.png) - Click on **+Add enrichment** data button - Add the `SACCOUNT `field - Define the alias to `@account` ![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/2yckQOoSjnxxKMpqLHKpp_image.png) - Repeat the task - Click on **+ Add enrichment data** - In the data model, click on `Targeting dimension > Items > FAMOUNT` - Change the setting named 'Select how the data is collected' from 'Collect data' to 'Aggregate data' ::Image[]{src="https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/IbcAJFXRyoF3FMctkgJcu_image.png" size="40" width="264" height="487" position="center" showCaption="false"} - Click on the little pen icon of the Attribute 1 - Click on **Edit expression** button - Go to the **Helper functions** - Expand the **Aggregates** menu - And define the expression this way: `Sum(@FAMOUNT)` ![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/SzP1jVezoQ7kRXEsC8nTm_image.png) - Confirm and set the alias to `@sum` ::Image[]{src="https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/n0IrphnewlbJ4B2PfETbF_image.png" size="42" width="252" height="448" position="center" showCaption="false"} - **Save, Resume **the composition flow and **Preview results** ![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/w27NsNns5NH5WqFbk9QiH_image.png) The next step is to filter this population and keep high value customers, those who have spent more than 25,000 ($,€,kr,...) in the past quarter. - Define the subset - Segment code = HIGH\_VALUE\_CUSTOMERS - Filter `Sum(FAMOUNT) greater than 25,000` - Enable the **Generate complement** option ::Image[]{src="https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/LejzT9mYs53sE03Gzrx7a_image.png" size="46" width="265" height="630" position="center" showCaption="false"} - **Save **and **Resume** ![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/2POq8xwgCFhLRdtajNSM6_image.png) - Add an **End **activity after the Complement transition ![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/HMIzfVnQWwLKe8xeFy2GK_image.png) - Add a **Deduplication **activity after the HIGH\_VALUE\_CUSTOMERS segment - Deduplicate on `SACCOUNT` ![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/WsXNemrpeMaFPP7PdmYcr_image.png) - **Save,** **Resume, Preview results** ![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/Pxl2tarNXfwfyRRkCRohy_image.png) - Finish the flow by adding the **Save audience** activity - Set Audience label = `[your name] - High value past purchasers` - Click on **Add Audience Mapping **to add the `SACCOUNT `field - Set Primary identity field = `SACCOUNT` - Set Identity namespace = `Demo System - CRMID` - **Save **and **Resume** ::Image[]{src="https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/so13rwm1haTD4czeVzHqh_image.png" size="36" width="251" height="153" position="center" showCaption="false"} - When this activity is done, the audience is available in the **Audiences > Browse **section ![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/at4F-CzZthyntF0qBDi6I_image.png) - Click on the Dataset name to land to this screen ![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/vd3CXSGRzNvyyKwIK44az_image.png) - Click on the **Preview dataset** button to look at the data put in Adobe Experience Platform: ![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/_LUbEudzo8vPFCbjfS9XU_image.png) - Go the Profiles screen and look for the profile - `Demo System - CRMID = 406tya` ![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/fm5qdV4V3OoaMsZhoql20_image.png) - There is a recurring job which calculates the audience memberships of profiles; the federated audience will appear in the Audience membership screen after the execution of this job ![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/OXkimD1OzvpR7Arz_9g76_image.png) :::hint{type="success"} You have now successfully created an audience of high value past purchasers leveraging historical transaction data in the warehouse, without copying those transactions into Adobe Experience Platform :::