We’d love to have more filter possibilities for Pipedrive deals connector. ATM we’re running a query and push the results into a dataset. Our query looks like this:
SELECT count(*) AS KPI FROM pipedrive_deals WHERE pipeline_id IN (96, 107, 124) AND (creator_user_id = 2960880 OR marketing_channel LIKE '%330%') AND date_trunc('month', add_time) = date_trunc('month', now())
So it would be nice to be able to filter on creator_user_id and add_time directly in the Pipedrive deals connector.
marketing_channel is a custom field, could that be filtered on too?