Google Shopping Trend Report Example

	A	B	C	D	E	F	H
1	Summary
2							Instructions
3	Today	9/9/2025
4	Total Bad Feeds	0					This example features two clients, each with a shopping campaign running in Google and Bing
5	Overall Status						1. Update the tables to represent your unique client & engine campaigns (B9:E10 and C15:F16 and C34:F35). Delete irrelevant columns
6							a) Note: you can only pull in Bing campaigns if this data is clean in GA or if you have the paid version (and then pull directly from Bing)
7	Feed Status						2. Update the formulas in tables C17:F30 and C36:F49 to match the column location and tab name of your raw data
8							3. With free [or no] version of Supermetrics, use Tools > Notification Rules to schedule the report to email to you
9	Insert view name here >	Shopping Client 1	Shopping Client 1	Shopping Client 2	Shopping Client 2		With paid version of Supermetrics, use Add-ons > schedule refresh & emailling > triggers to set up a conditional email rule
10	Insert source / medium here >	google / cpc	bing / cpc	google / cpc	bing / cpc
11	Adjust appropriate % change. Default is -50% >	Good	Good	Good	Good
12
13	Rolling Daily Spend Report
14
15	Insert view name here >		Shopping Client 1	Shopping Client 1	Shopping Client 2	Shopping Client 2
16	Insert source / medium here >		google / cpc	bing / cpc	google / cpc	bing / cpc
17	Mon	9/8/2025	$89	$13	$8	$10
18	Sun	9/7/2025	$100	$14	$10	$16
19	Sat	9/6/2025	$103	$13	$9	$11
20	Fri	9/5/2025	$110	$15	$9	$15
21	Thu	9/4/2025	$186	$22	$8	$11
22	Wed	9/3/2025	$148	$19	$6	$11
23	Tue	9/2/2025	$129	$17	$7	$12
24	Mon	9/1/2025	$132	$16	$9	$13
25	Sun	8/31/2025	$157	$18	$10	$15
26	Sat	8/30/2025	$234	$25	$11	$12
27	Fri	8/29/2025	$286	$28	$11	$12
28	Thu	8/28/2025	$253	$27	$9	$9
29	Wed	8/27/2025	$246	$26	$9	$9
30	Tue	8/26/2025	$212	$23	$11	$10
31
32	Rolling Daily Revenue Report
33
34	Insert view name here >		Shopping Client 1	Shopping Client 1	Shopping Client 2	Shopping Client 2
35	Insert source / medium here >		google / cpc	bing / cpc	google / cpc	bing / cpc
36	Mon	9/8/2025	$23	$0	$0	$0
37	Sun	9/7/2025	$736	$320	$0	$0
38	Sat	9/6/2025	$23	$0	$0	$0
39	Fri	9/5/2025	$736	$320	$427	$608
40	Thu	9/4/2025	$552	$240	$0	$442
41	Wed	9/3/2025	$897	$0	$154	$178
42	Tue	9/2/2025	$1,932	$0	$0	$170
43	Mon	9/1/2025	$391	$170	$0	$0
44	Sun	8/31/2025	$690	$300	$0	$603
45	Sat	8/30/2025	$842	$366	$122	$222
46	Fri	8/29/2025	$715	$311	$0	$81
47	Thu	8/28/2025	$1,414	$615	$222	$36
48	Wed	8/27/2025	$1,966	$0	$105	$0
49	Tue	8/26/2025	$704	$306	$177	$0
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100