CreateInsightSchema
Creates a schema file for an insight.
Input
| Name | Type | Accepts Output Streams | Description |
| InsightName | String | False | The name of the insight to create a table for.
The allowed values are PAGE_ENGAGED_USERS, PAGE_FANS_GENDER_AGE, PAGE_FANS_ONLINE, PAGE_FANS_ONLINE_PER_DAY, PAGE_IMPRESSIONS_BY_AGE_GENDER_UNIQUE, PAGE_IMPRESSIONS_BY_CITY_UNIQUE, PAGE_IMPRESSIONS_BY_COUNTRY_UNIQUE, PAGE_IMPRESSIONS_BY_LOCALE_UNIQUE, PAGE_IMPRESSIONS_FREQUENCY_DISTRIBUTION, PAGE_IMPRESSIONS_ORGANIC, PAGE_IMPRESSIONS_ORGANIC_UNIQUE, PAGE_IMPRESSIONS_PAID_UNIQUE, PAGE_IMPRESSIONS_UNIQUE, PAGE_IMPRESSIONS_VIRAL_FREQUENCY_DISTRIBUTION, PAGE_IMPRESSIONS_VIRAL_UNIQUE, PAGE_NEGATIVE_FEEDBACK, PAGE_NEGATIVE_FEEDBACK_UNIQUE, PAGE_PLACES_CHECKIN_MOBILE, PAGE_PLACES_CHECKIN_MOBILE_UNIQUE, PAGE_PLACES_CHECKIN_TOTAL, PAGE_PLACES_CHECKIN_TOTAL_UNIQUE, PAGE_PLACES_CHECKINS_BY_AGE_GENDER, PAGE_PLACES_CHECKINS_BY_COUNTRY, PAGE_PLACES_CHECKINS_BY_LOCALE, PAGE_POSTS_IMPRESSIONS, PAGE_POSTS_IMPRESSIONS_FREQUENCY_DISTRIBUTION, PAGE_POSTS_IMPRESSIONS_ORGANIC, PAGE_POSTS_IMPRESSIONS_ORGANIC_UNIQUE, PAGE_POSTS_IMPRESSIONS_PAID, PAGE_POSTS_IMPRESSIONS_PAID_UNIQUE, PAGE_POSTS_IMPRESSIONS_UNIQUE, PAGE_POSTS_IMPRESSIONS_VIRAL, PAGE_POSTS_IMPRESSIONS_VIRAL_UNIQUE, PAGE_STORIES, PAGE_STORIES_BY_STORY_TYPE, PAGE_STORYTELLERS, PAGE_CONTENT_ACTIVITY_BY_AGE_GENDER_UNIQUE, PAGE_CONTENT_ACTIVITY_BY_CITY_UNIQUE, PAGE_CONTENT_ACTIVITY_BY_COUNTRY_UNIQUE, PAGE_CONTENT_ACTIVITY_BY_LOCALE_UNIQUE, PAGE_STORYTELLERS_BY_STORY_TYPE, PAGE_TAB_VIEWS_LOGIN_TOP, PAGE_TAB_VIEWS_LOGIN_TOP_UNIQUE, PAGE_TAB_VIEWS_LOGOUT_TOP, PAGE_VIDEO_COMPLETE_VIEWS_30S, PAGE_VIDEO_COMPLETE_VIEWS_30S_AUTOPLAYED, PAGE_VIDEO_COMPLETE_VIEWS_30S_CLICK_TO_PLAY, PAGE_VIDEO_COMPLETE_VIEWS_30S_ORGANIC, PAGE_VIDEO_COMPLETE_VIEWS_30S_PAID, PAGE_VIDEO_COMPLETE_VIEWS_30S_REPEAT_VIEWS, PAGE_VIDEO_COMPLETE_VIEWS_30S_UNIQUE, PAGE_VIDEO_REPEAT_VIEWS, PAGE_VIDEO_VIEW_TIME, PAGE_VIDEO_VIEWS, PAGE_VIDEO_VIEWS_AUTOPLAYED, PAGE_VIDEO_VIEWS_CLICK_TO_PLAY, PAGE_VIDEO_VIEWS_ORGANIC, PAGE_VIDEO_VIEWS_PAID, PAGE_VIDEO_VIEWS_UNIQUE, PAGE_VIEWS, PAGE_VIEWS_EXTERNAL_REFERRALS, PAGE_VIEWS_LOGIN, PAGE_VIEWS_LOGIN_UNIQUE, PAGE_VIEWS_LOGOUT, PAGE_VIEWS_UNIQUE, POST_CONSUMPTIONS, POST_CONSUMPTIONS_BY_TYPE, POST_CONSUMPTIONS_BY_TYPE_UNIQUE, POST_CONSUMPTIONS_UNIQUE, POST_ENGAGED_USERS, POST_IMPRESSIONS_FAN_PAID, POST_IMPRESSIONS_FAN_PAID_UNIQUE, POST_IMPRESSIONS_FAN_UNIQUE, POST_IMPRESSIONS_ORGANIC, POST_IMPRESSIONS_ORGANIC_UNIQUE, POST_IMPRESSIONS_PAID_UNIQUE, POST_IMPRESSIONS_UNIQUE, POST_IMPRESSIONS_VIRAL_UNIQUE, POST_NEGATIVE_FEEDBACK, POST_NEGATIVE_FEEDBACK_UNIQUE, POST_STORIES, POST_STORIES_BY_ACTION_TYPE, POST_STORYTELLERS, POST_STORYTELLERS_BY_ACTION_TYPE, POST_VIDEO_AVG_TIME_WATCHED, POST_VIDEO_COMPLETE_VIEWS_ORGANIC, POST_VIDEO_COMPLETE_VIEWS_ORGANIC_UNIQUE, POST_VIDEO_COMPLETE_VIEWS_PAID, POST_VIDEO_COMPLETE_VIEWS_PAID_UNIQUE, POST_VIDEO_RETENTION_GRAPH, POST_VIDEO_RETENTION_GRAPH_AUTOPLAYED, POST_VIDEO_RETENTION_GRAPH_CLICKED_TO_PLAY, POST_VIDEO_VIEW_TIME_BY_AGE_BUCKET_AND_GENDER, POST_VIDEO_VIEW_TIME_BY_COUNTRY_ID, POST_VIDEO_VIEW_TIME_BY_DISTRIBUTION_TYPE, POST_VIDEO_VIEW_TIME_BY_REGION_ID, POST_VIDEO_VIEWS_BY_DISTRIBUTION_TYPE, POST_VIDEO_VIEWS_ORGANIC, POST_VIDEO_VIEWS_ORGANIC_UNIQUE, POST_VIDEO_VIEWS_PAID, POST_VIDEO_VIEWS_PAID_UNIQUE, POST_ACTIVITY_BY_ACTION_TYPE, POST_ACTIVITY_BY_ACTION_TYPE_UNIQUE, PAGE_ACTIONS_POST_REACTIONS_TOTAL, POST_REACTIONS_BY_TYPE_TOTAL, PAGE_ACTIONS_POST_REACTIONS_ANGER_TOTAL, PAGE_ACTIONS_POST_REACTIONS_HAHA_TOTAL, PAGE_ACTIONS_POST_REACTIONS_LIKE_TOTAL, PAGE_ACTIONS_POST_REACTIONS_LOVE_TOTAL, PAGE_ACTIONS_POST_REACTIONS_SORRY_TOTAL, PAGE_ACTIONS_POST_REACTIONS_WOW_TOTAL, POST_REACTIONS_LIKE_TOTAL, POST_REACTIONS_LOVE_TOTAL, POST_REACTIONS_WOW_TOTAL, POST_REACTIONS_HAHA_TOTAL, POST_REACTIONS_SORRY_TOTAL, POST_REACTIONS_ANGER_TOTAL, PAGE_FOLLOWS, PAGE_FOLLOWS_CITY, PAGE_FOLLOWS_COUNTRY, PAGE_MEDIA_VIEW, POST_MEDIA_VIEW. |
| Target | String | False | The default target for this insight. |
| FromDateTime | String | False | The earliest date and time value for which to return insight data. This will override the Periods input and in some insights is required. |
| ToDateTime | String | False | The latest date and time value for which to return insight data. This will override the Periods input and in some insights is required. |
| Description | String | False | An optional description for the insight. This will override the description that comes from the data source. |
| FileStream | String | True | An instance of an output stream where file data is written to. |
Result Set Columns
| Name | Type | Description |
| Result | String | Returns Success or Failure. |
| SchemaFile | String | The generated schema file. You will need to set the Location connection property to the folder containing your schema files. |
| Columns | String | The number of columns found. |