SugarChimp

The same question applies for "sent". I see the webhook that determines when the campaign was sent, but I don't see one for each individual send. Is this also done by the scheduler? Or does it just create a "sent" record for each person in the target list when the campaign "sent" notification is received?

Hello John,

We use the 'Campaign' webhook to bring the campaign information into SugarCRM. From there, we use our scheduler to grab new Campaign opens and clicks for the next 30 days, every 24 hours based on when the Campaign was sent. So we use the 'Campaign' webhook, followed by the scheduler to grab all incoming activities in bunches. We use Mailchimp's streaming api to get those, as there is no v3 api call to get all activities from a campaign after a certain time stamp.

Kind Regards, Jon

Hi Fanatical Labs, thanks for the response.

Why only for 30 days after the send date? Is there a way to change this? This strikes me as restrictive - a lot of mass mails have a long "tail".

Hi John,

We limit the timeframe to 30 days to ensure we don't run into performance issues. Since most opens/clicks generally happen within 24 hours of the email being sent, we've found that 30 days allows for the vast majority of data to be synced. Out of curiosity, can you tell me more about the kinds of campaigns you send where you would expect open/click data to extend beyond 30 days? I'd love to know more about the use case to better understand the scenarios where this feature is needed.

We can certainly extend the amount of time, but it's worth noting that with the increase of days, depending on how many campaigns that are sent, performance can slow as more data is being sent from Mailchimp to Sugar. I'm providing instructions on increasing that timeframe below:

1. From the Sugar Admin page, click on Health Status
2. Right click anywhere on the page and click Inspect
3. Click Console tab
4. Copy/paste the following string into the console SUGAR.App.api.call('get',SUGAR.App.api.buildURL('FanaticalZendesk/setting/days_to_sync_activities/30'),{},{})
5. Change the 30 in the above string to the amount of days you'd like to sync (note, it shouldn't be any higher than 60 days)
6. Press Enter

This will extend the timeframe we'll track campaigns and sync the data to Sugar. Please let me know if you have any trouble along the way or any further questions!

Best, Heidi

Hi John,

My apologies. The string that should appear for step 4 is actually:

SUGAR.App.api.call('get',SUGAR.App.api.buildURL('SugarChimp/setting/days_to_sync_activities/30'),{},{})

Please let me know if you have trouble.

Best, Heidi