How to dedouble transactions

Copper Contributor

Hi,

I have a list from Google Analytics with transaction ID's and a list from our affiliate partner with their transaction ID's for which we are charged commission.

I wish to dedouble the transaction ID's from the affiliate partner with our Analytics data transactions. Why: because some transactions from the affiliate partner are not registered in the Analytics data and therefore can not be attributed.

How can I do this using Excel? I know the vlookup function might do it but I don't know how to properly do it :\

Thanks in advance for any kind of help or advice! 

Jeroen

1 Reply
Can you perhaps post an anonymised example of the data?