Excel Add-In for Pinterest

Build 24.0.9062

AdGroups

Get a list of the ad_accounts that the User has access to.

Table Specific Information

Select

The 本製品 will use the Pinterest API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.

  • AdAccountId supports the '=' operator.
  • Id supports the '=,IN' operator.
  • Status supports the '=' operator.
  • TranslateInterestsToNames supports the '=' operator.
For example:
	
	SELECT * FROM AdGroups WHERE AdAccountId = '3457832451'

Columns

Name Type References Description
Id [KEY] String Advertiser ID.
AdAccountId String

AdAccounts.Id

Ad Account ID.
CampaignId String

Campaigns.Id

Campaign ID of the ad group.
FeedProfileId String Feed Profile ID associated to the adgroup.
AutoTargetingEnabled Boolean Enable auto-targeting for ad group.
BidInMicroCurrency Integer Bid price in micro currency.
BillableEvent String Ad group billable event type.

使用できる値は次のとおりです。CLICKTHROUGH, IMPRESSION, VIDEO_V_50_MRC

BudgetInMicroCurrency Integer Budget in micro currency.
BudgetType String Budget type

使用できる値は次のとおりです。DAILY, LIFETIME, CBO_ADGROUP

ConversionLearningModeType String oCPM learn mode

使用できる値は次のとおりです。NOT_ACTIVE, ACTIVE

CreatedTime Datetime Ad group creation time.
EndTime Datetime Ad group end time.
LifetimeFrequencyCap Integer Set a limit to the number of times a promoted pin from this campaign can be impressed by a pinner within the past rolling 30 days.
Name String Ad group name.
PacingDeliveryType String PacingDeliveryType

使用できる値は次のとおりです。STANDARD, ACCELERATED

PlacementGroup String PlacementGroup
StartTime Datetime Ad group start time
Status String Ad group/entity status.

使用できる値は次のとおりです。ACTIVE, PAUSED, ARCHIVED, DRAFT, DELETED_DRAFT

SummaryStatus String Ad group summary status.

使用できる値は次のとおりです。RUNNING, PAUSED, NOT_STARTED, COMPLETED, ADVERTISER_DISABLED, ARCHIVED, DRAFT, DELETED_DRAFT

TargetingSpec String Ad group targeting specification defining the ad group target audience.
TrackingUrlsAudienceVerification String Third-party tracking URLs.
TrackingUrlsBuyableButton String Third-party tracking URLs.
TrackingUrlsClick String Third-party tracking URLs.
TrackingUrlsEngagement String Third-party tracking URLs.
TrackingUrlsImpression String Third-party tracking URLs.
Type String Type of ad group.
UpdatedTime Datetime Ad group last update time.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
TranslateInterestsToNames Boolean Return interests as text names and not topic IDs?

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062