Siebel Consumer Goods Guide > Account Targeting >

Creating Target Lists (End User)

The views in the Target Accounts screen allow end users to select profile information about which to query, such as visit frequency, last visit date, and order date. The results that they save consist of a set of accounts.

If end users query only an account profile attribute, they can use the Account Information view. This view returns all accounts that meet the query conditions, whether or not the accounts contain demographic or assessment information. Using a different view to query account profile information returns accounts that meet the query conditions and the condition for the view. For example, querying from the Orders view returns only those accounts that contain orders and meet the query conditions. For information about performing queries, see Siebel Fundamentals.

NOTE:  Account Targeting uses your local database. The end user's target lists are not synchronized with the Siebel Server. Therefore, if end users receive a new database extract, they must re-create their target lists. However, if an end user is a remote user, the normal process of synchronizing a local database with the Siebel Server does not affect the end user's target lists.

End users who want to perform queries on fields across multiple forms in a single targeting view need to use the refine query feature. For example, an end user who wants to perform a query for all California accounts with a distribution code of A must enter the query criteria (all California accounts) in the Account Attribute Selection form and then refine the query in the Demographics and Assessment form to include only those accounts with a distribution code of A.

This task is a step in Process of Account Targeting.

To refine a query

1. Navigate to the Target Accounts screen, then the Account Targeting List view.
2. From the visibility filter, select one of the following values:
   • Account Information. Select this value to perform a query for demographics and assessments.
   • Orders. Select this value to perform a query for orders.
   • Store conditions. Select this value to perform a query for store conditions.
3. In the Account Attribute Selection form, click Menu, and select New Query.
4. Enter the criteria in the fields for which you want to perform a query.
5. In the next form, click Menu, and select Refine Query.
6. Enter the criteria in the fields for which you want to perform a query, click Menu, and select Run Query.

   In the Target Accounts list, accounts that satisfy both sets of query criteria appear.

   To save the target list, see Saving Target Lists (End User).

Use the following procedure to create a target list based on demographics and assessments.

NOTE:  The more fields in which an end user enters query criteria, the longer the time to execute the query. Also, if an end user enters a query condition that is too general (such as all accounts with a Weekly ACV greater than 1), saving the query later can take a long time because of the number of records meeting the query criteria.

To create a target list based on demographics and assessments

1. Navigate to the Target Accounts screen, then the Account Targeting List view.
2. From the visibility filter, select Account Information.
3. In the Demographics and Assessment form, click Menu, and select New Query or select a predefined query from the Queries drop-down list.
4. Specify the query criteria or refine a predefined query, if necessary.
5. In the Demographics and Assessment list, click Menu, and select Run Query.

   The results of the query are returned.

   To save the target list, see Saving Target Lists (End User).

Use the following procedure to create a target list based on orders.

To create a target list based on orders

1. Navigate to the Target Accounts screen, then the Account Targeting List view.
2. From the visibility filter, select Orders.
3. In the Order form, click Menu, and select New Query, or select a predefined query from the Favorites drop-down list.
4. Specify the query criteria or refine a predefined query, if necessary.
5. In the Order form, click Menu, and select Run Query.

   The results of the query are returned.

   To save the target list, see Saving Target Lists (End User).

Use the following procedure to create a target list based on store conditions.

NOTE:  When an end user queries a product and a store condition, only the last audit date of the product is queried for the specified condition. When an end user queries only a store condition, all products with the store condition are returned.

To create a target list based on store conditions

1. Navigate to the Target Accounts screen, then the Account Targeting List view.
2. From the visibility filter, select Store Conditions.
3. In the Store Conditions form, click Menu, and select New Query or select a predefined query from the Queries drop-down list.
4. Specify the query criteria or refine a predefined query, if necessary.
5. In the Store Conditions form click Menu, and select Run Query.

   The results of the query are returned.

   To save the target list, see Saving Target Lists (End User).