Jungle Scout
Snapshot
| Feature | Details |
|---|---|
Release status | Released |
Source API version | v1 |
Table selection | Yes |
Column selection | Yes |
Edit integration | Yes |
Replication Type selection | No |
Authentication Parameters | API key, marketplace |
| Tables Supported | Dependent on |
|---|---|
Segments | - |
KeywordsByASINsQuery | ASINs from Segments |
SalesEstimatesQuery | ASINs from Segments |
BrandProductsByDay | Segment ids from Segments |
ShareOfVoice | Keywords from KeywordsByASINsQuery |
Integrate Jungle Scout with Daton
Sign in to Daton.
Select Jungle Scout from the Connectors page.
Provide Integration Name, Replication Frequency, and History. The integration name would be used in creating tables for the integration and cannot be changed later.
Provide Jungle Scout authentication key and marketplace.
Post successful authentication, you will be prompted to choose from the list of available tables.
Select all the required fields for each table.
Submit the integration.
Workflow
Integrations would be in the Pending state initially and will be moved to the Active state as soon as the first job loads data successfully onto the configured warehouse.
Users would be able to edit/pause/re-activate/delete integration anytime.
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list.
Generating the Jungle Scout API key
Go to the Account Settings page.
Generate your API key.
Make sure you take note of both the key name and key value. The key value is ONLY available while generating it so make sure you have it noted down.
The value you must pass in the API key field while setting up the integration is the KEY_NAME:API_KEY. Note the ':' between the both of them.
Jungle Scout Data
Segments
Used to show a list of all segments and query parameters. This is equivalent to the Segment Manager feature table.
Source API documentation: https://developer.junglescout.com/api#endpoints - GET /api/segments
Replication Type: Full load
| Field name | Type |
|---|---|
id | STRING |
type | STRING |
links | STRING |
name | STRING |
processing | BOOLEAN |
created_at | TIMESTAMP |
updated_at | TIMESTAMP |
static | BOOLEAN |
total_brands | NUMERIC |
total_asins | NUMERIC |
not_found_asins | STRING |
country | STRING |
order | STRING |
asins | STRING |
excluded_asins | STRING |
brands | STRING |
excluded_brands | STRING |
title_keywords | STRING |
excluded_title_keywords | STRING |
exclude_unavailable_products | BOOLEAN |
search_terms | STRING |
categories | STRING |
min_price | NUMERIC |
max_price | NUMERIC |
min_monthly_revenue | NUMERIC |
max_monthly_revenue | NUMERIC |
min_reviews | NUMERIC |
max_reviews | NUMERIC |
all_categories | BOOLEAN |
total_brands_trend | NUMERIC |
total_asins_trend | NUMERIC |
total_revenue | NUMERIC |
total_revenue_trend | NUMERIC |
total_unit_sales | NUMERIC |
total_unit_sales_trend | NUMERIC |
average_price | NUMERIC |
average_price_trend | NUMERIC |
monthly_unit_sales | NUMERIC |
monthly_unit_sales_trend | NUMERIC |
average_reviews | NUMERIC |
average_reviews_trend | NUMERIC |
min_monthly_revenue_st | STRING |
min_price_st | STRING |
max_price_st | STRING |
max_monthly_revenue_st | STRING |
min_reviews_st | STRING |
KeywordsByASINsQuery
Returns related keywords and data based on the keywords associated with the queried ASIN. The queried ASINs are taken from the ASINs contained in the Segments table response.
Source API documentation: https://developer.junglescout.com/api#endpoints - POST api/keywords/keywords_by_asin_query
Replication Type: Key based replication
Replication Key: ASIN
| Field name | Type |
|---|---|
id | STRING |
type | STRING |
country | STRING |
name | STRING |
primary_asin | STRING |
monthly_trend | NUMERIC |
monthly_search_volume_exact | NUMERIC |
quarterly_trend | NUMERIC |
monthly_search_volume_broad | NUMERIC |
dominant_category | STRING |
recommended_promotions | NUMERIC |
ppc_bid_broad | NUMERIC |
ppc_bid_exact | NUMERIC |
ease_of_ranking_score | NUMERIC |
relevancy_score | NUMERIC |
organic_product_count | NUMERIC |
sponsored_product_count | NUMERIC |
organic_rank | NUMERIC |
overall_rank | NUMERIC |
sp_brand_ad_bid | NUMERIC |
sponsored_rank | NUMERIC |
ease_of_ranking_score_st | STRING |
organic_product_count_st | STRING |
monthly_search_volume_exact_st | STRING |
monthly_search_volume_broad_st | STRING |
recommended_promotions_st | STRING |
sp_brand_ad_bid_st | STRING |
BrandProductsByDay
List daily product level data for a single brand over time. This endpoint is used to retrieve performance analysis of ASINs over a specified period of time with daily data points. Best used to see changes over time. Segment id required to call this end point is taken from the Segments APi response.
Source API documentation: https://developer.junglescout.com/api#endpoints GET /api/segments/{segment_id}/brand_products_by_day
Replication Type: Key based replication
Replication Keys: segment_id, start_date, end_date
| Field name | Type |
|---|---|
id | STRING |
type | STRING |
asin | STRING |
date | DATE |
country | STRING |
name | STRING |
brand | STRING |
image_url | STRING |
share | NUMERIC |
revenue | NUMERIC |
revenue1p | NUMERIC |
revenue3p | NUMERIC |
unit_sales | NUMERIC |
unit_sales1p | NUMERIC |
unit_sales3p | NUMERIC |
avg_price | NUMERIC |
high_price | NUMERIC |
low_price | NUMERIC |
reviews | NUMERIC |
rating | NUMERIC |
categories | STRING |
sub_categories | STRING |
sellers | NUMERIC |
seller_types | STRING |
length_value | NUMERIC |
height_value | NUMERIC |
width_value | NUMERIC |
dimensions_unit | STRING |
weight_value | NUMERIC |
weight_unit | STRING |
avg_bsr | NUMERIC |
date_first_available | TIMESTAMP |
SalesEstimatesQuery
Perform a query for a specified ASIN over a period of time. Use this endpoint to determine price and rank data overtime with daily datapoints. Sales estimates for variant ASINs will return values for the parent ASIN. The parent ASIN values are an aggregate of all variants under that parent. ASIN values required to call this end point are fetched from the Segments API respose.
Source API documentation: https://developer.junglescout.com/api#endpoints GET /api/sales_estimates_query
Replication Type: Key based replication
Replication Keys: ASIN, start_date, end_date
| Field name | Type |
|---|---|
id | STRING |
type | STRING |
asin | STRING |
is_parent | BOOLEAN |
is_variant | BOOLEAN |
is_standalone | BOOLEAN |
parent_asin | STRING |
variants | STRING |
date | DATE |
estimated_units_sold | NUMERIC |
last_known_price | NUMERIC |
ShareOfVoice
For a given keyword search on Amazon, return the share that each brand controls for the first 3 pages of search results. Data for organic, sponsored, and combined share of voice. This endpoint also returns the PPC bid and 30 day search volume for the queried keyword and the conversion rate of the top 3 ASINs for the last week. Keywords required to call this API are taken from the KeywordsByASINsQuery table.
Source API documentation: https://developer.junglescout.com/api#endpoints GET /api/share_of_voice
Replication Type: Key based
Replication Key: keywords
Filter
| Field name | Type |
|---|---|
id | STRING |
type | STRING |
estimated_30_day_search_volume | NUMERIC |
exact_suggested_bid_median | NUMERIC |
product_count | NUMERIC |
updated_at | TIMESTAMP |
brands | RECORD |
top_asins | RECORD |
top_asins_model_end_date | DATE |
top_asins_model_start_date | DATE |
Last updated