by Fanatical Labs

Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so that you can work in your preferred application. Segment and Group your MailChimp subscribers based on SugarCRM data so you can market to the right people at the right time. Fully compatible with all versions and editions of Sugar and SuiteCRM.

Cancel at any time!
Free Trial

#4216 - MailChimp Opens and Clicks

Closed General Question created by JohnK 2 years ago

I've been researching MailChimp webhooks, and there's no indication of how opens and clicks make their way into SugarCRM.

Is this done by the Scheduler? If not, what does the scheduler do?

  1. JohnK member avatar

    JohnK

    2 years ago

    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?

  2. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    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

  3. JohnK member avatar

    JohnK

    2 years ago

    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".

  4. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    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

  5. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    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

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.