CreatorIQ Connector Reference

49 metrics39 dimensions

The CreatorIQ connector exposes 88 fields (49 metrics, 39 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


CreatorIQ Fields

CreatorIQ Campaign Activity fields

The Campaign Activity report of the CreatorIQ connector includes 67 fields.

CreatorIQ Campaign Activity fields (actual_impressions to paid_unique_comments)

IDTypeNameDescription
actual_impressionsNUMERICActual ImpressionsImpressions that a CreatorIQ user entered manually, often from a creator screenshot.
actual_reachNUMERICActual ReachReach that a CreatorIQ user entered manually, often from a creator screenshot.
base_metricTEXTBase MetricThe denominator used to calculate the engagement rate, for example Followers or Impressions.
base_metric_valueNUMERICBase Metric ValueValue of the base metric used to calculate the engagement rate.
campaign_idTEXTCampaign IDThe unique ID of the campaign.
campaign_nameTEXTCampaign NameThe name of the campaign.
clicksNUMERICClicksNumber of times the post was clicked.
combined_clicksNUMERICCombined ClicksPaid clicks + clicks.
combined_commentsNUMERICCombined CommentsPaid comments + comments.
combined_impressionsNUMERICCombined ImpressionsPaid impressions + impressions.
combined_likesNUMERICCombined LikesPaid likes + likes.
combined_reachNUMERICCombined ReachPaid reach + reach.
combined_savesNUMERICCombined SavesPaid saves + saves.
combined_viewsNUMERICCombined ViewsPaid views + views.
commentsNUMERICCommentsNumber of comments.
engagementNUMERICEngagementLikes + comments + shares, the total number of actions.
estimated_impressionsNUMERICEstimated ImpressionsImpressions that CreatorIQ estimated for the post.
estimated_reachNUMERICEstimated ReachReach that CreatorIQ estimated for the post.
estimated_unique_stream_viewsNUMERICEstimated Unique Stream ViewsAggregate number of views on all live streams.
extended_reachNUMERICExtended ReachSum of the followers of the accounts that reposted the post.
facebook_commentsNUMERICFacebook CommentsNumber of Facebook comments.
facebook_likesNUMERICFacebook LikesNumber of Facebook likes.
followsNUMERICFollowsNumber of accounts that started to follow the creator.
impressionsNUMERICImpressionsNumber of impressions of the post.
last_updatedTIMESTAMPLast UpdatedThe time when CreatorIQ last updated the post metrics.
likesNUMERICLikesNumber of likes.
NUMERICLink ClicksNumber of clicks on the creator link.
linkedBOOLEANLinkedWhether the post is linked to the campaign.
linked_atTIMESTAMPLinked AtThe time when the post was linked to the campaign.
network_impressionsNUMERICNetwork ImpressionsImpressions that the social network reported for an authenticated account.
network_reachNUMERICNetwork ReachReach that the social network reported for an authenticated account.
NUMERICPaid ClicksNumber of clicks on the ads of the post.
NUMERICPaid CommentsNumber of comments on the ads of the post.
NUMERICPaid ImpressionsNumber of times the ads of the post were on screen.
NUMERICPaid LikesNumber of people that reacted to the ads of the post.
NUMERICPaid Link ClicksNumber of clicks on ad links that lead off the social network.
NUMERICPaid ReachNumber of people who saw the ads of the post at least once.
NUMERICPaid SavesNumber of times the ads of the post were saved.
NUMERICPaid Unique ClicksNumber of people that clicked the ads of the post.
NUMERICPaid Unique CommentsNumber of people that commented on the ads of the post.

CreatorIQ Campaign Activity fields (paid_unique_link_clicks to user_name_title)

IDTypeNameDescription
NUMERICPaid Unique Link ClicksNumber of people that clicked links in the ads of the post.
NUMERICPaid ViewsNumber of times the video ads of the post were viewed for at least three seconds.
peak_stream_concurrent_viewsNUMERICPeak Stream Concurrent ViewsMaximum number of people that watched the stream at the same time.
postTEXTPostThe text of the post.
post_activity_idTEXTPost Activity IDThe unique ID of the post record in the campaign.
post_clicksNUMERICPost ClicksNumber of times the post was clicked.
post_linkTEXTPost LinkThe URL of the post.
post_titleTEXTPost titleThe title of the post.
post_typeTEXTPost TypeThe type of the post on the social network, for example reel, story or video.
post_view_countNUMERICPost View CountNumber of post views.
publisher_idTEXTPublisher IDThe unique ID of the publisher (creator).
publisher_nameTEXTPublisher NameThe name of the publisher (creator).
reachNUMERICReachNumber of people who saw the post.
repliesNUMERICRepliesMessages sent in reply to a story.
savesNUMERICSavesNumber of times the post was saved.
social_networkTEXTSocial Network NameThe social network of the post.
sticker_tapsNUMERICSticker TapsInteractions with stickers such as geotags or hashtags.
submitted_timeTIMESTAMPSubmitted TimeThe time when the post was submitted, as CreatorIQ returns it with no time zone offset.
submitted_time_utcTIMESTAMPSubmitted Time UTCThe time when the post was submitted, in UTC.
swipe_awaysNUMERICSwipe AwaysTimes the audience swiped to the story of the next user.
swipe_upsNUMERICStory Swipe UpsTimes the audience clicked stickers that link to an external URL.
taps_backNUMERICTaps BackTimes the audience tapped back to replay a story.
taps_forwardNUMERICTaps ForwardTimes the audience tapped forward to the next story of the same creator.
total_reachNUMERICTotal ReachSum of reach and extended reach.
total_sharesNUMERICTotal SharesNumber of times the audience shared the post.
user_nameTEXTUser NameThe username of the creator on the social network.
user_name_titleTEXTUser Name TitleThe display title of the creator username.

CreatorIQ General fields

The General report of the CreatorIQ connector includes 3 fields.

IDTypeNameDescription
account_idTEXTAccount IDThe Windsor account ID for the connection.
account_nameTEXTAccount NameThe Windsor account name for the connection.
dateDATEDateThe UTC date when the post was submitted.

CreatorIQ other fields

The CreatorIQ connector has 18 fields that do not belong to a named report, or belong to a report with only one or two fields.

IDTypeNameDescriptionReport
data_fetched_atTIMESTAMPData fetched atUTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasourceTEXTData SourceThe name of the Windsor connector returning the row
day_of_monthTEXTDay of monthDay of the month
monthTEXTMonthNumber of the month
nowTIMESTAMPNowCurrent timestamp
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_month_nameTEXTYear month nameYear and month with the month name written out, e.g. "Jan 2025".
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20