by Fanatical Labs

Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so you can work in your preferred app. Segment and group your Mailchimp subscribers based on Sugar data so you can market to the right people at the right time. Compatible with all versions and editions of Sugar and SuiteCRM. Created by Fanatical Labs, 2023 SugarCRM Partner Award Winner.

Free Trial

By clicking you consent to share your profile with the developer

#1086 - Clickthrough response times - SugarChimp

Closed General Question created by mailchimp 9 years ago

Hi!

I have been setting up SugarChimp recently with help from a Sugar Professional and we noticed an issue last week when we sent out a mailer. The Dashlet that shows Clickthrough tasks following a mailer was working fine with a lag of between 10-15 minutes to show chlickthroughs but last weeks mailer took a day and a half to show any clickthroughs. This is not optimum! Can you please take a look into this for me as we need almost instant tasks showing as was before.

Thanks

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    9 years ago

    Hello, Chad here. We were emailing earlier about your SugarOutfitters account.

    Are you referring to the subscriber dashlet that's talked about on this page? https://www.sugaroutfitters.com/docs/SugarChimp/view-mailchimp-data-in-sugar

    When you load a contact's page, that dashlet makes a direct API call to MailChimp to get the latest data. If the dashlet isn't updating fast enough, it's because something is running slow on MailChimp's side. In my experience that dashlet has the latest data nearly all of the time.

    Maybe you're referring to the data from the MailChipActivity module? The activity records are added to the system ever 24 hours. We have to run it on this schedule due to performance issues and how the MailChimp API works. If we don't, it could cause the rest of your system to slow down.

    Can you explain more about why you need the data to be instant? There may be another Sugar/MailChimp tool that can help with this.

    Thanks!

  2. rolustech-primary-contact member avatar

    Rolustech

    9 years ago

    Hi Chad,

    They are mentioning the 2nd point which is related to MailchimpActivity module. The click actions are populated after a day. So they need these to sync ASAP because they have to contact all those leads on time.

    Also can you please let me know if mailchimp can reduce the 24 hours time for only this client? please let me know what is minimum bearable shortest time span of sync Click Activities in MailchimpActivities module?

    • fanaticallabs member avatar

      Fanatical Labs Provider Affiliate

      9 years ago

      Got it, that makes sense. For now we aren't planning on changing the frequency of the activity syncing. There is no limitation on the MailChimp side as to how fast the data can be provided, the reason we keep the sync rate low for activities is because for large campaigns, it could slow the system down for everyone if the job takes a long time to run and runs to frequently.

      Can you explain their use cases? What are they wanting to do after a click event occurs? There may be better Sugar/MailChimp APIs available.

      Here are a couple options:

      1) If you want to speed up the SugarChimp Activity sync, you can edit the code to remove the 24 hour limit. If you go to modules/SugarChimp/includes/classes/SugarChimp/Scheduler/MailchimpActivityToSugarCRM.php around line 175 you'll see a if($db->dbType == 'mysql'). If you remove the 'WHERE' statement for that query, it will remove the 24 hour sync rule and sync your campaigns' activities much faster. It will still be limited by our scheduler rules to run every 5 minutes, so it will depend on how many campaigns you have being watched for syncing. As new campaigns are sent, they are logged to this table for tracking when they were last synced: sugarchimp_activity_tracker. The scheduler cycles through each of those campaigns to get the latest activities until the campaign reaches 60 days old.

      2) Depending on your use case, you may want to look at MailChimp's new Automation features. They just released a lot of really cool new tools for things exactly like this. When logged into MailChimp, there is a new "Automation" link in the main navigation.

      Let me know if you have other questions on this. Thanks!

  3. rolustech-primary-contact member avatar

    Rolustech

    9 years ago

    Hi,

    A workflow is being triggered when there is any activity with Activity Type "click". And according to these click activities they are initiating calls to their leads. That is why they want to make it more synchronized on time.

    In Automation , getting following message, please advise...

    You have no automation workflows Automatically send one-to-one emails to subscribers to improve e-commerce sales, educate customers, and more.

    • fanaticallabs member avatar

      Fanatical Labs Provider Affiliate

      9 years ago

      Got it, thanks. So in that case, your best option is to customize the SugarChimp code to run more frequently as described above.

      The MailChimp Automation tools will not help in this case, it will only allow you to send more emails, not make calls.

      Let me know if you have other questions. Thanks!

  4. rolustech-primary-contact member avatar

    Rolustech

    9 years ago

    Thanks for your help.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "SugarChimp is working great. We're able to sync all of our lists and subscriber fields between MailChimp and SugarCRM. SugarChimp Support also did a great job supporting us as we were setting everything up."

    Read More Reviews