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 30 day trial
Try it Now

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

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

  1. fanaticallabs member avatar

    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.

  2. kartik member avatar

    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

    • fanaticallabs member avatar

      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.

  3. kartik member avatar

    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.

    • fanaticallabs member avatar

      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.

  4. kartik member avatar

    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

    • fanaticallabs member avatar

      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.

  5. kartik member avatar

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

    • fanaticallabs member avatar

      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.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "SugarChimp is exactly what we needed, it syncs nicely between MailChimp and Sugar. The added MailChimp dashlet is very sophisticated. Works great – thank you!"

    Read More Reviews