suse_microsoft_creative_search_staging_v2

Full reference: paidteam-data-warehouse.customer_ads_suse.suse_microsoft_creative_search_staging_v2Type: Staging | Rows: 978 | Size: 0.4 MB

Microsoft Ads creative metadata for Search campaigns (V2). Contains RSA (Responsive Search Ad) text ad metadata including ad title parts and descriptions. This table is in progress and may undergo schema changes.

In Progress

This table is actively being developed. The schema and ingestion pipeline are not yet finalized. Some columns (AdTitle, AdTitlePart1-3, AdDescription, AdDescription2, DestinationUrl) are currently typed as INTEGER but are expected to be changed to STRING once the ingestion tool is reconfigured.

Schema

Column	Type	Nullable	Description
CampaignID	STRING	Yes	Microsoft Ads campaign ID
AdGroupID	STRING	Yes	Microsoft Ads ad group ID
AdID	STRING	Yes	Microsoft Ads ad ID
CampaignName	STRING	Yes	Campaign name
AdGroupName	STRING	Yes	Ad group name
AdTitle	INTEGER	Yes	Ad title (expected: STRING after fix)
CampaignType	STRING	Yes	Campaign type
FinalUrl	STRING	Yes	Final destination URL
AdType	STRING	Yes	Ad type (e.g., ResponsiveSearchAd)
AdStatus	STRING	Yes	Ad status (Active, Paused, etc.)
AdTitlePart1	INTEGER	Yes	RSA headline 1 (expected: STRING after fix)
AdTitlePart2	INTEGER	Yes	RSA headline 2 (expected: STRING after fix)
AdTitlePart3	INTEGER	Yes	RSA headline 3 (expected: STRING after fix)
AdDescription	INTEGER	Yes	RSA description 1 (expected: STRING after fix)
AdDescription2	INTEGER	Yes	RSA description 2 (expected: STRING after fix)
DestinationUrl	INTEGER	Yes	Legacy destination URL (expected: STRING after fix)
Cost	FLOAT	Yes	Cost associated with this ad

Partitioning & Clustering

• Partitioned by: None
• Clustering: None

This is a metadata-only table (no Date dimension), so time-based partitioning does not apply.

Refresh Logic

This table is currently populated via Dataslayer ingestion. A corresponding final table and MERGE logic have not yet been created. Once the schema is stabilized:

1. A suse_microsoft_creative_search_final_v2 table will be created
2. MERGE logic on CampaignID + AdGroupID + AdID will be added to the Creative Refresh Script
3. A microsoft_creative_search_performance_v2 view will join this data with the adlevel table

Expected primary keys: CampaignID, AdGroupID, AdID

Sample Query

SELECT
  CampaignName,
  AdGroupName,
  AdType,
  AdStatus,
  FinalUrl,
  Cost
FROM `paidteam-data-warehouse.customer_ads_suse.suse_microsoft_creative_search_staging_v2`
WHERE AdStatus = 'Active'
ORDER BY Cost DESC
LIMIT 50;

Notes

• Several columns (AdTitle, AdTitlePart1-AdTitlePart3, AdDescription, AdDescription2, DestinationUrl) are incorrectly typed as INTEGER. These should contain text strings for RSA headline and description content. The type mismatch is a known issue from the initial Dataslayer configuration and will be corrected.
• This table focuses on Search campaign creatives (RSA text ads). Display and Video creative metadata would be tracked separately if needed.
• No _ingested_at column exists yet; it will be added when the final table is created.