Documentation and SupportV5 User Manual Creating Tables Using ConnectorsHow do I create a table using a Facebook Connector?

How do I create a table using a Facebook Connector?

1. Navigate to the Table(s) Tools.

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.

4. Navigate to the Table 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 Facebook connector.

2) Choose the Update Frequency.

3) The update time/date.

4) Choose which API to use.

5) Click Next.

Create your table (Step 2).

8. The remaining steps differs depending on the API chosen. These are the Get Page Insights API Steps.

8.1. Create your table (Get Page Insights Step 3).

1) Select which pages you wish to pull from.

2) Select which insights you wish to pull.

3) Select the Date Range.

4) The number of days to pull.

5) Start Date.

6) End Date.

7) Click Save.

Create your table (Get Page Insights Step 3).

9. These are the Create FQL Query steps.

9.1. Create your table (Create FQL Query Step 3).

1) Enter your FQL Query.

2) Click Next.

Create your table (Create FQL Query Step 3).

9.2. Create your table (Create FQL Query Step 4).

1) If your syntax is correct it will show succesful.  If incorrect it will show what is incorrect.

2) Click Save.

Create your table (Create FQL Query Step 4).

10. Congratulations, the table was saved!

The data will be queued and a notification will be sent to you when the import is complete..

Congratulations, the table was saved!