suse_linkedin_creative_staging_v2

Full reference: paidteam-data-warehouse.customer_ads_suse.suse_linkedin_creative_staging_v2Type: Staging | Rows: 1,527 | Size: 1.5 MB

LinkedIn creative metadata staging table (V2). Contains creative asset details such as titles, text, thumbnail URLs, and download URLs. This is a metadata-only table with no Date column -- it represents the current state of all creatives rather than time-series data.

Schema

Column	Type	Nullable	Description
CampaignGroupID	STRING	Yes	LinkedIn campaign group ID
CampaignID	STRING	Yes	LinkedIn campaign ID
CreativeID	STRING	Yes	LinkedIn creative ID (primary key)
CampaignGroupName	STRING	Yes	Campaign group name
CampaignName	STRING	Yes	Campaign name
CampaignType	STRING	Yes	Campaign type
CampaignObjectiveType	STRING	Yes	Campaign objective (Lead Generation, Brand Awareness, etc.)
CampaignTargetType	STRING	Yes	Targeting type
CreativeName	STRING	Yes	Creative name / internal label
CreativeType	STRING	Yes	Creative format (SingleImage, Video, Carousel, etc.)
CreativeDestinationURL	STRING	Yes	Click destination URL
CreativeStatus	STRING	Yes	Creative status (Active, Paused, etc.)
CreativeTitle	STRING	Yes	Headline text displayed in the ad
CreativeText	STRING	Yes	Body text / introductory text
CreativePostUrl	STRING	Yes	URL of the sponsored post
CreativeThumbnailURL	STRING	Yes	Thumbnail image URL
CreativeThumbnailImage	STRING	Yes	Thumbnail image asset reference
CreativeDownloadmediaURL	STRING	Yes	Media download URL (for video/document ads)
CreativeDownloaddocumentURL	STRING	Yes	Document download URL (for document ads)
CreativeReferenceID	STRING	Yes	Reference ID linking to LinkedIn's internal asset

Partitioning & Clustering

• Partitioned by: None (metadata table, no Date column)
• Clustering: None

Refresh Logic

This is a staging table. Dataslayer populates it with the current state of all LinkedIn creatives. The Creative Refresh Script uses a MERGE to update the final table.

Primary key for MERGE: CreativeID (globally unique on LinkedIn)

Sample Query

SELECT
  CreativeID,
  CampaignName,
  CreativeName,
  CreativeType,
  CreativeStatus,
  CreativeTitle,
  CreativeThumbnailURL
FROM `paidteam-data-warehouse.customer_ads_suse.suse_linkedin_creative_staging_v2`
WHERE CreativeStatus = 'ACTIVE'
ORDER BY CampaignName
LIMIT 50;

Notes

• This table has no Date column. It is a point-in-time snapshot of creative metadata, not time-series performance data.
• The MERGE into the final table uses only CreativeID as the match key because LinkedIn CreativeIDs are globally unique.
• CreativeThumbnailURL and CreativeThumbnailImage provide access to the visual asset, enabling creative fatigue analysis in Looker Studio.
• CreativeDownloadmediaURL and CreativeDownloaddocumentURL are populated for video and document ad formats respectively.
• Creative metadata such as CreativeTitle and CreativeText are used by UDFs like get_content_name() to extract human-readable identifiers.