SQPs & TopSearchTerms + Ai + Amazon Search Api
Testing a way to find underutilised keyword opportunities with ai (NLPS) on amazon top search term reports.
i)Download June SQPS & Top Search Terms
ii)Clean the files with python pandas.Left only with keywords.
iii)Run a similarity match algorithm using NLPS (a score given if a keyword in your SQP is related/similar to any of topS terms list of keywords).
iii)Filtered keywords 80%(0,8>) as matched keywords.
iv)Run these matched keywords with amazon search api ,to get their organic & sponsored ranks data.
Sample SERPS for 'foldable floor chair' keyword
| Keyword | ASIN | Rank | Title | Image | Price | Rating | Reviews | Prime |
|---|---|---|---|---|---|---|---|---|
| foldable floor chair | B07B3Q485Y | 1 | Nnewvante Floor Chair Adjustable Back Support Chair Foldable Meditation Seating Suede-Like Fabric Multiangle Cushioned Recliner for Adults Kids Video-Gaming Reading Watching, Navy |  |
$68.99 | 4.5 | 458 | True |
| foldable floor chair | B0D3H74TNP | 2 | Floor Chair with Back Support Folding Chair with 6 Adjustable Position, Padded Sleeper Bed, Floor Gaming Chair, Meditation Chair, Gaming Floor Chairs for Adults |  |
$59.99 | 4.8 | 28 | True |
| foldable floor chair | B0C3QGZ18K | 3 | Folding Floor Gaming Chair 14-Position Cushioned Adjustable Floor Lazy Sofa Chair w/Breathable Cotton & Skin-Friendly Flannel for Adults & Kids Perfect for Reading Gaming Meditating, Camel |  |
$54.99 | 4.4 | 240 | True |
| foldable floor chair | B09KG6P6B2 | 4 | WAYTRIM 5-Position Indoor Adjustable Floor Chair, Padded Teens Adults Gaming Sofa Chair with Backrest, Perfect for Living Room, Bedroom - Charcoal |  |
$57.99 | 4.2 | 55 | True |
| foldable floor chair | B073DWN65X | 5 | Giantex Floor Chair with Back Support, Folding Sofa Chair with 14 Adjustable Position, Padded Sleeper Bed, Couch Recliner, Floor Gaming Chair, Meditation Chair, Gaming Floor Chairs for Adults(Grey) |  |
$62.99 | 4.3 | 3638 | True |
| foldable floor chair | B005D2ALI6 | 6 | Stansport Go Anywhere Chair G-7-25 Polyester Gray Portable |  |
$39.09 | 4.5 | 990 | |
| foldable floor chair | B003399128 | 7 | Coleman Portable Stadium Seat Cushion | Lightweight Padded Seat for Sporting Events and Outdoor Concerts | Bleacher Cushion with Backrest |  |
$14.76 | 4 | 13956 | True |
| foldable floor chair | B0012RI37C | 8 | ONIVA - a Picnic Time brand - Oniva Stadium Seat - Reclining Bleacher Seat with Back Support - Portable Recreation Recliner - Beach Seat |  |
$48.49 | 4.6 | 1491 |
Based on your organic and & sponsored ranks you can then take decisions (which your teams know better than me how to)
Talk To Us
NOTE:This API is not suitable for firms below 1M keywords/Asins required to monitor DAILY.
Aggregators/ppc softwares who already have data teams here's documentation email me info@asgardata.com to get a private api key to test it at scale.
Ppc managers/brand & agency owners email me keywords directly so you do not deal with technical stuff..