tool

• id: 5738
  tools_id: AOAT-005738
  tools_url: https://yotpo.com
  tools_name: Yotpo
  publish_date: 2011-01-02
  is_active: 1
  created_at: 2025-07-23T05:58:33.471061
  updated_at: 2025-07-27T08:15:21.895024
  company_domain:
  

---

badges

• tool_id: 5738
  badge_id: 35
  is_active:
  created_at: 2025-08-31T11:36:08.173102
  value: 1
  id: 60787
  updated_at: 2025-08-31T12:56:27.351129
  value_text:
  

---

• tool_id: 5738
  badge_id: 17
  is_active: 1
  created_at: 2025-07-21T12:34:50.291939
  value: 1
  id: 7900
  updated_at: 2025-07-27T08:11:45.309133
  value_text:
  

---

• tool_id: 5738
  badge_id: 25
  is_active: 1
  created_at: 2025-08-18T15:06:08.489155
  value: 16621
  id: 33593
  updated_at: 2025-08-18T15:06:08.489155
  value_text:
  

---

• tool_id: 5738
  badge_id: 26
  is_active: 1
  created_at: 2025-08-30T10:36:54.693492
  value: 1
  id: 47158
  updated_at: 2025-08-30T10:36:54.693492
  value_text:
  

---

images

• image_id: 68448
  tool_id: 5738
  image_url: https://ageofai.tools/wp-content/uploads/fullsc/fullsc-5738-AloUh.png
  image_type: homefullsc
  alt_text:
  order:
  is_active: 1
  created_at: 2025-08-11T16:34:26.65864
  updated_at: 2025-08-11T16:34:26.65864
  

---

• image_id: 15879
  tool_id: 5738
  image_url: https://ageofai.tools/wp-content/uploads/logo/AOAT-005738-logo.png
  image_type: logo
  alt_text:
  order:
  is_active: 1
  created_at: 2025-07-23T06:21:01.537453
  updated_at: 2025-07-27T08:07:15.656641
  

---

• image_id: 15880
  tool_id: 5738
  image_url: https://ageofai.tools/wp-content/uploads/sc/AOAT-005738-sc-11569.png
  image_type: screenshot
  alt_text:
  order:
  is_active: 1
  created_at: 2025-07-23T06:21:01.537453
  updated_at: 2025-07-27T08:07:15.656641
  

---

pricing_models

• tool_id: 5738
  pricing_model_id: 3
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 2121
  updated_at: 2025-07-27T08:16:13.168523
  

---

all_pricing_models

• pricing_model_id: 9
  pricing_model_name: Hybrid Models
  is_active:
  sort: 0
  

---

• pricing_model_id: 10
  pricing_model_name: Deprecated/Legacy
  is_active:
  sort: 0
  

---

• pricing_model_id: 1
  pricing_model_name: Free
  is_active: 1
  sort: 1
  

---

• pricing_model_id: 2
  pricing_model_name: Freemium
  is_active: 1
  sort: 2
  

---

• pricing_model_id: 12
  pricing_model_name: Free Trial
  is_active: 1
  sort: 3
  

---

• pricing_model_id: 3
  pricing_model_name: Subscription
  is_active: 1
  sort: 6
  

---

• pricing_model_id: 4
  pricing_model_name: Pay-As-You-Go (PAYG)
  is_active: 1
  sort: 4
  

---

• pricing_model_id: 5
  pricing_model_name: One-Time Purchase
  is_active: 1
  sort: 7
  

---

• pricing_model_id: 6
  pricing_model_name: Credit or Token-Based
  is_active: 1
  sort: 5
  

---

• pricing_model_id: 7
  pricing_model_name: Custom Pricing
  is_active: 1
  sort: 8
  

---

• pricing_model_id: 8
  pricing_model_name: Performance-Based
  is_active: 1
  sort: 9
  

---

• pricing_model_id: 11
  pricing_model_name: Miscellaneous
  is_active: 1
  sort: 10
  

---

active_pricing_model_names

ratings

• rating_id: 104955
  tool_id: 5738
  source_id: 3
  score: 4.997180333
  weight:
  comment:
  created_at: 2025-10-21T05:44:17.892549
  is_active: 1
  updated_at: 2025-10-21T05:44:17.892549
  

---

• rating_id: 88679
  tool_id: 5738
  source_id: 3
  score: 4.9971505
  weight:
  comment:
  created_at: 2025-09-18T00:27:06.78467
  is_active: 1
  updated_at: 2025-09-18T00:27:06.78467
  

---

• rating_id: 66554
  tool_id: 5738
  source_id: 3
  score: 4.99723
  weight:
  comment:
  created_at: 2025-08-12T15:29:38.463924
  is_active: 1
  updated_at: 2025-08-12T15:29:38.463924
  

---

