Member SinceNovember 28th, 2018
Last SeenSeptember 17th, 2019
lorraine.so does not have any add-ons for sale.
Support September 3rd, 2019 @ 9:02 pm
Thanks Jon. I got the invite - I am joined and standing by for 4:30 Central.View Comment
Support September 3rd, 2019 @ 11:35 am
I am still a little confused - when we issued the manual commands through the console it pulled all of the historical open/click data through - even though we still didn't have the webhooks enabled.
I am guessing that the campaign sent information needs to be received by Sugar/SugarChimp to then know to run the once every 24 hour sweep - but I don't understand why that just can't happen every 24 hours and collect the info like it did when we fired it manually.
Is there any chance I can grab 5 minutes on the phone with someone tomorrow (Tuesday)? I am in Sydney and normally online by 4:30pm East Coast time/ 1:30pm West Coast time (assuming you guys are in the states somewhere.)
Support September 1st, 2019 @ 10:56 am
Heidi That clears things up substantially. The key takeway here is that Webhooks are NOT necessary to have Open/Clicked information flow across from Mailchimp to Sugar - this is the information that is polled every 24 hours. That information was the issue that we were having with not being updated and what led Lorraine to open the initial ticket.So the issue we are having does not require a reverse proxy or webhook functionality.
Running the commands in the console while the Reverse Proxy was still disabled yielded the information we needed in the right pane in Sugar. So the question is - what process on the backend controls that 24 hour automatic poll - it seems like it is broken at the moment. Given that running the task manually brought us fully up to date, is there something we need to check in terms of that task - a Cron job or somesuch?View Comment
Support August 28th, 2019 @ 11:28 am
Thanks for following up Heidi - I have been overseas at a conference and haven't had a chance to jump on and follow the instructions.
Thanks for this. The webhooks are also responsible for sending Mailchimp Activity data, which is why that data wasn't appearing previously. That data populates about every 24 hours once the campaign is sent. Since having the reverse proxy established, have you sent any campaigns?
We sent out at test campaign as soon as I configured the webhooks correctly. I didn't leave the reverse proxy open though - it is currently only in test functionality at our end and needs some work to be fully secured - I didn't want to do that until I was sure it was what we needed so I have only been opening it up while we were testing.
I am a little bit unclear on the webhook functionality though - I understand that the Webhook functionality is meant to **PUSH ** data from MailChimp to Sugar. I can't see anywhere in the Mailchimp documentation that indicates that it will be used to communicate Open/LinkClicked information from Mailchimp back to Sugar. Here is our Webhook config:
The list of things that will be sent by the Webhook doesn't seem to include Opens/ClickedLinks.
Additionally, the screenshots earlier in the ticket of campaigns successfully populating the main pane with Clicks/LinkOpen stats were from campaigns sent while the CRM was behind the firewall with no reverse proxy in place.
I have followed the instructions above to issue the commands at the console:
I currently don't have the reverse proxy open - can you come back to me on the above questions - if I need to open the reverse proxy permanently I am happy to do so - I just want to make sure it is actually what we need to do here.
Support August 23rd, 2019 @ 11:02 am
Just a followup - I went back through the Zendesk ticket and noted that you asked for a copy of the Health Status and the Admin page - I have popped them below.
I note that you Lorraine was told:
Are you referring to the data that should appear within Mailchimp Activities or within the Dashlet? The data on the Dashlet should always be a live pull of data, but the data within Mailchimp Activities refreshes about once every 24 hours. We update every 24 hours so as to not overload the system with updates. For the campaigns sent today, it's worth checking in the morning to see if they appear for you.
If this is the issue, is it possible that there is a cron job or scheduled task somewhere that isn't firing to sync that data across?
Support August 22nd, 2019 @ 11:18 am
Jon Thanks so much for the quick reply! You were right - I can see now why the PHP wasn't firing.
I know it is an edge case and the support page for it probably doesn't get many hits - but you might want to update https://fanaticallabs.zendesk.com/hc/en-us/articles/360022146071-Setting-Up-a-Reverse-Proxy to indicate that the webhook has to include the string in the URL to get through the IF statement.
It is probably crystal clear to someone who can write PHP well - but I totally missed that.
The data is now flowing correctly into Sugar - that is great.
Unfortunately it looks like I might be working at crossed purposes - I just sat down with Lorraine and it appears that the data she is not getting into SugarCRM is the Open/Click Link data from Mailchimp. All is not lost, because now we get the profile change and unsubscribe info as well - but I will open another ticket regarding her specific issue - hopefully it is an easy fix.
Thanks again for the prompt reply.View Comment
lorraine.so has not rated any add-ons.
lorraine.so has not verified any add-ons.
lorraine.so has not created any Wanted Add-ons.