---
title: Data Ingestion
slug: us-bank-ajo-oc-lab-april26/data-ingestion
docTags: 
createdAt: 2025-10-15T22:56:33.959Z
---

![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/DW1m7zskI0oXtHNcGXpQY-20251205-161239.png)

::::ExpandableHeading{isOpen="true"}
## Lab Material

You can either download the file or copy the contents and save it in a note pad (notepad++, notes, textEdit, etc) with the extension .csv.

::File{src="https://api.archbee.com/api/presign/1Jp0iolWv35Z_mkI7oUiT/i0iwNYGlKF-WNZORQexPH-20260407-141835.csv" label="CAMPAIGN_MEMBERSHIP_FILE.csv"}

:::CodeblockTabs
csv

```none
CustomerID,CampaignID,Channel,Date,LastModified
C0001,BUSINESS_CHECKING_OFFER,EMAIL,2025-10-15,2026-04-15T00:00:00Z
C0001,OTHER_CAMPAIGN_X,EMAIL,2026-03-01,2026-04-15T00:00:00Z
C0002,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2025-11-01,2026-04-15T00:00:00Z
C0003,BUSINESS_CHECKING_OFFER,MOBILE,2025-12-10,2026-04-15T00:00:00Z
C0004,BUSINESS_CHECKING_OFFER,EMAIL,2026-01-15,2026-04-15T00:00:00Z
C0005,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2026-02-20,2026-04-15T00:00:00Z
C0005,OTHER_CAMPAIGN_X,EMAIL,2026-03-01,2026-04-15T00:00:00Z
C0006,BUSINESS_CHECKING_OFFER,MOBILE,2026-04-15,2026-04-15T00:00:00Z
C0007,BUSINESS_CHECKING_OFFER,EMAIL,2025-10-15,2026-04-15T00:00:00Z
C0008,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2025-11-01,2026-04-15T00:00:00Z
C0009,BUSINESS_CHECKING_OFFER,MOBILE,2025-12-10,2026-04-15T00:00:00Z
C0009,OTHER_CAMPAIGN_X,EMAIL,2026-03-01,2026-04-15T00:00:00Z
C0010,BUSINESS_CHECKING_OFFER,EMAIL,2026-01-15,2026-04-15T00:00:00Z
C0011,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2026-02-20,2026-04-15T00:00:00Z
C0012,BUSINESS_CHECKING_OFFER,MOBILE,2026-04-15,2026-04-15T00:00:00Z
C0013,BUSINESS_CHECKING_OFFER,EMAIL,2025-10-15,2026-04-15T00:00:00Z
C0013,OTHER_CAMPAIGN_X,EMAIL,2026-03-01,2026-04-15T00:00:00Z
C0014,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2025-11-01,2026-04-15T00:00:00Z
C0015,BUSINESS_CHECKING_OFFER,MOBILE,2025-12-10,2026-04-15T00:00:00Z
C0016,BUSINESS_CHECKING_OFFER,EMAIL,2026-01-15,2026-04-15T00:00:00Z
C0017,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2026-02-20,2026-04-15T00:00:00Z
C0017,OTHER_CAMPAIGN_X,EMAIL,2026-03-01,2026-04-15T00:00:00Z
C0018,BUSINESS_CHECKING_OFFER,MOBILE,2026-04-15,2026-04-15T00:00:00Z
C0019,BUSINESS_CHECKING_OFFER,EMAIL,2025-10-15,2026-04-15T00:00:00Z
C0020,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2025-11-01,2026-04-15T00:00:00Z
C0051,BUSINESS_CHECKING_OFFER,MOBILE,2025-12-10,2026-04-15T00:00:00Z
C0051,OTHER_CAMPAIGN_X,EMAIL,2026-03-01,2026-04-15T00:00:00Z
C0052,BUSINESS_CHECKING_OFFER,EMAIL,2026-01-15,2026-04-15T00:00:00Z
C0053,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2026-02-20,2026-04-15T00:00:00Z
C0054,BUSINESS_CHECKING_OFFER,MOBILE,2026-04-15,2026-04-15T00:00:00Z
C0055,BUSINESS_CHECKING_OFFER,EMAIL,2025-10-15,2026-04-15T00:00:00Z
C0055,OTHER_CAMPAIGN_X,EMAIL,2026-03-01,2026-04-15T00:00:00Z
C0056,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2025-11-01,2026-04-15T00:00:00Z
C0057,BUSINESS_CHECKING_OFFER,MOBILE,2025-12-10,2026-04-15T00:00:00Z
C0058,BUSINESS_CHECKING_OFFER,EMAIL,2026-01-15,2026-04-15T00:00:00Z
C0059,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2026-02-20,2026-04-15T00:00:00Z
C0059,OTHER_CAMPAIGN_X,EMAIL,2026-03-01,2026-04-15T00:00:00Z
C0060,BUSINESS_CHECKING_OFFER,MOBILE,2026-04-15,2026-04-15T00:00:00Z
C0061,BUSINESS_CHECKING_OFFER,EMAIL,2025-10-15,2026-04-15T00:00:00Z
C0062,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2025-11-01,2026-04-15T00:00:00Z
C0063,BUSINESS_CHECKING_OFFER,MOBILE,2025-12-10,2026-04-15T00:00:00Z
C0063,OTHER_CAMPAIGN_X,EMAIL,2026-03-01,2026-04-15T00:00:00Z
C0064,BUSINESS_CHECKING_OFFER,EMAIL,2026-01-15,2026-04-15T00:00:00Z
C0065,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2026-02-20,2026-04-15T00:00:00Z
C0066,BUSINESS_CHECKING_OFFER,MOBILE,2026-04-15,2026-04-15T00:00:00Z
C0067,BUSINESS_CHECKING_OFFER,EMAIL,2025-10-15,2026-04-15T00:00:00Z
C0067,OTHER_CAMPAIGN_X,EMAIL,2026-03-01,2026-04-15T00:00:00Z
C0068,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2025-11-01,2026-04-15T00:00:00Z
C0069,BUSINESS_CHECKING_OFFER,MOBILE,2025-12-10,2026-04-15T00:00:00Z
C0070,BUSINESS_CHECKING_OFFER,EMAIL,2026-01-15,2026-04-15T00:00:00Z
C0101,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2026-02-20,2026-04-15T00:00:00Z
C0101,OTHER_CAMPAIGN_X,EMAIL,2026-03-01,2026-04-15T00:00:00Z
C0102,BUSINESS_CHECKING_OFFER,MOBILE,2026-04-15,2026-04-15T00:00:00Z
C0103,BUSINESS_CHECKING_OFFER,EMAIL,2025-10-15,2026-04-15T00:00:00Z
C0104,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2025-11-01,2026-04-15T00:00:00Z
C0105,BUSINESS_CHECKING_OFFER,MOBILE,2025-12-10,2026-04-15T00:00:00Z
C0105,OTHER_CAMPAIGN_X,EMAIL,2026-03-01,2026-04-15T00:00:00Z
C0106,BUSINESS_CHECKING_OFFER,EMAIL,2026-01-15,2026-04-15T00:00:00Z
C0107,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2026-02-20,2026-04-15T00:00:00Z
C0108,BUSINESS_CHECKING_OFFER,MOBILE,2026-04-15,2026-04-15T00:00:00Z
C0109,BUSINESS_CHECKING_OFFER,EMAIL,2025-10-15,2026-04-15T00:00:00Z
C0109,OTHER_CAMPAIGN_X,EMAIL,2026-03-01,2026-04-15T00:00:00Z
C0110,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2025-11-01,2026-04-15T00:00:00Z
C0111,BUSINESS_CHECKING_OFFER,MOBILE,2025-12-10,2026-04-15T00:00:00Z
C0112,BUSINESS_CHECKING_OFFER,EMAIL,2026-01-15,2026-04-15T00:00:00Z
C0113,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2026-02-20,2026-04-15T00:00:00Z
C0113,OTHER_CAMPAIGN_X,EMAIL,2026-03-01,2026-04-15T00:00:00Z
C0114,BUSINESS_CHECKING_OFFER,MOBILE,2026-04-15,2026-04-15T00:00:00Z
C0115,BUSINESS_CHECKING_OFFER,EMAIL,2025-10-15,2026-04-15T00:00:00Z
C0116,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2025-11-01,2026-04-15T00:00:00Z
C0117,BUSINESS_CHECKING_OFFER,MOBILE,2025-12-10,2026-04-15T00:00:00Z
C0117,OTHER_CAMPAIGN_X,EMAIL,2026-03-01,2026-04-15T00:00:00Z
C0118,BUSINESS_CHECKING_OFFER,EMAIL,2026-01-15,2026-04-15T00:00:00Z
C0119,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2026-02-20,2026-04-15T00:00:00Z
C0120,BUSINESS_CHECKING_OFFER,MOBILE,2026-04-15,2026-04-15T00:00:00Z
C0021,BUSINESS_CHECKING_OFFER,EMAIL,2025-04-01,2026-04-15T00:00:00Z
C0021,OTHER_CAMPAIGN_RETENTION,MOBILE,2026-02-01,2026-04-15T00:00:00Z
C0026,BUSINESS_CHECKING_OFFER,EMAIL,2025-04-01,2026-04-15T00:00:00Z
C0028,OTHER_CAMPAIGN_RETENTION,MOBILE,2026-02-01,2026-04-15T00:00:00Z
C0031,BUSINESS_CHECKING_OFFER,EMAIL,2025-04-01,2026-04-15T00:00:00Z
C0035,OTHER_CAMPAIGN_RETENTION,MOBILE,2026-02-01,2026-04-15T00:00:00Z
C0036,BUSINESS_CHECKING_OFFER,EMAIL,2025-04-01,2026-04-15T00:00:00Z
C0041,BUSINESS_CHECKING_OFFER,EMAIL,2025-04-01,2026-04-15T00:00:00Z
C0042,OTHER_CAMPAIGN_RETENTION,MOBILE,2026-02-01,2026-04-15T00:00:00Z
C0046,BUSINESS_CHECKING_OFFER,EMAIL,2025-04-01,2026-04-15T00:00:00Z
C0049,OTHER_CAMPAIGN_RETENTION,MOBILE,2026-02-01,2026-04-15T00:00:00Z
C0071,BUSINESS_CHECKING_OFFER,EMAIL,2025-04-01,2026-04-15T00:00:00Z
C0076,BUSINESS_CHECKING_OFFER,EMAIL,2025-04-01,2026-04-15T00:00:00Z
C0076,OTHER_CAMPAIGN_RETENTION,MOBILE,2026-02-01,2026-04-15T00:00:00Z
C0081,BUSINESS_CHECKING_OFFER,EMAIL,2025-04-01,2026-04-15T00:00:00Z
C0083,OTHER_CAMPAIGN_RETENTION,MOBILE,2026-02-01,2026-04-15T00:00:00Z
C0086,BUSINESS_CHECKING_OFFER,EMAIL,2025-04-01,2026-04-15T00:00:00Z
C0090,OTHER_CAMPAIGN_RETENTION,MOBILE,2026-02-01,2026-04-15T00:00:00Z
C0091,BUSINESS_CHECKING_OFFER,EMAIL,2025-04-01,2026-04-15T00:00:00Z
C0096,BUSINESS_CHECKING_OFFER,EMAIL,2025-04-01,2026-04-15T00:00:00Z
C0097,OTHER_CAMPAIGN_RETENTION,MOBILE,2026-02-01,2026-04-15T00:00:00Z
C0121,BUSINESS_CHECKING_OFFER,EMAIL,2025-04-01,2026-04-15T00:00:00Z
C0124,OTHER_CAMPAIGN_RETENTION,MOBILE,2026-02-01,2026-04-15T00:00:00Z
C0126,BUSINESS_CHECKING_OFFER,EMAIL,2025-04-01,2026-04-15T00:00:00Z
C0131,BUSINESS_CHECKING_OFFER,EMAIL,2025-04-01,2026-04-15T00:00:00Z
C0131,OTHER_CAMPAIGN_RETENTION,MOBILE,2026-02-01,2026-04-15T00:00:00Z
C0136,BUSINESS_CHECKING_OFFER,EMAIL,2025-04-01,2026-04-15T00:00:00Z
C0138,OTHER_CAMPAIGN_RETENTION,MOBILE,2026-02-01,2026-04-15T00:00:00Z
C0141,BUSINESS_CHECKING_OFFER,EMAIL,2025-04-01,2026-04-15T00:00:00Z
C0145,OTHER_CAMPAIGN_RETENTION,MOBILE,2026-02-01,2026-04-15T00:00:00Z
C0146,BUSINESS_CHECKING_OFFER,EMAIL,2025-04-01,2026-04-15T00:00:00Z
C0154,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0165,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0176,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0187,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0198,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0209,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0220,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0231,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0242,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0253,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0264,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0275,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0286,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0297,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0306,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2024-06-01,2026-04-15T00:00:00Z
C0308,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0319,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0323,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2024-06-01,2026-04-15T00:00:00Z
C0330,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0340,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2024-06-01,2026-04-15T00:00:00Z
C0341,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0352,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0357,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2024-06-01,2026-04-15T00:00:00Z
C0363,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0374,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0374,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2024-06-01,2026-04-15T00:00:00Z
C0385,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0391,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2024-06-01,2026-04-15T00:00:00Z
C0396,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0407,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0408,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2024-06-01,2026-04-15T00:00:00Z
C0418,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0425,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2024-06-01,2026-04-15T00:00:00Z
C0429,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0440,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0442,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2024-06-01,2026-04-15T00:00:00Z
C0451,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0459,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2024-06-01,2026-04-15T00:00:00Z
C0462,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0473,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0476,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2024-06-01,2026-04-15T00:00:00Z
C0484,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0493,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2024-06-01,2026-04-15T00:00:00Z
C0495,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0506,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0510,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2024-06-01,2026-04-15T00:00:00Z
C0517,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0527,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2024-06-01,2026-04-15T00:00:00Z
C0528,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0539,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0544,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2024-06-01,2026-04-15T00:00:00Z
C0550,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0561,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0561,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2024-06-01,2026-04-15T00:00:00Z
C0572,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0578,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2024-06-01,2026-04-15T00:00:00Z
C0583,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0594,OTHER_CAMPAIGN_X,EMAIL,2025-08-01,2026-04-15T00:00:00Z
C0595,BUSINESS_CHECKING_OFFER,DIRECT_MAIL,2024-06-01,2026-04-15T00:00:00Z

```
:::
::::

:::ExpandableHeading{isOpen="true"}
## Exercise

### Configure a Data Flow

- Go to **Sources** under **Catalog** from the **Navigation**.
- In the catalog: Search for **Local File Upload**
- Click **Add Data**
- Click the **toggle under Change data Capture**
- Select the **dataset** you created under your initials
- Click Next
- Drag and Drop **your csv** file. Click Next. Click Finish.
:::

