The Community is hosting an End of Summer sweepstakes! Participants must complete tasks to earn tickets that will enter them with a chance to win a free year of Constant Contact and other great prizes!*
*No Purchase Necessary. For Official Rules, visit here. Constant Contact’s End of Summer 2020 Sweepstakes ends on October, 20, 2020 at 11:50 PM EST.

Add last_run_date to email campaign collection query

Participating Solution Provider

Add last_run_date to email campaign collection query

When you (Constant Contact) do one of your database updates, ALL my clients' campaigns suddenly show a new last_modified date. This makes the email campaigns query 'modified_since' parameter useless. The only way to find which campaigns were recently sent is to query each and every campaign to check the last_run_date.


This is not the first time you have messed things up with an update. This is forcing us to significantly increase the API queries we need in order to generate the reports we need.


Please add a new parameter to the email campaigns collection query for last_run_since or similar.


Mike Sullivan is the founder of Analytics Edge, providing simple Excel-based report automation products for individuals and small businesses.

Re: Add last_run_date to email campaign collection query

Hi @AnalyticsEdge,


We did notice this change to the last modified_date on campaigns and we are looking at a way to make sure it does not happen again. I will be happy to forward this feedback to our engineers as a possible solution.

Jimmy D.
Tier II API Support Engineer
Developer Portal

View API documentation, code samples, get your API key.

Visit Page

Constant Contact 2020 End of Summer Community Sweepstakes!

The Constant Contact User Community is hosting a sweepstakes. The more you participate, the more chances you have to win! Read on to learn more...

Read More