The mkt_flag60 has both positive and negative value, despite the negative being only associated to target=1. This make sense as the mkt_flag tell us if a marketing touchpoint was present, and if to that touchpoint followed up an opportunity or not (there are no record where a marketing touchpoint did not happen; but there are records where an opportunity happened BUT no marketing touchpoint was not present) Those opp 12 and 24 records count the number of opportunities in the previous 12 and 24 months preceding the marketing date (or before the 60th day before the opportunity date, if not marketing touchpoint did happen) The int_60 days measure if there were other marketing touchpoints BEFORE the last touchpoint described bu the mkt_flag60. There are only values ONLY IF there is a mkt_flag=1 (as if there is no mkt touchpoint, then there can't be a chain of mkt touchpoint before that)
... View more
