If this description is hard to read, I also have it here: https://www.dropbox.com/s/055mfd9gcszrjsr/Database%20Job%20Interspire%20Upwork.pdf?dl=0
OVERVIEW: Need a Database Tool built that we can use inside Wordpress. The Database Tool will allow us to look at our email sending data from Interspire Email Marketer.
I use Interspire Email Marketer (http://www.interspire.com/emailmarketer/) to manage our email marketing.
My problem is that we have perhaps 50 email lists, and segmentations of those lists.
I send 5-10 emails per day, and each email is a split test of 3-4 versions. So that is possibly 40 sets of results every single day.
It is becoming too difficult and time-consuming to go into Interspire and review the individual clicks and opens and put them in a CSV file.
Interspire allows me to either export all of my sending data as a database...or they provide an API (https://www.interspire.com/support/kb/questions/1224/Email+Marketer+XML+API+Documentation).
Using our some sample data, we would like to have a simple database tool built so we can quickly see our email sending results.
Will need to be able to query the database by
- Email List
- Email Name
and see the results the database provides, which is Emails Sent, Data and Time, Open Rate and Click Rate.
If the functionality could be built inside Wordpress, this would allow us to have a simple web interface.
An additional feature I would consider paying for would be querying options that would allow for smarter marketing. For example:
- Show Emails with highest /lowest Open Rate
- Show Emails with highest /lowest Click Rate
- Comparisons of Emails, etc