• rating_id: 5738
  tool_id: 5738
  source_id: 3
  score: 4.995278
  weight:
  comment:
  created_at: 2025-06-28T07:49:38.28653
  is_active: 1
  updated_at: 2025-07-27T08:17:24.286376
  

---

seo

• seo_id: 5738
  tool_id: 5738
  title: Boost E-commerce Success with Yotpo's Reviews & Loyalty
  tldr:
  short_description: Boost e-commerce sales with Yotpo's customer reviews, loyalty programs, and UGC tools.
  introduction_title: Yotpo: Unlocking the Power of AI for Enhanced eCommerce Marketing and Customer Engagement
  introduction_body: Yotpo is a leading commerce marketing cloud that empowers eCommerce brands to leverage AI-driven solutions for enhanced customer engagement and retention. Unlike typical AI image generators or AI photo editing tools, Yotpo focuses on harnessing the power of user-generated content (UGC) and AI to create personalized customer experiences. It helps businesses collect, manage, and showcase customer reviews and ratings, while also integrating AI design principles to optimize product pages. By using AI to highlight key review content and filter relevant feedback, Yotpo enhances customer confidence and drives sales. This platform assists brands in building loyalty programs and crafting personalized marketing strategies, making it an indispensable tool for businesses aiming to boost customer lifetime value and accelerate growth.
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  updated_at: 2025-07-27T08:11:20.221553
  

---

social_media

• tool_id: 5738
  network_id: 12
  social_media_url: https://linkedin.com/company/yotpo
  is_active: 1
  created_at: 2025-07-01T18:37:06.603568
  id: 7492
  updated_at: 2025-07-27T08:14:10.033253
  

---

• tool_id: 5738
  network_id: 13
  social_media_url: https://instagram.com/yotpo
  is_active: 1
  created_at: 2025-07-01T18:37:06.603568
  id: 7493
  updated_at: 2025-07-27T08:14:10.033253
  

---

• tool_id: 5738
  network_id: 14
  social_media_url: https://twitter.com/yotpo
  is_active: 1
  created_at: 2025-07-01T18:37:06.603568
  id: 7494
  updated_at: 2025-07-27T08:14:10.033253
  

---

• tool_id: 5738
  network_id: 15
  social_media_url: https://facebook.com/yotpo
  is_active: 1
  created_at: 2025-07-01T18:37:06.603568
  id: 7495
  updated_at: 2025-07-27T08:14:10.033253
  

---

• tool_id: 5738
  network_id: 16
  social_media_url: womeninecomm@yotpo.com
  is_active: 1
  created_at: 2025-07-01T18:37:06.603568
  id: 7496
  updated_at: 2025-07-27T08:14:10.033253
  

---

tags

• tool_id: 5738
  tag_id: 115
  weight: 1
  is_active: 1
  created_at: 2025-08-26T10:40:48.657343
  id: 106409
  updated_at: 2025-08-26T10:40:48.657343
  

---

• tool_id: 5738
  tag_id: 63
  weight: 2
  is_active: 1
  created_at: 2025-08-26T10:40:49.11882
  id: 106410
  updated_at: 2025-08-26T10:40:49.11882
  

---

• tool_id: 5738
  tag_id: 90
  weight: 3
  is_active: 1
  created_at: 2025-08-26T10:40:49.558254
  id: 106411
  updated_at: 2025-08-26T10:40:49.558254
  

---

• tool_id: 5738
  tag_id: 36
  weight: 4
  is_active: 1
  created_at: 2025-08-26T10:40:50.004689
  id: 106412
  updated_at: 2025-08-26T10:40:50.004689
  

---

• tool_id: 5738
  tag_id: 27
  weight: 5
  is_active: 1
  created_at: 2025-08-26T10:40:50.444541
  id: 106413
  updated_at: 2025-08-26T10:40:50.444541
  

---

• tool_id: 5738
  tag_id: 81
  weight: 6
  is_active: 1
  created_at: 2025-08-26T10:40:50.894994
  id: 106414
  updated_at: 2025-08-26T10:40:50.894994
  

---

• tool_id: 5738
  tag_id: 181
  weight: 7
  is_active: 1
  created_at: 2025-08-26T10:40:51.335125
  id: 106415
  updated_at: 2025-08-26T10:40:51.335125
  

---

• tool_id: 5738
  tag_id: 207
  weight: 8
  is_active: 1
  created_at: 2025-08-26T10:40:51.77764
  id: 106416
  updated_at: 2025-08-26T10:40:51.77764
  

---

• tool_id: 5738
  tag_id: 108
  weight: 9
  is_active: 1
  created_at: 2025-08-26T10:40:52.236819
  id: 106417
  updated_at: 2025-08-26T10:40:52.236819
  

---

