Facebook Ads
Facebook Ads is the advertising platform of the social network Facebook. You can use Facebook Ads as a data source when landing or replicating data.
You can leave all custom report fields empty to use pre-built reports. Fill in the custom report fields, levels, and breakdowns fields to use user-defined reports.
-
For more information about connecting to SaaS applications, see Verbinding maken met SaaS-applicaties.
-
Gegevensgateway - Gegevensverplaatsing must be installed to land or replicate data from SaaS applications. For more information, see Qlik Gegevensgateway - Gegevensverplaatsing.
Supported update methods
-
Change data capture (CDC)
Landing or replication starts with a full load. The data is then kept up-to-date using incremental loading based on date fields.
- Reload and compare
This extracts the entire data set from the source and reloads it to your target. You can schedule periodic reloads to keep the data up-to-date.
For more information, see Verwerken wijzigen.
Preparing for authentication
To access your Facebook Ads data, you need to authenticate the connection with your account credentials.
Create an app
-
Go to https://developers.facebook.com/apps/.
-
Click Create an app, click Manage Business Integrations, and click Continue.
-
Set App Display Name to Qlik.
-
Set the app purpose appropriately for your use case.
-
Set Do you have a Business Manager account to the business manager account that you want to use.
-
Click Create App.
Generate an access token:
-
Go to https://developers.facebook.com/tools/explorer.
-
Set Facebook App to Qlik.
-
Click Generate Access Token.
-
Click Add a Permission, then click Events Groups Pages and select ads_read.
-
Click Generate Access Token and follow the instructions to authorize the app.
Get App ID and App Secret
-
Go to Marketing API and click Set Up.
-
On the top left of the screen under Dashboard, click Settings.
-
Click Basic.
Creating the connection
- Fill in the required connection properties.
-
Provide a name for the connection in Connection name.
-
Select Open connection metadata to define metadata for the connection when it has been created.
-
Click Create.
| Setting | Description |
|---|---|
| Gateway |
Select a Gateway voor gegevensverplaatsing to use when replicating data. |
| Access Token |
The access token you have generated for your app. |
| App ID |
The ID of your Qlik app on Facebook. |
| Ad Account ID | To get your Ad Account ID, go to Find your Facebook ad account ID number and follow the instructios. |
| App Secret | The secret associated with your Qlik app on Facebook. |
| Start Date | Start date for the reporting period you require in format YYYY-MM-DD. |
| Custom Report One Fields |
Fields for custom report one. You can use fields listed in Parameters and Fields. InformatieThis field is optional, leave it empty to use pre-defined reports.
|
| Custom Report One Levels |
Levels for custom report one. The following levels are possible to use: ad, adset, campaign, account InformatieThis field is optional, leave it empty to use pre-defined reports.
|
| Custom Report One Breakdowns |
Breakdowns for custom report one. The following breakdowns are possible to use: ad_format_asset, age, app_id, body_asset, call_to_action_asset, coarse_conversion_value, country, description_asset, fidelity_type, gender, hsid, image_asset, impression_device, is_conversion_id_modeled, link_url_asset, postback_sequence_index, product_id, redownload, region, skan_campaign_id, skan_conversion_id, skan_version, title_asset, video_asset, dma, frequency_value, hourly_stats_aggregated_by_advertiser_time_zone, hourly_stats_aggregated_by_audience_time_zone, mmm, place_page_id, publisher_platform, platform_position, device_platform, standard_event_content_type, marketing_messages_btn_name InformatieThis field is optional, leave it empty to use pre-defined reports.
|
| Custom Report Two Fields |
Fields for custom report two. You can use fields listed in Parameters and Fields. InformatieThis field is optional, leave it empty to use pre-defined reports.
|
| Custom Report Two Levels |
Levels for custom report two. The following levels are possible to use: ad, adset, campaign, account InformatieThis field is optional, leave it empty to use pre-defined reports.
|
| Custom Report Two Breakdowns |
Breakdowns for custom report two. The following breakdowns are possible to use: ad_format_asset, age, app_id, body_asset, call_to_action_asset, coarse_conversion_value, country, description_asset, fidelity_type, gender, hsid, image_asset, impression_device, is_conversion_id_modeled, link_url_asset, postback_sequence_index, product_id, redownload, region, skan_campaign_id, skan_conversion_id, skan_version, title_asset, video_asset, dma, frequency_value, hourly_stats_aggregated_by_advertiser_time_zone, hourly_stats_aggregated_by_audience_time_zone, mmm, place_page_id, publisher_platform, platform_position, device_platform, standard_event_content_type, marketing_messages_btn_name InformatieThis field is optional, leave it empty to use pre-defined reports.
|
| Custom Report Three Fields |
Fields for custom report three. You can use fields listed in Parameters and Fields. InformatieThis field is optional, leave it empty to use pre-defined reports.
|
| Custom Report Three Levels |
Levels for custom report three. The following levels are possible to use: ad, adset, campaign, account InformatieThis field is optional, leave it empty to use pre-defined reports.
|
| Custom Report Three Breakdowns |
Breakdowns for custom report three. The following breakdowns are possible to use: ad_format_asset, age, app_id, body_asset, call_to_action_asset, coarse_conversion_value, country, description_asset, fidelity_type, gender, hsid, image_asset, impression_device, is_conversion_id_modeled, link_url_asset, postback_sequence_index, product_id, redownload, region, skan_campaign_id, skan_conversion_id, skan_version, title_asset, video_asset, dma, frequency_value, hourly_stats_aggregated_by_advertiser_time_zone, hourly_stats_aggregated_by_audience_time_zone, mmm, place_page_id, publisher_platform, platform_position, device_platform, standard_event_content_type, marketing_messages_btn_name InformatieThis field is optional, leave it empty to use pre-defined reports.
|
| Custom Report Four Fields |
Fields for custom report four. You can use fields listed in Parameters and Fields. InformatieThis field is optional, leave it empty to use pre-defined reports.
|
| Custom Report Four Levels |
Levels for custom report four. The following levels are possible to use: ad, adset, campaign, account InformatieThis field is optional, leave it empty to use pre-defined reports.
|
| Custom Report Four Breakdowns |
Breakdowns for custom report four. The following breakdowns are possible to use: ad_format_asset, age, app_id, body_asset, call_to_action_asset, coarse_conversion_value, country, description_asset, fidelity_type, gender, hsid, image_asset, impression_device, is_conversion_id_modeled, link_url_asset, postback_sequence_index, product_id, redownload, region, skan_campaign_id, skan_conversion_id, skan_version, title_asset, video_asset, dma, frequency_value, hourly_stats_aggregated_by_advertiser_time_zone, hourly_stats_aggregated_by_audience_time_zone, mmm, place_page_id, publisher_platform, platform_position, device_platform, standard_event_content_type, marketing_messages_btn_name InformatieThis field is optional, leave it empty to use pre-defined reports.
|
| Custom Report Five Fields |
Fields for custom report five. You can use fields listed in Parameters and Fields. InformatieThis field is optional, leave it empty to use pre-defined reports.
|
| Custom Report Five Levels |
Levels for custom report five. The following levels are possible to use: ad, adset, campaign, account InformatieThis field is optional, leave it empty to use pre-defined reports.
|
| Custom Report Five Breakdowns |
Breakdowns for custom report five. The following breakdowns are possible to use: ad_format_asset, age, app_id, body_asset, call_to_action_asset, coarse_conversion_value, country, description_asset, fidelity_type, gender, hsid, image_asset, impression_device, is_conversion_id_modeled, link_url_asset, postback_sequence_index, product_id, redownload, region, skan_campaign_id, skan_conversion_id, skan_version, title_asset, video_asset, dma, frequency_value, hourly_stats_aggregated_by_advertiser_time_zone, hourly_stats_aggregated_by_audience_time_zone, mmm, place_page_id, publisher_platform, platform_position, device_platform, standard_event_content_type, marketing_messages_btn_name InformatieThis field is optional, leave it empty to use pre-defined reports.
|