Date when existing record get linked with target list of Campaign

Thanks André.

But date_modified is prospect's modified date, not when it's get linked with prospect list, right?

You can get datetime using advance query

Query:

SELECT
p.name AS target_list,
c.name AS campaign_name,
pc.date_modified AS target_list_linked_campaign_datetime
FROM campaigns c
INNER JOIN prospect_list_campaigns pc ON (c.id = pc.campaign_id)
INNER JOIN prospect_lists p ON (p.id = pc.prospect_list_id)
WHERE
c.deleted = 0 AND
pc.deleted = 0 AND
p.deleted = 0

You can get datetime using advance query

Query:

SELECT
p.name AS target_list,
c.name AS campaign_name,
pc.date_modified AS target_list_linked_campaign_datetime
FROM campaigns c
INNER JOIN prospect_list_campaigns pc ON (c.id = pc.campaign_id)
INNER JOIN prospect_lists p ON (p.id = pc.prospect_list_id)
WHERE
c.deleted = 0 AND
pc.deleted = 0 AND
p.deleted = 0