Skip to main content

Count Data

The Count Data section provides a quick summary of important metrics related to email campaigns.
These values are shown as numerical counts and help users understand the current status and performance of their email outreach.

Fields and Their Meanings​

Total Data​

Represents the total number of website data entries available for the selected website.
It includes all records regardless of whether an email has been sent or not.

SQL Query (Total Data)​

-- Query: Fetch total website data count
--

Not Yet Sent​

Represents the count of website data entries to which the user has not yet sent any email.

SQL Query (Not Yet Sent)​

-- Query: Fetch count of website data not yet sent
--

1st Email Sent​

Represents the count of website data entries to which the first email has been successfully sent.

SQL Query (1st Email Sent)​

-- Query: Fetch count of website data with 1st email sent
--

2nd Email Sent​

Represents the count of website data entries to which the second email has been successfully sent.

SQL Query (2nd Email Sent)​

-- Query: Fetch count of website data with 2nd email sent
--

3rd Email Sent​

Represents the count of website data entries to which the third email has been successfully sent.

SQL Query (3rd Email Sent)​

-- Query: Fetch count of website data with 3rd email sent
--

Converted on 1st​

Represents the count of website data entries that converted (opened the email) after receiving the first email.

SQL Query (Converted on 1st)​

-- Query: Fetch count of website data converted on 1st email
--

Converted on 2nd​

Represents the count of website data entries that converted (opened the email) after receiving the second email.

SQL Query (Converted on 2nd)​

-- Query: Fetch count of website data converted on 1st email
--

Converted on 3rd​

Represents the count of website data entries that converted (opened the email) after receiving the third email.

SQL Query (Converted on 3rd)​

-- Query: Fetch count of website data converted on 3rd email
--

Unsubscribed​

Represents the count of website data entries that unsubscribed from the email campaign. These users have opted out of receiving further emails.

SQL Query (Unsubscribed)​

-- Query: Fetch count of website data unsubscribed
--

Summary​

  • Total Data = all website data entries.
  • Not Yet Sent = data entries with no email sent.
  • 1st / 2nd / 3rd Email Sent = data entries that received respective campaign emails.
  • Converted on 1st / 2nd / 3rd = data entries that engaged with (opened) the email after respective campaigns.
  • Unsubscribed = data entries that opted out from receiving further emails.