Essential attributes, supported tables, reporting dimensions, and metrics

Discover key attributes, tables, reporting dimensions, and metrics for effective data analysis and decision-making.

Need help with something?

Talk to data expert

The NewsBreak connector imports advertising performance data from your NewsBreak Business account into your destination data warehouse. It uses the NewsBreak Integrated Report API to retrieve campaign delivery, conversion, event, and return on ad spend (ROAS) metrics.

Supported Tables

Currently, the NewsBreak connector supports the following table.

Table Description
NewsBreak_Integrated_Report Contains integrated advertising performance data, including account and campaign hierarchy, delivery and conversion metrics, event metrics, and ROAS metrics.

Reporting Dimensions

The connector retrieves advertising performance using the following reporting dimensions:

  • Date  
  • Hour  
  • Organization  
  • Ad Account 
  • Campaign  
  • Ad Set 
  • Ad  
  • Placement  

These dimensions allow campaign performance to be analyzed at different levels of the advertising hierarchy. They correspond to the dimensions requested by Daton when calling the NewsBreak Integrated Report API. 

Performance Metrics

The connector imports the following advertising performance metrics:

  • Cost  
  • Impressions  
  • Clicks  
  • Conversions  
  • Conversion Value 
  • CPM  
  • CPC  
  • CPA  
  • CTR  
  • CVR  
  • VPA  
  • ROAS  
  • Complete Payment ROAS 
  • Sale ROAS 
  • App Purchase ROAS 
  • App In-App Ad Impression ROAS 

These metrics provide insights into advertising spend, delivery, engagement, conversions, and return on advertising investment. 

Event Metrics

The connector supports event-level reporting for the following NewsBreak conversion events:

  • Complete Payment 
  • App Install 
  • App Purchase 
  • Add to Cart 
  • App In-App Ad Impression 

For each supported event, Daton retrieves the following metrics where available:

  • Event Count 
  • Event Value 
  • Event CPA 
  • Event VPA 
  • Event CVR 

Event metrics are stored as structured values in the destination table to preserve the event-specific reporting returned by the NewsBreak API.

Data Synchronization

Daton performs incremental synchronization using the Date dimension. Data is retrieved in daily partitions, allowing efficient synchronization while reducing API load and supporting scheduled incremental updates. 

Source API

The NewsBreak connector retrieves data using the NewsBreak Integrated Report API.

Endpoint

POST https://business.newsbreak.com/business-api/v1/reports/getIntegratedReport

For each synchronization, Daton submits a request containing:

  • Reporting date range 
  • Selected dimensions 
  • Performance metrics 
  • Event metrics 
  • Authentication credentials 

The API response is automatically transformed and loaded into the NewsBreak_Integrated_Report table in the destination data warehouse.