I have a mass mailer program installed in my server which creates metrics from the emails delivered. This data is stored in a data base, but I encountered a problem to extract the ids from the users that opened the email. Each campaign I send, stores the ids of the users that opens the email in a row using the following format:
One row for each campaign..
6130 is the id for the user and CO is the country
I want to be able to select the campaign title and to see which users opened that campaign. This is the layout..