Exporting to CSV Vistors and Pages

  • Resolved dirkargyle

    (@dirkargyle)


    3 months, 2 weeks ago

    When I export visitor and pages in the Optimization I see the ID column at Visitor CSV while in Page CSV I see Page_id and id again. Which index should I use to corelate both records? The ID(Visitor csv) and Page_id(page CSV).

    Thank you.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Amir

    (@amirfallah)

    Hi @dirkargyle

    In the wp_statistics_visitor table, the ID is a unique identifier assigned to users. In the wp_statistics_pages table, page_id is also a unique identifier assigned to the page, and id is the identifier of that page in the wp_post or wp_terms table.

    These two tables are not related to each other. To check which pages a visitor has viewed, you need to use the wp_statistics_visitor_relationships table in your database, where visitor_id refers to the ID field in the wp_statistics_visitor table, and page_id refers to the page_id in the wp_statistics_pages table.

    I hope this helps you. If you have any questions, feel free to ask.
    Regards,

    Thread Starter dirkargyle

    (@dirkargyle)

    Thank you I’ll do that. Can you include that in your next update so that we can download from the plugin dashboard. Just a suggestion.

    Plugin Support Amir

    (@amirfallah)

    In the development version, we have added this table for output in the Data Export section in this commit. In the next release, the ability to export this table will also be available to you.

    Additionally, in future updates, we will completely database refactoring to provide you with better and more comprehensive outputs and reports.
    Regards,

    Thread Starter dirkargyle

    (@dirkargyle)

    I appreciate your help more power to you and your team.

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.