Creating macros

Create a macro:
- Press in the left-hand menu bar to bring up the list of macros
- Press in the list of macros to create a new macro
- Configure the macro:
  - Name: NumOfWeeks
  - Minimum Parameters: 2
  - Maximum Parameters: 2
  - Expression: create an expression to work out the number of weeks - as a whole number – between two dates
    - Use the functions dateDiff() and round() to help with this
- Press to save your new macro

Using Macros

Create a new model: Try Macros
Drag the Stream MC Macro Terminated Customers on to your model

This contains some key dates for terminated customers: the signup date; the date that the customer terminated their service; the date that the final debt on the customer's account was cleared

Add attributes for:
- the number of weeks between signup and termination
- the number of weeks between termination and the final debt being cleared
In each case, use your macro to calculate the number of weeks between the two dates
Run the stream MC Macro Terminated Customers to test your new attributes

Browser not supported