Example - Merchant Excellence report

	B	C	D	E	G	H	P
1							v2024.7
2
3
4
5
6
7
8
9	Data extracted in:
10	20240714	Score:
11
12	1. Maximize Total Offers
13	Metrics		Benchmark	Current	Status	Priority
14	products uploaded via API		TRUE	TRUE	✅	Low
15	has Market Insights enabled		TRUE	TRUE	✅	Low
16	has LIA implemented		TRUE	TRUE	✅	High
17	has Free Listings enabled		TRUE	TRUE	✅	Low
18
19	2. Increase Approval Rate
20	Metrics		Benchmark	Current	Status	Priority
21	% items disapproved		8%	0.7%	✅	High
22	% items with robots.txt issue		0%	0.4%	🔴	High
23	% items with generic image		0%	0.0%	✅	High
24	% items with price / availability / condition AIU		0.5%	0.8%	🔴	High
25	% items with invalid gtins		0%	0.0%	✅	High
26	% items with shipping		90%	0.2%	🔴	High
27	uses structure data on pdp		TRUE	TRUE	✅	Medium
28	image AIU enabled		TRUE	TRUE	✅	High
29	availability AIU enabled		TRUE	TRUE	✅	Medium
30	LIA: % approved items		90%	27.2%	🔴	High
31	LIA: % items disapproved for missing inventory		30%	72.7%	🔴	Medium
32
33	3. Increase Targeted Products
34	Metrics		Benchmark	Current	Status	Priority
35	% items with custom label		90%	100.0%	✅	Low
36	% items with item_group_id		35%	100.0%	✅	Low
37	LIA: % eligible items		50%	25.6%	🔴	High
38	% items with good product_type depth		75%	100.0%	✅	Medium
39	% targeted items		95%	88.9%	🔴	High
40
41	4. Increase Impressions
42	Metrics		Benchmark	Current	Status	Priority
43	% items that have brand		85%	100.0%	✅	High
44	% items that have gtin		85%	81.7%	🔴	High
45	% items with description length >= 500		80%	74.4%	🔴	Low
46	% items with title length >= 30		97%	99.3%	✅	Medium
47	% items with product highlight attributes		10%	0.0%	🔴	Low
48	% items with color**		45%	32.0%	🔴	High/Low
49	% items with age group*		80%	0.0%	🔴	High/Low
50	% items with gender*		80%	0.0%	🔴	High/Low
51	% items with size*		80%	0.0%	🔴	High/Low
52	% items with lifestyle image		5%	0.0%	🔴	Low
53	% items with image quality >= 1500x1500		55%	0.4%	🔴	High
54	% items with duplicate titles		25%	1.2%	✅	Low
55	% items with impressions		30%	87.8%	✅	High
56	exclusive to Apparel & Accessories. The percentage only counts those types of products. *80% for Apparel & Accessories - "High/Low" means priority is High for Apparel & Accessories and Low for all other categories.
57	5. Boost CTR
58	Metrics		Benchmark	Current	Status	Priority
59	LIA: has MHLSF implemented		TRUE	TRUE	✅	Medium
60	LIA: has Store Pickup implemented		TRUE	TRUE	✅	Low
61	LIA: has Curbside Pickup implemented		TRUE	FALSE	🔴	Low
62	LIA: On display to order implemented		TRUE	FALSE	🔴	Low
63	active promotions last year		5	7	✅	Medium
64	has Merchant Promotions enabled		TRUE	TRUE	✅	Medium
65	has Product Ratings enabled		TRUE	FALSE	🔴	Medium
66	% items with sale price		35%	100.0%	✅	Medium
67	% items with 3 or more additional images		50%	70.0%	✅	Medium
68	% items with shipping speed		35%	0.2%	🔴	High
69	% items with fast shipping option		5%	0.2%	🔴	Low
70	% items with free shipping		65%	0.2%	🔴	Medium
71	has return policy enabled		TRUE	FALSE	🔴	High
72	% items with cost_of_goods_sold		5%	0.0%	🔴	Low
73	has Conversions with Cart Data implemented		TRUE	FALSE	🔴	Low
74	has Seller Ratings implemented		TRUE	FALSE	🔴	Low
75	% items with clicks		10%	77.2%	✅	Medium
76