...
AdHoc 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.
...
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.
| Anchor | ||||
|---|---|---|---|---|
|
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.
...
Composite Field
This feature lets you create dynamic text strings in your output files, by substituting values from your database into the composite string.
| Anchor | ||||
|---|---|---|---|---|
|
Condition
This is an operator that determines if any given record meets your criteria, such as EQUALS or BETWEEN.
...
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. Analyzer
Analyzer = '.ALR'
DataExport = '.XPT'
HTML - '.HTM' or .'HTML'
Package = '.PKG'
QueryBuilder = '.QBR'
SendEx = .'EPR'
Solicit Template = '.STE'
SQL Script = '.SQL'
TouchPoint = '.TOP'
TouchPoint Template = '.TTE'
Filter
This gives rules to the server to only return records that match the specified criteria.
| Anchor | ||||
|---|---|---|---|---|
|
Fixed Width
Fixed Width files specify a specific width for each field written into a solicit file. Regardless of the true length of the first field, each record will start at the same point. Fixed Width files are typically sent with a layout defining where fields start and end. Solicit files with a Fixed Width can easily be loaded into spreadsheets for reference, as well as mail campaigns.
Frequency Distribution
This option allows you to view your output based on a specific field (for example, by state). Be careful not to do a frequency distribution on a field with many different values (for example, Consumer ID).
| Anchor | ||||
|---|---|---|---|---|
|
Host
This refers to the machine that is running the MarketWide software remotely. The host interacts with the database directly, and does the labor for the client machines.
...
Join
This allows two tables to be joined into one table for evaluative purposes. There are many kinds of joins to allow you to compare your data effectively.
KPI FilterAnchor KPI KPI
The KPI (key performance indicator) filter allows you to filter customers based on all their records rather than considering only one record at a time. For example, you can filter based on the sum of all the order amounts of a customer. Those customers that do not meet the criteria are not passed from the server.
...
Nth
This is a number that you specify as a cell constraint. By default, there is no cell constraint.
| Anchor | ||||
|---|---|---|---|---|
|
Objects
Elements of a TouchPoint campaign with specific functions that are used in the segmentation process. Objects include: New Cell, Group OR, Match All and Match None. See "Using Objects" in the Segments section of the help files.
...
Query (Active)
An active query is an immediate request being asked in MarketWide. Consequently, all active queries must be closed before the program can shut down. Queries in the form of a task can be scheduled. These tasks run, regardless of if MarketWide or your computer is running.
QueryBuilder
This is an application within MarketWide that allows you to look at specific information without running a campaign.
...
Tables
A series of records.
TaskAnchor #task #task
See Query.
Template
This is a predefined way of viewing information, creating a solicit file, or running a report.
...