MEMCM itself will only keep the records for ~370 days. If you enable the data warehouse, it will keep the records for 3-5 years (if I remember right). So you might need to create a custom solutions for this. But I would start with the Data warehouse.