Downstrung
New Member
Hello! I'm very new to the forum and am hopeful it will help! I need to recover from a blunder caused by my email marketing software. I sent out a survey but the responses all came back as anonymous, with the exception of respondents IP addresses. In my client database, I have a list of most of my clients IP address so I'm hoping to be able to cross reference (I don't know if there's a more appropriate term for this) the two lists (I have them exported as CSVs) and identify the name that corresponds with the IP address.
The master database lists IP addresses in column G with essential client info (name and email addresses) in columns B & C, while the incomplete survey lists the IP address in column D, with columns B & C ready to be filled from the database with names and email addresses for the matches. Also relevant is that the incomplete survey has on average 4-6 rows per client correlating to the different questions - they can either all be filled with the same name & email or just the first row, doesn't matter to me.
I realize that due to IP discrepancies and other variables it may not be possible for me to recover the entire list, but I would like to get as many of them matched as possible. I manually searched the first two IP addresses and found a match for one of the two - even 50% is good enough for me at this point! The survey has ~200 unique entries and my database was parsed to only include those who responded (exported based on those who clicked the survey link).
I'm going to tinker with Excel and see if anything jumps out as far as a way to do this, but figured I'd ask here as well. Perhaps this is a noob question, but I'm a noob!
Thanks in advance!
The master database lists IP addresses in column G with essential client info (name and email addresses) in columns B & C, while the incomplete survey lists the IP address in column D, with columns B & C ready to be filled from the database with names and email addresses for the matches. Also relevant is that the incomplete survey has on average 4-6 rows per client correlating to the different questions - they can either all be filled with the same name & email or just the first row, doesn't matter to me.
I realize that due to IP discrepancies and other variables it may not be possible for me to recover the entire list, but I would like to get as many of them matched as possible. I manually searched the first two IP addresses and found a match for one of the two - even 50% is good enough for me at this point! The survey has ~200 unique entries and my database was parsed to only include those who responded (exported based on those who clicked the survey link).
I'm going to tinker with Excel and see if anything jumps out as far as a way to do this, but figured I'd ask here as well. Perhaps this is a noob question, but I'm a noob!
Thanks in advance!