Product Custom Label Excel Generator

Back to Home (More tools)

Define flexible label rules based on product ID and ad metrics, generate Excel/Sheets custom label formulas with one click, and preview results and label distribution using mock data.

Data import

Current: mock sample data

Import from file

Label Rules

Choose which custom_label columns to generate

Product type rules (optional)

Detect product type from product ID to limit where rules apply.

No product type rules yet. Click the button below to add one.

Product type source

Controls how product type is determined for each row and which rules apply.

From product ID using rules aboveUse product type column from imported data

Use a custom_label column as product type

Active label column

Rule product type view

Initializing editor...

Default label:

Smart rule generator

Generate good / bad / low_volume rules from target ROAS, add-to-cart cost, etc.

Excel custom label formula

Formula example for Excel/Sheets. It assumes data starts at row 2, product id in column A and the selected metrics are mapped sequentially to columns B–J.

Cost field unit:Use API cost_micros (micro), divide by 1,000,000 in formulaUse standard Cost (account currency), no unit conversion

=LET(k, A2, IF(k="", "", IF(OR(AND(F2>0, J2>2), AND(E2>0, H2<10, (D2/1000000)<100)), "good", IF(OR(AND((D2/1000000)>20, E2=0), AND((D2/1000000)>20, E2>0, H2>20), AND((D2/1000000)>200, J2<1)), "bad", IF((D2/1000000)<0, "low_volume", "neutral")))))

You can also paste an existing formula below to reverse-generate the rules above.

Select metrics for table

Control metrics shown in preview table

Data preview

Sort: id (ASC)

