Data reference - Adriel Knowledge Base

Introduction

Basis (formerly Centro) is a programmatic advertising platform from Basis Technologies. The connector pulls daily delivery data from Basis through either a Snowflake data share or an Amazon S3 export, depending on how the Basis account is provisioned. Two report types are supported out of the box: a creative-level report and a line-item-level report. Basis is a schema-flexible source: the fields available in Adriel mirror the columns Basis includes in the share or export. The built-in fields on this page are provided for every generic source; the delivery fields you actually report on come from the columns in your Basis share or export. Reports are normalized and stored in a daily cache, so dashboards read from the cache rather than running live queries against Basis. To connect this data source, see How to connect Basis to Adriel.

Data refresh strategy

Architecture data

Architecture covers the advertiser account and the campaigns, line items, and creatives discovered through the Snowflake share or S3 export. It refreshes alongside the report cache. New entities appear after the next scheduled refresh.

Reports data

Reports include daily delivery data for advertisers, campaigns, line items, and creatives. This is a daily-cache connector, so dashboards read from cached daily performance rather than live queries against Basis.

Initial fetch. After connection, the last 180 days of daily data are retrieved.
Refresh schedule. Once per day at 14:00 UTC, the latest 15 days of data are refreshed in place. Because each refresh re-fetches the trailing 15 days, late-arriving or restated conversions within that window are picked up without a manual reconnection.

Architecture levels

Advertiser → Campaign → Line item → Creative

Date range limits

There are no fixed date-range caps on queries. The cache retains rolling daily data per the schedule above, and queries are bounded only by the history Basis exposes through its data share or export.

Metrics

How to read the columnsData type uses Adriel’s vocabulary — Number, Currency, Percentage, Ratio, Duration, Date, Text, URL, Array, Boolean. Basis delivers data through a Snowflake share or an Amazon S3 export rather than a reporting API, so its fields carry no platform API key; italic marks how Adriel sources each value — From Basis share/export for a delivery column mapped from the connected source, and Adriel-side for a built-in field Adriel adds to every source. Currency values are reported in the connected account’s configured currency.

General

Metric	Description	Data type	API Key
Datasource Name	The name of the connected data source.	Text	Adriel-side

Date Calculation

Metric	Description	Data type	API Key
Number Of Days In Current Month	The total number of days in the current calendar month.	Number	Adriel-side
Number Of Days Per Row	The number of days each row of the source represents.	Number	Adriel-side
Remaining Days	The number of days remaining in the selected period.	Number	Adriel-side
Total Duration In Days	The total number of days covered by the selected date range.	Number	Adriel-side

Basis-specific

These metrics exist only for Basis and aren’t part of any cross-connector category. Every group above is a standard category shared with other connectors.

Metric	Description	Data type	API Key
Country	Country of the delivery geography.	Text	From Basis share/export
Creative Preview Image	A media object for the creative’s preview image, resolved from Basis’ ad-preview page so it renders inline. Left unset when the creative has no directly embeddable image.	URL	From Basis share/export
Creative Preview Url	Direct URL to the creative’s preview image as plain text, resolved from Basis’ ad-preview page. Falls back to the raw ad-preview page URL when the creative has no directly embeddable image (for example audio, video, or native/HTML5 rich media).	URL	From Basis share/export
CTR	Click-through rate: clicks divided by impressions.	Percentage	From Basis share/export
Dma Code	Designated Market Area (DMA) code.	Text	From Basis share/export
Dma Name	Designated Market Area (DMA) name.	Text	From Basis share/export
Imps Won	Impressions won in the bidding auction.	Number	From Basis share/export
Link Clicks	Clicks on your ads.	Number	From Basis share/export
Media Spend	Media spend.	Currency	From Basis share/export
Net Spend	Net advertising spend.	Currency	From Basis share/export
Primary Region	Primary region of the delivery geography.	Text	From Basis share/export
Total Conversions	Total conversions attributed to your ads.	Number	From Basis share/export

Breakdowns

General

Breakdown	Description	API Key
Datasource Name	Groups results by connected data source.	Adriel-side
No Grouping	Shows all results as a single combined group.	Adriel-side

Date

Breakdown	Description	API Key
Auto Time Breakdown	Automatically groups results by an appropriate time interval for the selected date range.	Adriel-side
Daily Breakdown	Groups results by calendar day.	Adriel-side
Monthly Breakdown	Groups results by calendar month.	Adriel-side
Quarterly Breakdown	Groups results by calendar quarter.	Adriel-side
Week Date Breakdown	Groups results by the date representing each reporting week.	Adriel-side
Week Number Breakdown (W#)	Groups results by week number in the year.	Adriel-side
Weekly Breakdown (Start: Mon)	Groups results by calendar week (Monday start).	Adriel-side
Weekly Breakdown (Start: Sun)	Groups results into weeks running from Sunday through Saturday.	Adriel-side
Yearly Breakdown	Groups results by calendar year.	Adriel-side

Basis-specific

These breakdowns exist only for Basis and aren’t part of any cross-connector category. Every group above is a standard category shared with other connectors.

Breakdown	Description	API Key
Country	Groups results by delivery country.	From Basis share/export
Dma Code	Groups results by Designated Market Area (DMA) code.	From Basis share/export
Dma Name	Groups results by Designated Market Area (DMA) name.	From Basis share/export
Primary Region	Groups results by primary delivery region.	From Basis share/export

Limitations

Free-format schema. The connector never adds, removes, or renames fields; the available metrics and breakdowns mirror the columns Basis includes in the share or export. Keeping column names and types consistent across exports is the account owner’s responsibility.
Two separate report types. The creative-level and line-item-level reports are fetched and cached independently. Widgets that span both levels see them combined through the standard marketing hierarchy.
No deleted-data exclusion. Once an element is deleted on the Basis side, its data is no longer provided.
SDK-level credentials only. There is no HTTP API key or OAuth token. Snowflake JWT authentication and AWS S3 signing handle every request directly, so rotating credentials means editing the connection rather than refreshing a token.
Amazon S3 export access required for accounts provisioned in S3 mode.

API references

Basis does not expose a public reporting API. Data is delivered through a Snowflake data share (queried with JWT key-pair authentication) or an Amazon S3 CSV export, so the relevant references are the underlying access surfaces:

​Introduction

​Data refresh strategy

​Architecture data

​Reports data

​Architecture levels

​Date range limits

​Metrics

​General

​Date Calculation

​Basis-specific

​Breakdowns

​General

​Date

​Basis-specific

​Limitations

​API references

​See also

Introduction

Data refresh strategy

Architecture data

Reports data

Architecture levels

Date range limits

Metrics

General

Date Calculation

Basis-specific

Breakdowns

General

Date

Basis-specific

Limitations

API references

See also