Guides
Shape Help Center

Agorapulse Fields

Suggest Edits

Dimensions (23)

Account

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

Currency

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

Data Source

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

Date

API Name: date
NinjaCat System ID: agorapulse:DIM_Date
Data Type: date
Aggregates To: DIM_DATE

Day Of Month

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

Day Of Week

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

External Id

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

Hour Of Day

NinjaCat System ID: agorapulse:DIM_HOUR_OF_DAY
Data Type: integer
Aggregates To: DIM_HOUR_OF_DAY

Month Of Year

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

Network

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

Platform

API Name: platform
NinjaCat System ID: agorapulse:DIM_platform
Data Type: text

Post Author

API Name: username
NinjaCat System ID: agorapulse:DIM_postAuthor
Data Type: text

Post ID on Platform

API Name: id
NinjaCat System ID: agorapulse:DIM_postPlatformId
Data Type: text

Post Tags

API Name: tags
NinjaCat System ID: agorapulse:DIM_postTags
Data Type: text

Post Text

API Name: text
NinjaCat System ID: agorapulse:DIM_postText
Data Type: text

Post Type

API Name: type
NinjaCat System ID: agorapulse:DIM_postType
Data Type: text

Post URL

API Name: postUrl
NinjaCat System ID: agorapulse:DIM_postUrl
Data Type: text

Quarter

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

Row

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

Source

API Name: source
NinjaCat System ID: agorapulse:DIM_source
Data Type: text

System Account ID

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

Week Of Year

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

Year

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

Metrics (71)

Add to Playlists

API Name: addedToPlaylistCount
NinjaCat System ID: agorapulse:MET_addedToPlaylistCount
Data Type: integer

Average Organic Reach

NinjaCat System ID: agorapulse:MET_averageOrganicReach
Data Type: decimal
Display As: float
Aggregates To: MET_REACH
Formula: agorapulse:MET_organicReachCount / NUM_ROWS

Average Paid Reach

NinjaCat System ID: agorapulse:MET_averagePaidReach
Data Type: decimal
Display As: float
Aggregates To: MET_REACH
Formula: agorapulse:MET_paidReachCount / NUM_ROWS

Average Reach

NinjaCat System ID: agorapulse:MET_reachCount
Data Type: decimal
Display As: float
Aggregates To: MET_REACH
Formula: agorapulse:MET_reachTotal / NUM_ROWS

Average Sentiment

NinjaCat System ID: agorapulse:MET_sentimentScore
Data Type: decimal
Display As: float
Formula: agorapulse:MET_sentimentTotal / NUM_ROWS

Back Taps

API Name: tapBackCount
NinjaCat System ID: agorapulse:MET_tapBackCount
Data Type: integer

Clicks

API Name: clicksCount
NinjaCat System ID: agorapulse:MET_clicksCount
Data Type: integer
Aggregates To: MET_CLICKS

Comments

API Name: commentsCount
NinjaCat System ID: agorapulse:MET_commentsCount
Data Type: integer

Count (Unique Dimensions)

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

Dislikes

API Name: dislikesCount
NinjaCat System ID: agorapulse:MET_dislikesCount
Data Type: integer

Engagement Count

API Name: engagementCount
NinjaCat System ID: agorapulse:MET_engagementCount
Data Type: integer
Aggregates To: MET_ENGAGEMENTS

Engagement Rate (Impressions)

NinjaCat System ID: agorapulse:MET_engagementRatePerImpression
Data Type: decimal
Display As: percent
Formula: agorapulse:MET_engagementCount / agorapulse:MET_impressionsCount

Engagement Rate (Reach)

NinjaCat System ID: agorapulse:MET_engagementRatePerReach
Data Type: decimal
Display As: percent
Formula: agorapulse:MET_engagementCount / agorapulse:MET_reachTotal

Exits

API Name: exitCount
NinjaCat System ID: agorapulse:MET_exitCount
Data Type: integer

Fans Gained

API Name: fansGainedCount
NinjaCat System ID: agorapulse:MET_fansGainedCount
Data Type: integer

