Schema Information for Neon Pixel

Explore the schema details for Neon Pixel, enhancing your understanding of its data structure and usage.

Need help with something?

Talk to data expert

In this article, we will look at the schema information of the supported APIs and tables for Neon Pixel.

Find the links to other articles related to Neon Pixel below:

Tables/APIs Supported

The tables and APIs associated with the Neon Pixel connector are as follows.

CTV_Blended

Purpose: The CTV_Blended endpoint of Neon_Pixel is designed to provide a unified performance view of connected TV (CTV) campaigns, combining impression, visit, and conversion data into a single, queryable report for analysis and optimization. It lets advertisers pull day-level metrics like impressions, visits, conversions, order value, spend, ROAS, frequency, CPM, and related ratios over a chosen date range so they can evaluate and improve CTV campaign effectiveness.

Source API Documentation: NA — the API is private and not exposed publicly.

Replication Type: Key Based

Primary Key: Please choose according to the business need.

Name Data Type
Day DATE
Impressions STRING
Visits STRING
VisitRate STRING
Conversions STRING
OrderValue STRING
ROAS STRING
Spend STRING
ConversionRate STRING
AverageOrderValue STRING
CPA STRING
HouseholdsReached STRING
Frequency STRING
CPM STRING

TV_Network

Purpose: The TV_Network field in the Neon Pixel API identifies the specific television network associated with ad campaign performance data. It enables advertisers and analysts to segment and compare campaign effectiveness across different TV networks. By using this field, users can evaluate metrics such as impressions, conversions, visits, and spend by network, allowing for more precise budget allocation and performance optimization. This capability supports data-driven decisions on which networks deliver the highest return on ad spend (ROAS) and engagement, helping refine media strategies for better audience reach and campaign efficiency.

Source API Documentation: NA — the API is private and not exposed publicly.

Replication Type: Key Based

Primary Key: Please choose according to the business need.

Name Data Type
TVNetwork STRING
AverageOrderValue STRING
ConversionRate STRING
Spend STRING
Visits STRING
Conversions STRING
Impressions STRING
OrderValue STRING
ROAS STRING
VisitRate STRING
HouseholdsReached STRING
CPM STRING

Display_Publisher

Purpose: The Display_Publisher field in the Neon_Pixel API represents the platform, website, or network where a digital advertisement is displayed. It enables advertisers to identify which publishers are delivering impressions, visits, and conversions, allowing detailed performance comparisons across different sources. By using this parameter in data queries, users can analyze key metrics such as spend, impressions, ROAS, conversion rate, and order value for each publisher. This helps advertisers measure the effectiveness of various display channels, optimize budget allocation, and refine their media strategy for maximum campaign impact.

Source API Documentation: NA — the API is private and not exposed publicly.

Replication Type: Key Based

Primary Key: Please choose according to the business need.

Name Data Type
DisplayPublisher STRING
AverageOrderValue STRING
ConversionRate STRING
Spend STRING
Visits STRING
Conversions STRING
Impressions STRING
OrderValue STRING
ROAS STRING
VisitRate STRING
HouseholdsReached STRING

Creative

Purpose: The Creative endpoint in Neon_Pixel provides functionality for retrieving and analyzing creative-level advertising data, enabling marketers to evaluate the effectiveness of individual ad assets. By using API calls (such as via cURL), users can access key performance metrics like impressions, conversions, spend, ROAS, and conversion rate for each creative. This helps advertisers understand which creatives drive engagement and sales, optimize ad performance, and allocate budgets efficiently. The API supports filtering, sorting, and date-based queries, allowing real-time, data-driven insights into campaign and creative performance.

Source API Documentation: NA — the API is private and not exposed publicly.

Replication Type: Key Based

Primary Key: CreativeID

Name Data Type
CreativeID STRING
CreativeName STRING
CreativeThumbnail STRING
MarketingObjectiveName STRING
AverageOrderValue STRING
ConversionRate STRING
Spend STRING
Visits STRING
Conversions STRING
Impressions STRING
OrderValue STRING
ROAS STRING
VisitRate STRING
HouseholdsReached STRING