#425 - MailChimp past campaigns not visible inside Sugar CRM
Hi
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
8 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.
8 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
8 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.
8 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.
8 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.
8 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
8 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.
8 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)?
8 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.