The API will get you some of what you want, but you'd have to calculate some of the values yourself. From what I've seen in the API documentation and in the forum, you can pull down the program ID, the members of the program, their status' in the program, etc., but it's all point-in-time.
To get to WoW or MoM reports, you'd have to pull the data down for those programs weekly and calculate new members (based on new members since the last data extract), as well as progression down the funnel via their status (again, compared to the previous data extract).
Not the easiest solution but that would likely get you what you need. If you don't want to use the API, you could do an export weekly of program members for the program in status and do the same type of thing using excel, but more manual work :/
So I found an intermediate solution that won't be real-time per say, but it did work for me. I created a report subscription for the Program Performance report, so it would pull daily. From there, I set up a Macro in Excel that would merge two of these reports into an Macro-enabled Excel Workbook.
In running the macro, it:
- Merged the two files together
- Solved for the member change number in the program and summed up all entries within the table [note: I .
- Formatted the table and sorted by highest change
If anyone wants to know more, I can do my best to walk through my process along with sending over my spreadsheet. I did this for both MoM and WoW reports.
