ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
To create a copy of the generator, go to File > Make a Copy
2
3
Product Meta Description Generator
Brand Name/Callout
Test Company
4
5
6
Directions
7
8
1. Run a Screaming Frog crawl and grab a list of all the product URL's that are missing Meta Descriptions. Take the data and paste it into the sheet called Product Data. You'll need the following parts of data; URL & Product Title. To do this there are two ways to filter down to just products, either set up a Custom Extraction to pull the Product SKU or, Add an Inclusion through Screaming Frog that will just crawl URLs that have /products/ or /product/.
9
2. Once you plug the data into Product Data, it should start pulling through the information automatically. Move to the Callouts tab and enter what CTA's you would like to use at the start and the end of your meta descriptions. The formula is designed to randomise these areas so the more options you have the better.
10
3. Edit the Client Name to the right of this box and add whichever client it might be. This will populate the "at Test" part of the meta description.
11
4. Click and drag each of the cells in the Meta Description Generator to drag the formula down and populate for the remaining cells.
12
5. Once you're happy with your meta descriptions, I would recommend creating a duplicate of the Meta Description Generator tab. That way, you'll be able to paste the values of the description and tweak it without breaking the formula.
13
14
*CAUTION* - When you drag the formula down it might refresh, which will change the descriptions that you might've been happy with.
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
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