Is there any field which stores the date when existing record get linked with target list of Campaign
Is there any field which stores the 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?
Table prospect_lists_prospects is the relationship table between Prospect Lists and Prospects, so its date_modified field stores the date when that record (Prospect, Lead, Contact, Account) has been added into specified Prospect List.
Regards
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
How to Make an API call to retrieve Leads from ProspectLists which are linked after a certain date?
I'm making an API call to ProspectLists with a filter added as date_modified >= Specific date-time, but this is filtering date_modified filed on leads table, not on ProspectLists table.