Facebook Ads is an advertising platform developed by Facebook, a paid ad system for businesses to connect with users which helps in targeted advertising to the exact target audience.
Sprinkle now supports Facebook Ads as a data source. So, if you are running multiple campaigns across Facebook Ads, Sprinkle serves as a single source of truth for all the campaigns. In order to add Facebook Ads as a Data Source, the user can click on Data Sources and then on the ‘+’ sign. Upon clicking on the ‘+’ sign a list of data sources appears. The user needs to select Facebook Ads in this case and name the data source.
To create a connection, the user needs to provide an App ID, App Secret and Access Token to update the connection. Access tokens needs to be provided every 60 days as the old ones expire in the given interval.
In the home page of facebook developer account click on “Basic Settings“ on the left side tab. Copy the App Id and App Secret information and paste it over the respective fields.
Click on “Tools” and “Graph API Explorer” to generate Access token.
Next, in the datasets tab, users need to name and select the report type from the drop down list that needs to be ingested. The reports require fields to be selected.
Insight reports have optionally breakdown fields that can be selected. For insights reports, “Start date” field needs to be filled i.e. the start date from which the data needs to be pulled. The “window for backfill” field is where the metrics are backfilled in every run to include updates from the attribution window, it can take values like 1, 7 or 28.
In the Ingestion Jobs tab, the concurrency (number of tables that can run in parallel, a maximum of 7) can be set preferentially before running the job. The status of the job will be updated in the tab below once it’s complete. The jobs can also be set to run automatically by enabling autorun. Frequency can be changed by clicking on More --> Autorun-->Change Frequency.