Wordpress Script to track Visits and Clicks
$30-250 USD
Πληρώθηκε κατά την παράδοση
I need a script which can be included in wordpress to track unique visits and clicks on a certain link.
After initialising the tracked user, the var "clienthash" is stored in a session which is used again, if the user clicks on a certain link.
I need these script(s) to work on a wordpress installation.
the format of the database looks like that:
TABLE `track_visit` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`domain` varchar(30) DEFAULT NULL, --> is a fixed var like "[url removed, login to view]"
`landingpage` varchar(250) DEFAULT NULL, --> track the landingpage of the visitor
`organic_keyword` varchar(150) DEFAULT NULL, --> is there a keyword which can be stored?
`referer` varchar(150) DEFAULT NULL, --> the referer is stored if available
`campaign` varchar(60) DEFAULT NULL, --> are there utm-params? if yes, store all the params
`subid` varchar(100) DEFAULT NULL, --> create a uuid and store it
`gclid` varchar(150) DEFAULT NULL, --> is there a url param "gclid" available? yes-> store it
`ip` varchar(17) DEFAULT NULL,
`useragent` varchar(200) DEFAULT NULL,
`initdate` datetime DEFAULT NULL,
`clienthash` varchar(32) DEFAULT NULL, --> create a md5 hash of ip+useragent and set the session cookie
`utma` varchar(250) DEFAULT NULL, --> are theses google analytics cookies available? if yes, store it! always check again with each new visit if there are these cookies available and if they are available, update the datarow and add these data to the row
`utmc` varchar(250) DEFAULT NULL,
`utmz` varchar(250) DEFAULT NULL,
PRIMARY KEY (`id`)
Create a script which is called like "[url removed, login to view]" and which gets this data from the table "track_reflinks". The script creates an entry in the table "track_click" with the information about the user (=session cookie with the data of the var "clienthash") and the information from the table "track_reflinks". the user gets the information that he will be forwarded automatically (and if it doesn'nt work he should click on this link).
TABLE `track_click` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` varchar(200) DEFAULT NULL,
`vendor` varchar(50) DEFAULT NULL,
`product` varchar(50) DEFAULT NULL,
`category` varchar(50) DEFAULT NULL,
`target` varchar(250) DEFAULT NULL,
`clickdate` datetime DEFAULT NULL,
`cta` varchar(50) DEFAULT NULL,
`att1` varchar(50) DEFAULT NULL,
`att2` varchar(50) DEFAULT NULL,
`att3` varchar(50) DEFAULT NULL,
`att4` varchar(50) DEFAULT NULL,
`att5` varchar(50) DEFAULT NULL,
`referer` varchar(150) DEFAULT NULL,
`utma` varchar(150) DEFAULT NULL,
`utmc` varchar(150) DEFAULT NULL,
`utmz` varchar(150) DEFAULT NULL,
PRIMARY KEY (`id`)
)
in this table you can find the information about the url etc.
TABLE `track_reflinks` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`vendor` varchar(50) DEFAULT NULL,
`product` varchar(50) DEFAULT NULL,
`category` varchar(50) DEFAULT NULL,
`target` varchar(200) DEFAULT NULL,
PRIMARY KEY (`id`)
)
one thing that I forgot:
when clicking on the link, the refering url gets an extra param which is called "id" and the value of the param is subid from the table "track_visit"
Ταυτότητα Εργασίας: #8248058
Σχετικά με την εργασία
Ανατέθηκε στον:
Hello. Wordpress dev expert ready to help you with tracking script. I have more 200 good reviews in dev projects, so all will be done on highest level. Please, do not award project until we will clear details.
17 freelancers κάνουν προσφορές κατά μέσο όρο $184 για αυτή τη δουλειά
Hi, we have read all the requirements and we are very confident to do this project from start till end. We definitely have some questions when we discuss project with you. Due to the change of bid system at freelancer. Περισσότερα
I have read your project details, and I am interested in offering my services. I provide 100% satisfaction guaranteed on all my work. Milestone is required to begin; to be released when the job has been satisfactor Περισσότερα
Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks
Hi, I'm senior web developer and I'm very interested in your project. I've done many Wordpress projects. Hope I will have a chance to work for you on this project. Please contact me. Thanks
Dear Employer, I am ready to work on your required task and can assure 100% satisfaction. You can read reviews/details about my past work on my profile http://www.freelancer.com/u/alyaspk.html Looking forward to Περισσότερα
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably Περισσότερα
Dear You, I am really interested to work on this project, I can start the work now , and can provide the best services from my end. Please come on chat to discuss more about the project. Thanks! Mr Khoa
I've experienced team to develop web applications and we're willing to do this job. we can do what you want in minimum time. we'll provide best service. Give a chance and you will get what you want.
