suse_6sense_adlevel_staging_v2

Full reference: paidteam-data-warehouse.customer_ads_suse.suse_6sense_adlevel_staging_v2Type: Staging | Rows: 192,880 | Size: 53.3 MB

6sense ad-level performance data (V2). Contains ad-level metrics including impressions, clicks, cost, and accounts reached. Ingested via Dataslayer with ID columns and Segment targeting data.

Schema

Column	Type	Nullable	Description
Date	DATE	No (REQUIRED)	Date of ad performance
Campaign_ID	STRING	Yes	6sense campaign ID
AdGroup_ID	STRING	Yes	6sense ad group ID
Ad_ID	STRING	Yes	6sense ad/creative ID
Campaign	STRING	Yes	Campaign name
AdGroup	STRING	Yes	Ad group name
Ad	STRING	Yes	Ad/creative name
Segment	STRING	Yes	Target segment
Impressions	INTEGER	Yes	Number of impressions
Clicks	INTEGER	Yes	Number of clicks
Cost	NUMERIC	Yes	Cost in USD (precise decimal)
AccountReached	INTEGER	Yes	Number of accounts reached

Partitioning & Clustering

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

This is one of the few staging tables with clustering enabled, reflecting the high row count.

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_6sense_adlevel_final_v2.

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

Sample Query

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

Notes

• Underscore ID naming: 6sense uses Campaign_ID, AdGroup_ID, Ad_ID with underscores, unlike Google/Microsoft/LinkedIn/Reddit which use camelCase (CampaignID, AdGroupID). This must be handled in cross-platform views.
• NUMERIC type for Cost: 6sense uses NUMERIC (DECIMAL) for cost instead of FLOAT. This provides exact decimal precision, avoiding floating-point rounding issues.
• The Date column is marked as REQUIRED (NOT NULL), unlike most other platform staging tables where Date is nullable.
• The Segment column is unique to 6sense and represents the account-based targeting segment.
• AccountReached is a 6sense-specific metric representing the number of target accounts that received an impression.
• With 192,880 rows, this is the highest row-count staging table, reflecting the granular segment-level data 6sense provides.