As most members know by now, Squidoo just unleashed a dramatically different layout two weeks before Christmas. This fits a pattern: Squidoo typically launches changes with little or no warning (that one was released on December 21, 2010, and it managed to throw some top-earning lenses into WIP, hiding them entirely from view and killing their tier earnings for the month.) Clearly, Squidoo thinks we have far too much time on our hands during the holidays.
If you’ve got hundreds of lenses, it may take days to salvage and check all of them. So how do we prioritize? Well, I’ve discovered a handy Excel trick to list all our lenses in order of how much they earn, which can aid in triage assessment.
But first, let’s look at some possible ways to repair layout problems caused by this so-called “Responsive” update (as a major iPad user, the old Squidoo layout gave me no trouble, whereas this one does):
- [UPDATE] SquidTool’s creator A3 Labs has been on the ball and has updated SquidTools to work with Squidoo’s new layout. See this announcement post from A3 Labs explaining the fixes, and/or Annie’s tutorial on how to get these repairs to fix old Squidtools layouts.
- For what it’s worth, most of my templates from my Amazon Associates Links Tutorial seem to be working under the new layout. Exception is the five-items-across. The rest are flexible enough to cope with varying screen sizes.
- Create smallish fixed-width building blocks that flow and wrap around like the words in this paragraph when they hit the right-hand margin. By “building blocks,” I mean a box-shaped unit such as one image plus its caption underneath and maybe a “buy” button. My How to Align Image Side-by-Side templates all work this way, and as far as I can see, I think they’re all still behaving correctly.
- One might be able to change dimensions to percentages, so that layout elements stay proportional to the page width. For instance, with a three-in-a-row layout, set the width of each of the three “building blocks” to 30% with a margin-right of 2% to give a little padding and still leave a smidge of wiggle room for borders. But there’s a problem with this, too, as kburns notes: 30% of the screen width on a smartphone is tiny, too small for images. [UPDATE: See my next post: Cheat Sheet for Converting fixed-width to flexible-width Squidoo layouts. I think I’ve gotten the hang of it now.]
- People who really know CSS backwards and forwards may find that some percentage-width problems are solved by adding max-width or min-width: making bits of a layout stretchy and flexible, but not infinitely so.
WHATEVER YOU DO: Keep in mind that Squidoo’s width and font sizes now vary on the fly to fit people’s screens and devices, so you can’t assume anyone else’s column width will be the same as it is on your computer. One quick way to check is to grab the lower right-hand corner of your browser window (if you can) and drag it left and right to view the lens resizing itself to fit the new window size. Also, check Screenfly (thanks, dee) to see how it will look on an iPad and other devices.
NOW, ABOUT THAT TRIAGE:
This was what I was going to post before I got distracted trying to solve layout issues (note: I cannot answer any more questions now, as I’ve only managed to check/repair 11 of my 431 lenses since yesterday and I’ve gotta get back to them).
If you have over a hundred lenses, it seems daunting to figure out where to start. Here’s a five-minute exercise you can do with Excel to help you find and prioritize your top-earning lenses on Squidoo.
- Go to the big blue Dashboard Stats tab. (that link takes you there.)
- Choose “My Payments” and “Life to Date” in the pulldown menus at the bottom, and click “go”. Go to the bathroom while that loads in. [UPDATE: you might want to set it to “Previous 3 months” instead; old lenses may have earned more historically, but may not be top earners now.]
- Click “Download report as TSV” at upper right-ish.
- Open the result in Excel.
- Select All, then, under the Data > Sort… box, Sort By Lens Title (or URL).
- Choose “Subtotals” under the Data menu and click OK.
- Now at the top of the left-hand corner, you should see buttons for “1 2 3.” Click the 2, and it should hide all the different month-by-month payouts for each lens and show you just the total lifetime earnings for each lens. (If you can’t find the numbers, under the Data > Group and Outline submenu, choose “hide detail” to collapse everything and then “show detail” to get the summary. This is dumb but it works.)
- Under the “Data” menu, choose “Sort” again and Sort by “Total,” Descending.