ODBC Driver for Facebook Ads

Build 23.0.8839

Delivery_Platform_And_Device_Report

Ad Report focused on campaigns, broken down by the Meta platform on which it was delivered. 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.

使用できる値は次のとおりです。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.

デフォルト値は1です。

Level String The level to represent the results at.

使用できる値は次のとおりです。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
PublisherPlatform String The platforms the ads were published on.
DevicePlatform String The device or platform used for viewing the ad. This is a breakdown column that may not be selected with other breakdown columns.
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 23.0.8839