dotsandcoms
asked on
track open rate of email newsletter
hi folks,
I am sending the newsletter to some of the users. I want to track whether they have opened the newsletter or not programmatically.
how can i achieve this?
Any help will be appreciated.
I am sending the newsletter to some of the users. I want to track whether they have opened the newsletter or not programmatically.
how can i achieve this?
Any help will be appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you have told your customers that you will be placing becon images in newsletters, then you are within your right to place a transparent 1px by 1px image inside your email. Point this becon image to be an ASPX page that can keep track in a database of the number of hits to it.
Cheers,
G.
Cheers,
G.
Its a tricky thing to do, because most mail clients will block images, because thats how spammers confirm a working email address, so your stats, if using images, wont be completely accurate.
Another way would be to require a read receipt, but a lot of web based emails dont support this, and even if it does, some people just ignore it or choose not to send it.
You could use a cheeky JavaScript that launched on page load to call a handler page that updated your database, but the user could be reading mail whilst offline, or the script could be blocked.
If this is a request from the marketing team, I'd advise them that there's no certain way of knowing how many people have read the newsletter :)
Another way would be to require a read receipt, but a lot of web based emails dont support this, and even if it does, some people just ignore it or choose not to send it.
You could use a cheeky JavaScript that launched on page load to call a handler page that updated your database, but the user could be reading mail whilst offline, or the script could be blocked.
If this is a request from the marketing team, I'd advise them that there's no certain way of knowing how many people have read the newsletter :)
ASKER
hi darshan_derasari,
how can i return the image in response.
I am using the below coding but not getting the image in return:
PowerGeneralFunction objGen;
string strQuery = "";
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["camp id"] == null)
{
if (Request.QueryString["camp id"].ToStr ing() == "")
{
Response.Redirect("http://www.cocoona.ae/");
}
}
if (Request.QueryString["emai lid"] == null)
{
if (Request.QueryString["emai lid"].ToSt ring() == "")
{
Response.Redirect("http://www.cocoona.ae/");
}
}
this.Camp_Details();
}
protected string Camp_Details()
{
int result = 0;
objGen = new PowerGeneralFunction();
try
{
strQuery = "Insert into campaignRead (campid,nemail,addedip,add eddate,rea dnl) values ( " + Request.QueryString["campi d"].ToStri ng().Repla ce("'", "'") + ",'" + Request.QueryString["email id"].ToStr ing().Repl ace("'", "'") + "','" + this.FinalIP() + "','" + System.DateTime.Now + "',1)";
result = objGen.InsertUpdateDeleteC ommand(str Query);
if (result > 0)
{
return "http://www.cocoona.ae/images/knews.jpg";
}
}
catch (Exception ex)
{
return "http://www.cocoona.ae/images/knews.jpg";
}
finally
{
strQuery = "";
objGen = null;
}
return "http://www.cocoona.ae/images/knews.jpg";
}
public string FinalIP()
{
string strHostName = "";
strHostName = System.Net.Dns.GetHostName ();
IPHostEntry ipEntry = System.Net.Dns.GetHostEntr y(strHostN ame);
IPAddress[] addr = ipEntry.AddressList; return addr[addr.Length - 1].ToString();
}
how can i return the image in response.
I am using the below coding but not getting the image in return:
PowerGeneralFunction objGen;
string strQuery = "";
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["camp
{
if (Request.QueryString["camp
{
Response.Redirect("http://www.cocoona.ae/");
}
}
if (Request.QueryString["emai
{
if (Request.QueryString["emai
{
Response.Redirect("http://www.cocoona.ae/");
}
}
this.Camp_Details();
}
protected string Camp_Details()
{
int result = 0;
objGen = new PowerGeneralFunction();
try
{
strQuery = "Insert into campaignRead (campid,nemail,addedip,add
result = objGen.InsertUpdateDeleteC
if (result > 0)
{
return "http://www.cocoona.ae/images/knews.jpg";
}
}
catch (Exception ex)
{
return "http://www.cocoona.ae/images/knews.jpg";
}
finally
{
strQuery = "";
objGen = null;
}
return "http://www.cocoona.ae/images/knews.jpg";
}
public string FinalIP()
{
string strHostName = "";
strHostName = System.Net.Dns.GetHostName
IPHostEntry ipEntry = System.Net.Dns.GetHostEntr
IPAddress[] addr = ipEntry.AddressList; return addr[addr.Length - 1].ToString();
}
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
You can't, the best you can hope for is to ask them to inform you they have done so.