#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
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.
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
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.
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.
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.
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
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.
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)?
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.