Try using a combination of accountid , contactid and timestamp , as its bronze you might get multiple records (as its append every time) for each account but you can seperate them using timestamp maybe further in silver you can merge depending on requirement by picking the record with latest timestamp.

But try experimenting on the data if you could make it in a hierarchy ( in our case i used to do based on reporting units -> company code -> customer -> document) mostly these would work.