Skip to main content
justin_lautenschlager
justin_lautenschlager
Contributor ⭐️⭐️
December 2, 2015
Solved

Copilot Metrics

  • December 2, 2015
  • 29 replies
  • 346 views
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?
    Best answer by ben
    Hey Kelly,

    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!

    29 replies

    sundar
    sundar
    Expert ⭐️
    December 3, 2015
    You can create a report from "Email Logs" as you see in the following snapshot.
    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

      justin_lautenschlager
      justin_lautenschlagerAuthor
      Contributor ⭐️⭐️
      December 3, 2015
      Thanks, Sundar! Do you have an idea of when unique open/clicks would be available in the analytics section?
      sundar
      sundar
      Expert ⭐️
      December 3, 2015
      My guesstimate would be February. Will keep you posted on the exact dates anyway.
      cail_judy
      cail_judy
      Contributor ⭐️⭐️
      March 10, 2016
      Is this still the case? Would be great to get for my analytics reports as well.
      sundar
      sundar
      Expert ⭐️
      March 11, 2016
      Cail - we got the open rate on the outreach listing page last release. Does that help?
        cail_judy
        cail_judy
        Contributor ⭐️⭐️
        March 11, 2016
        Yes, it does. Can you advise how that's calculated? For example, I sent a group of clients 467 emails and they were opened 955 times. Why is the open rate calculated at 34%?
          lauren_mintz
          lauren_mintz
          Helper ⭐️⭐️
          March 18, 2016
          We also have a strong interest in having unique opens and unique clicks available in the analytics section, as well as visible from the main co-pilot page. 
            john_gerritsen
            john_gerritsen
            Contributor ⭐️
            April 1, 2016
            I would be very interested in hearing a response to this question. My organization has wondered if this may be due to an email being forwarded? This may still catch the open rate, but is unable to account for the additional contact.
            Would someone be able to confirm how are forwarded emails accounted for, if at all? Thanks!
            sundar
            sundar
            Expert ⭐️
            April 5, 2016
            Cail - Open rate is calculated based on unique opens / # emails sent whereas the total opens you see is total opens and not unique. 

            Total opens can be huge for following reasons
            1. Email being forwarded as John pointed out
            2. You start a conversation by replying to that email, then every time that thread gets opened the count is incremented 
            3. You have some email clients that cache your images which might get counted as opened even though the user has not opened. Edge case... (Gmail does not cache these images even though some articles assume so)
              sundar
              sundar
              Expert ⭐️
              April 5, 2016
              Lauren - Using unique opens the open rate is calculated, whereas the total opens you see is not unique. 
              We are working on bringing the unique clicks in copilot reporting by next quarter.
                Show more replies
                Terms & ConditionsAccessibility statement