ETL Facebook Ads data to SQL Server

Facebook Ads is a popular advertising platform for running campaigns on Facebook.

Renta integrates your Facebook Ads data to SQL Server in 4 clicks. You’re free from writing ETL scripts and can get straight to analytics in your BI-tools.

Simple integration configuration

The integration configuration requires the following steps:

  1. Select Facebook Ads from the list of integrations
  2. Fill in your Facebook Ads account
  3. Specify the data for export
  4. Select your data warehouse

This is it. Transferring your Facebook Ads info to SQL Server is that easy with Renta.

Data structure of the Facebook Ads API

Renta supports the standard method of exporting statistics from an advertising account, including data from Business Manager.

Below are some supported report types.

Statistics report

Main report type. Contains data about the costs of an advertising campaign.

ads_read
Campaign report

Retrieves status and settings of ad campaigns.

Insights
Ads report

Retrieves status and settings of ad.

сampaign