Overview

This page covers creating and updating queries for BD Select and will cover each of the cases

Creating Select Queries

This procedure is fairly straightforward

1. From the left navigation bar, choose the Select
2. From the Select Owner dropdown menu, select the owner for the query. The “Create Audience” button will appear on the top right.
3. Click on the “Create Audience” button to create a new query. This will open a new page
4. Enter text for:
• Order Name
• Description
5. From the “Select Data Source” dropdown, select the data source you will use
• Check with your team which data source you need
6. No segment are created by default. Click on the “New Segment” button to create a segment
1. A default label is added to the segment “Segment 1”. Change as needed.
7. You are now ready to edit the select query.

Updating Query Attributes to Segments

To add a query attribute do these steps

1. In the left pane of the query, expand the categories where your attribute is.
1. Example: Personal Data > Is Child Present
2. Check the box(es) on the select segment(s) you want add or remove from
• You can add or remove from multiple segments at the same time

3. If you hover over the attribute, it will show three icons
1. A plus sign to add to a segment Include field
2. A minus sign to add to a segment Exclude field
3. An x sign to remove an attribute
4. Click on the icon that you want to act on. The attribute is added to the segment. You may need to expand the segment (Downward chevron next to the segment name)
• If added, select the attribute parameters as makes sense for the attribute type

Adding a New Segment

Duplicating Segments

Duplicating a segment is a matter of clicking on the duplicate icon, which is the black square over the white square

Getting Order Count

• Prerequisite to run a custom count is to set up an order query in the data source details section

Do these steps to get an order count

1. After editing the seqments and query as needed, make sure to click on the “Save Order” button on the top right.
2. Click on the “Get Order Count” button on the top right. A dialog box will appear.
3. Depending on how many data source details were created prior, you may have one or more tabs the get counts from.
4. Choose the tabs applicable to your work and check the counts for them

Export Order

• Prerequisite to run and order is to set up an order query in the data source details section

Steps for this are:

1. Click on the “Export Order” button on the top right
1. If there is more than one order they will be displayed in rows
2. Click the “Run Export” button on the order that you want. The “spinner” icon of a green clockwise turning 7/8 circle will appear.
3. When it is finished, the spinner icon will disappear and there will be a download icon. Click to download the file locally

4. Additionally, the file will be exported to BD Ingest for further automated processing as needed