Subscribers' click count stats

MCM

Member
Dear @twisted1919,

For a long time, it wasn't possible to take action against subscribers and/or to change subscribers' custom fields on click when using URLs from XML feed. It is possible from Version 2.4.6 (2024-04-03)

So we do it, counting clicks to CF, but we need to access historical data about subscriber's clicks.

You have this data in dtb, because we can filter the users in Lists like this:

1726060519255.png

Question - how can we access data about clicks per subscriber? Where is it stored in the DB?

We need to download historical data and copy them to Custom Field.

Thank you a lot!
 
The campaign_track_url table store this information. You have to join to the campaign_url table to get the full picture.
 
Back
Top