This is a public Forum  publicRSS

Topic

    Philipp Berkemeier
    Analysis of the Inivitation messageAnswered
    Topic posted May 7, 2018 by Philipp BerkemeierRegular 
    129 Views, 5 Comments
    Title:
    Analysis of the Inivitation message
    Content:

    Hello, community,

    I want a list of who the invitation message has been sent to.
    This means which contact received the e-mail for the survey. Do either of you know how to do this? I have already done research in the Analytics area, but I did not find what I was looking for.

    Many greetings,
    Philipp

    Best Answer

    Simon Kilgarriff

    Hi Philipp,

    You should be able to see in the ma_trans table the 'sent' action for each invitation sent out.   The table should show marketing and feeback mails sent.  So you need to filter based on the survey.  There isn't a survey filter for the table but you can filter based on mailing ID - you should be able to work it out.

    Just be aware data is only present in the ma_trans table for a limited period of time set by a purge configuration setting.

    Hope that helps,

    Simon

    Answer

     

    • Saju Kumar

      Hi Philipp,

      I'm not sure whether we have any report for this, but if you want to know the audience details then it is available in survey's Summary tab->Audience Count. Click on the Details link in Audience Count

      Thanks

      Saju

    • Pavol Procka

      One way you could go is to report on Incidents that were sent with this survey.

      Since there is no such table, you would have to filter based on what decides whether a survey is sent or not.

    • Simon Kilgarriff

      Hi Philipp,

      You should be able to see in the ma_trans table the 'sent' action for each invitation sent out.   The table should show marketing and feeback mails sent.  So you need to filter based on the survey.  There isn't a survey filter for the table but you can filter based on mailing ID - you should be able to work it out.

      Just be aware data is only present in the ma_trans table for a limited period of time set by a purge configuration setting.

      Hope that helps,

      Simon

    • Philipp Berkemeier

      Dear Simon,

      Thank you very much for your answer. She helps me a lot. Do you know how long these are stored in the default or where you can adjust this setting in the configuration setting?

      Thank you very much,
      Philip

    • Pavol Procka