• tool_id: 5738
  tag_id: 156
  weight: 10
  is_active: 1
  created_at: 2025-08-26T10:40:52.686718
  id: 106418
  updated_at: 2025-08-26T10:40:52.686718
  

---

toolsets

• tool_id: 5738
  toolset_id: 8
  weight: 1
  is_active:
  created_at: 2025-07-23T06:17:37.581901
  id: 58763
  updated_at: 2025-08-25T13:32:12.896129
  

---

• tool_id: 5738
  toolset_id: 6
  weight: 2
  is_active:
  created_at: 2025-07-23T06:17:37.581901
  id: 58764
  updated_at: 2025-08-25T13:32:12.896129
  

---

• tool_id: 5738
  toolset_id: 21
  weight: 3
  is_active:
  created_at: 2025-07-23T06:17:37.581901
  id: 58765
  updated_at: 2025-08-25T13:32:12.896129
  

---

• tool_id: 5738
  toolset_id: 29
  weight: 4
  is_active:
  created_at: 2025-07-23T06:17:37.581901
  id: 58766
  updated_at: 2025-08-25T13:32:12.896129
  

---

• tool_id: 5738
  toolset_id: 47
  weight: 5
  is_active:
  created_at: 2025-07-23T06:17:37.581901
  id: 58767
  updated_at: 2025-08-25T13:32:12.896129
  

---

• tool_id: 5738
  toolset_id: 14
  weight: 1
  is_active: 1
  created_at: 2025-08-25T13:32:26.849408
  id: 144972
  updated_at: 2025-08-25T17:02:02.843
  

---

• tool_id: 5738
  toolset_id: 30
  weight: 2
  is_active: 1
  created_at: 2025-08-25T13:32:27.30118
  id: 144973
  updated_at: 2025-08-25T17:02:02.843
  

---

• tool_id: 5738
  toolset_id: 17
  weight: 3
  is_active: 1
  created_at: 2025-08-25T13:32:27.746724
  id: 144974
  updated_at: 2025-08-25T17:02:02.843
  

---

• tool_id: 5738
  toolset_id: 22
  weight: 4
  is_active: 1
  created_at: 2025-08-25T13:32:28.198186
  id: 144975
  updated_at: 2025-08-25T17:02:02.843
  

---

jobs

• tool_id: 5738
  job_id: 42
  weight: 1
  is_active:
  created_at: 2025-07-23T06:17:37.581901
  id: 135926
  updated_at: 2025-08-26T09:53:52.28157
  

---

• tool_id: 5738
  job_id: 5
  weight: 1
  is_active: 1
  created_at: 2025-08-26T09:54:11.253848
  id: 279884
  updated_at: 2025-08-26T13:23:50.532
  

---

• tool_id: 5738
  job_id: 35
  weight: 2
  is_active: 1
  created_at: 2025-08-26T09:54:12.142086
  id: 279885
  updated_at: 2025-08-26T13:23:50.532
  

---

• tool_id: 5738
  job_id: 29
  weight: 3
  is_active: 1
  created_at: 2025-08-26T09:54:12.58659
  id: 279886
  updated_at: 2025-08-26T13:23:50.532
  

---

• tool_id: 5738
  job_id: 20
  weight: 4
  is_active: 1
  created_at: 2025-08-26T09:54:13.038266
  id: 279887
  updated_at: 2025-08-26T13:23:50.532
  

---

• tool_id: 5738
  job_id: 12
  weight: 5
  is_active: 1
  created_at: 2025-08-26T09:54:13.481873
  id: 279888
  updated_at: 2025-08-26T13:23:50.532
  

---

• tool_id: 5738
  job_id: 7
  weight: 6
  is_active: 1
  created_at: 2025-08-26T09:54:13.918459
  id: 279889
  updated_at: 2025-08-26T13:23:50.532
  

---

• tool_id: 5738
  job_id: 21
  weight: 7
  is_active: 1
  created_at: 2025-08-26T09:54:14.360661
  id: 279890
  updated_at: 2025-08-26T13:23:50.532
  

---

• tool_id: 5738
  job_id: 39
  weight: 8
  is_active: 1
  created_at: 2025-08-26T09:54:14.798972
  id: 279891
  updated_at: 2025-08-26T13:23:50.532
  

---

platforms

• tool_id: 5738
  platform_id: 1
  priority: 1
  platform_url: https://yotpo.com
  is_active:
  created_at: 2025-07-23T06:17:37.581901
  id: 5736
  updated_at: 2025-08-15T23:04:40.681
  

---

• tool_id: 5738
  platform_id: 1
  priority: 1
  platform_url: https://yotpo.com
  is_active: 1
  created_at: 2025-08-15T19:34:42.372219
  id: 35307
  updated_at: 2025-08-15T19:34:42.372219
  

---

score_log

