SugarChimp

Thanks for the help. I now have the activity showing up however I've noticed that the MailChimp campaign name only appears mapped to a human-readably value in the edit pane. Is there any way to get the MailChimp campaign name to show up in the list view?

When I mentioned MailChimp data staying intact, I am referring to when lists or merged or removed. Granted these are not every-day procedures, however list management is important to ensure MailChimp doesn't over inflate subscriber numbers. When this happens, I loose any kind of history data for subscribers on the list.

Thanks.

That makes sense on how the activity data could be lost in those cases. Thanks.

So it requires more custom code to do that. It's something we could work into the product, but not anything I could do in the near term. You'll notice the same issue exists on the list view of the SugarChimpActivity module. This fix would fix both places.

Basically you need to create a process_record logic hook for the SugarChimpActivity module. Whenever it fires, you would take the $record->mailchimp_list_id and $record->mailchimp_campaign_id values and look up the MailChimp List name and Campaign name by the IDs. You could then have a couple custom fields on the SugarChimpActivity module mailchimp_list_name and mailchimp_campaign_name and then you would set those values with the human-readable names you looked up. The new name fields are what you would then display in the subpanel views.

Does that make sense?

Thanks for the suggestion.

I have implemented a custom hook as you suggested and the list and campaign names are now being stored within the CRM.

I have noticed one odd thing however. We are currently using both standard campaigns and automations within MailChimp. For campaigns, all hooks seem to be coming across including send, open, and click. However, for automations, the send hook does not appear to come over. I do not see any "send" hooks for emails sent by a automation workflow and we have sent several thousand.

Any thoughts?

Thanks.

That's awesome you implemented that!

I know the campaign emails and automation emails are two separate things for MailChimp. I've reached out to them to see how this would be possible via the api. I'll let you know what they say and what we can do about it.

You say you do not see any "send" hooks. Are you seeing any open or click activities for automation emails coming through?

Thanks for your help.

Yes I am seeing opens and clicks come through for Automations. It just seems to be the send that is not showing up.

Thanks.

Got it, thanks. After hearing from MailChimp and testing a few things out myself, I see how they are doing things behind the scenes now.

It's going to be tricky to implement this in our codebase in a reliable and scalable way for everyone, but there's a way you can manually have SugarChimp update the sends for the automation campaigns.

The way their export api works to get the activity data is that to get the send data, you have to retrieve the entire list of people who receive a campaign along with all of their activity. Because this can be a potentially large api call/response, we only make this call the very first time we get word a new campaign has been sent. Going forward, nightly we check for activity updates (clicks, opens).

For this to work with automation campaigns, where not everyone is sent the campaign initially, we would need to run the full export nightly which could get pretty big/slow over time.

To manually import the sends for automation campaigns, you can go to the sugarchimp_activity_tracker table and set initial_import=1 and last_sync=NULL for the automation campaign id you want to get all of the 'sends' for.

Does that make sense? Knowing this, do you think you can work around what you're wanting? Thanks!