Difference between revisions of "Configuring Automated Wave Campaigns"
>Johno (→Selection Worksheet) |
>Johno (→Selection Worksheet) |
||
| Line 176: | Line 176: | ||
| Global | | Global | ||
| 4 | | 4 | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| Field | | Field | ||
| OK_TO_MAIL | | OK_TO_MAIL | ||
| Line 194: | Line 188: | ||
| eStatements | | eStatements | ||
| 1 | | 1 | ||
| + | | Field | ||
| + | | MBR_ACCOUNT | ||
| + | | =age(only(Wave_Start_Date), MBR_BIRTH_DATE)>=18 | ||
| + | |- | ||
| + | | eStatements | ||
| + | | 2 | ||
| Field | | Field | ||
| eSTATEMENTS | | eSTATEMENTS | ||
| Line 203: | Line 203: | ||
| | | | ||
| | | | ||
| + | |- | ||
| + | | eStatements | ||
| + | | 1 | ||
| + | | Field | ||
| + | | MBR_ACCOUNT | ||
| + | | =age(only(Wave_Start_Date), MBR_BIRTH_DATE)>=18 | ||
|- | |- | ||
| CDs | | CDs | ||
| − | | | + | | 2 |
| Field | | Field | ||
| MBR_TOT_SH_BALANCE | | MBR_TOT_SH_BALANCE | ||
| Line 219: | Line 225: | ||
| 1 | | 1 | ||
| Field | | Field | ||
| − | | | + | | MBR_ACCOUNT |
| − | | > | + | | =age(only(Wave_Start_Date), MBR_BIRTH_DATE)>=18 |
|- | |- | ||
| Loans | | Loans | ||
| 2 | | 2 | ||
| + | | Field | ||
| + | | MBR_TOT_LN_COUNT | ||
| + | | <1 | ||
| + | |- | ||
| + | | Loans | ||
| + | | 3 | ||
| Field | | Field | ||
| MBR_CREDIT_SCORE | | MBR_CREDIT_SCORE | ||
| >620 | | >620 | ||
| + | |- | ||
| + | | Survey | ||
| + | | 1 | ||
| + | | Field | ||
| + | | MBR_ACCOUNT | ||
| + | | =age(only(Wave_Start_Date), MBR_BIRTH_DATE)>=18 | ||
|} | |} | ||
| − | # The | + | # The step '''JoinLetter''' uses the '''Global''' selection and does not have any additional selection criteria. |
| + | # The age restriction is repeated in all steps except '''JoinLetter''' since members under 18 will still get the welcome letter. | ||
# The syntax shown here is currently untested. | # The syntax shown here is currently untested. | ||
Revision as of 01:30, 12 February 2016
Summary
Automated Wave Campaigns are configured in a spreadsheet called WaveCampaigns, located in the data/config directory.
The file contains two global worksheets (tabs) called WaveConfig and Campaigns, plus an additional worksheet (tab) for each Wave name. For example, a wave campaign called Welcome, will include a worksheet called Welcome containing all of the specific selection criteria needed to execute all steps of the wave campaign.
WaveConfig Worksheet
The WaveConfig worksheet contains one record for each different wave campaign:
| Excel Column (Note) | Purpose |
| WaveName | The unique wave campaign name. |
| WaveStartDays (1) | The ending month day number the wave uses. May be a semi-colon delimited list if the wave runs multiple times per month. |
| WaveMaxSteps | The maximum number of steps executed by this wave campaign. |
| WaveFilePath (2) | The output file path where the wave files are created. |
| WaveEmailList (3) | A semi-colon delimited list of email addresses to receive confirmation that the wave files were created. |
- This day number represents the day the wave was created and may be used as part of the selection criteria. If the wave runs more than once per month, this is a semi-colon delimited list.
- The specified path is a sub-directory of data/config and must exist.
- Not all configurations support email notifications. Since GenWaveData uses the Vital Signs document distribution engine, the ViewDocLog document is a good way to review the results of GenWaveData.
For example, a Welcome wave campaign might look like this:
| WaveName | WaveStartDays | WaveMaxSteps | WaveFilePath | WaveEmailList |
| Welcome | 15 | 5 | WelcomeWave |
Campaigns Worksheet
The Campaigns worksheet contains one record for each step of each different wave campaign:
| Excel Column (Note) | Purpose |
| WaveName | The unique wave campaign name. |
| CampaignName | The name of the campaign for that wave step. |
| Step | The step number. |
| ExportType | The export type is usually Export, but can be any type supported by document distribution. |
| Definition | The ID of the object being exported. Usually one of MBR_ADDR_DATA or MBR_PHONE_DATA. |
| ProdType | The product type being promoted. One of: Share, Loan or Service. |
| ProdCodes | A list of valid product codes. |
For example, the Welcome wave campaign might look like this:
| WaveName | Step | CampaignName | ExportType | Definition | ProdType | ProdCodes |
| Welcome | 1 | JoinLetter | Export | MBR_PHONE_DATA | ||
| Welcome | 2 | eStatements | Export | MBR_ADDR_DATA | Service | 79 |
| Welcome | 3 | CDs | Export | MBR_ADDR_DATA | Share | C06;C12;C18;C24 |
| Welcome | 4 | Loans | Export | MBR_ADDR_DATA | Loan | 21;31;41 |
| Welcome | 5 | Survey | Export | MBR_ADDR_DATA |
Selection Worksheet
Each wave campaign needs a Selection worksheet to specify the selection criteria for each step of the wave. The worksheet name is the same as the WaveName.
The column names in this worksheet are the same as a selection worksheet in document distribution.
See defining a selection for more information on how to create a selection.
With wave campaigns, an optional Global selection is followed by an optional selection specific for that step in the wave. The StepName is used as the selection name.
The following table shows an example for the Welcome wave campaign:
| Name | Step | Type | TypeName | TypeValue |
| Global | 1 | SetVar | OpenStartDate | =Date(MonthStart(Only(Wave_Start_Date)),'YYYY-MM-DD') |
| Global | 2 | SetVar | OpenEndDate | =Date(MonthEnd(Only(Wave_Start_Date)),'YYYY-MM-DD') |
| Global | 2 | SetVar | OpenEndDate | =Date(MonthEnd(Only(Wave_Start_Date)),'YYYY-MM-DD') |
| Global | 3 | Field | MBR_OPEN_DATE | >=$(OpenStartDate)<=$(OpenEndDate) |
| Global | 4 | Field | OK_TO_MAIL | Yes |
| eStatements | 1 | Field | MBR_ACCOUNT | =age(only(Wave_Start_Date), MBR_BIRTH_DATE)>=18 |
| eStatements | 2 | Field | eSTATEMENTS | No |
| eStatements | 1 | Field | MBR_ACCOUNT | =age(only(Wave_Start_Date), MBR_BIRTH_DATE)>=18 |
| CDs | 2 | Field | MBR_TOT_SH_BALANCE | >=5000 |
| Loans | 1 | Field | MBR_ACCOUNT | =age(only(Wave_Start_Date), MBR_BIRTH_DATE)>=18 |
| Loans | 2 | Field | MBR_TOT_LN_COUNT | <1 |
| Loans | 3 | Field | MBR_CREDIT_SCORE | >620 |
| Survey | 1 | Field | MBR_ACCOUNT | =age(only(Wave_Start_Date), MBR_BIRTH_DATE)>=18 |
- The step JoinLetter uses the Global selection and does not have any additional selection criteria.
- The age restriction is repeated in all steps except JoinLetter since members under 18 will still get the welcome letter.
- The syntax shown here is currently untested.
