Campaign ID: 269
🔗 Direct LinkAPI Endpoint: api/start_background_scraping.php (POST)
Database Table: campaigns_impact (SELECT)
| Field | Value |
|---|---|
| ID | 269 |
| Title | Coke |
| Keywords | "Coke" |
| Platforms | |
| Status | active |
| Date From | 2026-06-08 |
| Date To | 2026-06-11 |
| Client Keywords | |
| Monitor Links | |
| Relevancy Threshold | 0.70 |
ℹ️ This prepares the campaign for data collection. This step must be completed before Step 2.
API Endpoint: api/collect_data_step2.php (POST)
Database Tables: twitter_raw, youtube_raw, instagram_raw, news_raw, blogs_raw, facebook_raw (INSERT, SELECT COUNT)
Database Table: background_jobs (SELECT)
ℹ️ What this means: Background jobs track long-running scraping processes. If no jobs are found, it means either:
• Scraping completed and jobs were cleaned up
• Scraping happened directly without creating job records (this is normal)
• No background scraping has been started yet
✅ Check Step 3 (Data Collection Status) to see if data was actually collected - that's what matters!
No background jobs found for this campaign
This is normal! Background jobs are optional tracking records. The important thing is whether data was collected - check Step 3 below.
ℹ️ This collects 100 results from each selected platform. This may take 10-20 minutes.
ℹ️ Limits: Loaded from platform_limits table (managed via Settings > Platform Limit)
| Platform | Table Name | Records Count | Limit | Status | Action |
|---|---|---|---|---|---|
twitter_raw | 100 | 1000 | ✓ Data Collected | ||
| Youtube | youtube_raw | 0 | 100 | ⚠ No Data | |
instagram_raw | 0 | 100 | ⚠ No Data | ||
facebook_raw | 0 | 100 | ⚠ No Data | ||
| News | news_raw | 0 | 1000 | ⚠ No Data | |
| Blogs | blogs_raw | 0 | 1000 | ⚠ No Data | |
| Total Records | 100 | - | ✓ Data Available | - | |
API Endpoint: api/check_raw_mentions.php (POST)
OpenAI key: loaded from api_keys_db.api_keys (then OPENAI_API_KEY env, then config). Model: gpt-4o-mini.
Database Tables: twitter_raw, youtube_raw, instagram_raw, news_raw, blogs_raw, facebook_raw (SELECT), ai_relevancy_results (INSERT)
ℹ️ Run sends every raw row to the API with force_reprocess (full pass, re-scores by AI). Re-Run does the same. Batches of 50; large campaigns can take 15+ minutes.
Database Table: ai_jobs (SELECT)
No AI jobs found for this campaign. Click the button above to create AI jobs from raw data.
Total AI Relevancy Results: 100
| Platform | Results Count |
|---|---|
| 100 |
| Relevancy Label | Count |
|---|
| Sentiment | Count |
|---|---|
| positive | 88 |
| neutral | 9 |
| negative | 3 |
| Processing State | Count |
|---|---|
| analyzed | 100 |
| ID | Platform | Platform Post ID | Relevancy Score | Relevancy Label | Sentiment | Processing State | Raw Item ID | Raw Table | Created At |
|---|---|---|---|---|---|---|---|---|---|
| 104761 | 238 | 0.9000 | N/A | positive | analyzed | 238 | twitter_x_api_raw | 2026-06-11 10:18:10 | |
| 104773 | 250 | 0.9000 | N/A | positive | analyzed | 250 | twitter_x_api_raw | 2026-06-11 10:18:10 | |
| 104771 | 248 | 0.9000 | N/A | positive | analyzed | 248 | twitter_x_api_raw | 2026-06-11 10:18:10 | |
| 104739 | 216 | 0.9000 | N/A | positive | analyzed | 216 | twitter_x_api_raw | 2026-06-11 10:18:10 | |
| 104776 | 253 | 0.9000 | N/A | positive | analyzed | 253 | twitter_x_api_raw | 2026-06-11 10:18:10 |
API Endpoint: api/sync_campaign_articles.php (POST)
Database Table: campaign_articles (INSERT/UPDATE, SELECT COUNT, SELECT)
ℹ️ This finalizes all collected data and syncs relevant items to campaign_articles.
Total Campaign Articles: 93
ℹ️ This will sync relevant items (relevancy score ≥ 70% - campaign threshold: 0.7) from ai_relevancy_results to campaign_articles. Note: 93 relevant items found, 0 can be synced (others may already exist in campaign_articles).
| Platform | Articles Count |
|---|---|
| 93 |
| ID | Platform | Platform Post ID | Title/Content | Relevancy Score | Relevancy Label | Sentiment | Sentiment Score | Raw Item ID | Raw Table | Created At |
|---|---|---|---|---|---|---|---|---|---|---|
| 51717 | 208 | #コカコーラ勝敗予想対決 に参戦中⚽第1戦は #ガチ勢の私はメキシコが勝利 と予想！ @CocaCo... | 0.9000 | very_high | positive | 0.8000 | 208 | twitter_x_api_raw | 2026-06-11 10:18:10 | |
| 51718 | 210 | #コカコーラ勝敗予想対決 に参戦中⚽第2戦は #ガチ勢の私はブラジルが勝利 と予想！ @CocaCo... | 0.9000 | very_high | positive | 0.8000 | 210 | twitter_x_api_raw | 2026-06-11 10:18:10 | |
| 51719 | 211 | #コカコーラ勝敗予想対決 に参戦中⚽第1戦は #エンジョイ勢の私はメキシコが勝利 と予想！ @Coc... | 0.9000 | very_high | positive | 0.8000 | 211 | twitter_x_api_raw | 2026-06-11 10:18:10 | |
| 51720 | 212 | #コカコーラ勝敗予想対決 に参戦中⚽第2戦は #エンジョイ勢の私はブラジルが勝利 と予想！ @Coc... | 0.9000 | very_high | positive | 0.8000 | 212 | twitter_x_api_raw | 2026-06-11 10:18:10 | |
| 51721 | 213 | #コカコーラ勝敗予想対決 に参戦中⚽第2戦は #エンジョイ勢の私はモロッコが勝利 と予想！ @Coc... | 0.9000 | very_high | positive | 0.8000 | 213 | twitter_x_api_raw | 2026-06-11 10:18:10 |
| Relevancy Label | Count |
|---|---|
| high | 30 |
| very_high | 63 |
Database Table: background_jobs (SELECT)
ℹ️ Background jobs track long-running scraping processes. This is optional tracking.
No background jobs found for this campaign
Database Table: ai_jobs (SELECT)
No AI jobs found for this campaign
| Metric | Value |
|---|---|
| Campaign ID | 269 |
| Campaign Status | active |
| Relevancy Threshold | 0.70 |
| Total Raw Records Collected | 100 |
| AI Relevancy Results | 100 |
| Campaign Articles (Final) | 93 |
| Background Jobs | 0 |
| AI Jobs | 0 |
| API Service | Provider | Usage |
|---|---|---|
apidojo~tweet-scraper | Apify | Twitter data collection (Step 3) |
streamers~youtube-scraper | Apify | YouTube data collection (Step 3) |
apify~instagram-post-scraper | Apify | Instagram data collection (Step 3) |
| ScrapingDog API | ScrapingDog | News & Blogs data collection (Step 3) |
| OpenAI API | OpenAI | AI relevancy analysis (Step 5) |
| Gemini API | AI relevancy analysis (Step 5, alternative) |
| Step | API Endpoint | Table Name | Operation |
|---|---|---|---|
| Step 1 | api/start_background_scraping.php | campaigns_impact (relevancy_threshold) | SELECT |
| Step 2 | api/collect_data_step2.php | twitter_raw, youtube_raw, instagram_raw, news_raw, blogs_raw, facebook_raw | INSERT, SELECT COUNT |
| Step 3 | api/check_raw_mentions.php | twitter_raw, youtube_raw, instagram_raw, news_raw, blogs_raw, facebook_raw, ai_relevancy_results (platform_post_id, content_hash, processing_state, raw_item_id, raw_table_name) | SELECT, INSERT |
| Step 4 | api/sync_campaign_articles.php | campaign_articles (platform_post_id, matched_terms, ai_reasoning, relevancy_label, sentiment_score, raw_item_id, raw_table_name) | INSERT/UPDATE, SELECT COUNT, SELECT |
| Step | Description | API Endpoint | Duration |
|---|---|---|---|
| Step 1 | Initialize scraping process | api/start_background_scraping.php | 10-20 seconds |
| Step 2 | Collect data from platforms (100 results per platform) | api/collect_data_step2.php | 10-20 minutes |
| Step 3 | AI relevancy analysis (50 mentions per batch) | api/check_raw_mentions.php | 5-7 minutes |
| Step 4 | Complete processing & save results | api/sync_campaign_articles.php | 1-2 minutes |
All steps debugged successfully!
Campaign ID: 269 | Raw Records: 100 | AI Results: 100 | Articles: 93