This is a public Forum  publicRSS

Topic

    Brandon Coo
    Filter on automatically generated mailing ID in report...
    Topic posted January 24, 2018 by Brandon CooJourneyer 
    113 Views, 2 Comments
    Title:
    Filter on automatically generated mailing ID in report filters
    Content:

    I'm trying to build a report and select only customers with certain responses on a survey from the marketing transactions table.

    The automatically generated mailings folder doesn't show up in the report filters so I'm unable to select it.

    Is there anyway to filter by mailings within the automatically generated mailings folder?

    Answer

     

    • Carl Elliott

      Survey reports can get very complicated.  You can filter by mailing or survey names so I am not sure why you need to identify the generate id.  

      I would start with an existing report to get the correct structure and you would need to add a filter to the question_responses table to look for specific responses. 

    • Sebastiaan

      Hi Brandon.

      It seems like the information you are looking for "select only customers with certain responses on a survey" (if I understood the question correctly) is located in the question_responses table.

      question_responses.question_id
      question_responses.score

      You can then select the question ID and the score for that response.