#	A		B	C	D	E	F	G	H	I	J	K
#	id↑	Product type	Impressions	Clicks	Cost	All conv.	Conversions	Conv. value	Cost / all conv.	Cost / conv.	ROAS	custom_label_0
2	pid0001	Unmatched	10,293	536	40.80	0.75	10.00	2494.19	54.22	2.64	3.00	good
3	pid0002	Unmatched	49,191	468	0.00	5.00	13.72	772.13	5.00	3.29	10.00	good
4	pid0003	Unmatched	12,360	763	0.00	0.00	0.00	714.35	0.98	0.66	1.00	neutral
5	pid0004	Unmatched	2,425	221	0.00	5.00	1.53	520.52	30.00	11.76	1.00	neutral
6	pid0005	Unmatched	45,327	229	0.00	0.00	0.00	3520.69	0.00	1.51	0.50	neutral
7	pid0006	Unmatched	49,346	628	0.00	0.00	0.00	3042.50	0.00	1.55	0.00	neutral
8	pid0007	Unmatched	20,659	700	0.00	0.00	0.00	735.62	0.00	3.58	1.50	neutral
9	pid0008	Unmatched	98,803	621	43.19	20.04	4.10	2084.77	2.16	10.52	10.00	good
10	pid0009	Unmatched	93,666	16	48.49	0.17	18.17	3311.51	200.00	2.67	10.00	good
11	pid0010	Unmatched	57,822	752	18.90	14.84	19.86	3507.55	1.27	0.95	10.00	good
12	pid0011	Unmatched	15,725	437	12.86	8.69	13.33	129.34	1.48	0.97	10.00	good
13	pid0012	Unmatched	84,087	123	8.17	6.11	4.61	231.44	1.34	1.77	10.00	good
14	pid0013	Unmatched	55,139	1	12.64	11.64	1.44	2958.31	1.09	8.79	10.00	good
15	pid0014	Unmatched	80,163	151	7.13	7.17	10.81	1587.08	0.99	0.66	10.00	good
16	pid0015	Unmatched	97,779	437	3.09	2.51	14.32	2911.72	1.23	0.22	10.00	good
17	pid0016	Unmatched	52,736	543	3.80	17.08	1.36	2268.84	0.22	2.80	10.00	good
18	pid0017	Unmatched	29,477	310	42.36	23.69	0.31	2485.14	1.79	138.07	10.00	good
19	pid0018	Unmatched	21,908	134	43.62	11.49	7.94	44.97	3.80	5.50	1.03	good
20	pid0019	Unmatched	67,142	57	22.30	0.46	17.31	3273.73	48.45	1.29	10.00	good
21	pid0020	Unmatched	99,212	318	22.27	3.22	4.37	3052.97	6.91	5.09	10.00	good
22	pid0021	Unmatched	16,310	1	42.59	4.54	13.59	620.26	9.39	3.13	10.00	good
23	pid0022	Unmatched	88,592	682	11.30	27.90	2.92	1447.12	0.41	3.87	10.00	good
24	pid0023	Unmatched	24,229	186	37.27	24.81	8.52	2412.90	1.50	4.38	10.00	good
25	pid0024	Unmatched	17,986	68	7.21	0.76	9.46	1261.04	9.49	0.76	10.00	good
26	pid0025	Unmatched	15,174	510	36.63	27.07	12.85	3790.73	1.35	2.85	10.00	good
27	pid0026	Unmatched	85,741	86	12.55	0.20	19.65	3074.63	63.22	0.64	10.00	good
28	pid0027	Unmatched	69,555	138	31.68	15.28	11.53	1762.96	2.07	2.75	10.00	good
29	pid0028	Unmatched	3,536	72	46.44	25.87	19.15	2424.06	1.80	2.42	10.00	good
30	pid0029	Unmatched	25,504	652	5.10	6.87	11.92	2829.29	0.74	0.43	10.00	good
31	pid0030	Unmatched	18,871	79	40.68	8.00	9.68	2350.60	5.08	4.20	10.00	good
32	pid0031	Unmatched	3,733	592	31.16	18.64	16.37	2529.05	1.67	1.90	10.00	good
33	pid0032	Unmatched	50,351	204	49.73	16.70	15.87	3784.88	2.98	3.13	10.00	good
34	pid0033	Unmatched	46,640	329	33.74	10.55	10.12	585.11	3.20	3.33	10.00	good
35	pid0034	Unmatched	93,487	5	33.52	22.98	19.52	375.89	1.46	1.72	10.00	good
36	pid0035	Unmatched	27,474	317	3.87	13.51	5.63	713.96	0.29	0.69	10.00	good
37	pid0036	Unmatched	52,931	415	30.62	9.74	16.11	148.46	3.14	1.90	4.85	good
38	pid0037	Unmatched	77,822	646	8.60	10.45	11.77	3413.46	0.82	0.73	10.00	good
39	pid0038	Unmatched	15,081	786	41.62	29.28	15.59	3676.02	1.42	2.67	10.00	good
40	pid0039	Unmatched	41,584	549	17.76	20.12	3.50	1712.45	0.88	5.07	10.00	good
41	pid0040	Unmatched	5,793	38	33.61	12.28	16.66	3218.77	2.74	2.02	10.00	good
42	pid0041	Unmatched	18,194	313	46.77	26.30	15.02	866.52	1.78	3.11	10.00	good
43	pid0042	Unmatched	89,130	125	45.78	17.43	11.71	2998.67	2.63	3.91	10.00	good
44	pid0043	Unmatched	46,967	73	17.54	6.78	8.20	3461.19	2.59	2.14	10.00	good
45	pid0044	Unmatched	3,467	88	5.10	7.85	9.55	2155.09	0.65	0.53	10.00	good
46	pid0045	Unmatched	66,804	704	28.22	13.85	19.69	2850.63	2.04	1.43	10.00	good
47	pid0046	Unmatched	21,097	185	10.21	19.51	16.25	11.15	0.52	0.63	1.09	good
48	pid0047	Unmatched	44,626	74	45.96	0.05	4.59	2166.52	200.00	10.02	10.00	good
49	pid0048	Unmatched	40,500	283	41.25	29.67	10.81	1015.89	1.39	3.82	10.00	good
50	pid0049	Unmatched	22,602	221	10.89	12.89	13.35	3918.98	0.84	0.82	10.00	good
51	pid0050	Unmatched	16,423	426	33.32	8.32	12.96	1990.78	4.01	2.57	10.00	good
52	pid0051	Unmatched	35,657	536	24.77	3.47	0.81	255.82	7.15	30.52	10.00	good
53	pid0052	Unmatched	11,459	529	26.28	5.06	4.59	1956.73	5.19	5.72	10.00	good
54	pid0053	Unmatched	84,443	91	6.30	18.03	12.37	1323.09	0.35	0.51	10.00	good
55	pid0054	Unmatched	80,531	264	34.43	4.72	14.25	3653.50	7.29	2.42	10.00	good
56	pid0055	Unmatched	21,255	743	27.62	8.18	1.67	3808.71	3.38	16.55	10.00	good
57	pid0056	Unmatched	10,932	421	19.41	8.43	4.42	2207.46	2.30	4.39	10.00	good
58	pid0057	Unmatched	51,085	140	44.91	1.22	5.51	3206.62	36.89	8.16	10.00	good
59	pid0058	Unmatched	18,823	498	7.09	20.51	13.78	28.16	0.35	0.51	3.97	good
60	pid0059	Unmatched	2,708	152	32.59	17.52	14.77	561.50	1.86	2.21	10.00	good
61	pid0060	Unmatched	33,530	231	4.21	16.80	19.66	959.40	0.25	0.21	10.00	good
62	pid0061	Unmatched	21,191	636	33.15	27.85	12.86	3401.98	1.19	2.58	10.00	good
63	pid0062	Unmatched	36,678	615	1.14	2.82	18.38	3021.12	0.40	0.06	10.00	good
64	pid0063	Unmatched	81,401	63	38.96	8.60	5.22	3877.44	4.53	7.46	10.00	good
65	pid0064	Unmatched	73,885	487	4.97	20.58	12.31	1841.14	0.24	0.40	10.00	good
66	pid0065	Unmatched	93,329	69	15.75	14.15	13.14	230.14	1.11	1.20	10.00	good
67	pid0066	Unmatched	39,448	79	10.67	16.16	0.58	3467.95	0.66	18.53	10.00	good
68	pid0067	Unmatched	58,814	394	5.67	9.22	12.07	350.80	0.62	0.47	10.00	good
69	pid0068	Unmatched	26,658	135	42.73	0.72	15.75	2818.00	59.04	2.71	10.00	good
70	pid0069	Unmatched	65,971	268	22.87	14.26	17.57	2147.44	1.60	1.30	10.00	good
71	pid0070	Unmatched	32,460	257	4.63	20.77	9.86	3700.87	0.22	0.47	10.00	good
72	pid0071	Unmatched	36,521	625	14.47	20.45	1.62	3949.84	0.71	8.94	10.00	good
73	pid0072	Unmatched	86,537	123	28.98	3.37	10.55	1805.94	8.59	2.75	10.00	good
74	pid0073	Unmatched	37,498	394	8.46	17.27	17.31	2209.90	0.49	0.49	10.00	good
75	pid0074	Unmatched	21,012	475	20.51	22.57	1.83	3125.76	0.91	11.22	10.00	good
76	pid0075	Unmatched	16,190	297	40.85	18.42	1.99	1244.86	2.22	20.56	10.00	good
77	pid0076	Unmatched	48,237	184	10.97	23.62	14.56	1345.43	0.46	0.75	10.00	good
78	pid0077	Unmatched	6,194	725	49.02	27.25	18.44	3640.77	1.80	2.66	10.00	good
79	pid0078	Unmatched	10,373	496	37.89	20.66	0.10	3571.80	1.83	200.00	10.00	good
80	pid0079	Unmatched	99,581	658	41.91	22.83	1.13	1926.81	1.84	37.02	10.00	good
81	pid0080	Unmatched	6,505	469	29.05	28.73	7.67	635.64	1.01	3.79	10.00	good
82	pid0081	Unmatched	70,251	406	26.54	12.50	1.57	202.39	2.12	16.89	7.63	good
83	pid0082	Unmatched	5,780	641	14.59	5.87	13.03	1814.93	2.49	1.12	10.00	good
84	pid0083	Unmatched	88,550	642	23.55	21.50	14.33	3632.79	1.10	1.64	10.00	good
85	pid0084	Unmatched	56,122	404	50.15	12.21	14.50	327.04	4.11	3.46	6.52	good
86	pid0085	Unmatched	27,769	377	22.41	20.33	14.46	1154.58	1.10	1.55	10.00	good
87	pid0086	Unmatched	12,436	463	23.22	9.07	2.36	3094.29	2.56	9.84	10.00	good
88	pid0087	Unmatched	85,043	332	48.97	13.51	8.76	2367.95	3.63	5.59	10.00	good
89	pid0088	Unmatched	91,901	750	34.33	2.11	1.30	221.51	16.28	26.31	6.45	good
90	pid0089	Unmatched	76,756	182	41.34	16.84	18.56	3011.10	2.45	2.23	10.00	good
91	pid0090	Unmatched	35,509	457	20.18	11.06	2.69	302.09	1.82	7.50	10.00	good
92	pid0091	Unmatched	91,098	280	39.28	17.42	10.70	2449.02	2.25	3.67	10.00	good
93	pid0092	Unmatched	8,692	404	9.70	25.04	3.99	1223.88	0.39	2.43	10.00	good
94	pid0093	Unmatched	15,128	342	27.84	1.92	16.03	2365.99	14.51	1.74	10.00	good
95	pid0094	Unmatched	80,133	467	39.78	5.26	17.91	3807.15	7.57	2.22	10.00	good
96	pid0095	Unmatched	8,843	526	25.42	21.69	1.67	265.45	1.17	15.20	10.00	good
97	pid0096	Unmatched	1,380	446	12.65	13.80	1.47	763.89	0.92	8.62	10.00	good
98	pid0097	Unmatched	40,710	312	44.56	14.56	12.27	1507.43	3.06	3.63	10.00	good
99	pid0098	Unmatched	51,402	328	49.12	8.87	6.39	3240.82	5.54	7.69	10.00	good
100	pid0099	Unmatched	40,498	751	1.28	8.51	7.80	1388.46	0.15	0.16	10.00	good
101	pid0100	Unmatched	64,891	696	10.55	23.83	4.35	2543.76	0.44	2.43	10.00	good

Label summary table

Select metrics to summarize (multi-select)

custom_label_0	Product count	Impressions	Clicks	Cost	Conversions	Conv. value	ROAS
good	95	4,265,145	34,011	2,426.04	973.08	196639.91	81.05
neutral	5	130,117	2,541	0.00	1.53	8533.68	23064010.53
Total	100	4,395,262	36,552	2,426.04	974.61	205173.60	84.57

Select Metrics

Select multiple metrics

Label share by metric (pie charts)

Impressions

good97.0%

neutral3.0%

Clicks

good93.0%

neutral7.0%

Cost

good100.0%

neutral0.0%

Conversions

good99.8%

neutral0.2%

Conv. value

good95.8%

neutral4.2%

Made with ♥ ByXiaoFlow