suse_stackadapt_adlevel_staging_v2

Full reference: paidteam-data-warehouse.customer_ads_suse.suse_stackadapt_adlevel_staging_v2Type: Staging | Rows: 3,765 | Size: 1.8 MB

StackAdapt ad-level performance data (V2). Contains ad-level metrics with Campaign IDs, Ad Group IDs, Ad IDs, Channel Type, Click URL, and Creative Size. Ingested via Dataslayer.

Schema

Column	Type	Nullable	Description
Date	DATE	No (REQUIRED)	Date of ad performance
Campaign_ID	STRING	Yes	StackAdapt campaign ID
AdGroup_ID	STRING	Yes	StackAdapt campaign group ID
Ad_ID	STRING	Yes	StackAdapt creative ID
Campaign	STRING	Yes	Campaign name
AdGroup	STRING	Yes	Campaign group name
Ad	STRING	Yes	Creative name
Channel_Type	STRING	Yes	Channel type (Display, Video, Native, etc.)
Click_URL	STRING	Yes	Click destination URL
Creative_Size	STRING	Yes	Creative dimensions (e.g., "300x250", "728x90")
Impressions	INTEGER	Yes	Number of impressions
Clicks	INTEGER	Yes	Number of clicks
Cost	NUMERIC	Yes	Cost in USD (precise decimal, converted from GBP)
Conversions	NUMERIC	Yes	Number of conversions

Partitioning & Clustering

• Partitioned by: Date (DAY)
• Partitions: 25
• Clustered by: Campaign_ID, Date

Refresh Logic

This is a staging table. Dataslayer overwrites data here on a daily schedule. The refresh script reads from this table and upserts into suse_stackadapt_adlevel_final_v2.

Primary keys used for refresh: Date, Campaign_ID, AdGroup_ID, Ad_ID

Sample Query

SELECT
  Date,
  Campaign,
  AdGroup,
  Ad,
  Channel_Type,
  Creative_Size,
  Impressions,
  Clicks,
  Cost
FROM `paidteam-data-warehouse.customer_ads_suse.suse_stackadapt_adlevel_staging_v2`
WHERE Date >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
ORDER BY Date DESC, Cost DESC
LIMIT 100;

Notes

• Underscore ID naming: Like 6sense, StackAdapt uses Campaign_ID, AdGroup_ID, Ad_ID with underscores. It also uses underscores for Channel_Type, Click_URL, and Creative_Size.
• NUMERIC type for Cost and Conversions: Both use NUMERIC (DECIMAL) for exact precision. Cost values are converted from GBP to USD.
• The Date column is marked as REQUIRED (NOT NULL).
• Channel_Type distinguishes between Display, Video, and Native placements, which is important for creative size analysis.
• Creative_Size contains the ad dimensions (e.g., "300x250"), useful for tracking creative performance by format.
• StackAdapt's AdGroup_ID maps to StackAdapt's "Campaign Group" concept, and Ad_ID maps to StackAdapt's "Creative" concept.