Google Sheets - The Comprehensive Masterclass Google Sheets Learnings

• Section 3: Getting Started Right with Google Sheets

  • Type sheets.new as URL in chrome for a shortcut to open a blank sheet

  • Spacebar is a shortcut to check / uncheck checkboxes

  • A range is defined by the upper-left and lower-right cells (i.e. A1:B10)

  • Location and timezone settings can be changed in File --> Settings

• Section 4: Data Entry & Basic Formulas

Chris

• For Client: Trips2Italy

  • Reach out to Linode support for main-user access to Trips2Italy linode Chris Trips2Italy September 22nd, 2022 task

• For Client: SourceTech

  • Define milestones for SEO project Chris SourceTech September 22nd, 2022 task

• SourceTech

  • Meeting Notes

    • Client Feedback

      • ST/Investigate functionality of RFQ submissions

        • Test emphasizing RFQ over phone for an experiment

        • Email delivery flow to David

          • Forward David most recent Maintenance form submission entry

        • Migrations wiping out entires (staging --> production)

    • Action Items

    • Report

      • Report: Reports/SourceTech/09-14-22

Evan

• SourceTech

  • ST/Optimize SEO performance of product pages

    • https://source-tech.net/hp-dl360-g10-vs-dl380-g10/

      • ~15-20 monthly visitors, rank 1

      • Currently no live-chat trigger for this page, could use one for this page as well as other blog posts

    • https://source-tech.net/top-server-brands-2/

      • ~80-90 monthly visitors

      • Currently no live-chat trigger for this page, could use one for this page as well as other blog posts

      • Update content for this page to 2021/2022 data (

      • Redirect https://source-tech.net/top-server-brands/ - https://source-tech.net/top-server-brands-2

    • https://source-tech.net/product-category/pre-configured-servers/

      • Currently ranked 6th somehow, even extremely low-quality content. Gets around 35-40 visitors a month.

      • I would push hard to explore options to put our top 8 (and their 3 pre-configured options) servers on this page

        • Ways to output

          • Make each row its own server and have each "product" as the entry, mid, and performance model.

            • Each page would output just like a product page (copy/paste the same template, de-index these pages so they don't compete with our actual service pages)

    • Product Pages

      • Product descriptions

      • Keyword insertion (R640 only appears on the R640 page 4 times)

      • Adding links to related blog articles