Start by exporting your data from Mailchimp. Log in to your Mailchimp account, navigate to the Reports section, and select the specific campaign or list you want to export. Click on the "Export" button, and choose the format you prefer (CSV is recommended for easy compatibility). Download the exported file to your local machine.

Ensure that DuckDB is installed on your local machine. You can download it from the official DuckDB website and follow the installation instructions for your operating system. Ensure you have a Python environment set up if you plan to use the DuckDB Python API for loading data.

Open the exported CSV file using a text editor or spreadsheet software. Inspect the data for any inconsistencies or errors. Clean the data by removing any unnecessary columns, correcting data types, and ensuring there are no corrupt entries. Save the cleaned data as a new CSV file.

Open your terminal or command prompt. Create a new DuckDB database by executing the command `duckdb my_database.duckdb`. Replace `my_database.duckdb` with your desired database name. This command initializes a new database file where you will load your data.

Launch the DuckDB shell by typing `duckdb` in your terminal. Use the SQL `CREATE TABLE` statement to define a table schema that matches the structure of your cleaned CSV data. For example:

```sql
CREATE TABLE campaign_data (
id INTEGER,
email VARCHAR,
campaign_name VARCHAR,
open_rate FLOAT,
click_rate FLOAT
);
```

Adjust the column names and types to match your CSV data.

Use the `COPY` command within the DuckDB shell to load your CSV data into the newly created table. Make sure your terminal is in the directory where your CSV file is located:

```sql
COPY campaign_data FROM 'cleaned_mailchimp_data.csv' (HEADER, DELIMITER ',');
```

Replace `'cleaned_mailchimp_data.csv'` with the name of your cleaned CSV file. This command reads the CSV file and inserts the data into the specified table.

Run a few simple queries in the DuckDB shell to ensure that the data has been loaded correctly. For instance, use:

```sql
SELECT * FROM campaign_data LIMIT 10;
```

This query displays the first ten rows of the table. Check for correct data types and any potential loading issues. Once verified, your data is successfully moved from Mailchimp to DuckDB.

---

By following these steps, you can efficiently transfer data from Mailchimp to DuckDB without the need for third-party connectors or integrations.