Selections

selections are the core building blocks in unaric segment they are advanced filters that allow you to select and filter data from data extensions and data views apply complex filtering rules and relationships define target data extensions for results generate sql queries that run in salesforce marketing cloud how it works pick or create selection existing selections are available at the home page here you can find selections that you or your colleagues created you can edit the existing selections, copy them, or remove them to create a new selection in the home page, click the new selection button provide a name for your selection choose a folder for saving your selection and click save selection criteria docid\ oe7f04wth1xbj0sooj7vl (input) configure the input data to be segmented you can provide an alias for your data extension or data view at this moment for convenience purposes (the initial name of the data extension won’t be changed) select your data sources docid 15d3guepxa0fkvzoje5t9 drag and drop your input tables (including standard, shared, or synchronized data extensions, system data views, or predefined data sets) from the available data extensions panel to the selected data sources area you can optionally assign convenient aliases define relationships between data sources docid\ pjtenukvt5ib40 knfxkt combine multiple tables by dragging one on top of another to establish sql like relationships (such as with matching or without matching ) apply filters docid\ voomv8gsnejk9afymnmva drag fields to the filter section to target specific audiences you can combine criteria with and/or logic or leverage reusable filter sets docid\ coq3dcjpohji 5w8fnyfl and behavioral filter sets docid\ cfa9x2la4x7fzdwriin9a target definition docid\ adegube9bfrsfwlippun6 (output) define the output by choosing how data is written to the target data extension create or choose target data extension docid\ y2nmbgsegctlxl6 eac1s select an existing data extension or create a new sendable target de on the fly directly inside unaric segment create advanced custom values values docid\ l1w6vtgyzsiirujk4sy32 these fields help you personalize data on the fly, including fixed values (static text), dynamic values (if/then conditional logic), aggregations (sums, averages, counts), or formula fields (timestamps and date differences) define which fields from your selected data extensions will populate the fields of your target data extension use field mapping docid 7w yenpxyaoerzfr5cxui to drag and drop source fields to map them to the target data extension, or click automap to match them automatically by name and type handle duplicate records set rules with prio deduplication docid\ vkr1reinyo3puldkkdvou to handle duplicate records by selecting a unique field and defining priority criteria (e g , keeping the order line with the highest quantity) preview & run docid\ c5emu95zi0ebmkzfzgzc0 preview and run your selection run preview docid\ afvlojmpg9lrvabmvjrtl run a safe simulation of your query this displays a sample results table in an empty, temporary data extension so you can validate joins, columns, filters, and record count before writing to production run selection once validated, click run to execute the query and permanently write the results to your actual target data extension in salesforce marketing cloud automation leverage query activities docid 4hq24elflpecylgltlg5b after running selections, query activities can be integrated directly into broader sfmc workflows set up schedule selections docid\ wupztar3qnmtjqpbi5ic7 (optional) click the scheduling calendar icon on the top bar of your selection to automate runs (once or recurringly at a specific time, date, and frequency) integrate journey builder docid\ q7c8zyykgevdlh6wnu4bf running a selection automatically generates standard sfmc sql query activities in automation studio > activities > sql query > deselect > selections that you can easily drag into multi step automations