Creatives

Retrieves all creatives associated with an ad account

Select

The 本製品 will use the Snapchat Ads API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

Id supports the following operator: =
AccountId supports the following operator: =; If no value is specified, the 本製品 will try to get the first Account from the list returned by the Accounts view.

The following queries are processed server side:

    SELECT * FROM Creatives WHERE Id = 'c1e6e929-acec-466f-b023-852b8cacc18f'
    SELECT * FROM Creatives WHERE AccountId = '331deb8082b8-a1d5-4579-9f7c-2e874d37'

Columns


Name	Type	References	Description
Id [KEY]	String		ID of the creative.
UpdatedAt	Datetime		The date when the entity was last updated.
CreatedAt	Datetime		The creation date of the entity.
Name	String		Creative name.
Headline	String		Creative headline.
AccountId	String	Accounts.Id	Creative Account ID.
Type	String		Creative type. 使用できる値は次のとおりです。SNAP_AD, APP_INSTALL, LONGFORM_VIDEO, WEB_VIEW, DEEP_LINK, AD_TO_LENS, AD_TO_CALL, AD_TO_MESSAGE, PREVIEW, COMPOSITE, FILTER, LENS, LENS_WEB_VIEW, LENS_APP_INSTALL, LENS_DEEP_LINK, LENS_LONGFORM_VIDEO, COLLECTION
PackagingStatus	String		Packaging Status. 使用できる値は次のとおりです。PENDING, SUCCESS, IN_PROGRESS
ReviewStatus	String		Review Status.
Shareable	Boolean		Allow Users to Share with Friends
TopSnapMediaId	String		Top Snap Media ID.
CallToAction	String		Call to Action. 使用できる値は次のとおりです。BLANK, INSTALL_NOW, WATCH, VIEW_MORE, WATCH_EPISODE, DOWNLOAD, PLAY, SHOP_NOW, SIGN_UP, USE_APP, APPLY_NOW, BOOK_NOW, BUY_TICKETS, GET_NOW, LISTEN, MORE, ORDER_NOW, READ, SHOW, SHOWTIMES, VIEW, OPEN_APP, TRY
TopSnapCropPosition	String		Top Snap Crop Position. 使用できる値は次のとおりです。OPTIMIZED, MIDDLE, TOP, BOTTOM
LongformVideoProperties	String		Long Form Video Properties.
AppInstallProperties	String		App Install Properties.
WebViewProperties	String		Web View Properties.

ODBC Driver for Snapchat Ads

Creatives

Select

Columns