Pinterest Fields

Dimensions (27)

Account

NinjaCat System ID: pinterest:DIM_ACCOUNT
Data Type: text
Aggregates To: DIM_ACCOUNT

Board Created Date

API Name: board.created_at
NinjaCat System ID: pinterest:DIM_boardCreatedAt
Data Type: date

Board Description

API Name: board.description
NinjaCat System ID: pinterest:DIM_description
Data Type: text

Board Id

API Name: board.id
NinjaCat System ID: pinterest:DIM_boardId
Data Type: text

Board Name

API Name: board.name
NinjaCat System ID: pinterest:DIM_boardName
Data Type: text

Board Privacy

API Name: board.privacy
NinjaCat System ID: pinterest:DIM_privacy
Data Type: text

Board Url

API Name: board.url
NinjaCat System ID: pinterest:DIM_boardUrl
Data Type: text
Display As: url

Created

API Name: created_at
NinjaCat System ID: pinterest:DIM_date
Data Type: date
Aggregates To: DIM_DATE

Currency

NinjaCat System ID: pinterest:DIM_CURRENCY
Data Type: text
Aggregates To: DIM_CURRENCY

Data Source

NinjaCat System ID: pinterest:DIM_DATA_SOURCE
Data Type: text
Aggregates To: DIM_DATA_SOURCE

Day Of Month

NinjaCat System ID: pinterest:DIM_DAY_OF_MONTH
Data Type: integer
Aggregates To: DIM_DAY_OF_MONTH

Day Of Week

NinjaCat System ID: pinterest:DIM_DAY_OF_WEEK
Data Type: text
Display As: day_of_week
Aggregates To: DIM_DAY_OF_WEEK

External Id

NinjaCat System ID: pinterest:DIM_EXTERNAL_ID
Data Type: text
Aggregates To: DIM_EXTERNAL_ID

Month Of Year

NinjaCat System ID: pinterest:DIM_MONTH_OF_YEAR
Data Type: text
Display As: date_month_of_year
Aggregates To: DIM_MONTH_OF_YEAR

Network

NinjaCat System ID: pinterest:DIM_NETWORK
Data Type: text
Display As: title_case
Aggregates To: DIM_NETWORK

Pin Id

API Name: id
NinjaCat System ID: pinterest:DIM_pinId
Data Type: text

Pin Image Url

API Name: image.original.url
NinjaCat System ID: pinterest:DIM_pinImageUrl
Data Type: text
Display As: url

Pin Link

API Name: origional_link
NinjaCat System ID: pinterest:DIM_pinLink
Data Type: text
Display As: url

Pin Media Type

API Name: media.type
NinjaCat System ID: pinterest:DIM_media
Data Type: text

Pin Note

API Name: note
NinjaCat System ID: pinterest:DIM_note
Data Type: text

Pin Preview

NinjaCat System ID: pinterest:DIM_pinPreview
Data Type: text
Display As: pinterest_pin

Pin Url

API Name: url
NinjaCat System ID: pinterest:DIM_pinUrl
Data Type: text
Display As: url

Quarter

NinjaCat System ID: pinterest:DIM_QUARTER
Data Type: text
Display As: quarter
Aggregates To: DIM_QUARTER

Row

NinjaCat System ID: pinterest:DIM_ROW
Data Type: text
Aggregates To: DIM_ROW

System Account ID

NinjaCat System ID: pinterest:DIM_ACCOUNT_ID
Data Type: text
Aggregates To: DIM_ACCOUNT_ID

Week Of Year

NinjaCat System ID: pinterest:DIM_WEEK_OF_YEAR
Data Type: text
Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

Year

NinjaCat System ID: pinterest:DIM_Year
Data Type: text
Aggregates To: DIM_YEAR

Metrics (6)

Board Collaborators

API Name: board.counts.collaborators
NinjaCat System ID: pinterest:MET_boardCollaborators
Data Type: integer

Board Followers

API Name: board.counts.followers
NinjaCat System ID: pinterest:MET_boardFollowers
Data Type: integer

Board Pins

API Name: board.counts.pins
NinjaCat System ID: pinterest:MET_boardPins
Data Type: integer

Count (Unique Dimensions)

NinjaCat System ID: pinterest:MET_COUNT_NC
Data Type: integer
Aggregates To: MET_COUNT_NC

Pin Comments

API Name: counts.comments
NinjaCat System ID: pinterest:MET_pinComments
Data Type: integer

Pin Saves

API Name: counts.saves
NinjaCat System ID: pinterest:MET_pinSaves
Data Type: integer