Sankey/Flow Diagram Data Structure

Hi Everyone, I am trying to use Sankey diagram for the first time and after several hours of research and experimentation, I still can't figure out how to get the data structure formatted the way it needs to be. I'm attempting to basically translate Google Anlaytics Multi Touch Attribution data into a data flow visualization to quantify and visualize the number of conversions from each journey type. I understand that the structure must be as follows: Source Destination Weight/Value The following is an example of the data set that comes out of GA: ________PATH______________ _____# of Conversions_____ _____Conversion Value_______ Email > Paid Search > Email > Organic 90 $1,500 Paid Search > Direct > Email 77 $1,239 So I have gotten as far as splitting the various path types by a > delimiter, but I don't know how to structure/group all the various path combinations when there could be repeating channels at different touch points of the path. I would really appreciate it if someone could give me some direction on the way to structure the data to make Sankey charts work. Thanks in advance! LeMarc