Skip to content

campaign_audience

The households selected for each email campaign, including the group deliberately not sent it. One row is one household in one campaign.

One row is
one household in one campaign
Columns
6
Rows in Sample
29,722
Rows in Standard
299,133
Rows in Full
2,991,726

Columns

ColumnTypeWhat it holdsValues or range
campaign_idkeyintegerLinks to campaigns.
household_idkeyintegerThe travelling party's account. Links to households.
assignmenttextTreatment was sent the email. Holdout was selected at random to receive nothing, as a comparison group.holdout; treatment
sent_atdate and timeWhen the email went out. Empty for the holdout. Can be empty.2018-01-10 09:00 to 2025-09-05 12:00
openedtrue/falseTrue when the email was opened.
clickedtrue/falseTrue when a link in it was clicked.

How it connects

First five rows

Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.

campaign_idhousehold_idassignmentsent_atopenedclicked
90051000507treatment2018-01-10 09:01:06truetrue
90051001107treatment2018-01-10 09:08:25falsefalse
90051001307treatment2018-01-10 11:52:37falsefalse
90051001907treatment2018-01-10 10:13:58truefalse
90051002107treatment2018-01-10 10:31:42falsefalse

Download from Kaggle