Email Campaign Logs

This dataset provides detailed logs of email marketing campaigns, including send dates, recipient interactions, open/click/bounce rates, and campaign performance metrics. It enables in-depth analysis of campaign effectiveness, audience engagement, and delivery issues, making it valuable for optimizing marketing strategies and improving ROI.

  • opened 15 times
  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Analyzing email campaign effectiveness and audience engagement

Sample rows

preview · 8 of 200 rows · all 16 columns
log_idintegercampaign_statusstringopen_ratefloatopenedbooleancampaign_idintegercampaign_namestringsend_datedatetimerecipient_emailstringrecipient_idintegerclickedbooleanbouncedbooleanclick_through_ratefloatbounce_ratefloattotal_recipientsintegersuccessful_deliveriesintegersubject_linestring
1sent92.5true1001Spring Savings Blast2023-03-16T10:23:00joshua.morgan@claytonmail.com20101truefalse45.127573Save Big This Spring!
2scheduledblankfalse1002Scheduled: April Flash Sale2024-04-11T13:35:00sophia-rose.hughes@targetgroup.org20723falsefalseblankblankblankblankComing Soon: April Flash Sale!
3cancelledblankfalse1003Cancelled: Earth Day Update2023-04-20T15:12:00liam.o'reilly@greenearth.net20555falsefalseblankblank00Earth Day Campaign Cancelled
4draftblankfalse1004Draft: Summer Kickoff2024-06-10T09:08:00maria.garcia@sunshinecorp.com22101falsefalseblankblankblankblankDraft: Summer Kickoff Plans
5sent58.3true1005Black Friday Super Deals2023-11-24T08:49:00alexander.smith@dealszone.co.uk21212falsefalse9.71.220001980Huge Savings This Black Friday!
6sent87true1006Nonprofit: Giving Tuesday2023-11-28T11:00:00olivia.rivers@supportnow.org20888truefalse33.42.26059Join Us for Giving Tuesday
7sent81.2true1007Retention: Welcome Back Offer2023-09-15T14:17:00ethan.lee@retailplus.com23333falsefalse21.81120119We Miss You! Special Offer Inside
8scheduledblankfalse1008Scheduled: Labor Day Deals2024-09-02T12:45:00emma.wilson@holidaymarket.com20202falsefalseblankblankblankblankLabor Day Deals Coming Soon

What the 200 rows show

from the 200-row sample

Sent (campaign status) stands out: 105 of its 118 rows have opened = true, against 0 of 82 for the rest.

  • 53%opened = true
  • 66.1median open_rate
  • 16.6median click_through_rate
  • 2.2median bounce_rate
  • 62median total_recipients
  • 55median successful_deliveries
Opened rate by campaign_statusopened = true
0%50%100%89%sent105 of 1180%scheduled0 of 330%cancelled0 of 190%draft0 of 30
open_rate118 rows, in bands of 10
0204013856159422333opened from 101050100open_rate →

Every row with open_rate of 10 or more has opened = true. None below it.

16 columns by typefrom the column list below
  • string 4
  • integer 5
  • float 3
  • datetime 1
  • boolean 3

Columns

16 columns in four groups
blueprint · 16 columns
columntypedescriptionexample
Text 4 columns
campaign_namestringName of the email campaignup to 255Spring Savings Blast
recipient_emailstringEmail address of the recipientethan.lee@retailplus.com
subject_linestringSubject line of the email campaignup to 255 · optionalSave Big This Spring!
campaign_statusstringCurrent status of the campaign (e.g., sent, scheduled, cancelled)sent · scheduled · cancelled · draftsent
Numbers 8 columns
log_idintegerUnique identifier for each email campaign log entryunique · 1 or more1
campaign_idintegerUnique identifier for the email campaign1 or more1001
recipient_idintegerUnique identifier for the recipient1 or more · optional20101
open_ratefloatPercentage of recipients who opened the email (0-100)0 to 100 · optional92.5
click_through_ratefloatPercentage of recipients who clicked a link in the email (0-100)0 to 100 · optional45.1
bounce_ratefloatPercentage of emails that bounced (0-100)0 to 100 · optional2
total_recipientsintegerTotal number of recipients for the campaign0 or more · optional75
successful_deliveriesintegerNumber of emails successfully delivered0 or more · optional73
Dates and times 1 column
send_datedatetimeDate and time the email campaign was sent2023-03-16T10:23:00
True or false 3 columns
openedbooleanIndicates if the recipient opened the emailtrue
clickedbooleanIndicates if the recipient clicked a link in the emailtrue
bouncedbooleanIndicates if the email bounced for the recipientfalse

Use it for

  • opened53%105 of 200 rowsopened by campaign st…89%sent0%sche…0%canc…0%draft

    A marketing dashboard

    The opened rate and open_rate by campaign_status. Excel, Power BI or Tableau.

  • Why do 105 of 200 rows have opened = true?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable rows with campaign_id, campaign_name and send_date to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 16 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 dataset200 rows16 columns
Yours1,000 rows16 columns

blueprint · email-campaign-logs

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 16 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
  • Campaign ID unique per campaign
  • Send date and time recorded
  • Open rate percentage 0-100
  • Click-through rate calculated from opens
  • Bounce type: hard bounce or soft bounce
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-logs

More in Marketing

Browse all
Also in MarketingMarketing Campaign AI Optimization LogsCampaign Channel Conversion BreakdownAd Spend to Revenue AnalysisAll 1,958 datasets

What should your data show?

Preview 20 rows free
No signup. No card.