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

1. Sign in to Daton.

2. Select Jungle Scout from the Connectors page.

3. Provide Integration Name, Replication Frequency, and History. The integration name would be used in creating tables for the integration and cannot be changed later.

4. Provide Jungle Scout authentication key and marketplace.

5. Post successful authentication, you will be prompted to choose from the list of available tables.

6. Select all the required fields for each table.

7. Submit the integration.

Workflow

1. 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.

2. Users would be able to edit/pause/re-activate/delete integration anytime.

3. 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

1. Go to the Account Settings page.

2. Generate your API key.

3. 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.

4. 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