Difference between revisions of "Contact Selection Range"
From TrueERP wiki
Simon Clive (Talk | contribs) |
Simon Clive (Talk | contribs) |
||
| Line 31: | Line 31: | ||
*Select the '''Field''' you want to filter on from the dropdown list. eg. If you want Melbourne CBD contacts, you would most likely want everyone with a Melbourne CBD postcode (3000) therefore you will be filtering on the Postcode field - ''''tblmarketingcontacts.PostCode'''' | *Select the '''Field''' you want to filter on from the dropdown list. eg. If you want Melbourne CBD contacts, you would most likely want everyone with a Melbourne CBD postcode (3000) therefore you will be filtering on the Postcode field - ''''tblmarketingcontacts.PostCode'''' | ||
| − | *Select the '''Comparison''' drop down list - This is a list of functions that define how you want to compare the data in the 'Field'to the Value that you will enter at the next step. eg. In the above example you would choose the comparison | + | *Select the '''Comparison''' drop down list - This is a list of functions that define how you want to compare the data in the ''''Field'''' to the Value that you will enter at the next step. eg. In the above example you would choose the comparison ''''Equal To''''<br> |
| − | *Select Value - enter the value being compared to eg. 3000 | + | *Select '''Value''' - enter the value being compared to eg. 3000 |
Note that as you populate the above fields, a search formula is being written in the selection criteria field. At this point you will see the formula'''"tblmarketingcontacts.postcode equal to 3000"''' Save or select '''Add''' again if you wish to add to this selection criteria | Note that as you populate the above fields, a search formula is being written in the selection criteria field. At this point you will see the formula'''"tblmarketingcontacts.postcode equal to 3000"''' Save or select '''Add''' again if you wish to add to this selection criteria | ||
| Line 42: | Line 42: | ||
*Select [[Marketing]] Tab | *Select [[Marketing]] Tab | ||
| − | *Select '''Contact Selection Range''' | + | *Select '''Contact Selection Range''' |
*Enter a '''Name''' for the Range to be created. The name should be descriptive enough that it is easily recognised by other users ie. In this case "Postcodes 3000 to 3005 excluding 3001" | *Enter a '''Name''' for the Range to be created. The name should be descriptive enough that it is easily recognised by other users ie. In this case "Postcodes 3000 to 3005 excluding 3001" | ||
| − | *Select the '''Add button - This will highlight a new line in the selection criteria area and the '''Field''' box | + | *Select the '''Add button - This will highlight a new line in the selection criteria area and the '''Field'''box ''' |
*Select the '''Field''' you want to filter on ie. ''''tblmarketingcontacts.PostCode'''' | *Select the '''Field''' you want to filter on ie. ''''tblmarketingcontacts.PostCode'''' | ||
*Select the '''Comparison''' drop down list - choose the comparison ''''Greater or Equal to'''' | *Select the '''Comparison''' drop down list - choose the comparison ''''Greater or Equal to'''' | ||
| Line 53: | Line 53: | ||
*Select ''''And'''' | *Select ''''And'''' | ||
*Select the '''Field''' you want to filter on ie. ''''tblmarketingcontacts.PostCode'''' | *Select the '''Field''' you want to filter on ie. ''''tblmarketingcontacts.PostCode'''' | ||
| − | *Select the '''Comparison''' drop down list - choose the comparison ''''Less or Equal to''''<br> | + | *Select the '''Comparison''' drop down list - choose the comparison ''''Less or Equal to''''<br> |
*Select '''Value''' - enter the value being compared to ie. 3005 | *Select '''Value''' - enter the value being compared to ie. 3005 | ||
*Select the '''Add''' button again- This will highlight a new line in the selection criteria area and the '''And/Or '''box | *Select the '''Add''' button again- This will highlight a new line in the selection criteria area and the '''And/Or '''box | ||
| − | *Select ''''And'''' | + | *Select ''''And'''' |
*Select the '''Field''' you want to filter on ie. "tblmarketingcontacts.PostCode" | *Select the '''Field''' you want to filter on ie. "tblmarketingcontacts.PostCode" | ||
*Select the '''Comparison''' drop down list - choose the comparison ''''Not Equal To''''. | *Select the '''Comparison''' drop down list - choose the comparison ''''Not Equal To''''. | ||
| Line 64: | Line 64: | ||
*'''Save''' | *'''Save''' | ||
| − | You have just created a selection criteria that reads; '''tblmarketingcontacts.postcode greater or equal to 3000''' and '''tblmarketingcontacts.postcode less or equal to 3005''' and '''tblmarketingcontacts.postcode not equal to 3001''' | + | You have just created a selection criteria that reads; '''tblmarketingcontacts.postcode greater or equal to 3000''' and '''tblmarketingcontacts.postcode less or equal to 3005''' and '''tblmarketingcontacts.postcode not equal to 3001''' |
The result when applied to a list is to show all marketing contacts with postcodes 3000, 3002, 3003, 3004 or 3005 | The result when applied to a list is to show all marketing contacts with postcodes 3000, 3002, 3003, 3004 or 3005 | ||
Revision as of 16:38, 24 June 2011
Overview
A Contact Selection Range is a filter that is applied to the Marketing Contact List in order to create a filtered or targeted list for the purpose of telemarketing. It can also be selected as a criteria for filtering the Marketing Contact List e.g. If targeting a geographical area, you would create a Contact Selection Range that filters the Marketing Contact List by Postcode.
How to use Contact Selection Range
- Select Marketing Tab
- Select Contact Selection Range
- Enter a Name for the Range to be created. The name should be descriptive enough that it is easily recognised by other users eg. Postcodes 4207 to 4210
- Select the Add button - This will highlight a new line in the selection criteria area and the Field box
- Select the Field you want to filter on from the dropdown list. eg. If you want Melbourne CBD contacts, you would most likely want everyone with a Melbourne CBD postcode (3000) therefore you will be filtering on the Postcode field - 'tblmarketingcontacts.PostCode'
- Select the Comparison drop down list - This is a list of functions that define how you want to compare the data in the 'Field' to the Value that you will enter at the next step. eg. In the above example you would choose the comparison 'Equal To'
- Select Value - enter the value being compared to eg. 3000
Note that as you populate the above fields, a search formula is being written in the selection criteria field. At this point you will see the formula"tblmarketingcontacts.postcode equal to 3000" Save or select Add again if you wish to add to this selection criteria
Using Multiple Criteria
Here is an example of how to select a range of postcodes and excluding one value within that range.
- Select Marketing Tab
- Select Contact Selection Range
- Enter a Name for the Range to be created. The name should be descriptive enough that it is easily recognised by other users ie. In this case "Postcodes 3000 to 3005 excluding 3001"
- Select the Add button - This will highlight a new line in the selection criteria area and the Fieldbox
- Select the Field you want to filter on ie. 'tblmarketingcontacts.PostCode'
- Select the Comparison drop down list - choose the comparison 'Greater or Equal to'
- Select Value - enter the value being compared to ie. 3000
- Select the And button again- This will highlight a new line in the selection criteria area and the And/Or box
- Select 'And'
- Select the Field you want to filter on ie. 'tblmarketingcontacts.PostCode'
- Select the Comparison drop down list - choose the comparison 'Less or Equal to'
- Select Value - enter the value being compared to ie. 3005
- Select the Add button again- This will highlight a new line in the selection criteria area and the And/Or box
- Select 'And'
- Select the Field you want to filter on ie. "tblmarketingcontacts.PostCode"
- Select the Comparison drop down list - choose the comparison 'Not Equal To'.
- Select Value - enter the value being compared to ie. 3001
- Save
You have just created a selection criteria that reads; tblmarketingcontacts.postcode greater or equal to 3000 and tblmarketingcontacts.postcode less or equal to 3005 and tblmarketingcontacts.postcode not equal to 3001
The result when applied to a list is to show all marketing contacts with postcodes 3000, 3002, 3003, 3004 or 3005
