# Getting (Days Visited) in CSV User List Report

**URL:** <https://meta.discourse.org/t/getting-days-visited-in-csv-user-list-report/140079>\
**Category:** Feature\
**Created:** [January 29, 2020, 4:11pm UTC](https://meta.discourse.org/t/getting-days-visited-in-csv-user-list-report/140079 "2020-01-29T16:11:36Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![YaserAlnajjar](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/yaseralnajjar/32/100729_2.png) [@YaserAlnajjar](https://meta.discourse.org/u/YaserAlnajjar)\
**Post date:** [January 29, 2020, 8:48pm UTC](https://meta.discourse.org/t/getting-days-visited-in-csv-user-list-report/140079/3 "2020-01-29T20:48:44Z")

</div>

Not quite precise, the CSV file includes columns likes\_given and likes\_received which are also in the same table user\_stats:

```plaintext
--
-- Name: user_stats; Type: TABLE; Schema: public; Owner: discourse
--

CREATE TABLE public.user_stats (
    user_id integer NOT NULL,
    topics_entered integer DEFAULT 0 NOT NULL,
    time_read integer DEFAULT 0 NOT NULL,
    days_visited integer DEFAULT 0 NOT NULL,
    posts_read_count integer DEFAULT 0 NOT NULL,
    likes_given integer DEFAULT 0 NOT NULL,
    likes_received integer DEFAULT 0 NOT NULL,
    topic_reply_count integer DEFAULT 0 NOT NULL,
    new_since timestamp without time zone NOT NULL,
    read_faq timestamp without time zone,
    first_post_created_at timestamp without time zone,
    post_count integer DEFAULT 0 NOT NULL,
    topic_count integer DEFAULT 0 NOT NULL,
    bounce_score double precision DEFAULT 0 NOT NULL,
    reset_bounce_score_after timestamp without time zone
);

```

[From schema.sql](https://github.com/prisma/database-schema-examples/blob/master/postgres/discourse/schema.sql#L4984)

---

_[View the full topic](https://meta.discourse.org/t/getting-days-visited-in-csv-user-list-report/140079)._