Web Widget Data Visualization
- Status: Pending
- Hadiah: $385
- Penyertaan diterima: 2
- Pemenang: Donc310
I am wanting a JS or similar widget made that can be embedded in a website. It will use a updated monthly table of data, or can be hooked straight into a mysql table, or other cloud based resource.
The base file has a ID which is a unique Visitor ID, and the State that ID is in, then the Chain Locations that the ID has visited along with a Frequency code of either Mild (1-2), Moderate (3-4), Frequent (5+).
The Mild (1-2), Moderate (3-4), Frequent (5+) indicates how often the MAID is visiting that particular chain.
What I would like a user to be able to do on the tool is to Select either Nation Wide or select states and then select what Location, or even the Level_1 or Level_2 selects and it to display as a heat map by state with a qty the total ID's that have been there. As you can see we track a number of locations that a given Visitor ID is found at. We would want to count Unique ID.
I can either roll up our main ID table and make it so that it just has totals by Chain or Totals by Level_1 & Level_2 or I can let this tool hit the main ID table.
The goal is to have one Basic Function widget, it will be used to just provide rough analysis. Then to have a more complex visual tool that can actually in the end output the ID's based on how the criteria was filtered.
The more advanced widget you might be able to for example filter all those that have gone to Starbucks that are a Frequent Visitor in these 10 states. And then on Step2 (Analyze This Audience) It would be cool to then Look at those ID's and provide the analysis of what other Locations those ID's go to. So that in essence they could filter down just the ID's that go to Starbucks and then also goto Subway and CVS and just pull that pocket of data.
Step 3 it would take their total final qty of Visitor ID's and fit that in a pre-defined bucket of required credits to pull the data down. And then prompt them to purchase the correct credits on the next page.
This needs to be simple, and be able to work inside a sales funnel, we are using Click Funnels to automate the access to this widget.
I have attached some sample files. as well as some sketches that was a rough idea.
All final delivery code must be verified.
Rolled up totals for Chain Totals building in the location Categories
[login to view URL]