ConversionTags
Get information about the conversion tags in an ad account.
View-Specific Information
SELECT
The add-in uses the Pinterest API to process WHERE clause conditions built with the following columns and operators. Any remaining filters are processed client-side within the add-in.
| Column | Supported Operators |
| AdAccountId | = |
| Id | = |
| FilterDeleted | = |
For example:
SELECT * FROM ConversionTags WHERE AdAccountId = '549768561505'
SELECT * FROM ConversionTags WHERE AdAccountId = '549768561505' AND Id = '2617998078212'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Tag ID. | |
| AdAccountId | String |
AdAccounts.Id | The unique identifier of the ad account this conversion tag belongs to. |
| Name | String | Conversion tag name. | |
| Status | String | Entity status of the conversion tag.
The allowed values are ACTIVE, PAUSED, ARCHIVED, DRAFT, DELETED_DRAFT. | |
| Version | String | Version number. | |
| CodeSnippet | String | Tag code snippet. | |
| EnhancedMatchStatus | String | The enhanced match status of the tag.
The allowed values are UNKNOWN, NOT_VALIDATED, VALIDATING_IN_PROGRESS, VALIDATION_COMPLETE. | |
| LastFiredTime | Datetime | Time for the last event fired. | |
| Configs | String | The configuration settings of the conversion tag. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| FilterDeleted | Boolean | Filter conversion tags by deleted status.
The default value is false. |