MAIPs - Media Analytics & Insights

MAIP Dataset Management

View, search, edit, and bulk-exclude MAIP raw mention records.

Bulk Exclusion (WHERE DSL)

Use a restricted SQL-like WHERE clause to find and soft-delete matching rows. Excluded rows are hidden from analytics and can be undone.

WHERE DSL syntax help
Examples:
  platform = 'Facebook'
  platform = 'Facebook' AND manual_sentiment = 'negative'
  (platform = 'Twitter' OR platform = 'Facebook') AND manual_sentiment = 'positive'
  reach > 1000
  title NOT LIKE '%spam%'
  title NOT ILIKE '%spam%'

Supported columns: date, time, title, channel, author, url, platform,
  groupName, keywordName, manualSentiment, autoSentiment, mentionSnippet,
  languages, locations, tags, reach, virality, engagementRate, interactions,
  followersCount, likeCount, commentCount, shareCount

Operators: =, !=, <, >, <=, >=, LIKE, ILIKE, NOT LIKE, NOT ILIKE, IN (a, b), NOT IN (a, b)
Connectives: AND, OR, ( )
Restores the most recently excluded batch.
per page...
IDDateTitlePlatformAuthorChannelSentimentActions