suse_google_adlevel_staging_v2

Full reference: paidteam-data-warehouse.customer_ads_suse.suse_google_adlevel_staging_v2Type: Staging | Rows: 22,911 | Size: 10.3 MB

Google Ads ad-level staging data (V2). Dataslayer writes a rolling ~60-day window of ad-level performance data into this table daily. The scheduled refresh script reads from here to update the final table.

Schema

Column	Type	Nullable	Description
Date	DATE	No	Date of ad performance
CampaignID	STRING	Yes	Google Ads campaign ID
AdgroupID	STRING	Yes	Google Ads ad group ID
AdID	STRING	Yes	Google Ads ad ID
Campaign	STRING	Yes	Campaign name
Adgroup	STRING	Yes	Ad group name
Adname	STRING	Yes	Ad name
Advertisingchanneltype	STRING	Yes	Channel type (Search, Display, Video, etc.)
CreativeFinalURL	STRING	Yes	Final destination URL of the ad
Impressions	INTEGER	Yes	Number of impressions
Clicks	INTEGER	Yes	Number of clicks
CTR	FLOAT	Yes	Click-through rate
CPC	FLOAT	Yes	Cost per click (USD)
CPM	FLOAT	Yes	Cost per thousand impressions (USD)
CostUSD	FLOAT	Yes	Total cost in USD
Conversions	FLOAT	Yes	Number of conversions (fractional)
Viewthroughconversions	INTEGER	Yes	View-through conversions
AllconversionratePercent	FLOAT	Yes	All-conversion rate as a percentage
Watch25Percentrate	FLOAT	Yes	Video watched to 25% rate
Watch50Percentrate	FLOAT	Yes	Video watched to 50% rate
Watch75Percentrate	FLOAT	Yes	Video watched to 75% rate
Watch100Percentrate	FLOAT	Yes	Video watched to 100% rate
VideoViewsrate	FLOAT	Yes	Video views rate

Partitioning & Clustering

• Partitioned by: Date (DAY)
• Partitions: 56
• Clustering: None

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

Primary keys used for refresh: Date, CampaignID, AdgroupID, AdID

Sample Query

SELECT
  Date,
  Campaign,
  Adgroup,
  Adname,
  Impressions,
  Clicks,
  CostUSD
FROM `paidteam-data-warehouse.customer_ads_suse.suse_google_adlevel_staging_v2`
WHERE Date >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
ORDER BY Date DESC, Impressions DESC
LIMIT 100;

Notes

• The Advertisingchanneltype column distinguishes Search, Display, and Video campaigns. This is important when splitting Google data by network.
• Conversions is FLOAT (not INTEGER) because Google Ads reports fractional conversions when using data-driven attribution.
• VideoViewsrate should be FLOAT64 for consistency with percentage columns. Verify this matches the final table type.