ODBC Driver for Facebook Ads

Build 24.0.9060

Demographic_Region_Report

Ad Report focused on campaigns, broken down by sub-country geographic region. Accessing Ad Report information requires the ads_read permission.

Columns

Name Type Description
Target String The Id of the Account, Campaign, Ad Group, or Ad to get insights for.
DatePreset String An alternative to specifying the DateStart and DateEnd. A date range will automatically be calculated based on the specified preset value.

The allowed values are maximum, today, yesterday, this_week_sun_today, this_week_mon_today, last_week_sun_sat, last_week_mon_sun, last_3d, last_7d, last_14d, last_28d, last_30d, last_90d, this_month, last_month.

DateStart Date The starting date to retrieve insights for. In the Facebook UI, this is the Report Start field. In the Facebook UI, this is the Report Start field.
DateEnd Date The ending date to retrieve insights for. In the Facebook UI, this is the Report End field. In the Facebook UI, this is the Report End field.
TimeIncrement String The number of days of data aggregation. An int (1-90) or one of monthly or all_days. This value splits the range or preset date into smaller increments.

The default value is 1.

Level String The level to represent the results at.

The allowed values are ad, adset, campaign, account.

ActionType String The kind of actions taken on your ad, Page, app or event after your ad was served to someone, even if they didn't click on it.
ActionValue Integer Metric value of default attribution window.
AdAccountId String The Id of the Ad Account associated with the report row.
CampaignId String The Id of the Campaign associated with the report row.
CampaignName String The name of the Campaign associated with the report row.
Reach Integer The number of people who saw your ads at least once.
Impressions Integer The number of times your ads were on screen.
Frequency Double The average number of times each person saw your ad. This value is estimated.
Spend Double The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. What sort of ad object is targeted depends on the Target used for the report.
Cpm Double The average cost for 1,000 impressions.
Cpc Double The average cost for each click (all).
Ctr Double The percentage of times people saw your ad and performed a click (all).
InlineLinkClicks Integer The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties.
InlineLinkClickCtr Integer The percentage of time people saw your ads and performed an inline link click.
CostPerInlineLinkClick Double The average cost of each inline link click.
ActionCollection String The action collection to retrieve. The available values are: Actions, CostPerActionType
Region String The region someone viewed the Ad from. This is a breakdown column and selecting this column will cause results to be further broken down by this metric.
UseAsync Boolean A boolean indicating if an asynchronous call should be used for retrieving the insights.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060