When my team signed up for RCA, this was a report that we were all very excited about because it can help with ROI a lot. I think one of the largest issues with this report is the fact that you cannot set an attribution period in which leads successfully touched or acquired by the program will cease to attribute to opportunities under an account.
What I have below is a screenshot of the report highlighting a single opportunity where many programs were involved. The opportunity was closed in July 2014 and 3 programs from May/June 2012 are attributed to the opportunity. One of the acquisition programs is from 2011!
There needs to be a global setting that can be updated that turns off the program attribution after a certain number of years or any time period of your choosing for that matter. Otherwise, your reporting will be skewed and the oldest programs will always seem to be the best performers, because they are indefinitely getting attributed to opportunities. This is especially an issue if your customers repeat purchases and are transactional. This is a must have.