Query Linkedin Posts
query_linkedin_postsUse this to answer "which of my posts performed best?", "what's my average engagement?", "show me posts from last month", etc. This is the account-global table, with no agent/monitor dimension — for the feed a specific agent's monitors discovered (and to act on it), call query_monitored_posts.
Columns: id, social_id, text, share_url, posted_at, impressions, reactions, comments, reposts, is_own_post, author_name, author_headline, fetched_at, created_at, plus a derived engagement_rate string (reactions+comments+reposts over impressions, matching the UI) — '0.0' for posts with no impression data (e.g. third-party posts). The engagement_rate is computed after the query runs, so it can't appear in where_clause or order_by; filter and sort on the raw columns instead. Dict with count, truncated, and posts array (each row carries the columns above plus the derived engagement_rate).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | default 25, max 200. | |
| offset | No | Rows to skip for paging (default 0). When the result is truncated, re-call with offset += limit for the next page. | |
| order_by | No | default "posted_at DESC". For top performers: "impressions DESC". | posted_at DESC |
| where_clause | No | SQL WHERE. Examples: "posted_at >= NOW() - INTERVAL '30 days'" "impressions > 1000" "text ILIKE '%hiring%'" "is_own_post = false" | 1=1 |