AdsCreditDiscounts
Returns the list of ads credit discounts applied to the specified ad account.
View-Specific Information
SELECT
The connector 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 connector.
| Column | Supported Operators |
| AdAccountId | = |
For example:
SELECT * FROM AdsCreditDiscounts WHERE AdAccountId = '549768561505'
Columns
| Name | Type | References | Description |
| AdAccountId | String |
AdAccounts.Id | The unique identifier of the ad account associated with these discounts. |
| Active | Boolean | True if the offer code is currently active. | |
| AdvertiserId | String | Advertiser ID the offer was applied to. | |
| DiscountCurrency | String | Currency value for the discount. | |
| DiscountInMicroCurrency | Double | The discount applied in the offer's currency value. | |
| DiscountType | String | The type of discount of this credit.
The allowed values are COUPON, CREDIT, COUPON_APPLIED, CREDIT_APPLIED, MARKETING_OFFER_CREDIT, MARKETING_OFFER_CREDIT_APPLIED, GOODWILL_CREDIT, GOODWILL_CREDIT_APPLIED, INTERNAL_CREDIT, INTERNAL_CREDIT_APPLIED, PREPAID_CREDIT, PREPAID_CREDIT_APPLIED, SALES_INCENTIVE_CREDIT, SALES_INCENTIVE_CREDIT_APPLIED, CREDIT_EXPIRED, FUTURE_CREDIT, REFERRAL_CREDIT, INVOICE_SALES_INCENTIVE_CREDIT, INVOICE_SALES_INCENTIVE_CREDIT_APPLIED, PREPAID_CREDIT_REFUND. | |
| RemainingDiscountInMicroCurrency | Double | The credits left to spend. | |
| Title | String | Human readable title of the offer code. |