Creatives
Retrieves all creatives associated with an ad account
Select
The provider 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 provider.
- Id supports the following operator: =
- AccountId supports the following operator: =; If no value is specified, the provider will try to get the first Account from the list returned by the Accounts view.
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.
The allowed values are 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.
The allowed values are 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.
The allowed values are 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.
The allowed values are OPTIMIZED, MIDDLE, TOP, BOTTOM. | |
| LongformVideoProperties | String | Long Form Video Properties. | |
| AppInstallProperties | String | App Install Properties. | |
| WebViewProperties | String | Web View Properties. |