Here is a quick 3-step process for querying Facebook Ads data in Holistics. Facebook Ads reporting in Holistics requires you to connect your Facebook Ads database
Set up your database to allow write access for a given data source.
Please have a look at our docs on how to connect your database to Holistics.
Go to New data source page -> Select Facebook Ads for Database Type.
You will see the below:
So what you need for the connection are Access Token and Ad Account ID.
Please login to the facebook account that manages the data you want to explore.
Then go to your Ad Account Setup
You will find your Ad Account ID as in the image:
Create a new facebook app if you haven't got one: please refer this guide on how to do it.
Holistics is using API v2.11. Please set permitted API version to v2.11 in Settings -> Advanced:
In your app dashboard, add a new product called Marketing API:
Now go to tab Tools under Marketing API. In section Get Access Token, check ads_read, then click Get Token
You will see your generated token. Copy and paste it to field Access Token in your new data source form.
Now that you can click Test Connection and connect to your facebook ads data!
To explore the data, you need to import them into a database that you can perform direct query.
Go to Data Import listing -> New single import
Select Facebook Ads as the source type and choose your recently connected data source:
You can now see the preview of your data. We currently support 3 tables:
Specify the destination data source, schema name and table name that you would like to import the data into.
Follow the steps below:
1) Choose import mode for this import.
2) Setup destination columns' name and type
3) You can add a new schedule for current data import. Optionally, data import can be executed manually after created.
4) Once you Validated Sync Config, you can submit by clicking Save or Save and Execute to run the data import now.
Once a data import has been executed, either manually or based on its schedule, a new job corresponding to the import job will be created to track its progress.
You can see the job's status by clicking value in column
Here are details of our supported tables.