Web Widget Data Visualization

  • Status: Pending
  • Hadiah: $385
  • Penyertaan diterima: 2
  • Pemenang: Donc310

Ringkasan Peraduan

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]

Kemahiran Disyorkan

Penyertaan teratas dari peraduan ini

Lihat Lagi Entri

Papan Penjelasan Umum

  • fdjbuhr
    Penganjur Peraduan
    • 1 minggu yang lalu

    The difficult decision I am at is you both have done a fantastic job! And there are pieces I actually want from both. Mon Mohon's is fast and snappy. Chibuzor's is very responsive and has a nice search feature to it. decision will be made today.

    • 1 minggu yang lalu
  • fdjbuhr
    Penganjur Peraduan
    • 2 minggu yang lalu

    How difficult would it be to make it so on State selection, you could click on the states to add them to the search?

    • 2 minggu yang lalu
    1. Donc310
      Donc310
      • 1 minggu yang lalu

      Hi , I have pushed some updates to my build , it now implements a click to add states to search functionality. let me know when you test it .. Thanks . looking forward to your feedback

      • 1 minggu yang lalu
    2. Donc310
      Donc310
      • 1 minggu yang lalu

      PLEASE NOTE : DELETE PREVIOUS STORED SEARCHES BEFORE TESTING...

      • 1 minggu yang lalu
  • Donc310
    Donc310
    • 2 minggu yang lalu

    Hello , I have made some changes. one of which is the new search button once click it will initiate a new search . Also I have added a feature which saves every search performed by a user . This will be saved even though if the page is reloaded

    • 2 minggu yang lalu
    1. Donc310
      Donc310
      • 2 minggu yang lalu

      Looking forward to a feedback from you . Thank you and have a nice day.

      • 2 minggu yang lalu
  • fdjbuhr
    Penganjur Peraduan
    • 2 minggu yang lalu

    https://contestwidget.herokuapp.com/index.html

    Like the intro step-by-step tutorial.
    like the functionality of this platform (i.e., search and hit “enter” to add my search criteria vs. the other platform where I have to “click” the buttons).
    Like how I can click back on ‘search’ to do modifications/edits to the same search vs. having to start over with the other widget.
    I also think it is easier to navigate by NOT having the various “level” filters.
    Don’t like only place to do a “New Search” is under the “Summary” tab/view.
    It might be better to add another option after the “summary” tab/view that says “New Search”.
    It might also make sense to have the Home Icon to the right go to a “new search” screen. It doesn’t appear to do anything right now.
    Export / Download
    I do like how it does NOT provide the LocationID.

    • 2 minggu yang lalu
    1. Donc310
      Donc310
      • 2 minggu yang lalu

      "It might also make sense to have the Home Icon to the right go to a “new search” screen. It doesn’t appear to do anything right now." the icon is to reposition the map to the visual center after it has been zoomed

      • 2 minggu yang lalu
    2. Donc310
      Donc310
      • 2 minggu yang lalu

      Will adjust the new search button . is there any other observations. is feature for emailing the results a required feature ? so that i will include it.

      • 2 minggu yang lalu
  • monmohon
    monmohon
    • 3 minggu yang lalu

    widget done in angular........

    • 3 minggu yang lalu
    1. Donc310
      Donc310
      • 2 minggu yang lalu

      Mine is with Vue though

      • 2 minggu yang lalu
    2. Donc310
      Donc310
      • 2 minggu yang lalu

      How do you intend to embed an angular app , will require more work i guess

      • 2 minggu yang lalu
  • monmohon
    monmohon
    • 3 minggu yang lalu

    Hi,
    Just to let you know that Backend is flexible i use json data.
    Any database like: MySQL, MSSQL, postgresql, Oracle or any other Database
    No server side Dependency

    • 3 minggu yang lalu
    1. Donc310
      Donc310
      • 3 minggu yang lalu

      Not at all @Mon Mohon

      • 3 minggu yang lalu
    2. monmohon
      monmohon
      • 3 minggu yang lalu

      haha........ your welcome

      • 3 minggu yang lalu
  • Donc310
    Donc310
    • 4 minggu yang lalu

    hello any update as regards the contest ...

    • 4 minggu yang lalu
    1. fdjbuhr
      Penganjur Peraduan
      • 3 minggu yang lalu

      On your widget, it seems to load really slow. What would be the cause for that?

      • 3 minggu yang lalu
    2. Donc310
      Donc310
      • 3 minggu yang lalu

      the API i built for the backend and also the site hosting the widget currently is on a free tier on heroku , so the server automatically shoots down when no requests are being made , and requires some few secs to reboot once it receives a new requests .

      • 3 minggu yang lalu
  • Donc310
    Donc310
    • 1 bulan yang lalu

    Hi , Joel good morning , so today I was reviewing your project description , and I noticed something . I think we are approaching the widget from the wrong angle. from my understanding of your description the widget is meant to analyze those audience who's id's have visited other chain ids. so for instance if we searched "starbucks coffee with an audience of nationwide" . the widget should give us an analysis of other chain id's which those id's have visited . if this is corrected , then the data sample file should contain an ID column just like the previous one did before you updated it .so the csv headers should be "ID,state,Level_1,Level_2,LOCATION,ChainID,Mild,Moderate,Frequent , AudienceTotal". with this the widget can then truly provide an analysis rather than just showing just audience total .

    • 1 bulan yang lalu
    1. Donc310
      Donc310
      • 1 bulan yang lalu

      ok , thanks for the update . i added some updates to my entry , am redoing some tabs . will have a summary tab ready by tomorrow. you an check it

      • 1 bulan yang lalu
    2. Donc310
      Donc310
      • 1 bulan yang lalu

      concerning your reply "You are correct, later in the end I do want to have a tool that could actually query all 200+ million rows of data. But that doesn't make for a really fast tool" querying as regards this will be much easier , if single locations were used , by querying one location at a time the widget will perform better with regards to the original project description

      • 1 bulan yang lalu
  • fdjbuhr
    Penganjur Peraduan
    • 1 bulan yang lalu

    @chibuzor feedback on your entry https://www.loom.com/share/7a7b323522df40ec9038be5ec97e9ed7

    • 1 bulan yang lalu
    1. Donc310
      Donc310
      • 1 bulan yang lalu

      going through it now

      • 1 bulan yang lalu
  • fdjbuhr
    Penganjur Peraduan
    • 1 bulan yang lalu

    @mon mohon here is the feedback on the latest version. https://www.loom.com/share/e42711e46b304baa9fcf536d134923dd

    • 1 bulan yang lalu
  • fdjbuhr
    Penganjur Peraduan
    • 1 bulan yang lalu

    Please remember that this must be an embeddable website widget, needs to be responsive to different devices and use open source libraries.

    • 1 bulan yang lalu
    1. Donc310
      Donc310
      • 1 bulan yang lalu

      Hi Good evening , I have finished the multiple location options . you can test it out now . tomorrow i will work on redesigning the look and feel of the widget . so please if you have time review the current stage of the widget and make your observations . thank you and looking forward to your feedback

      • 1 bulan yang lalu
    2. Donc310
      Donc310
      • 1 bulan yang lalu

      https://contestwidget.herokuapp.com/index.html

      • 1 bulan yang lalu
  • isotopeee
    isotopeee
    • 1 bulan yang lalu

    In the dataset you've provided, I've noticed that there are some rows that have empty cells. Is it a valid data entry or just bad data?

    • 1 bulan yang lalu
    1. fdjbuhr
      Penganjur Peraduan
      • 1 bulan yang lalu

      Any updates?

      • 1 bulan yang lalu
    2. isotopeee
      isotopeee
      • 1 bulan yang lalu

      Hi,

      I've left a comment on my entry, thanks for your patience

      • 1 bulan yang lalu
  • monmohon
    monmohon
    • 1 bulan yang lalu

    will update tomorrow....... almost done

    • 1 bulan yang lalu
  • fdjbuhr
    Penganjur Peraduan
    • 1 bulan yang lalu

    Feedback on Mon Mohon's entry . https://www.loom.com/share/593af3ac39ed4931b15f04b62cda50c5

    • 1 bulan yang lalu
  • fdjbuhr
    Penganjur Peraduan
    • 1 bulan yang lalu

    Please keep all comments as much as possible in the Public Clarification Board. I am making comments on the Loom videos which I encourage all to be sure you are looking for even if it is for another entry.

    • 1 bulan yang lalu
  • fdjbuhr
    Penganjur Peraduan
    • 1 bulan yang lalu

    https://www.loom.com/share/b657aed2b18d40e18380794653f9ba1b

    • 1 bulan yang lalu
    1. Donc310
      Donc310
      • 1 bulan yang lalu

      https://www.loom.com/share/b657aed2b18d40e18380794653f9ba1b

      • 1 bulan yang lalu
    2. fdjbuhr
      Penganjur Peraduan
      • 1 bulan yang lalu

      https://www.loom.com/share/b657aed2b18d40e18380794653f9ba1b

      • 1 bulan yang lalu
  • fdjbuhr
    Penganjur Peraduan
    • 1 bulan yang lalu

    Feedback on Mon Mohons entry https://hindphotostate.com/demo/ . https://www.loom.com/share/030fda9acaa344a99ae96dcc3fe6a51c

    • 1 bulan yang lalu
  • fdjbuhr
    Penganjur Peraduan
    • 1 bulan yang lalu

    Here are updated data files, some structure. https://www.dropbox.com/sh/mjmjj1f55z7p1ap/AAA0JIvckKWB_zThaXBalbmea?dl=0

    • 1 bulan yang lalu
  • Donc310
    Donc310
    • 1 bulan yang lalu

    Hi , Good Morning sir . I have submitted my update . Entry #8 , please provide feedback thank you...

    • 1 bulan yang lalu
    1. Donc310
      Donc310
      • 1 bulan yang lalu

      #link https://contestwidget.herokuapp.com/index.html

      • 1 bulan yang lalu
    2. Donc310
      Donc310
      • 1 bulan yang lalu

      Hi , i have added a feature for multiple search locations

      • 1 bulan yang lalu
  • fdjbuhr
    Penganjur Peraduan
    • 1 bulan yang lalu

    Please keep in mind that this widget is going to be used both on Desktop and Mobile.

    • 1 bulan yang lalu
  • fdjbuhr
    Penganjur Peraduan
    • 1 bulan yang lalu

    I have extended the contest and added money to the prize. Here are also the LOOM video links that I have shared with each of you so that you both get ideas for what I am trying to get to.

    • 1 bulan yang lalu
    1. monmohon
      monmohon
      • 1 bulan yang lalu

      for temporally, i delete demo link because its hosted on public server. anyone can copy my source code. Today, will hosted on private domain and share link with you

      Hope you not mind

      • 1 bulan yang lalu
  • fdjbuhr
    Penganjur Peraduan
    • 1 bulan yang lalu

    Here is some additional feedback on Chibuzor C. submission. - https://www.loom.com/share/2a54fdb6776447d0bae45216fc975396

    • 1 bulan yang lalu
  • fdjbuhr
    Penganjur Peraduan
    • 1 bulan yang lalu

    What I would like to see when the Analyze button is hit, is that the states selected, are shaded or a true heatmap by totals. A Summary with a current Date and Time at the top of a report of the combination of selects to the side would be great so that possible the user could copy and paste that in an email.

    • 1 bulan yang lalu
  • fdjbuhr
    Penganjur Peraduan
    • 1 bulan yang lalu

    Also added an updated data file which provides the totals for each chain location and incorporates the Category Level 1 and Sub Category in the same data file.

    • 1 bulan yang lalu
  • fdjbuhr
    Penganjur Peraduan
    • 1 bulan yang lalu

    Loom Links . https://www.loom.com/share/9c997ad227074ee985b6fe4bb0f45a2f
    https://www.loom.com/share/f970975dd5bb46ffbd3b47c33f5d8f04

    • 1 bulan yang lalu
  • fdjbuhr
    Penganjur Peraduan
    • 1 bulan yang lalu

    Question is each of your solutions using Angular or React?

    • 1 bulan yang lalu
    1. Donc310
      Donc310
      • 1 bulan yang lalu

      Mine is using vue.js which is similar to react

      • 1 bulan yang lalu

Tunjukkan lebih banyak komen

Bagaimana mula dengan peraduan

  • Paparkan peraduan anda

    Paparkan Peraduan Anda Cepat dan mudah

  • Dapatkan berjuta penyertaan

    Dapatkan Bertan-tan Penyertaan Dari serata dunia

  • Anugerahkan penyertaan terbaik

    Anugerahkan penyertaan terbaik Muat turun fail-fail - Mudah!

Paparkan Peraduan Sekarang atau Sertai kami Hari Ini!