SugarChimp

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

#425 - MailChimp past campaigns not visible inside Sugar CRM

Closed Installation created by kartik 10 years ago

I am unable to see the existing campaigns from MailChimp inside the Sugar CRM. Campaigns Tab in the CRM is blank

Also while doing the installation I could not see any option to update Campaign Headers. Perhaps this is causing the problem.

Let me know how to fix this

Thanks Kartik

Fanatical Labs Provider Affiliate
10 years ago

Anytime you see white/blank screens, usually it's a permissions issue on the Sugar instance. You may want to check to see if the permissions are setup correctly on your Sugar server. Here are a couple good resources for that:

http://support.sugarcrm.com/04_Find_Answers/02KB/02Administration/100Install/Required_File_System_Permissions_on_Linux http://support.sugarcrm.com/04_Find_Answers/02KB/02Administration/100Install/Setting_File_Permissions_and_Ownership_in_config.php

What do you mean by "option to update Campaign Headers"?

There is a SugarChimp option that let's you set how new/old a campaign needs to be for it to be synced. You may want to check that as well.

reply
kartik
10 years ago

Thank you for the reply.

Here is how the Campaign's section looks like: https://www.dropbox.com/s/lj60hn7syte9smj/Screen%20Shot%202014-02-24%20at%208.52.42%20PM.png

I thought in this section we can see the details of the campaigns from Mail Chimp. Am I missing something here?

"There is a SugarChimp option that let's you set how new/old a campaign needs to be for it to be synced. You may want to check that as well."

I have set this to 5

reply
- Fanatical Labs Provider Affiliate
  10 years ago
  
  Ahh, yes. SugarChimp installs a new module called "Mailchimp Campaigns". It may be in the module dropdown of additional modules. That's where you will find all of the Mailchimp campaigns that sync to Sugar.
  
  reply
kartik
10 years ago

Thanks for the help. I am able to view the campaigns now.

Another related question - Is there a way to see/export a list of all contacts who clicked on a particular URL in a campaign? I can see the individual URLs clicked, number of clicks etc under MailChimp Campaigns/Activities..but was unable to sort or make a list of the contacts who clicked on a particular URL in the campaign.

reply
- Fanatical Labs Provider Affiliate
  10 years ago
  
  Good to hear. Glad you can see the campaigns now.
  
  Unfortunately there isn't a good way to do that right now. What you could do though is write a query against the atc_mailchimpactivities to get the data that you need and format it how you want.
  
  reply
kartik
10 years ago

'What you could do though is write a query against the atc_mailchimpactivities to get the data that you need and format it how you want."

Is there any add on module (like a reporting module) that can make this work for us.

when a link in the MailChimp campaign email is clicked I can see under MailChimp Activities tab in CRM a new activity with subject as follows:

'{contact name] - Unique Link Clicked - [website name]'

when I open the activity the exact URL clicked is not displayed. Is it possible to edit the activity subject / description to have the URL clicked also appear?

Thanks

reply
- Fanatical Labs Provider Affiliate
  10 years ago
  
  The url is stored in the CampaignTrackers module. You would need to use some queries to dig into that data.
  
  KReporter is a solid CE reporting solution. Richlode (a SugarCRM partner) also has one they are about to release on SugarOutfitters.
  
  reply
kartik
10 years ago

with reference to the earlier discussion I am wondering whether i will be able to use Advanced Marketing Lists module which you are selling for generating a list of contacts who clicked on a particular URL (by writing a SQL query)?

reply
- Fanatical Labs Provider Affiliate
  10 years ago
  
  That's a really good idea, but "Advanced Marketing Lists" current state will not work. It looks like the developer implemented it in a SugarChimp will not know when records change in Sugar so it won't be able to keep the lists in sync in Mailchimp.
  
  reply