# Contact Activity Log table for SugarCRM custom sync

**URL:** <https://forum.mautic.org/t/contact-activity-log-table-for-sugarcrm-custom-sync/4564>\
**Category:** Product Support\
**Created:** [July 20, 2016, 9:53am UTC](https://forum.mautic.org/t/contact-activity-log-table-for-sugarcrm-custom-sync/4564 "2016-07-20T09:53:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![giovanni](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/giovanni/32/577_2.png) [@giovanni](https://forum.mautic.org/u/giovanni)\
**Post date:** [July 20, 2016, 9:53am UTC](https://forum.mautic.org/t/contact-activity-log-table-for-sugarcrm-custom-sync/4564/1 "2016-07-20T09:53:21Z")

</div>

Hi guys, where can I find the data about the activities of a contact in the database? I would like to see the record for:

- email open  
- URL visit  
- form filled  
  
etc.  
  
I found out email\_stats, form\_submissions, page\_hits, are these correct? I would like then to push these info to SugarCRM so we would like to create a better integration between the two systems.

---

<div class="post-metadata">

**Author:** ![giovanni](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/giovanni/32/577_2.png) [@giovanni](https://forum.mautic.org/u/giovanni)\
**Post date:** [July 20, 2016, 9:53am UTC](https://forum.mautic.org/t/contact-activity-log-table-for-sugarcrm-custom-sync/4564/2 "2016-07-20T09:53:21Z")

</div>

Hi guys, where can I find the data about the activities of a contact in the database? I would like to see the record for:

- email open
- URL visit
- form filled  
etc.  
I found out email\_stats, form\_submissions, page\_hits, are these correct? I would like then to push these info to SugarCRM so we would like to create a better integration between the two systems.

---

<div class="post-metadata">

**Author:** ![cuong.tranvugroup](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/cuong.tranvugroup/32/1970_2.png) [@cuong.tranvugroup](https://forum.mautic.org/u/cuong.tranvugroup)\
**Post date:** [August 8, 2020, 3:38am UTC](https://forum.mautic.org/t/contact-activity-log-table-for-sugarcrm-custom-sync/4564/3 "2020-08-08T03:38:21Z")

</div>

> [@giovanni](#):
>
> , where can I find the data about the activities of a contact in the database? I would like to see the record for:

I use Odoo CRM. How to sync “log page hit” from Mautic to Odoo CRM? Help and give me document