Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Time between DESIRED events?

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Time between DESIRED events?

Jan 14, 2009 11:27 AM
(1456 views)

Thanks for starting the JMP forum! Looks like I'm the first non-SAS submitter, so...

I'm trying to develop factors to add to an existing likelihood-to-buy model. I'm taking known sales and create mean and stddev on time between purchases, plus a variable representing time-since-most-recent-buy. Is there a platform in JMP that could take the purchase info (one record per item purchased) and generate these stats on a per-customer basis?

I've searched JMP help for periodicity, and the closest I've seen so far is Survival and Reliability, Recurrence Analysis, but I can't see how to adapt the required Cost, End of Service field for my purposes. Of course, I can use SAS and SQL to construct the data I want, but if there's a tool that'll bypass that tedium, I'd love to use it.

Thanks for any leads,

Steve

I'm trying to develop factors to add to an existing likelihood-to-buy model. I'm taking known sales and create mean and stddev on time between purchases, plus a variable representing time-since-most-recent-buy. Is there a platform in JMP that could take the purchase info (one record per item purchased) and generate these stats on a per-customer basis?

I've searched JMP help for periodicity, and the closest I've seen so far is Survival and Reliability, Recurrence Analysis, but I can't see how to adapt the required Cost, End of Service field for my purposes. Of course, I can use SAS and SQL to construct the data I want, but if there's a tool that'll bypass that tedium, I'd love to use it.

Thanks for any leads,

Steve

6 REPLIES 6

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Time between DESIRED events?

Given what you say above, Steve, the chances are a response would come from a SAS person, and just to be clear, I am one such – Actually I work with JMP specifically.

If you want or need the convenience of working in one environment, then it’s perfectly possible (through JMP’s scripting language, JSL) to do this (at least for modest data volumes). Not sure if it’s exactly what you need, but I recently submitted an entry to the File Exchange at http://www.jmp.com/community/ that may help (there can be bit of a lag because of the review process).

To move the discussion on a little, my motivation for the above was to find some useful ways to visualise raw point of sale transactional data prior to more formal statistical modelling. Because we are all consumers in one way or another, it’s easy to appreciate that the behaviour that drives the dynamics of the buying process is non-trivial. At any rate, it seemed to me that by using summary data prematurely we are open to what’s been called ‘the flaw of averages’, which is what led me to investigate fruitful ways to look at the raw data. One idea (featured in the script) is to use a parallel coordinates plot,

Ian

If you want or need the convenience of working in one environment, then it’s perfectly possible (through JMP’s scripting language, JSL) to do this (at least for modest data volumes). Not sure if it’s exactly what you need, but I recently submitted an entry to the File Exchange at http://www.jmp.com/community/ that may help (there can be bit of a lag because of the review process).

To move the discussion on a little, my motivation for the above was to find some useful ways to visualise raw point of sale transactional data prior to more formal statistical modelling. Because we are all consumers in one way or another, it’s easy to appreciate that the behaviour that drives the dynamics of the buying process is non-trivial. At any rate, it seemed to me that by using summary data prematurely we are open to what’s been called ‘the flaw of averages’, which is what led me to investigate fruitful ways to look at the raw data. One idea (featured in the script) is to use a parallel coordinates plot,

Ian

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Time between DESIRED events?

The File Exchange entry to which Ian refers is now available here.

*Note: a SAS.com profile is required to download the file.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Time between DESIRED events?

I'm encountering two problems trying to check this out:

1) When I hit the "download now" button, I just get a web page with a missing image icon (square with a red x in it).

2) The notes on the posting say I'd need JMP 8 - I'm still at v7.

Seems like (2) means this won't help until I upgrade.

1) When I hit the "download now" button, I just get a web page with a missing image icon (square with a red x in it).

2) The notes on the posting say I'd need JMP 8 - I'm still at v7.

Seems like (2) means this won't help until I upgrade.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Time between DESIRED events?

Strange_Attractor, with regard to question 1:

Are you logged in to your sas.com profile? If so, can you download other items from the File Exchange?

Are you logged in to your sas.com profile? If so, can you download other items from the File Exchange?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Time between DESIRED events?

JJones,

Yes, the page referred to my name (not guest) at the time I tried it.

I just went back and tried to download a different one. That worked, this one still doesn't.

Yes, the page referred to my name (not guest) at the time I tried it.

I just went back and tried to download a different one. That worked, this one still doesn't.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Time between DESIRED events?

FYI - I still get the same behavior when I try to download this file.