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
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| campaign_idkey | integer | Links to campaigns. | |
| household_idkey | integer | The travelling party's account. Links to households. | |
| assignment | text | Treatment was sent the email. Holdout was selected at random to receive nothing, as a comparison group. | holdout; treatment |
| sent_at | date and time | When the email went out. Empty for the holdout. Can be empty. | 2018-01-10 09:00 to 2025-09-05 12:00 |
| opened | true/false | True when the email was opened. | |
| clicked | true/false | True when a link in it was clicked. |
How it connects
This table points to
- campaign_id matches campaigns.campaign_id
- household_id matches households.household_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| campaign_id | household_id | assignment | sent_at | opened | clicked |
|---|---|---|---|---|---|
| 9005 | 1000507 | treatment | 2018-01-10 09:01:06 | true | true |
| 9005 | 1001107 | treatment | 2018-01-10 09:08:25 | false | false |
| 9005 | 1001307 | treatment | 2018-01-10 11:52:37 | false | false |
| 9005 | 1001907 | treatment | 2018-01-10 10:13:58 | true | false |
| 9005 | 1002107 | treatment | 2018-01-10 10:31:42 | false | false |