• log_id: 212877
  tool_id: 5738
  final_score: 4.49
  logged_at: 2025-10-21T05:44:17.892549
  change_reason: New rating added | Coverage: 8.6% | Penalty: 0.8982
  triggered_by: System
  source_summary: Similar web Raiting: 4.997180333 (w=58.000) | Base Score: 4.997 | Final: 4.488
  final_score_2: 4.4884823666
  

---

• log_id: 203453
  tool_id: 5738
  final_score: 4.49
  logged_at: 2025-09-18T00:27:06.78467
  change_reason: New rating added | Coverage: 8.6% | Penalty: 0.8982
  triggered_by: System
  source_summary: Similar web Raiting: 4.997150500 (w=58.000) | Base Score: 4.997 | Final: 4.488
  final_score_2: 4.4884555706
  

---

• log_id: 181852
  tool_id: 5738
  final_score: 4.49
  logged_at: 2025-08-19T16:20:53.067949
  change_reason: rating_sources changed | Coverage: 8.6% | Penalty: 0.8982
  triggered_by: System
  source_summary: Similar web Raiting: 4.997230000 (w=58.000) | Base Score: 4.997 | Final: 4.489
  final_score_2: 4.4885269777
  

---

• log_id: 166307
  tool_id: 5738
  final_score: 4.5
  logged_at: 2025-08-19T16:20:25.813463
  change_reason: rating_sources changed | Coverage: 10.2% | Penalty: 0.8999
  triggered_by: System
  source_summary: Similar web Raiting: 4.997230000 (w=59.000) | Base Score: 4.997 | Final: 4.497
  final_score_2: 4.4971521967
  

---

• log_id: 149506
  tool_id: 5738
  final_score: 4.49
  logged_at: 2025-08-12T15:29:38.463924
  change_reason: New rating added | Coverage: 8.6% | Penalty: 0.8982
  triggered_by: System
  source_summary: Similar web Raiting: 4.997230000 (w=58.000) | Base Score: 4.997 | Final: 4.489
  final_score_2: 4.4885269777
  

---

• log_id: 147173
  tool_id: 5738
  final_score: 4.49
  logged_at: 2025-08-12T06:15:25.263278
  change_reason: Rating source weights updated | Coverage: 8.6% | Penalty: 0.8982
  triggered_by: System
  source_summary: Similar web Raiting: 4.995278000 (w=58.000) | Base Score: 4.995 | Final: 4.487
  final_score_2: 4.4867736854
  

---

• log_id: 129532
  tool_id: 5738
  final_score: 4.5
  logged_at: 2025-08-11T16:36:22.187859
  change_reason: Applied precise penalty formula - Similar Web = 4.5 | Coverage: 10.2% | Penalty: 0.9000
  triggered_by: Manual Refresh
  source_summary: Similar web Raiting: 4.995278000 (w=49.000) | Base Score: 4.995 | Final: 4.496
  final_score_2: 4.4955853558
  

---

• log_id: 118399
  tool_id: 5738
  final_score: 3.87
  logged_at: 2025-08-11T16:32:06.680827
  change_reason: Applied milder penalty formula - v2 | Coverage: 10.2% | Penalty: 0.776
  triggered_by: Manual Refresh
  source_summary: Similar web Raiting: 4.995278000 (w=49.000) | Base Score: 4.995 | Final: 3.874
  final_score_2: 3.8738880418
  

---

• log_id: 107266
  tool_id: 5738
  final_score: 2.75
  logged_at: 2025-08-11T16:28:07.06408
  change_reason: Applied new fair penalty system | Coverage: 10.2% | Penalty: 0.551
  triggered_by: Manual Refresh
  source_summary: Similar web Raiting: 4.995278000 (w=49.000) | Base Score: 4.995 | Final: 2.753
  final_score_2: 2.7525030788
  

---

• log_id: 96133
  tool_id: 5738
  final_score: 5
  logged_at: 2025-08-11T16:16:08.254948
  change_reason: weights updated to defaults
  triggered_by: Manual
  source_summary: Similar web Raiting: 4.995278000 (w=49.000)
  final_score_2: 4.995278
  

---

• log_id: 70367
  tool_id: 5738
  final_score: 0.51
  logged_at: 2025-08-11T16:10:08.878468
  change_reason: weights updated to defaults
  triggered_by: Manual
  source_summary: Similar web Raiting: 4.995278000 (w=5.00)
  final_score_2: 0.5097222449
  

---

• log_id: 35261
  tool_id: 5738
  final_score: 5
  logged_at: 2025-06-28T07:38:11.151992
  change_reason: New rating added
  triggered_by: System
  source_summary: Similar web Raiting: 4.995278000 (weight: 1.0000)
  final_score_2: 4.995278
  

---

last_update

• tool_id: 5738
  last_update: 2025-08-30T10:36:54.693492
  

---