NewsBreak Report Schema
NewsBreak Report Schema
This article documents the schema for the NewsBreak_Integrated_Report table available through the Daton NewsBreak connector. The table stores advertising performance data across account and campaign hierarchies, including delivery, conversion, event, and return on ad spend (ROAS) metrics.
Table Name |
Description |
|---|---|
NewsBreak_Integrated_Report |
Contains integrated advertising performance data retrieved from the NewsBreak Integrated Report API, including account and campaign hierarchies, delivery metrics, conversion metrics, event metrics, and ROAS metrics. |
Schema Information
The schema below lists each available column, its destination data type, and its meaning. Identifier and dimension fields describe the reporting hierarchy, while metric fields capture delivery, conversion, event, and ROAS performance.
Column |
Data Type |
Description |
|---|---|---|
date |
DATE |
Reporting date. |
hour |
STRING |
Reporting hour. |
adId |
STRING |
Unique identifier of the ad. |
ad |
STRING |
Ad name. |
adSetId |
STRING |
Unique identifier of the ad set. |
adSet |
STRING |
Ad set name. |
campaignId |
STRING |
Unique identifier of the campaign. |
campaign |
STRING |
Campaign name. |
adAccountId |
STRING |
Unique identifier of the ad account. |
adAccount |
STRING |
Ad account name. |
orgId |
STRING |
Unique identifier of the organization. |
organization |
STRING |
Organization name. |
placement |
STRING |
Ad placement. |
cost |
NUMERIC |
Total advertising cost. |
costDecimal |
BIGNUMERIC |
Decimal representation of advertising cost. |
impression |
NUMERIC |
Total impressions. |
click |
NUMERIC |
Total clicks. |
conversion |
NUMERIC |
Total conversions. |
conversionValue |
NUMERIC |
Total conversion value. |
conversionValueDecimal |
NUMERIC |
Decimal representation of the conversion value. |
eventCount |
STRING |
Event count metrics returned for supported conversion events. |
eventValue |
STRING |
Event value metrics returned for supported conversion events. |
eventValueDecimal |
STRING |
Decimal representation of event values. |
eventCpa |
STRING |
Cost per acquisition (CPA) metrics for supported conversion events. |
eventCpaDecimal |
STRING |
Decimal representation of event CPA metrics. |
eventVpa |
STRING |
Value per action (VPA) metrics for supported conversion events. |
eventVpaDecimal |
STRING |
Decimal representation of event VPA metrics. |
eventCvr |
STRING |
Conversion rate (CVR) metrics for supported conversion events. |
cpmDecimal |
BIGNUMERIC |
Decimal representation of cost per thousand impressions (CPM). |
cpcDecimal |
BIGNUMERIC |
Decimal representation of cost per click (CPC). |
cpaDecimal |
NUMERIC |
Decimal representation of cost per acquisition (CPA). |
vpaDecimal |
NUMERIC |
Decimal representation of value per action (VPA). |
roas |
NUMERIC |
Return on ad spend (ROAS). |
completePaymentRoas |
NUMERIC |
ROAS for Complete Payment events. |
saleRoas |
NUMERIC |
ROAS for Sale events. |
appPurchaseRoas |
NUMERIC |
ROAS for App Purchase events. |
appInAppAdImprRoas |
NUMERIC |
ROAS for App In-App Ad Impression events. |
vpa |
NUMERIC |
Value per action (VPA). |
cpm |
NUMERIC |
Cost per thousand impressions (CPM). |
cpc |
NUMERIC |
Cost per click (CPC). |
ctr |
NUMERIC |
Click-through rate (CTR). |
cpa |
NUMERIC |
Cost per acquisition (CPA). |
cvr |
NUMERIC |
Conversion rate (CVR). |
cpcDecimal_nu |
NUMERIC |
System-generated decimal CPC field. |
costDecimal_nu |
NUMERIC |
System-generated decimal cost field. |
cpmDecimal_nu |
NUMERIC |
System-generated decimal CPM field. |
cpaDecimal_bn |
BIGNUMERIC |
System-generated BIGNUMERIC CPA field. |
roas_bn |
BIGNUMERIC |
System-generated BIGNUMERIC ROAS field. |
completePaymentRoas_bn |
BIGNUMERIC |
System-generated BIGNUMERIC Complete Payment ROAS field. |
vpaDecimal_bn |
BIGNUMERIC |
System-generated BIGNUMERIC VPA field. |
During synchronization, Daton maps the NewsBreak Integrated Report API response fields to the corresponding columns in the NewsBreak_Integrated_Report table.
Notes
- The NewsBreak_Integrated_Report table contains advertising performance data across the organization, ad account, campaign, ad set, ad, placement, date, and hour dimensions.
- Standard advertising metrics are stored using numeric data types wherever applicable.
- Event-related columns, including eventCount, eventValue, eventValueDecimal, eventCpa, eventCpaDecimal, eventVpa, eventVpaDecimal, and eventCvr, contain metrics returned for supported NewsBreak conversion events.
- Fields ending in _nu and _bn are generated during data processing to preserve numeric precision and maintain compatibility with supported destination data warehouses. The _nu suffix identifies NUMERIC fields, while _bn identifies BIGNUMERIC fields.