Hello, everybody! How are you?
How can I make a report with the quantity of emails opting out to receive our communications per day?
Thanks!
Hello, everybody! How are you?
How can I make a report with the quantity of emails opting out to receive our communications per day?
Thanks!
Hi @MWascheck,
This can be accomplished with a custom contact date property and a workflow (there isn’t any default feature for this).
First, you would create a custom contact date property, for example Unsubscribed from all email date.
Next, you would create a contact-based workflow which enrolls contact when “Unsubscribed from all email is equal to True”. The next and only action of this workflow would be to set the value of property created above to the step of the value, making it a timestamp. When you switch this workflow, only enroll contacts that meet the enrollment criteria after the workflow is set live. Otherwise all contacts who opted out before will receive the timestamp for the current date. Unfortunately, that also means that data will not be available retroactively, only from the day onward that you switched the workflow live.
Now, navigate to Menu > Reports > Reports > Create custom report > Single object > Contacts. Click Filters on the upper right, set “Create date is aftar [pick the date when you’re creating this report]” and “Unsubscribed from all email is equal to True”, click Hide filters and Add contact properties. This is where you want to find our custom property from earlier, Unsubscribed from all email date. Now click into the Visualization tab, drag and drop Unsubscribed from all email and Count of contacts in the data area and switch the Frequency from Daily to Weekly on the upper right of the screen.
This will start showing data once contacts unsubscribe.
If you’re interested in contacts who unsubscribed from certain subscriptions (not all email), you’d have to adapt the process acordingly (separate custom date property, additional workflow).
Best regards!
This is unfortunate that it isn’t something easily seen in Hubspot and needs to have a custom worklfow created. So, I can’t go back and see what the opt out dates were for people who have already opted out?