Email Campaign Open Rate Logs

This dataset provides detailed logs of email marketing campaigns, including send times, subject lines, delivery and open metrics, device usage, and recipient actions such as bounces and unsubscribes. It enables marketers to analyze and optimize campaign performance, refine subject lines, and determine the most effective send times for improved engagement.

  • last updated 12 Jul 2025
  • by GoMask
The brief that made it

Analyzing and optimizing email subject lines and send times for higher engagement

Sample rows

preview · 8 of 70 rows · all 15 columns
campaign_idstringopen_device_typestringopen_ratefloatcampaign_namestringsend_datedatesend_timestringsubject_linestringtotal_recipientsintegeremails_deliveredintegeremails_openedintegerunique_opensintegeropen_time_peak_hourintegerbounce_countintegerunsubscribe_countintegercreated_atdatetime
CMP-20240401-01mobile33.8Spring Essentials Launch2024-04-0109:00Refresh Your Spring Wardrobe Today!3500347511751100102582024-04-01T09:02:14
CMP-20240402-02desktop40.6April Deals Blast2024-04-0210:30Unmissable April Savings Inside42004170169516001130152024-04-02T10:32:01
CMP-20240403-03mobile55.8New Arrivals Weekly2024-04-0313:45Just In: This Week's Fresh Picks2000197511021030152572024-04-03T13:46:14
CMP-20240404-04desktop90VIP Exclusive Preview2024-04-0418:00VIPs: Early Access To Summer Styles60060054052019002024-04-04T18:00:33
CMP-20240405-05mobile21.1Weekend Flash Sale2024-04-0508:15Flash Sale Only This Weekend!10000995021002000950252024-04-05T08:16:00
CMP-20240406-06tablet48Sunday Inspiration2024-04-0607:30Sunday Reads: Our Top Picks32003195153514608532024-04-06T07:30:51
CMP-20240407-07desktop21.8Last Chance Reminder2024-04-0720:00Last Day: Don't Miss Out!85008480185017502120122024-04-07T20:01:24
CMP-20240408-08mobile50.5Travel Essentials Promo2024-04-0815:30Get Ready For Summer Journeys4800478024152288162082024-04-08T15:31:10

What the 70 rows show

from the 70-row sample
  • 38.3median open_rate
  • 3,920median total_recipients
  • 3,912median emails_delivered
  • 1,455median emails_opened
  • 1,403median unique_opens
  • 13median open_time_peak_hour
open_device_type70 rows by value
0204036mobile51%23desktop33%11tablet16%
open_rate70 rows, in bands of 10
015300111261485131050100open_rate →

Median 38.3, from 19.0 to 90.0.

15 columns by typefrom the column list below
  • string 5
  • integer 7
  • float 1
  • date 1
  • datetime 1

Columns

15 columns in three groups
blueprint · 15 columns
columntypedescriptionexample
Text 5 columns
campaign_idstringUnique identifier for the email marketing campaignCMP-20240401-01
campaign_namestringDescriptive name of the email campaignSpring Essentials Launch
send_timestringTime of day the email campaign was sent (24-hour format, e.g., '14:00')09:00
subject_linestringSubject line used in the email campaignBack In Stock: Shop Now!
open_device_typestringMost common device type used to open emails (e.g., 'mobile', 'desktop', 'tablet')mobile · desktop · tablet · unknown · optionalmobile
Numbers 8 columns
total_recipientsintegerTotal number of recipients the email was sent to0 or more3500
emails_deliveredintegerNumber of emails successfully delivered0 or more3475
emails_openedintegerNumber of emails that were opened by recipients0 or more1175
open_ratefloatPercentage of delivered emails that were opened (0-100)0 to 10033.8
unique_opensintegerNumber of unique recipients who opened the email0 or more · optional1100
open_time_peak_hourintegerHour of the day (0-23) when most opens occurred0 to 23 · optional10
bounce_countintegerNumber of emails that bounced (failed to deliver)0 or more · optional25
unsubscribe_countintegerNumber of recipients who unsubscribed after this campaign0 or more · optional8
Dates and times 2 columns
send_datedateDate when the email campaign was sent2024-04-01
created_atdatetimeTimestamp when this log entry was created2024-04-01T09:02:14

Use it for

  • median open ra…38.370 rowsmean open rate by ope…42.8mobile41.4desktop45.2tablet

    A marketing dashboard

    Open_rate by open_device_type. Excel, Power BI or Tableau.

  • What pattern can you find in 70 rows?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 70 rows.

  • A software demo

    Believable campaigns with campaign_name, send_date and send_time to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 15 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset70 rows15 columns
Yours1,000 rows15 columns

blueprint · email-campaign-open-rate-logs

Behind this dataset

Same schema. As many rows as you need.

These 70 rows came out of a blueprint — 15 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Record send date/time and open timestamp
  • Include recipient segment information
  • Campaigns must have unique IDs
  • Calculate open rate per campaign
  • Flag emails with open rate <10% for review
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
email-campaign-open-rate-logs

More in Marketing

Browse all
Also in MarketingA/B Testing Results DatasetOnline Ad Performance MetricsDigital Ad Campaign Reach MetricsAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.