How to Load Facebook Insights into your Data Warehouse

Speed and simplicity are at the heart of Rivery and loading data to your warehouse in the cloud from third-party platforms, such as Facebook, is a quick process within the platform. We’ve broken this process down into 10 easy steps below:

Step 1: Go to Data Source to Target and name your new River

Step 2: Select the data source (i.e. Facebook Social) & connect with your credentials

Step 3: Select which of your pages you’d like the data for

Step 4: Choose the page attributes you’d like to bring into your data set

Step 5: Choose which type of data report you’d like to receive (e.g. page insights, post insights, etc.).

Step 6: Pick the metrics and time frame for your data

Step-6

Step 7: Choose your target to define where the data will be shared to (e.g. Snowflake, AWS, Google, Azure).

Step 8: Define which database, schema, and table you want to load your data into – and choose a loading mode (append, upsert, overwrite).

Step 9: Column mapping. You can automate fields, without manually inputting them in your schema. Rivery will detect the fields you selected in your source step.

Step 10: Run River! Click on ‘run’ and that’s it, your river will load the data into your table.

In addition, these steps are very similar for integrations with other sources of data like Facebook.

You can also watch a full video, which takes you through these steps as well.

4 Likes