Best answer by benView original
When I view some of the outreaches we've put together in Copilot, it seems as though we're only able to track the number of opens, clicks, bounces, etc. The way we currently track our email outreaches is by the % of unique opens, clicks, and bounces. While I could see the benefit of tracking the pure number of opens and clicks, is there no way to also track the percent of unique opens and clicks as well?
Already have an account? Login
Login to the community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Clicked -- Contains 1 or 0 based on clicked or not.
Click count -- Is the sum of all clicks on that email -- This is what you see in copilot analytics. We are planning to get unique open rate in the analytics down the line
Would someone be able to confirm how are forwarded emails accounted for, if at all? Thanks!
Total opens can be huge for following reasons
We are working on bringing the unique clicks in copilot reporting by next quarter.
Is there an update on the ETA for when we will be able to pull unique clickthroughs and unique opens in Reports?
I don't think that's going to be in the late August (5.2) release, but Sundar can provide more insight on the timeline.
I think what you are looking for is "Opened" vs. "Opened Count". "Opened Count" in the Email Logs table is the RAW number of times the contact opened the email. This could be 0 to infinity. Meanwhile "Opened" is a numeric field that is a 0 if they have never opened the email, and a 1 if they have opened it at least once.
With this in mind, you can do aggregations across various groupings and use "Opened" as your unique field. You can calculate Open Rate by taking "Opened" / "Sent" for a given aggregate field.
Hope this helps!