I'm testing sendy, sending campaigns, creating lists, subscribers, everything works fine. But what is the table ares and ares_email for? Where does sendy logs to whom I send the campaigns?
Thanks Ben, and where does sendy register to whom I sent the campaigns and who opened it? Besides the id of the list, I can see inside the campaign details that it shows wich users opened the campaign, but I can't see that reflected in the db.
Who you send it to: to_send_lists column in campaigns table
Who opened it: opens column in campaigns table
The to_send_lists column in campaigns table stores all the lists' ids separated by comma. To check who's in the list(s), go to subscribers table and query with the list id.
The opens column in campaigns table stores all subscriber's ids and country code separated by comma.
Comments
They are for autoresponders.
Thanks Ben, and where does sendy register to whom I sent the campaigns and who opened it? Besides the id of the list, I can see inside the campaign details that it shows wich users opened the campaign, but I can't see that reflected in the db.
Hi Marcelo,
to_send_listscolumn incampaignstableopenscolumn incampaignstableThe
to_send_listscolumn incampaignstable stores all the lists' ids separated by comma. To check who's in the list(s), go tosubscriberstable and query with the list id.The
openscolumn incampaignstable stores all subscriber's ids and country code separated by comma.Ben