• Resolved Wendihihihi

    (@wendihihihi)


    Hello,

    I want to analyze the Activity Info to see which subscribers never viewed the emails and then delete those subscribers.

    Some questions.

    1. How is the Viewed Date collected? Are these all the people who opened the email or is it possible that not all people are registered as Viewed after they’ve opened their email?

    2. Is it possible to export these Activity Info lists? And if not, in which table can I find the Activity Info data?

    3. In the Contacts table in the database I see there is engagement_score. They are all Null. Is this a Pro option?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor kishanranawat

    (@kishanranawat)

    Hello there,

    Thanks for sharing your doubts with us.

    We have added our responses to your queries as below
    1. How is the Viewed Date collected? Are these all the people who opened the email or is it possible that not all people are registered as Viewed after they’ve opened their email?
    –> Yes, the viewed data is calculated when someone opens your email. The plugin adds a hidden pixel image to emails. It gets rendered when opening the email and the email gets marked as opened. Therefore if subscribers have disabled images in the email, then it is possible that open tracking doesn’t work in this case.

    2. Is it possible to export these Activity Info lists? And if not, in which table can I find the Activity Info data?
    –> Currently, there isn’t any option to export the Activity Info but we have noted down your request. If requested by more number users, then we can consider adding it into the plugin. At present, if you need to export the activity info
    then you can get it from the wp_ig_actions table. You can refer to the following screenshot for more information.
    Note: wp_ prefix in the wp_ig_actions table might be different on your site depending on site setup.

    3. In the Contacts table in the database I see there is engagement_score. They are all Null. Is this a Pro option?
    –> Yes, the engagement score column in the contacts table is used to store the overall engagement level of subscribers between the scale from 0 to 5. When a subscriber regularly opens or clicks your emails, he/she will have a higher engagement score and thus will be considered as highly active. This feature is available in the pro version of the plugin. Also in the pro version, you can send emails to subscribers based on their engagements score. i.e. if some subscribers aren’t much engaged then you can send them tailored emails to win them back.

    Hope this helps you. Let us know if you have any further queries.

    Thank you.

    Thread Starter Wendihihihi

    (@wendihihihi)

    Thank you for your very clear answer. I really appreciate it. I can work with this.

    Just to get the full picture, in the wp_ig_actions table, the type column, 5 probably means unsubscribed but what does 1 mean?

    After I’ve finished the theme I’m working I will get the pro version.

    Thank you

    Plugin Contributor kishanranawat

    (@kishanranawat)

    Hello there,

    Yes, you are right. 5 in the type column means unsubscribed. 1 is for subscribed.

    Also thanks for showing your interest in the plugin. We hope you will find it easy to use and helpful.

    Let us know if you have any further queries. Thank you.

    Thread Starter Wendihihihi

    (@wendihihihi)

    Thank you for confirming. In Excel I can easily combine some tables to get what I need.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Export Activity Info’ is closed to new replies.