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)
| ID | Type | Name | Description |
|---|---|---|---|
| actual_impressions | NUMERIC | Actual Impressions | Impressions that a CreatorIQ user entered manually, often from a creator screenshot. |
| actual_reach | NUMERIC | Actual Reach | Reach that a CreatorIQ user entered manually, often from a creator screenshot. |
| base_metric | TEXT | Base Metric | The denominator used to calculate the engagement rate, for example Followers or Impressions. |
| base_metric_value | NUMERIC | Base Metric Value | Value of the base metric used to calculate the engagement rate. |
| campaign_id | TEXT | Campaign ID | The unique ID of the campaign. |
| campaign_name | TEXT | Campaign Name | The name of the campaign. |
| clicks | NUMERIC | Clicks | Number of times the post was clicked. |
| combined_clicks | NUMERIC | Combined Clicks | Paid clicks + clicks. |
| combined_comments | NUMERIC | Combined Comments | Paid comments + comments. |
| combined_impressions | NUMERIC | Combined Impressions | Paid impressions + impressions. |
| combined_likes | NUMERIC | Combined Likes | Paid likes + likes. |
| combined_reach | NUMERIC | Combined Reach | Paid reach + reach. |
| combined_saves | NUMERIC | Combined Saves | Paid saves + saves. |
| combined_views | NUMERIC | Combined Views | Paid views + views. |
| comments | NUMERIC | Comments | Number of comments. |
| engagement | NUMERIC | Engagement | Likes + comments + shares, the total number of actions. |
| estimated_impressions | NUMERIC | Estimated Impressions | Impressions that CreatorIQ estimated for the post. |
| estimated_reach | NUMERIC | Estimated Reach | Reach that CreatorIQ estimated for the post. |
| estimated_unique_stream_views | NUMERIC | Estimated Unique Stream Views | Aggregate number of views on all live streams. |
| extended_reach | NUMERIC | Extended Reach | Sum of the followers of the accounts that reposted the post. |
| facebook_comments | NUMERIC | Facebook Comments | Number of Facebook comments. |
| facebook_likes | NUMERIC | Facebook Likes | Number of Facebook likes. |
| follows | NUMERIC | Follows | Number of accounts that started to follow the creator. |
| impressions | NUMERIC | Impressions | Number of impressions of the post. |
| last_updated | Last Updated | The time when CreatorIQ last updated the post metrics. | |
| likes | NUMERIC | Likes | Number of likes. |
| link_clicks | NUMERIC | Link Clicks | Number of clicks on the creator link. |
| linked | BOOLEAN | Linked | Whether the post is linked to the campaign. |
| linked_at | Linked At | The time when the post was linked to the campaign. | |
| network_impressions | NUMERIC | Network Impressions | Impressions that the social network reported for an authenticated account. |
| network_reach | NUMERIC | Network Reach | Reach that the social network reported for an authenticated account. |
| paid_clicks | NUMERIC | Paid Clicks | Number of clicks on the ads of the post. |
| paid_comments | NUMERIC | Paid Comments | Number of comments on the ads of the post. |
| paid_impressions | NUMERIC | Paid Impressions | Number of times the ads of the post were on screen. |
| paid_likes | NUMERIC | Paid Likes | Number of people that reacted to the ads of the post. |
| paid_link_clicks | NUMERIC | Paid Link Clicks | Number of clicks on ad links that lead off the social network. |
| paid_reach | NUMERIC | Paid Reach | Number of people who saw the ads of the post at least once. |
| paid_saves | NUMERIC | Paid Saves | Number of times the ads of the post were saved. |
| paid_unique_clicks | NUMERIC | Paid Unique Clicks | Number of people that clicked the ads of the post. |
| paid_unique_comments | NUMERIC | Paid Unique Comments | Number of people that commented on the ads of the post. |
CreatorIQ Campaign Activity fields (paid_unique_link_clicks to user_name_title)
| ID | Type | Name | Description |
|---|---|---|---|
| paid_unique_link_clicks | NUMERIC | Paid Unique Link Clicks | Number of people that clicked links in the ads of the post. |
| paid_views | NUMERIC | Paid Views | Number of times the video ads of the post were viewed for at least three seconds. |
| peak_stream_concurrent_views | NUMERIC | Peak Stream Concurrent Views | Maximum number of people that watched the stream at the same time. |
| post | TEXT | Post | The text of the post. |
| post_activity_id | TEXT | Post Activity ID | The unique ID of the post record in the campaign. |
| post_clicks | NUMERIC | Post Clicks | Number of times the post was clicked. |
| post_link | TEXT | Post Link | The URL of the post. |
| post_title | TEXT | Post title | The title of the post. |
| post_type | TEXT | Post Type | The type of the post on the social network, for example reel, story or video. |
| post_view_count | NUMERIC | Post View Count | Number of post views. |
| publisher_id | TEXT | Publisher ID | The unique ID of the publisher (creator). |
| publisher_name | TEXT | Publisher Name | The name of the publisher (creator). |
| reach | NUMERIC | Reach | Number of people who saw the post. |
| replies | NUMERIC | Replies | Messages sent in reply to a story. |
| saves | NUMERIC | Saves | Number of times the post was saved. |
| social_network | TEXT | Social Network Name | The social network of the post. |
| sticker_taps | NUMERIC | Sticker Taps | Interactions with stickers such as geotags or hashtags. |
| submitted_time | Submitted Time | The time when the post was submitted, as CreatorIQ returns it with no time zone offset. | |
| submitted_time_utc | Submitted Time UTC | The time when the post was submitted, in UTC. | |
| swipe_aways | NUMERIC | Swipe Aways | Times the audience swiped to the story of the next user. |
| swipe_ups | NUMERIC | Story Swipe Ups | Times the audience clicked stickers that link to an external URL. |
| taps_back | NUMERIC | Taps Back | Times the audience tapped back to replay a story. |
| taps_forward | NUMERIC | Taps Forward | Times the audience tapped forward to the next story of the same creator. |
| total_reach | NUMERIC | Total Reach | Sum of reach and extended reach. |
| total_shares | NUMERIC | Total Shares | Number of times the audience shared the post. |
| user_name | TEXT | User Name | The username of the creator on the social network. |
| user_name_title | TEXT | User Name Title | The display title of the creator username. |
CreatorIQ General fields
The General report of the CreatorIQ connector includes 3 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| account_id | TEXT | Account ID | The Windsor account ID for the connection. |
| account_name | TEXT | Account Name | The Windsor account name for the connection. |
| date | DATE | Date | The 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.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| data_fetched_at | Data fetched at | UTC 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. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |
