• Email Summary Transition
    Transition Plans
  • Standard Reporting
    Standard Reporting Overview Standard Reporting Glossary Realtime Dashboard Weekly Performance Report
  • Usage Dashboard
    Send Volume Usage
  • Message Summary
    Email Summary Campaign Reports Triggered Send Reports Content Summary SMS Summary Push and In-App Summary NHI Clicks User Guide Apple MPP User Guide
  • User Reports
    User Reports Overview User Lookup Lists Report List Growth Report Source Signup Report Snapshots List List Performance Report Jobs Page Postback Log
  • Purchase Reports
    Use the Purchase Log to View/Export Purchase Data
  • Sailthru System
    System Status and Alerts
  • Connect
    Connect S3 Bucket Policy Information Event Stream Overview Email Event Stream Data Sets Mobile Event Stream Data Sets Data Exporter Overview Data Exporter Data Sets
  • Business Intelligence

    • Calculations

    Add calculated fields to your Business Intelligence worksheets to show data for specific stats.

    Calculations are saved to your current workbook and can be used across all worksheets in the workbook that use the same datasource. If you create a new workbook or add a secondary data source, you will need to recreate the calculated fields. 

    Add a Calculated Field

    1. Create a new sheet or select Edit for an existing sheet. 
    2. Select the data source you wish to work with from the Data tab if your worksheet contains more than one data source.  
    3. Follow one of two paths to open the Create Calculated Field modal window:
      1. Open the Analysis menu in the main menu bar. Select Create Calculated Field from the menu.

      2. Select the dropdown arrow next to the Search bar. Select Create Calculated Field from the menu.

    4. Give your calculation a unique name.

      Note: The Create Calculated Field modal may initially show that the calculation contains errors. 
    5. Enter your formula in the box. The easiest method is to copy and paste a formula from the Calculations documentation for your selected data source.
      1. If the field names don't match what exists in the data source, they show red.

      2. Correct the field names by dragging the data points from the left-hand data table.
      3. The fields validate automatically as you select the correct fields.

    6. Select Okay. The new calculation shows under Measure Names in the Data Sources panel.
    7.  To add the calculation to your report, drag and drop it to a column or row. 
      1. Once you add your calculation, you may wish to reformat the calculation to, for example, a percentage. 
      2. Hover over your calculation and select the down arrow.

      3. Select Format Number from the menu.

      4. Select your new format from the modal window.

     

    Add Complex Calculated Fields

    Sometimes the calculated field you want to use in a report requires a more complex formula to get the data you need. All of the calculations available are listed in the Calculations documentation, separated by data source. 

    1. Create a new worksheet or open an existing one. 
    2. Open the Analysis menu in the main menu bar. Select Create Calculated Field from the menu.

      The Create Calculated Field modal opens. 
    3. Locate the data source you're working with in the Calculations documentation. Select and copy the formula for the field you wish to add.
    4. Paste the formula into the Create Calculated Field modal.

    5. Your formula should validate automatically. If the modal shows a validation error, check to make sure you selected a formula from the correct data source. 
    6. Select OK.
    7. Locate your new calculated field in the Measure Names table. Drag the field and drop it to a column or row.

    Calculations

    The following calculations can be used to create metrics within Business Intelligence. Calculations are sorted by data source to allow you to copy and paste the calculation into Business Intelligence as a new Calculated Field under the Analysis menu. 

    Email and List Stats

    Unique opens

    SUM([Beacon Click Count]+[Beacon Noclick Count]+[Nobeacon Click Count])

    Open rate

    SUM([Beacon Click Count]+[Beacon Noclick Count]+[Nobeacon Click Count])/SUM([Delivered Count])

    Unique clicks  & CTR

    SUM([Beacon Click Count]+[Nobeacon Click Count])

    SUM([Beacon Click Count]+[Nobeacon Click Count])/SUM([Delivered Count])

    Unique Real Clicks & CTR

    SUM([real_click_count])

    SUM([real_click_count])/ SUM([Delivered Count])

    Total Real Clicks & CTR

    SUM([real_total_click_count])

    SUM([real_total_click_count])/ SUM([Delivered Count])

    Total Clicks & CTR

    SUM([Total Click Count])

    SUM([Total Click Count])/ SUM([Delivered Count])

    PV/M

    SUM([Pageview Count])/SUM([Delivered Count])*1000

    Delivery rate

    SUM([Delivered Count])/SUM([Send Count])

    Complaint rate

    SUM([Spam Count])/SUM([Send Count])

    Rev/M

    (SUM([Revenue]/100)/[Delivered Count])*1000

    Conversion rate

    SUM([Purchase Count])/sum([Send Count])

    Hard bounce rate

    SUM([Hardbounce Count])/SUM([Send Count])

    Soft bounce rate

    SUM([Softbounce Count])/SUM([Send Count])

    Average Order Value (AOV)

    sum([Revenue])/SUM([Purchase Count])/100

    Pageviews per click

    SUM([Pageview Count])/SUM([Beacon Click Count]+[Nobeacon Click Count])

    RPM

    (SUM([Revenue])/SUM([Delivered Count]))*10

    Campaign Stats by Domain & Engagement

    campaign_stats_by_domain

    Unique opens

    SUM([Beacon Click Count]+[Beacon Noclick Count]+[Nobeacon Click Count])

    Open rate

    SUM([Beacon Click Count]+[Beacon Noclick Count]+[Nobeacon Click Count])/SUM([Send Count]-[Hardbounce Count]-[Softbounce Count])

    Unique clicks  & CTR

    SUM([Beacon Click Count]+[Nobeacon Click Count])

    SUM([Beacon Click Count]+[Nobeacon Click Count])/SUM([Send Count]-[Hardbounce Count]-[Softbounce Count])

    Unique Real Clicks & CTR

    SUM([real_click_count])

    SUM([real_click_count])/ SUM([Send Count]-[Hardbounce Count]-[Softbounce Count])

    Total Real Clicks & CTR

    SUM([real_total_click_count])

    SUM([real_total_click_count])/ SUM([Send Count]-[Hardbounce Count]-[Softbounce Count])

    Total Clicks & CTR

    SUM([Total Click Count])

    SUM([Total Click Count])/ SUM([Send Count]-[Hardbounce Count]-[Softbounce Count])

    PV/M

    SUM([Pageview Count])/SUM([Send Count]-[Hardbounce Count]-[Softbounce Count])*1000

    Delivery rate

    SUM([Send Count]-[Hardbounce Count]-[Softbounce Count])/SUM([Send Count])

    Complaint rate

    SUM([Spam Count])/SUM([Send Count])

    Rev/M

    (SUM([Revenue])/100)/SUM([Send Count]-[Hardbounce Count]-[Softbounce Count]))*1000

    Conversion rate

    SUM([Purchase Count])/sum([Send Count])

    Hard bounce rate

    SUM([Hardbounce Count])/SUM([Send Count])

    Soft bounce rate

    SUM([Softbounce Count])/SUM([Send Count])

    Average Order Value (AOV)

    sum([Revenue])/SUM([Purchase Count])/100

    Pageviews per click

    SUM([Pageview Count])/SUM([Beacon Click Count]+[Nobeacon Click Count])

    RPM

    (SUM([Revenue])/SUM([Send Count]-[Hardbounce Count]-[Softbounce Count]))*10

    campaign_stats_by_engagement

    Unique opens

    SUM([Beacon Click Count (Campaign Stats By Engagement)]+[Beacon Noclick Count (Campaign Stats By Engagement)]+[Nobeacon Click Count (Campaign Stats By Engagement)])

    Open rate

    SUM([Beacon Click Count (Campaign Stats By Engagement)]+[Beacon Noclick Count (Campaign Stats By Engagement)]+[Nobeacon Click Count (Campaign Stats By Engagement)])/SUM([Send Count (Campaign Stats By Engagement)]-[Hardbounce Count (Campaign Stats By Engagement)]-[Softbounce Count (Campaign Stats By Engagement)])

    Unique clicks  & CTR

    SUM([Beacon Click Count (Campaign Stats By Engagement)]+[Nobeacon Click Count (Campaign Stats By Engagement)])


    SUM([Beacon Click Count (Campaign Stats By Engagement)]+[Nobeacon Click Count (Campaign Stats By Engagement)])/SUM([Send Count (Campaign Stats By Engagement)]-[Hardbounce Count (Campaign Stats By Engagement)]-[Softbounce Count (Campaign Stats By Engagement)])

    Unique Real Clicks & CTR

    SUM([real_click_count (campaign_stats_by_engagement)])



    SUM([real_click_count (campaign_stats_by_engagement)])/SUM([Total Click Count (Campaign Stats By Engagement)])/ SUM([Send Count (Campaign Stats By Engagement)]-[Hardbounce Count (Campaign Stats By Engagement)]-[Softbounce Count (Campaign Stats By Engagement)])

    Total Real Clicks & CTR

    SUM([real_total_click_count (campaign_stats_by_engagement)])



    SUM([real_total_click_count (campaign_stats_by_engagement)])/ SUM([Total Click Count (Campaign Stats By Engagement)])/ SUM([Send Count (Campaign Stats By Engagement)]-[Hardbounce Count (Campaign Stats By Engagement)]-[Softbounce Count (Campaign Stats By Engagement)])

    Total Clicks & CTR

    SUM([Total Click Count (Campaign Stats By Engagement)])




    SUM([Total Click Count (Campaign Stats By Engagement)])/ SUM([Send Count (Campaign Stats By Engagement)]-[Hardbounce Count (Campaign Stats By Engagement)]-[Softbounce Count (Campaign Stats By Engagement)])

    PV/M

    SUM([Pageview Count (Campaign Stats By Engagement)])/SUM([Send Count (Campaign Stats By Engagement)]-[Hardbounce Count (Campaign Stats By Engagement)]-[Softbounce Count (Campaign Stats By Engagement)])*1000

    Delivery rate

    SUM([Send Count (Campaign Stats By Engagement)]-[Hardbounce Count (Campaign Stats By Engagement)]-[Softbounce Count (Campaign Stats By Engagement)])/SUM([Send Count (Campaign Stats By Engagement)])

    Complaint rate

    SUM([Spam Count (Campaign Stats By Engagement)])/SUM([Send Count (Campaign Stats By Engagement)])

    Rev/M

    (SUM([Revenue (Campaign Stats By Engagement)]/100)/SUM([Send Count (Campaign Stats By Engagement)]-[Hardbounce Count (Campaign Stats By Engagement)]-[Softbounce Count (Campaign Stats By Engagement)]))*1000

    Conversion rate

    SUM([Purchase Count (Campaign Stats By Engagement)])/sum([Send Count (Campaign Stats By Engagement)])

    Hard bounce rate

    SUM([Hardbounce Count (Campaign Stats By Engagement)])/SUM([Send Count (Campaign Stats By Engagement)])

    Soft bounce rate

    SUM([Softbounce Count (Campaign Stats By Engagement)])/SUM([Send Count (Campaign Stats By Engagement)])

    Average Order Value (AOV)

    sum([Revenue (Campaign Stats By Engagement)])/SUM([Purchase Count (Campaign Stats By Engagement)])/100

    Pageviews per click

    SUM([Pageview Count (Campaign Stats By Engagement)])/SUM([Beacon Click Count (Campaign Stats By Engagement)]+[Nobeacon Click Count (Campaign Stats By Engagement)])

    RPM

    (SUM([Revenue (Campaign Stats By Engagement)])/SUM([Send Count (Campaign Stats By Engagement)]-[Hardbounce Count (Campaign Stats By Engagement)]-[Softbounce Count (Campaign Stats By Engagement)]))*10

     

    Campaign Stats by Signup Month

     

    Unique opens

    SUM([Beacon Click Count]+[Beacon Noclick Count]+[Nobeacon Click Count])

    Open rate

    SUM([Beacon Click Count]+[Beacon Noclick Count]+[Nobeacon Click Count])/SUM([Send Count]-[Hardbounce Count]-[Softbounce Count])

    Unique clicks & CTR

    SUM([Beacon Click Count]+[Nobeacon Click Count])

    SUM([Beacon Click Count]+[Nobeacon Click Count])/SUM([Send Count]-[Hardbounce Count]-[Softbounce Count])

    Unique Real Clicks & CTR

    SUM([real_click_count])



    SUM([real_click_count])/ SUM([Send Count]-[Hardbounce Count]-[Softbounce Count])

    Total Real Clicks & CTR

    SUM([real_total_click_count])



    SUM([real_total_click_count])/SUM([Send Count]-[Hardbounce Count]-[Softbounce Count])

    Total Clicks & CTR

    SUM([Total Click Count])




    SUM([Total Click Count])/SUM([Send Count]-[Hardbounce Count]-[Softbounce Count])

    PV/M

    SUM([Pageview Count])/SUM([Send Count]-[Hardbounce Count]-[Softbounce Count])*1000

    Delivery rate

    SUM([Send Count]-[Hardbounce Count]-[Softbounce Count])/SUM([Send Count])

    Complaint rate

    SUM([Spam Count])/SUM([Send Count])

    Rev/M

    (SUM([Revenue])/100)/(SUM([Send Count]-[Hardbounce Count]-[Softbounce Count])))*1000

    Conversion rate

    SUM([Purchase Count])/sum([Send Count])

    Hard bounce rate

    SUM([Hardbounce Count])/SUM([Send Count])

    Soft bounce rate

    SUM([Softbounce Count])/SUM([Send Count])

    Average Order Value (AOV)

    sum([Revenue])/SUM([Purchase Count])/100

    Pageviews per click

    SUM([Pageview Count])/SUM([Beacon Click Count]+[Nobeacon Click Count])

    RPM

    (SUM([Revenue])/SUM([Send Count]-[Hardbounce Count]-[Softbounce Count]))*10

    Campaign Stats by Device

     

    Unique opens

    SUM([Beacon Click Count]+[Beacon Noclick Count]+[Nobeacon Click Count])

    Open rate

    SUM([Beacon Click Count]+[Beacon Noclick Count]+[Nobeacon Click Count])/SUM([Send Count]-[Hardbounce Count]-[Softbounce Count])

    Unique clicks 

    SUM([Beacon Click Count]+[Nobeacon Click Count])

    Clickthrough rate (CTR)

    SUM([Beacon Click Count]+[Nobeacon Click Count])/SUM([Send Count]-[Hardbounce Count]-[Softbounce Count])

    Click to open rate (CTOR)

    SUM([Beacon Click Count]+[Nobeacon Click Count])/SUM([Beacon Click Count]+[Beacon Noclick Count]+[Nobeacon Click Count])

    PV/M

    SUM([Pageview Count])/SUM([Send Count]-[Hardbounce Count]-[Softbounce Count])*1000

    Delivery rate

    SUM([Send Count]-[Hardbounce Count]-[Softbounce Count])/SUM([Send Count])

    Complaint rate

    SUM([Spam Count])/SUM([Send Count])

    Rev/M

    ((SUM([Revenue])/100)/(SUM([Send Count]-[Hardbounce Count]-[Softbounce Count])))*1000

    Conversion rate

    SUM([Purchase Count])/sum([Send Count])

    Hard bounce rate

    SUM([Hardbounce Count])/SUM([Send Count])

    Soft bounce rate

    SUM([Softbounce Count])/SUM([Send Count])

    Average Order Value (AOV)

    sum([Revenue])/SUM([Purchase Count])/100

    Pageviews per click

    SUM([Pageview Count])/SUM([Beacon Click Count]+[Nobeacon Click Count])

    RPM

    (SUM([Revenue])/SUM([Send Count]-[Hardbounce Count]-[Softbounce Count]))*10

    Campaign Stats

    Unique opens

    SUM([Beacon Click Count]+[Beacon Noclick Count]+[Nobeacon Click Count])

    Open rate

    SUM([Beacon Click Count]+[Beacon Noclick Count]+[Nobeacon Click Count])/SUM([Delivered Count])

    Unique clicks 

    SUM([Beacon Click Count]+[Nobeacon Click Count])

    Clickthrough rate (CTR)

    SUM([Beacon Click Count]+[Nobeacon Click Count])/SUM([Delivered Count])

    Click to open rate (CTOR)

    SUM([Beacon Click Count]+[Nobeacon Click Count])/SUM([Beacon Click Count]+[Beacon Noclick Count]+[Nobeacon Click Count])

    PV/M

    SUM([Pageview Count])/SUM([Delivered Count])*1000

    Delivery rate

    SUM([Delivered Count])/SUM([Send Count])

    Complaint rate

    SUM([Spam Count])/SUM([Send Count])

    Rev/M

    (SUM([Revenue])/100)/[Delivered Count])*1000

    Conversion rate

    SUM([Purchase Count])/sum([Send Count])

    Hard bounce rate

    SUM([Hardbounce Count])/SUM([Send Count])

    Soft bounce rate

    SUM([Softbounce Count])/SUM([Send Count])

    Average Order Value (AOV)

    sum([Revenue])/SUM([Purchase Count])/100

    Pageviews per click

    SUM([Pageview Count])/SUM([Beacon Click Count]+[Nobeacon Click Count])

    RPM

    (SUM([Revenue])/SUM([Delivered Count]))*10

     

    Campaign Stats by Label

    campaign_stats_blast_label

    Unique opens

    SUM([Beacon Click Count]+[Beacon Noclick Count]+[Nobeacon Click Count])

    Open rate

    SUM([Beacon Click Count]+[Beacon Noclick Count]+[Nobeacon Click Count])/SUM([Delivered Count])

    Unique clicks 

    SUM([Beacon Click Count]+[Nobeacon Click Count])

    Clickthrough rate (CTR)

    SUM([Beacon Click Count]+[Nobeacon Click Count])/SUM([Delivered Count])

    Click to open rate (CTOR)

    SUM([Beacon Click Count]+[Nobeacon Click Count])/SUM([Beacon Click Count]+[Beacon Noclick Count]+[Nobeacon Click Count])

    PV/M

    SUM([Pageview Count])/SUM([Delivered Count])*1000

    Delivery rate

    SUM([Delivered Count])/SUM([Send Count])

    Complaint rate

    SUM([Spam Count])/SUM([Send Count])

    Rev/M

    (SUM([Revenue])/100)/[Delivered Count])*1000

    Conversion rate

    SUM([Purchase Count])/sum([Send Count])

    Hard bounce rate

    SUM([Hardbounce Count])/SUM([Send Count])

    Soft bounce rate

    SUM([Softbounce Count])/SUM([Send Count])

    Average Order Value (AOV)

    sum([Revenue])/SUM([Purchase Count])/100

    Pageviews per click

    SUM([Pageview Count])/SUM([Beacon Click Count]+[Nobeacon Click Count])

    RPM

    (SUM([Revenue])/SUM([Delivered Count]))*10

     

    campaign_stats_by_device_label

     

    Unique opens

    SUM([Beacon Click Count (Campaign Stats By Device Label)]+[Beacon Noclick Count (Campaign Stats By Device Label)]+[Nobeacon Click Count (Campaign Stats By Device Label)])

    Open rate

    SUM([Beacon Click Count (Campaign Stats By Device Label)]+[Beacon Noclick Count (Campaign Stats By Device Label)]+[Nobeacon Click Count (Campaign Stats By Device Label)])/SUM([Send Count (Campaign Stats By Device Label)]-[Hardbounce Count (Campaign Stats By Device Label)]-[Softbounce Count (Campaign Stats By Device Label)])

    Unique clicks 

    SUM([Beacon Click Count (Campaign Stats By Device Label)]+[Nobeacon Click Count (Campaign Stats By Device Label)])

    Clickthrough rate (CTR)

    SUM([Beacon Click Count (Campaign Stats By Device Label)]+[Nobeacon Click Count (Campaign Stats By Device Label)])/SUM([Send Count (Campaign Stats By Device Label)]-[Hardbounce Count (Campaign Stats By Device Label)]-[Softbounce Count (Campaign Stats By Device Label)])

    Click to open rate (CTOR)

    SUM([Beacon Click Count (Campaign Stats By Device Label)]+[Nobeacon Click Count (Campaign Stats By Device Label)])/SUM([Beacon Click Count (Campaign Stats By Device Label)]+[Beacon Noclick Count (Campaign Stats By Device Label)]+[Nobeacon Click Count (Campaign Stats By Device Label)])

    PV/M

    SUM([Pageview Count (Campaign Stats By Device Label)])/SUM([Send Count (Campaign Stats By Device Label)]-[Hardbounce Count (Campaign Stats By Device Label)]-[Softbounce Count (Campaign Stats By Device Label)])*1000

    Delivery rate

    SUM([Send Count (Campaign Stats By Device Label)]-[Hardbounce Count (Campaign Stats By Device Label)]-[Softbounce Count (Campaign Stats By Device Label)])/SUM([Send Count (Campaign Stats By Device Label)])

    Complaint rate

    SUM([Spam Count (Campaign Stats By Device Label)])/SUM([Send Count (Campaign Stats By Device Label)])

    Rev/M

    (SUM([Revenue (Campaign Stats By Device Label)])/100)/SUM([Send Count (Campaign Stats By Device Label)]-[Hardbounce Count (Campaign Stats By Device Label)]-[Softbounce Count (Campaign Stats By Device Label)])*1000

    Conversion rate

    SUM([Purchase Count (Campaign Stats By Device Label)])/sum([Send Count (Campaign Stats By Device Label)])

    Hard bounce rate

    SUM([Hardbounce Count (Campaign Stats By Device Label)])/SUM([Send Count (Campaign Stats By Device Label)])

    Soft bounce rate

    SUM([Softbounce Count (Campaign Stats By Device Label)])/SUM([Send Count (Campaign Stats By Device Label)])

    Average Order Value (AOV)

    sum([Revenue (Campaign Stats By Device Label)])/SUM([Purchase Count (Campaign Stats By Device Label)])/100

    Pageviews per click

    SUM([Pageview Count (Campaign Stats By Device Label)])/SUM([Beacon Click Count (Campaign Stats By Device Label)]+[Nobeacon Click Count (Campaign Stats By Device Label)])

    RPM

    (SUM([Revenue (Campaign Stats By Device Label)])/SUM([Send Count (Campaign Stats By Device Label)]-[Hardbounce Count (Campaign Stats By Device Label)]-[Softbounce Count (Campaign Stats By Device Label)]))*10

     

    campaign_stats_by_domain_label

     

    Unique opens

    SUM([Beacon Click Count (Campaign Stats By Domain Label)]+[Beacon Noclick Count (Campaign Stats By Domain Label)]+[Nobeacon Click Count (Campaign Stats By Domain Label)])

    Open rate

    SUM([Beacon Click Count (Campaign Stats By Domain Label)]+[Beacon Noclick Count (Campaign Stats By Domain Label)]+[Nobeacon Click Count (Campaign Stats By Domain Label)])/SUM([Send Count (Campaign Stats By Domain Label)]-[Hardbounce Count (Campaign Stats By Domain Label)]-[Softbounce Count (Campaign Stats By Domain Label)])

    Unique clicks 

    SUM([Beacon Click Count (Campaign Stats By Domain Label)]+[Nobeacon Click Count (Campaign Stats By Domain Label)])

    Clickthrough rate (CTR)

    SUM([Beacon Click Count (Campaign Stats By Domain Label)]+[Nobeacon Click Count (Campaign Stats By Domain Label)])/SUM([Send Count (Campaign Stats By Domain Label)]-[Hardbounce Count (Campaign Stats By Domain Label)]-[Softbounce Count (Campaign Stats By Domain Label)])

    Click to open rate (CTOR)

    SUM([Beacon Click Count (Campaign Stats By Domain Label)]+[Nobeacon Click Count (Campaign Stats By Domain Label)])/SUM([Beacon Click Count (Campaign Stats By Domain Label)]+[Beacon Noclick Count (Campaign Stats By Domain Label)]+[Nobeacon Click Count (Campaign Stats By Domain Label)])

    PV/M

    SUM([Pageview Count (Campaign Stats By Domain Label)])/SUM([Send Count (Campaign Stats By Domain Label)]-[Hardbounce Count (Campaign Stats By Domain Label)]-[Softbounce Count (Campaign Stats By Domain Label)])*1000

    Delivery rate

    SUM([Send Count (Campaign Stats By Domain Label)]-[Hardbounce Count (Campaign Stats By Domain Label)]-[Softbounce Count (Campaign Stats By Domain Label)])/SUM([Send Count (Campaign Stats By Domain Label)])

    Complaint rate

    SUM([Spam Count (Campaign Stats By Domain Label)])/SUM([Send Count (Campaign Stats By Domain Label)])

    Rev/M

    (SUM([Revenue (Campaign Stats By Domain Label)]/100)/SUM([Send Count (Campaign Stats By Domain Label)]-[Hardbounce Count (Campaign Stats By Domain Label)]-[Softbounce Count (Campaign Stats By Domain Label)]))*1000

    Conversion rate

    SUM([Purchase Count (Campaign Stats By Domain Label)])/sum([Send Count (Campaign Stats By Domain Label)])

    Hard bounce rate

    SUM([Hardbounce Count (Campaign Stats By Domain Label)])/SUM([Send Count (Campaign Stats By Domain Label)])

    Soft bounce rate

    SUM([Softbounce Count (Campaign Stats By Domain Label)])/SUM([Send Count (Campaign Stats By Domain Label)])

    Average Order Value (AOV)

    sum([Revenue (Campaign Stats By Domain Label)])/SUM([Purchase Count (Campaign Stats By Domain Label)])/100

    Pageviews per click

    SUM([Pageview Count (Campaign Stats By Domain Label)])/SUM([Beacon Click Count (Campaign Stats By Domain Label)]+[Nobeacon Click Count (Campaign Stats By Domain Label)])

    RPM

    (SUM([Revenue (Campaign Stats By Domain Label)])/SUM([Send Count (Campaign Stats By Domain Label)]-[Hardbounce Count (Campaign Stats By Domain Label)]-[Softbounce Count (Campaign Stats By Domain Label)]))*10

     

    Purchase

    AOV (Purchase)

    SUM([Total Price])/sum([Purchase Count (Purchase Stats By Hour)])

    AVG basket size

    sum([total_items_count])/sum([Purchase Count (Purchase Stats By Hour)])

     

    Profile Stats

    AOV 

    sum([Total Purchase Revenue])/sum([Total Purchase Count])

    Buyers

    if [Is Buyer] = 'Buyer' then [Num Profiles] END

    Cohort conversion

    sum(if [Is Buyer] = 'Buyer' then [Num Profiles] END)/sum([Num Profiles])

    Conversion rate

    SUM([Num Profiles Gte 1 Purchases])/SUM([Num Profiles])

    1 to 2 Retention

    SUM([Num Profiles Gte 2 Purchases])/SUM([Num Profiles Gte 1 Purchases])

    2 to 3 Retention

    SUM([Num Profiles Gte 3 Purchases])/SUM([Num Profiles Gte 2 Purchases])

    3 to 4 Retention

    SUM([Num Profiles Gte 4 Purchases])/SUM([Num Profiles Gte 3 Purchases])

     

    Email Stats

     

    Unique opens

    SUM([Beacon Click Count]+[Beacon Noclick Count]+[Nobeacon Click Count])

    Open rate

    SUM([Beacon Click Count]+[Beacon Noclick Count]+[Nobeacon Click Count])/SUM([Delivered Count])

    Unique clicks 

    SUM([Beacon Click Count]+[Nobeacon Click Count])

    Clickthrough rate (CTR)

    SUM([Beacon Click Count]+[Nobeacon Click Count])/SUM([Delivered Count])

    Click to open rate (CTOR)

    SUM([Beacon Click Count]+[Nobeacon Click Count])/SUM([Beacon Click Count]+[Beacon Noclick Count]+[Nobeacon Click Count])

    PV/M

    SUM([Pageview Count])/SUM([Delivered Count])*1000

    Delivery rate

    SUM([Delivered Count])/SUM([Send Count])

    Complaint rate

    SUM([Spam Count])/SUM([Send Count])

    Rev/M

    (SUM([Revenue]/100)/[Delivered Count])*1000

    Conversion rate

    SUM([Purchase Count])/sum([Send Count])

    Hard bounce rate

    SUM([Hardbounce Count])/SUM([Send Count])

    Soft bounce rate

    SUM([Softbounce Count])/SUM([Send Count])

    Average Order Value (AOV)

    sum([Revenue])/SUM([Purchase Count])/100

    Pageviews per click

    SUM([Pageview Count])/SUM([Beacon Click Count]+[Nobeacon Click Count])

    RPM

    (SUM([Revenue])/SUM([Delivered Count]))*10






    Contact us

    Top