Can I have custom reporting options?

  • Profile Image
    r2cgroup
    Asked on January 06, 2012 at 04:07 PM

     

    Hello Support,

     

    I work for a direct response advertising agency that does a lot of lead generation websites. I'm looking to replace our in-house survey system with a third-party solution. So far, yours is great!

    Here's a PDF of some slides I made that show you what our system does for us: http://mike.respond2.com/SurveySystemDiagram.pdf

    I'd like to talk these slides over with somebody. Can we schedule a call? Feel free to send me e-mail at rvanderwal@r2cgroup.com any time.

     

    Thanks,

    Rich Vanderwal
    Technical Director, R2C Group
    rvanderwal@r2cgroup.com
    (503) 222-0025

     

  • Profile Image
    Mike_T
    Answered on January 06, 2012 at 07:58 PM

    Hello Rich,

    Thank you for your interest in our services.

    We do not currently provide support over the phone, but we would be happy to help you either over the forum or email support.

    http://mike.respond2.com/SurveySystemDiagram.pdf - link is showing "not found" error. Could you please re-check the link?

    We are looking forward to hearing from you.

  • Profile Image
    Rich Vanderwal
    Answered on January 18, 2012 at 07:06 PM

    Yeah, I saw that my PDF had names of our clients in it, so I removed that file, since these forum articles are publicly visible. Here's a sample of one report, which counts the number of answers for a certain answer:

     

     

    Survey Date Question Answer Count
    Client Survey v03 11/29/2011 Where do you buy your floor cleaning tools? Select One: 2
    Client Survey v03 11/29/2011 Where do you buy your floor cleaning tools? Ace Hardware 1
    Client Survey v03 11/29/2011 Where do you buy your floor cleaning tools? Publix 2
    Client Survey v03 11/29/2011 Where do you buy your floor cleaning tools? Target 1
    Client Survey v03 11/29/2011 Where do you buy your floor cleaning tools? Walmart 9
    Client Survey v03 11/29/2011 What is your age? Under 25 1
    Client Survey v03 11/29/2011 What is your age? 25-34 4
    Client Survey v03 11/29/2011 What is your age? 35-44 2
    Client Survey v03 11/29/2011 What is your age? 45-54 3
    Client Survey v03 11/29/2011 What is your age? 55+ 4

     

    And another report, which locates the DMA (that's a direct marketing area) code by using a simple table lookup by a ZIP code which the site visitor enters, then counts surveys by DMA:

     

     

    Survey Title Date DMA Code count
    Client Survey v03 11/29/2011 524 2
    Client Survey v03 11/29/2011 529 1
    Client Survey v03 11/29/2011 581 1
    Client Survey v03 11/29/2011 617 1
    Client Survey v03 11/29/2011 670 2
    Client Survey v03 11/29/2011 686 1
    Client Survey v03 11/29/2011 693 1
    Client Survey v03 11/29/2011 734 1
    Client Survey v03 11/29/2011 770 1
    Client Survey v03 11/29/2011 862 1
    Client Survey v03 11/29/2011 Unknown 3

     

    If your system could produce these two reports, we'd be awfully happy and instantly sign up for a big account.

     

    Thanks,

    Rich Vanderwal

  • Profile Image
    NeilVicente
    Answered on January 18, 2012 at 08:11 PM

    Rich,

    Definitely, JotForm can produce results such as this using our Visual Report builder. Click here to view a sample report for this form.

    The only downside to this is that the report produced will be available in graphic images. That means the actual results, in numbers, cannot be directly copied.

  • Profile Image
    Rich Vanderwal
    Answered on January 19, 2012 at 01:59 PM

    Thanks for your answer -- I think we may be able to get by with manual entry of those reports, if they can be automatically e-mailed nightly to someone on my team.

    I have some other questions:

    Do you provide integration with 3rd-party reporting tools such as Crystal Reports?

    Can you automatically geocode each survey responder by IP and/or ZIP?

    Can your system post the survey results to a thank-you page that we host externally? We'd like to be able to e-mail a customized downloaded PDF to them, or perhaps do something else with the data.

    Thanks,

    Rich Vanderwal

  • Profile Image
    fxr
    Answered on January 19, 2012 at 07:42 PM

    Hello Rich, 

    'Do you provide integration with 3rd-party reporting tools such as Crystal Reports?'

    No, but you can download a CSV of your submissions which (I assume) you should be able to import into Crystal Reports. Exporting to CSV/Excel is much the same process and its explained here

    'Can you automatically geocode each survey responder by IP and/or ZIP?'

    The IP address of every submission is stored; you learn how to enable it here . Once enabled that data will also show on any CSV/Excel downloads of your submissions. 

    Can your system post the survey results to a thank-you page that we host externally?

    Yes, you can access the POST variables of your form submittals to a custom URL that you use as a 'thankyou page'. You can read about that here Obviously to make that work you would need to code something up in php. 

    ---

    I hope that answers your questions to a certain extent, we are here to help our users as much as possible so dont be afraid to ask if you do have any other questions or need help with something.