This skill is good for

Market Share Analysis provides users with an understanding of the share drivers or share change of a specific brand or manufacturer in the market. The provided explanation includes metrics drivers, competitive pressure, as well as impact of share change across different products and market segments.

Use this skill to

Determine which packs/segments are effecting my share and how?
Determine which key metrics are effecting my share and how?
Determine which competitor is my biggest threat and why?

Example Questions

How did Ebro Foods market share perform in California for June 2023 YTD?
Why is whole grain pasta losing share?
How is short cut rice performing?

Key Analysis Capabilities

Share and Impact Calculation: Analyze the share and assess the impact of various business segments on overall market share. This includes support for Share and Share Within: The skill accommodates both Share and Share Within calculations, providing comprehensive and context-specific analysis based on the data setup, enhancing the accuracy of insights.

Metrics Impact: Track growth or calculate the impact on share using Nielsen formulas, providing insights into performance drivers.

Flexible Analysis Pathways: Leverage multiple customizable analysis paths that allow you to drill down across various dimensions, ensuring tailored and business-relevant insights. This flexibility supports detailed exploration, from global views to specific segments, regions, customers, or products, delivering actionable results aligned with business needs.

Multi-level Drill Down: Add multi-level drill-downs within the same view, allowing you to move from broader categories like brand to more specific ones like sub-brand, all within a single analysis. See below example configuration***

Interactivity: Add interactive hyperlinks to rows, allowing users to drill down further by clicking, automatically following the correct drill-down path for seamless exploration.

Variables

variable	description	Example default value
metric	Share metric being analyzed. Confirm share metric is available in the data in the format of metric_share. If multiple share metrics are set in the data, recommended set a default.	Value_Share
growth_type	Y/Y or P/P	Y/Y
other_filters	Filters to use in analysis. Add a new brand/manufacturer filter parameter and set a default value.	Do NOT set up defaults
limit_n	Limit number of breakout values (rows in output)	20
time_extract OR Period	Period filter. This parameter description depends on the period data structure.	"{"flags":"YTD"}"
global_view	Determines the breakouts to display in the Global view. This is the default view. If remains empty, skill will run with no breakouts.	[ { 'dim': 'region', 'type': 'share', 'tab_label': 'Region' }, { 'dim': 'market', 'type': 'share', 'tab_label': 'Countries' } ][ { 'dim': 'region', 'type': 'share', 'tab_label': 'Region' }, { 'dim': 'market', 'type': 'share', 'tab_label': 'Countries' } ]
market_view	Determines the breakouts to display in the market view. See example for drill down tab configuration***	[ { 'dim': 'brand', 'type': 'contribution', 'tab_label': 'Portfolio', 'drilldown': { 'dim': 'sub_brand', 'type': 'contribution', } }, { 'dim': 'ogf_segment', 'type': 'share', 'tab_label': 'Segments' } ][ { 'dim': 'brand', 'type': 'contribution', 'tab_label': 'Portfolio', 'drilldown': { 'dim': 'sub_brand', 'type': 'contribution', } }, { 'dim': 'ogf_segment', 'type': 'share', 'tab_label': 'Segments' } ]
market_cols	If a filter is used that has a dimension from this list, the Market View is used, otherwise the Global View is used.	market detailed_mkt
impact_calcs	Calculations for impacts. Must use dataset names.	{ 'price_impact': "current(volume) * diff(volume_price) / prior_market(value)", 'tdpimpact': "((diff(tdp) prior(units)) / prior(tdp)) _ current(unit_weight) * prior(volume_price) / prior_market(value)", `'unit_ros_impact': "(diff(unit_rate_of_sales) * current(tdp) * current(unit_weight) * prior(volume_price)) / prior_market(value)"`}
include_drivers	Can be True or False. If set to False, the right side of the output (Metric Relationship / Impact on Share + Metric Decomposition/Impacts) will not be calculated or displayed	True
subject_metric_config	Configuration for right side of output (drivers) for subject breakout tab.	{ "Metric Relationship": { "value": ["pct_change"]["pct_change"], "volume": ["pct_change"]["pct_change"], "volume_price": ["current", "pct_change"]["current", "pct_change"], "tdp": ["pct_change"]["pct_change"], "volume_on_deal": ["pct_change"]["pct_change"] } }
decomposition_display_config	Configuration for right side of output (drivers) for breakouts tabs	{ "Impact on Share": { "value_share": ["impact"], "volume_share": ["impact"], }, "Metric Decomposition": { "value": ["pct_change"]["pct_change"], "volume": ["pct_change"]["pct_change"], "volume_price": ["current", "pct_change"]["current", "pct_change"], "tdp": ["pct_change"]["pct_change"], "volume_on_deal": ["pct_change"]["pct_change"] } }