Email Reporting

Posted on 2011-10-06
Medium Priority
Last Modified: 2012-05-12
hey guys, i am sending out emails on a monthly bases and want to keep track on who check my mail.

on my website a have a specails page and on the email i have a link that links to the specials page, i just want to do a report of who went to the specials page from my email.

my customer have a code and is stored in my database.

can someone help me?

i am programming in c# code
Question by:JCWEBHOST
  • 2
  • 2
LVL 26

Expert Comment

by:Anurag Thakur
ID: 36929020
First you cannot find out whether the user went to the special page from the email or just directly unless the link in the email has a querystring property indicating the same (on the page load even you can find the query string value and if the value is returned you can identify the call came from the email link else directly)

regarding users - is it a intranet application or internet application
in case of intranet application it should be windows authentication (assuming you are running on windows machines and have an active directory) so the request for credentials can easily provide you the logged in user name (domain name)

In case its a simple website hosted on internet the call will always be anonymous and its going to be difficult to identify the caller
LVL 19

Expert Comment

ID: 36930066
What we do in those cases is to send a link to the site inside the mails, and in the link include a parameter with the client id, this way, when the email link is clicked the user id parameter on the querystring allows our server code to know that it's reached through the link of an email (and not directly, where that parameters should be empty) and what client id did it.

Author Comment

ID: 36930419
sweet that corret but how can i make a coloum in the databse for every month?

LVL 19

Expert Comment

ID: 36931235
Mmm... I'm not sure why do you need that....

why don't you pass the month or the date as another parameter into the querystring so your server script can know the month in which the email was sent?
LVL 26

Accepted Solution

Anurag Thakur earned 2000 total points
ID: 36940791
even i am not sure whey will you need a column for every month when you can achieve the same functionality by have a date time column and through it we can find out when the link was clicked by saving the time stamp on click or page open

as mentioned by @Bardobrave you can add the client id and the email sent date as one of the querystring parameters and then they can be save to the db

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
High user turnover can cause old/redundant user data to consume valuable space. UserResourceCleanup was developed to address this by automatically deleting user folders when the user account is deleted.
Screencast - Getting to Know the Pipeline
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses
Course of the Month14 days, 9 hours left to enroll

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question