Fans Lost

API Name: fansLostCount
NinjaCat System ID: agorapulse:MET_fansLostCount
Data Type: integer

Followers Gained

API Name: followersGainedCount
NinjaCat System ID: agorapulse:MET_followersGainedCount
Data Type: integer

Followers Gained (organic)

API Name: organicFollowersGainedCount
NinjaCat System ID: agorapulse:MET_organicFollowersGainedCount
Data Type: integer

Followers Gained (paid)

API Name: paidFollowersGainedCount
NinjaCat System ID: agorapulse:MET_paidFollowersGainedCount
Data Type: integer

Followers Lost

API Name: followersLostCount
NinjaCat System ID: agorapulse:MET_followersLostCount
Data Type: integer

Forward Swipes

API Name: swipeForwardCount
NinjaCat System ID: agorapulse:MET_swipeForwardCount
Data Type: integer

Forward Taps

API Name: tapForwardCount
NinjaCat System ID: agorapulse:MET_tapForwardCount
Data Type: integer

Impressions

API Name: impressionsCount
NinjaCat System ID: agorapulse:MET_impressionsCount
Data Type: integer
Aggregates To: MET_IMPRESSIONS

Impressions (organic)

API Name: organicImpressionsCount
NinjaCat System ID: agorapulse:MET_organicImpressionsCount
Data Type: integer

Impressions (paid)

API Name: paidImpressionsCount
NinjaCat System ID: agorapulse:MET_paidImpressionsCount
Data Type: integer

Likes

API Name: likesCount
NinjaCat System ID: agorapulse:MET_likesCount
Data Type: integer
Aggregates To: MET_LIKES

Link Clicks

API Name: linkClicksCount
NinjaCat System ID: agorapulse:MET_linkClicksCount
Data Type: integer

Mentions

API Name: mentionsCount
NinjaCat System ID: agorapulse:MET_mentionsCount
Data Type: integer

Negative Items

API Name: negativeItemsCount
NinjaCat System ID: agorapulse:MET_negativeItemsCount
Data Type: integer

Neutral Items

API Name: neutralItemsCount
NinjaCat System ID: agorapulse:MET_neutralItemsCount
Data Type: integer

Other Clicks

API Name: otherClicksCount
NinjaCat System ID: agorapulse:MET_otherClicksCount
Data Type: integer
Aggregates To: MET_CLICKS

Photo Clicks

API Name: photoClicksCount
NinjaCat System ID: agorapulse:MET_photoClicksCount
Data Type: integer

Photo View Clicks

API Name: photoViewClicksCount
NinjaCat System ID: agorapulse:MET_photoViewClicksCount
Data Type: integer

Plays

API Name: playsCount
NinjaCat System ID: agorapulse:MET_playsCount
Data Type: integer

Positive Items

API Name: positiveItemsCount
NinjaCat System ID: agorapulse:MET_positiveItemsCount
Data Type: integer

Posts Published

API Name: publishedPostsCount
NinjaCat System ID: agorapulse:MET_publishedPostsCount
Data Type: integer

Published Carousels

API Name: publishedCarouselCount
NinjaCat System ID: agorapulse:MET_publishedCarouselCount
Data Type: integer

Published Links

API Name: publishedLinksCount
NinjaCat System ID: agorapulse:MET_publishedLinksCount
Data Type: integer

Published Media

API Name: publishedMediaCount
NinjaCat System ID: agorapulse:MET_publishedMediaCount
Data Type: integer

Published Photos

API Name: publishedPhotoCount
NinjaCat System ID: agorapulse:MET_publishedPhotosCount
Data Type: integer

Published Reels

API Name: publishedReelCount
NinjaCat System ID: agorapulse:MET_publishedReelCount
Data Type: integer

Published Statuses

API Name: publishedStatusCount
NinjaCat System ID: agorapulse:MET_publishedStatusCount
Data Type: integer

Published Stories

API Name: publishedStoryCount
NinjaCat System ID: agorapulse:MET_publishedStoryCount
Data Type: integer

Published Text Count

