Custom Web Report Tool V1 for Reciprocity Media
- or -
Post a project like this$$
- Posted:
- Proposals: 1
- Remote
- #1005190
- Expired
Description
Experience Level: Intermediate
I got a Database that registers the exact moment when a User logins to my WiFi Hotspots. It registers the following columns:
Date - Session Length - Username - Location - Upload - Download- Device - Reason for termination - Name - Gender - Profile URL - MAC - Social Type
The project needs to be done in 3 steps:
1.- Create working queries based on my Database (.csv)
-Average Days between visits (per user)( and globally) on specific location (Specific Time: Monthly, Last 3 Months, Etc)
- Amount of Visits (sum) (specific location) (Specific Time: Monthly, Last 3 Months, Etc)
- List of Users with only 1 visit (specific location)
- Sum of Minutes Connected per User (specific location)
- List of Users that Cross-Visit Locations (connect on multiple locations in different days)
2.- Deliver Data based on Queries (Manual Reports)(tables).
The Table Reports shall include the following Data: USERNAME - NAME - LOCATION- GENDER - PROFILE URL --- Plus the Data Obtained.
3.- Create a Web Based Software that delivers the same Data (Reports) Automatically (exportable to Excel).
After this we can talk about V2 (visual reports and custom reporting via the website with login methods for my clients)
I can be more specific by phone or skype for you to tell me the aproximately time needed on each step of v1.
Date - Session Length - Username - Location - Upload - Download- Device - Reason for termination - Name - Gender - Profile URL - MAC - Social Type
The project needs to be done in 3 steps:
1.- Create working queries based on my Database (.csv)
-Average Days between visits (per user)( and globally) on specific location (Specific Time: Monthly, Last 3 Months, Etc)
- Amount of Visits (sum) (specific location) (Specific Time: Monthly, Last 3 Months, Etc)
- List of Users with only 1 visit (specific location)
- Sum of Minutes Connected per User (specific location)
- List of Users that Cross-Visit Locations (connect on multiple locations in different days)
2.- Deliver Data based on Queries (Manual Reports)(tables).
The Table Reports shall include the following Data: USERNAME - NAME - LOCATION- GENDER - PROFILE URL --- Plus the Data Obtained.
3.- Create a Web Based Software that delivers the same Data (Reports) Automatically (exportable to Excel).
After this we can talk about V2 (visual reports and custom reporting via the website with login methods for my clients)
I can be more specific by phone or skype for you to tell me the aproximately time needed on each step of v1.
ANDRES M.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
0%
Last project
15 Jun 2016
Mexico
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies