I want to create a database that will store data about every visitor session in my website.
A. The data should include:
1. General data such as:
-Date and time of visit
-IP address
-browser info
-entry page URL
-exit page URL
-time spent in the website
2. Several designated columns, for certain url strings that the visitor might have arrived with:
Example:
A visitor arrives to "[login to view URL]",
I want to strip down the "?source=partner1&adtype=banner" from the URL address bar (which can be done with a 302 redirect).
Simultaneously, I want to store the "source=partner1" and "adtype=banner" values in the session data,
and have in database designated columns named "referrer" and "type of ad", that would contain the values "partner1" and "banner" under that session׳s row.
3. Actions which the visitor took on the website, probably in the form of events (Note that this is dynamic data that should be updated while the session is ongoing)
Example:
I have a "more info" button that pops up a modal window. If I a visitor clicked that button, I want it to be indicated in the database.
4. Unique Identifying number:
Each row in the database be given a unique identifying number or value (that should never repeat again).
B. I am also strongly interested in the option of having that database communicate with another external data source, in the form of an automatic XML request every 30 minutes to that external source, and look up the aforementioned unique identifying number, and in case it finds it, it should import the content of another field which correlates with this number in that XML output (I have the relevant information and access keys in order to make a manual XML request from that source).
C. General :
- I am thinking about having such a database separately for each month of the year.
- In general I am open to any of your advice and suggestions about the optimal way for building this whole project.
- I would like to be able to view the database with Microsoft Excel so I can analyze it occasionally and draw conclusions about user behavior.
- I need the database to be flexible in case I would like to add more data columns to it in the future.
- I also want to know if it will be possible to manually edit and modify the database from a friendly excel-like interface (though without running over new data that was generated by new sessions while I was modifying older sessions).
- I will also need a basic explanation about how the code works and what every line of code does, perhaps, in the form of comments within the code.
- The database should not slow down the website.
- It should be stored in a secured way to prevent it from being obtained by unauthorized sources.
Dear Sir
we are capable of performing the required task perfectly with accuracy,
please let us know if you want to clarify in details..
if you want us to share our skill and previous work
please initiate the chat by replying..
hope to hear you soon..
--
Thanks & Regards
PROMITI
Hello Sir,
We have studied all of the requested features very closely, and we have one question.
Q : Can you kindly explain point "B":
B. I am also strongly interested in the option of having that database communicate with another external data source, in the form of an automatic XML request every 30 minutes to that external source, and look up the aforementioned unique identifying number, and in case it finds it, it should import the content of another field which correlates with this number in that XML output (I have the relevant information and access keys in order to make a manual XML request from that source).
Waiting for your response.
regards
Ali ...
Hello sir,
Which platform do you use ?? I mean Wordpress, Magento, Shopify or what ??
Waiting for your reply. I have done such thing before but i need to know about your platform.
Thanks,
Sakib
Hi,
I have reviewed your project details and I would like to work on this, please send me the details.
Please come over to a conversation so that we can have a better discussion.
regards
sainul
Dear Employer ,
we have been in this industry for 7 years and such jobs are our daily practice in separate. This is our first time on this site and hence you can see that we do not have any ratings/testimonials to show you. we can assure you that if you work with us once, you will always look for us for these kind of projects.
We are looking forward to hear from you to discuss further about our job description .
Best Regard
Hi,
Good Day!!
I reviewed your post and It is doable. Thanks for the details. We can easily deliver with our certified developers But it will be great if we can discuss/chat a bit more.
We are new in this freelancing site, that is why we have very less rating but you will get Quality work & satisfactory job guaranteed, else money refundable.
KINDLY NOTE:
1. This bid & the duration provided by me is based on actual specification that you have written/ uploaded in the project description.
2. We might be from different time zones, so there might be delays in replies. But will try my best to reply ASAP.
3. Delivery time is contingent on good communication between us and could be shorter or longer depending on how easily I can get in touch with you when it is necessary.
If you have any question please let me know.
I have worked in MNC for 2 years and within this short period of time i have gained enough appreciations from my managers and lead. I will provide quality work.