API Name: publishedTextCount
NinjaCat System ID: agorapulse:MET_publishedTextCount
Data Type: integer

Published Videos

API Name: publishedVideoCount
NinjaCat System ID: agorapulse:MET_publishedVideoCount
Data Type: integer

Quote Posts Count

API Name: quotePostsCount
NinjaCat System ID: agorapulse:MET_quotePostsCount
Data Type: integer

Reactions

API Name: reactionsCount
NinjaCat System ID: agorapulse:MET_reactionsCount
Data Type: integer

Received Comments

API Name: receivedCommentsCount
NinjaCat System ID: agorapulse:MET_receivedCommentsCount
Data Type: integer
Aggregates To: MET_COMMENTS

Received Messages

API Name: receivedMessagesCount
NinjaCat System ID: agorapulse:MET_receivedMessagesCount
Data Type: integer

Removed Count

API Name: removedCount
NinjaCat System ID: agorapulse:MET_removedCount
Data Type: integer

Removed from Playlists

API Name: removedFromPlaylistCount
NinjaCat System ID: agorapulse:MET_removedFromPlaylistCount
Data Type: integer

Replays

API Name: replaysCount
NinjaCat System ID: agorapulse:MET_replaysCount
Data Type: integer

Reposts

API Name: repostsCount
NinjaCat System ID: agorapulse:MET_repostsCount
Data Type: integer

Saves

API Name: savesCount
NinjaCat System ID: agorapulse:MET_savesCount
Data Type: integer

Shares

API Name: sharesCount
NinjaCat System ID: agorapulse:MET_sharesCount
Data Type: integer
Aggregates To: MET_SHARES

Subscribers Gained

API Name: subscribersGainedCount
NinjaCat System ID: agorapulse:MET_subscribersGainedCount
Data Type: integer

Subscribers Lost

API Name: subscribersLostCount
NinjaCat System ID: agorapulse:MET_subscribersLostCount
Data Type: integer

Total Fans

API Name: fansCount
NinjaCat System ID: agorapulse:MET_fansCount
Data Type: integer
Is Unique: True

Total Followers

API Name: followersCount
NinjaCat System ID: agorapulse:MET_followersCount
Data Type: integer
Is Unique: True

Total Subscribers

API Name: subscribersCount
NinjaCat System ID: agorapulse:MET_subscribersCount
Data Type: integer
Is Unique: True

Video Clicks

API Name: videoClicksCount
NinjaCat System ID: agorapulse:MET_videoClicksCount
Data Type: integer

Video Completions

API Name: videoCompletedCount
NinjaCat System ID: agorapulse:MET_videoCompletedCount
Data Type: integer

Video Replays

API Name: videoReplaysCount
NinjaCat System ID: agorapulse:MET_videoReplaysCount
Data Type: integer

Video View Clicks

API Name: videoViewsClickCount
NinjaCat System ID: agorapulse:MET_videoViewsClickCount
Data Type: integer

Video Views

API Name: videoViewsCount
NinjaCat System ID: agorapulse:MET_videoViewsCount
Data Type: integer

Video Views (autoplay)

API Name: videoViewsAutoplayCount
NinjaCat System ID: agorapulse:MET_videoViewsAutoplayCount
Data Type: integer

Video Views (organic)

API Name: organicVideoViewsCount
NinjaCat System ID: agorapulse:MET_organicVideoViewsCount
Data Type: integer

Video Views (paid)

API Name: paidVideoViewsCount
NinjaCat System ID: agorapulse:MET_paidVideoViewsCount
Data Type: integer

Video View Time Watched

API Name: videoViewsTimeWatchedCount
NinjaCat System ID: agorapulse:MET_videoViewsTimeWatchedCount
Data Type: integer

Viral Impressions

API Name: viralImpressionsCount
NinjaCat System ID: agorapulse:MET_viralImpressionsCount
Data Type: integer

Watch Time (estimated)

API Name: estimatedWatchedTimeCount
NinjaCat System ID: agorapulse:MET_estimatedWatchedTimeCount
Data Type: integer

Updated 2 days ago