Track Users Clicking on Links from Emails via ALLOW_EXT_LINK_TRACKING

You can identify when a user clicks on a link from a Metric Insights email and logs into a third-party application like Tableau or QlikView. When you click on a link from a Metric Insights email, the system logs user ID, time, and Element (among other items) in the database. This is logged even when users click on a link to an external application.

Tracking Setting

NOTE: See Setting System Variables for details on System Variables configuration.

Tracking is enabled by default.

  1. If you want to turn tracking off, set ALLOW_EXT_LINK_TRACKING to "N"
  2. [Commit Changes]

Where Is Data Stored?

Where data is the stored?

The data is stored in the dashboard_element_view_log_detail table in the dashboard database.  

Reporting

You can then build Datasets using the table. For example, to get this sample above use:

select username,name,e. element_id, view_time from dashboard_element e, user u, dashboard_element_view_log_detail d where u.user_id=d.user_id and e.element_id=d.element_id

NOTE: The system captures unique clicks on an Element restarting every 15 minutes. For example, if I click on a link from an email twice within 15 minutes, MI only records it as once. If you click on it after 15 minutes, it is recorded again.