# Mailchimp ## Pipeline Concepts Before setting up the Pipeline, learn about Pipeline concepts [here](https://docs.sprinkledata.com/product/ingesting-your-data/pipelines) ## Step by Step Guide ### STEP-1: Configure Connection To learn about Connection, refer [here](https://docs.sprinkledata.com/product/ingesting-your-data/pipelines) * Log into Sprinkle application * Navigate to Ingest -> Connections Tab -> New Connection -> * Select Mailchimp * Provide all the mandatory details * *Name*: Name to identify this connection * Connect to Mailchimp * Test Connection * Create ### STEP-2: Configure Pipeline To learn about Pipeline, refer [here](https://docs.sprinkledata.com/product/ingesting-your-data/pipelines) * Navigate to Ingest -> Pipeline Tab -> Add -> * Select Mailchimp * Provide the name -> Create * **Connection Tab**: * From the drop-down, select the name of connection created in STEP-2 * Update ### STEP-3: Create Dataset **Datasets Tab**: To learn about Dataset, refer [here](https://docs.sprinkledata.com/product/ingesting-your-data/pipelines). Add Dataset for each report/dataset that you want to integrate, providing following details * *Report Type* (Required): * *Automation*: * *Sub-Reports: Select from drop-down* * *Campaigns* * *Conversations* * *Landing\_Pages* * *Reports* * *Sub-Reports: Select from drop-down* * *Lists* * *Members* * *Segments* * *Destination Schema* (Required) : Data warehouse schema where the table will be ingested into * *Destination Table name* (Required) : It is the table name to be created on the warehouse. If not given, sprinkle will create like ds\_\\_\ * *Destination Create Table Clause*: Provide additional clauses to warehouse-create table queries such as clustering, partitioning, and more, useful for optimizing DML statements. [Learn more](https://docs.sprinkledata.com/product/ingesting-your-data/pipelines/databases/features/destination-create-table-clause) on how to use this field. * Create ### STEP-4: Run and schedule Ingestion In the **Ingestion Jobs** tab**:** * Trigger the Job, using Run button * To schedule, enable Auto-Run. Change the frequency if needed ### Data Feilds All the datasets can have following fields.
Campaigns * id * web\_id * type * create\_time * archive\_url * long\_archive\_url * status * emails\_sent * send\_time * content\_type * needs\_block\_refresh * resendable * recipients\_list\_id * recipients\_list\_is\_active * recipients\_list\_name * recipients\_segment\_text * recipients\_recipient\_count * settings\_subject\_line * settings\_title * settings\_from\_name * settings\_reply\_to * settings\_use\_conversation * settings\_to\_name * settings\_folder\_id * settings\_authenticate * settings\_auto\_footer * settings\_inline\_css * settings\_auto\_tweet * settings\_fb\_comments * settings\_timewarp * settings\_template\_id * settings\_drag\_and\_drop * tracking\_opens * tracking\_html\_clicks * tracking\_text\_clicks * tracking\_goal\_tracking * tracking\_ecomm360 * tracking\_google\_analytics * tracking\_clicktale * delivery\_status\_enabled * report\_summary\_opens * report\_summary\_unique\_opens * report\_summary\_open\_rate * report\_summary\_clicks * report\_summary\_subscriber\_clicks * report\_summary\_click\_rate * report\_summary\_ecommerce\_total\_orders * report\_summary\_ecommerce\_total\_spent * report\_summary\_ecommerce\_total\_revenue * settings\_preview\_text
Connected_Sites * foreign\_id * store\_id * platform * domain * site\_script\_url * site\_script\_fragment * created\_at * updated\_at
Conversations * id * message\_count * campaign\_id * list\_id * unread\_message * from\_label * from\_email * subject * last\_message * \_links
Automation #### Automations * id * create\_time * start\_time * status * emails\_sent * recipients\_list\_id * recipients\_list\_is\_active * recipients\_list\_name * settings\_title * settings\_from\_name * settings\_reply\_to * settings\_use\_conversation * settings\_to\_name * settings\_authenticate * settings\_auto\_footer * settings\_inline\_css * tracking\_opens * tracking\_html\_clicks * tracking\_text\_clicks * tracking\_goal\_tracking * tracking\_ecomm360 * tracking\_google\_analytics * tracking\_clicktale * trigger\_settings\_workflow\_type * trigger\_settings\_workflow\_title * trigger\_settings\_runtime\_days\_0\_ * trigger\_settings\_runtime\_days\_1\_ * trigger\_settings\_runtime\_days\_2\_ * trigger\_settings\_runtime\_days\_3\_ * trigger\_settings\_runtime\_days\_4\_ * trigger\_settings\_runtime\_days\_5\_ * trigger\_settings\_runtime\_days\_6\_ * trigger\_settings\_runtime\_hours\_type * trigger\_settings\_workflow\_emails\_count * report\_summary\_opens * report\_summary\_unique\_opens * report\_summary\_open\_rate * report\_summary\_clicks * report\_summary\_subscriber\_clicks * report\_summary\_click\_rate #### Automation\_Email * id * web\_id * workflow\_id * position * delay\_type * delay\_action * delay\_action\_description * delay\_full\_description * create\_time * start\_time * archive\_url * status * emails\_sent * send\_time * content\_type * needs\_block\_refresh * has\_logo\_merge\_tag * recipients\_list\_id * recipients\_list\_is\_active * recipients\_list\_name * recipients\_segment\_text * recipients\_recipient\_count * settings\_subject\_line * settings\_preview\_text * settings\_title * settings\_from\_name * settings\_reply\_to * settings\_authenticate * settings\_auto\_footer * settings\_inline\_css * settings\_auto\_tweet * settings\_fb\_comments * settings\_template\_id * settings\_drag\_and\_drop * tracking\_opens * tracking\_html\_clicks * tracking\_text\_clicks * tracking\_goal\_tracking * tracking\_ecomm360 * tracking\_google\_analytics * tracking\_clicktale * trigger\_settings\_workflow\_type * trigger\_settings\_workflow\_title * trigger\_settings\_runtime\_days\_0\_ * trigger\_settings\_runtime\_days\_1\_ * trigger\_settings\_runtime\_days\_2\_ * trigger\_settings\_runtime\_days\_3\_ * trigger\_settings\_runtime\_days\_4\_ * trigger\_settings\_runtime\_days\_5\_ * trigger\_settings\_runtime\_days\_6\_ * trigger\_settings\_runtime\_hours\_type * trigger\_settings\_workflow\_emails\_count * report\_summary\_opens * report\_summary\_unique\_opens * report\_summary\_open\_rate * report\_summary\_clicks * report\_summary\_subscriber\_clicks * report\_summary\_click\_rate
Reports #### Campaign\_Reports * id * campaign\_title * type * list\_id * list\_is\_active * list\_name * subject\_line * preview\_text * emails\_sent * abuse\_reports * unsubscribed * send\_time * bounces\_hard\_bounces * bounces\_soft\_bounces * bounces\_syntax\_errors * forwards\_forwards\_count * forwards\_forwards\_opens * opens\_opens\_total * opens\_unique\_opens * opens\_open\_rate * opens\_last\_open * clicks\_clicks\_total * clicks\_unique\_clicks * clicks\_unique\_subscriber\_clicks * clicks\_click\_rate * clicks\_last\_click * facebook\_likes\_recipient\_likes * facebook\_likes\_unique\_likes * facebook\_likes\_facebook\_likes * list\_stats\_sub\_rate * list\_stats\_unsub\_rate * list\_stats\_open\_rate * list\_stats\_click\_rate * timeseries\_0\_\_timestamp * timeseries\_0\_\_emails\_sent * timeseries\_0\_\_unique\_opens * timeseries\_0\_\_recipients\_clicks * timeseries\_1\_\_timestamp * timeseries\_1\_\_emails\_sent * timeseries\_1\_\_unique\_opens * timeseries\_1\_\_recipients\_clicks * timeseries\_2\_\_timestamp * timeseries\_2\_\_emails\_sent * timeseries\_2\_\_unique\_opens * timeseries\_2\_\_recipients\_clicks * timeseries\_3\_\_timestamp * timeseries\_3\_\_emails\_sent * timeseries\_3\_\_unique\_opens * timeseries\_3\_\_recipients\_clicks * timeseries\_4\_\_timestamp * timeseries\_4\_\_emails\_sent * timeseries\_4\_\_unique\_opens * timeseries\_4\_\_recipients\_clicks * timeseries\_5\_\_timestamp * timeseries\_5\_\_emails\_sent * timeseries\_5\_\_unique\_opens * timeseries\_5\_\_recipients\_clicks * timeseries\_6\_\_timestamp * timeseries\_6\_\_emails\_sent * timeseries\_6\_\_unique\_opens * timeseries\_6\_\_recipients\_clicks * timeseries\_7\_\_timestamp * timeseries\_7\_\_emails\_sent * timeseries\_7\_\_unique\_opens * timeseries\_7\_\_recipients\_clicks * timeseries\_8\_\_timestamp * timeseries\_8\_\_emails\_sent * timeseries\_8\_\_unique\_opens * timeseries\_8\_\_recipients\_clicks * timeseries\_9\_\_timestamp * timeseries\_9\_\_emails\_sent * timeseries\_9\_\_unique\_opens * timeseries\_9\_\_recipients\_clicks * timeseries\_10\_\_timestamp * timeseries\_10\_\_emails\_sent * timeseries\_10\_\_unique\_opens * timeseries\_10\_\_recipients\_clicks * timeseries\_11\_\_timestamp * timeseries\_11\_\_emails\_sent * timeseries\_11\_\_unique\_opens * timeseries\_11\_\_recipients\_clicks * timeseries\_12\_\_timestamp * timeseries\_12\_\_emails\_sent * timeseries\_12\_\_unique\_opens * timeseries\_12\_\_recipients\_clicks * timeseries\_13\_\_timestamp * timeseries\_13\_\_emails\_sent * timeseries\_13\_\_unique\_opens * timeseries\_13\_\_recipients\_clicks * timeseries\_14\_\_timestamp * timeseries\_14\_\_emails\_sent * timeseries\_14\_\_unique\_opens * timeseries\_14\_\_recipients\_clicks * timeseries\_15\_\_timestamp * timeseries\_15\_\_emails\_sent * timeseries\_15\_\_unique\_opens * timeseries\_15\_\_recipients\_clicks * timeseries\_16\_\_timestamp * timeseries\_16\_\_emails\_sent * timeseries\_16\_\_unique\_opens #### Click\_Details * id * url * total\_clicks * click\_percentage * unique\_clicks * unique\_click\_percentage * last\_click * campaign\_id #### Email\_Activity * campaign\_id * list\_id * list\_is\_active * email\_id * email\_address * activity\_0\_\_action * activity\_0\_\_timestamp * activity\_0\_\_ip * activity\_1\_\_action * activity\_1\_\_timestamp * activity\_1\_\_ip * activity\_2\_\_action * activity\_2\_\_timestamp * activity\_2\_\_ip * activity\_3\_\_action * activity\_3\_\_timestamp * activity\_3\_\_ip * activity\_4\_\_action * activity\_4\_\_timestamp * activity\_4\_\_ip * activity * activity\_0\_\_type #### Sent\_To * email\_id * email\_address * merge\_fields\_fname * merge\_fields\_lname * merge\_fields\_address\_addr1 * merge\_fields\_address\_addr2 * merge\_fields\_address\_city * merge\_fields\_address\_state * merge\_fields\_address\_zip * merge\_fields\_address\_country * merge\_fields\_phone * merge\_fields\_birthday * vip * status * open\_count * last\_open * absplit\_group * gmt\_offset * campaign\_id * list\_id * list\_is\_active * merge\_fields\_address #### Unsubscribed * email\_id * email\_address * merge\_fields * vip * timestamp * reason * campaign\_id * list\_id * list\_is\_active * \_links
Landing_Pages * id * name * title * description * template\_id * content\_type * status * list\_id * web\_id * created\_by\_source * created\_at * published\_at * unpublished\_at * updated\_at * tracking\_track\_with\_mailchimp * tracking\_enable\_restricted\_data\_processing * url
Lists * id * web\_id * name * contact * permission\_reminder * use\_archive\_bar * campaign\_defaults * notify\_on\_subscribe * notify\_on\_unsubscribe * date\_created * list\_rating * email\_type\_option * subscribe\_url\_short * subscribe\_url\_long * beamer\_address * visibility * double\_optin * double\_optin * marketing\_permissions * modules * stats * \_links
Members * id * email\_address * unique\_email\_id * contact\_id * full\_name * web\_id * email\_type * status * consents\_to\_one\_to\_one\_messaging * merge\_fields\_fname * merge\_fields\_lname * merge\_fields\_address\_addr1 * merge\_fields\_address\_addr2 * merge\_fields\_address\_city * merge\_fields\_address\_state * merge\_fields\_address\_zip * merge\_fields\_address\_country * merge\_fields\_phone * merge\_fields\_birthday * stats\_avg\_open\_rate * stats\_avg\_click\_rate * ip\_signup * timestamp\_signup * ip\_opt * timestamp\_opt * member\_rating * last\_changed * language * vip * email\_client * location\_latitude * location\_longitude * location\_gmtoff * location\_dstoff * location\_country\_code * location\_timezone * location\_region * source * tags\_count * tags * list\_id * tags\_0\_\_id * tags\_0\_\_name * merge\_fields\_address
Segments * id * name * member\_count * type * created\_at * updated\_at * list\_id