Documentation and SupportV5 User Manual Creating Tables Using ConnectorsHow do I create a table using an Adobe Data Warehouse Extract Connector?

How do I create a table using an Adobe Data Warehouse Extract Connector?

If you have already created a table, the Table(s) icon will be available.

Navigate to the Table(s) Tools.

2. Click the 'Add New' bubble.

Click the 'Add New' bubble.

3. If this is your first table, you must navigate to the System Tools.

If this is your first table, you must navigate to the System Tools.
Navigate to the Table System Tools.

5. Click the 'Add New' bubble.

6. Create your table(Step 1).

  1. Name of the Table (Max length is 44 characters and can not include a back tick [ ` ])
  2. Enter a description for your table, this can be left blank.
  3. Select the folder where the table will live.
  4. Select From Connection from the table type drop down.
  5. Select Next.
Create your table(Step 1).

7. Create your table (Step 2).

1) Choose the Campaign Classification connector.

2) Choose the Update Frequency.

3) The update time/date.

4) Choose the Granularity: Hourly, Daily, Weekly, Monthly, Quarterly, or Yearly.

5) What time period you wish to get data from, this is either a user entered range or by keywords.

6) Click Next.

Create your table (Step 2).

8. Create your Table (Part 3).

1) Choose which Suite the data will be drawn from.

2) Choose which action when the table reloads.  Append Adobe Campaign Data to the Local Table will append any new data or changes.  Clear Local Campaign Data and Reload will truncate the table before loading the data.

3) Click Next.

Create your Table (Part 3).

9. Create your Table (Part 4).

1) Choose what Segment Selection you wish to use, if any.

2) Choose which Evars you wish to pull.

3) Choose which Props you wish to pull.

4) Click Next.

Create your Table (Part 4).

10. Create your Table (Part 5).

1) Choose which Data Elements you wish to pull.

2) Choose which Standard Items you wish to pull.

3) Click Next.

Create your Table (Part 5).

11. Create your Table (Part 6).

1) Choose the Data Element Ordering.

2) Click Next.

Create your Table (Part 6).

12. Create your Table (Part 7).

1) Choose which Metrics you wish to pull.

2) Choose which Events you wish to pull.

3) Click Next.

Create your Table (Part 7).

13. Create your Table (Part 8).

1) Choose Order Event/Metrics.

2) Click Next.

Create your Table (Part 8).

14. Create your table (Step 9).

Click Save.

Create your table (Step 9).

15. Congratulations, the table was saved!

You will recieve an email when the table is ready for viewing.

Congratulations, the table was saved!