GLOSSARY

AdHoc
This feature of MarketWide allows you to type your own queries in SQL script directly to the server. This can be useful to check counts for accuracy. 

Aggregate Function
These allow you to perform calculations on all the records owned by a single consumer to use in selection criteria. For example, you can select all consumers who have spent a cumulative total of more than X dollars by specifying that sum (order amounts) is greater than or equal to X. An aggregate function differs from the aggregate filter in that the calculations take place after the customer's records have been passed from the server.

Alias
This is the name MarketWide displays for a field. By default, this is the field name. More meaningful names can be specified by the administrator. Changing the alias does not change the actual field name.

Campaign
This is a method of obtaining from a database a smaller list of consumers with a higher response rate. The campaign retrieves the records for all the consumers that meet your requirements.

Campaign ID
This is the name that you define for your campaign on the Tracking tab. It is used to retrieve information from PromoHistory about past campaigns.

Catalog
This includes picklists, lookups, etc., that are stored on the host machine. When you refresh the catalog, you are asking the host machine to give you the most recent catalog information. When the catalog information is changed, you will be prompted to refresh.

Child Cell
This is a cell that only evaluates the records that meet the criteria of the parent cell.

Cleanup
This removes older information on your system that may no longer be needed. By default, Cleanup is set to Never Delete. This can be changed as necessary on the options menu in the MarketWide main menu.

Composite Field
This feature lets you create dynamic text strings in your output files, by substituting values from your database into the composite string.

Condition
This is an operator that determines if any given record meets your criteria, such as EQUALS or BETWEEN.

Constraints (Cell)
This is an amount that you specify to limit the number of records matching a cell. This can be expressed as a number or a percent.

Criteria (Report)
Your report criteria can be viewed and printed in TouchPoint by selecting Campaign Report from the File menu.

Cube Table
User built query, join, or union inside a cube.

Database
This holds a collection of tables.

Database Objects
A database object is an administrator created joined table.

Delimiter
This is a character within a solicit file that marks the end of each field in a delimited solicit file. Usually it is a comma.

Dependency (Cell)
Cells that are not on an equal hierarchical level as other cells.

Dimension
In Analyzer, each field you choose to view the information by is referred to as a dimension.

Distinct
This prevents any consumer from being selected more than once, despite the amount of cell criteria they match.

Drill-Down
This allows you to analyze records in greater detail, such as viewing the customer information or by a frequency distribution.

Error Occurred
When an error occurs with your report, the task status shows Error Occurred. Opening tasks let you view detailed information about report errors.

Exclude
Records that are not considered regardless of if they match data

Exclusive Cells
Records that match this type of cell are automatically excluded from selection by any further cells.

Expression
An expression is a user created function.

Field
A field is a piece of information in a record that is used to evaluate the record like a title.

File Extensions
The following are the file extensions used within MarketWide and its modules.

Filter
This gives rules to the server to only return records that match the specified criteria.