Step 4: Create a New Spreadsheet (or Google Doc) and Label
For now, have your pencil and paper ready, you will jotting down notes.
1. Open a NEW Excel Spreadsheet (or Google Doc) and create a tab called “Image List”Open your new Excel Spreadsheet (or Google Doc), and in your “Image List” tab create column labels for all of the following NEW information:
- Image CAM # (essentially the image number assigned by your camera)
- New Image URL
- Old Caption Name
- Revised Caption Name
- All Image column details: Format, Align, Size, Orientation
- Image Size (in Pixels)
- Image Size (KB)
- Original Image Full Size
- Link to URL
.
3. Create a 2nd tab called “Images to Optimize” in the new Excel Spreadsheet
4. Open “Images to Optimize” tab, and create column labels as per the screenshot.
Open your new Excel Spreadsheet (or Google Doc), and in your “Image to Optimize” tab create column labels for all of the following NEW information:
- Old Image #
- Page
- % Savings
- Optimized
- New Image #
- Date Revised
Once again as in Part 1, this is the future place you will keep track and revise data for Google Page Speed Insights recommendations. Don’t worry what they stand for yet, only label these columns for now and leave them. We will get back to them.
After creating both tabs in this document, save it and keep this spreadsheet (or Google Doc) open in a separate place and out of visibility for now. We will being going back to it soon.
Hang in there and pleasetake your time with each step. There is quite a bit of necessary record-keeping here in the following 2 steps that can try one’s patience - but it will certainly all be worth it in the end.
After you complete this entire process, you will periodically want to repeat Steps 4-7 from Part 1, since subsequent images you post and future plugins you upload, activate and deactivate will cause your Page Speed Insights to change.
Now click “Next Page” and let’s move onto ADDING GALLERY images in Step 5.
Saving this.:)