How to Use Cardinal’s Rank Investigation Template

Cardinal Digital Marketing has developed a Data Studio template for digital marketers to use to help investigate sudden ranking drops. John, Cardinal’s SEO Director, wrote an a how-to guide on Search Engine Journal about how to use Python programming to investigate which pages are ranking well for targeted keywords.

Below are instructions on how to take the raw Python data and put them into Google Data Studio for powerful visualizations.

Step 1) Open & Copy Our Google Sheets Template

Before you edit anything, you’ll need to open our Google Sheets template. Please DO NOT request access, as it will not be accepted and will waste your time. To access and edit this template, follow these instructions:

  1. Open this link to our Google Sheets template.
  2. Click File => Make a Copy.
  3. On your new version of your Google Sheet, paste your raw python data in columns A-C starting on row 2.
  4. The rest of the columns, highlighted in gray, should automatically update.


Step 2) Open & Copy Our Google Data Studio Template

You’re almost there! To start getting visual insights to into which competitor pages are outranking you, follow these steps below.

  1. Open this link to our Data Studio template.
  2. At the top of the page, click the make a copy image icon.
  3. This will generate a popup and ask you to select a “New Data Source.” Click on the dropdown and select “Create New Data Source” at the bottom.
  4. As a data source, find and select Google Sheets.
  5. Find your raw data sheet and select that as your data source.
  6. This may take a moment to process, but from here your data will update with your Python results.

Alex Membrillo Cardinal CEO

Alex Membrillo

Founder and CEO

Alex Membrillo is the CEO of Cardinal, a digital marketing agency focused on growing multi location companies. His work as CEO of Cardinal has recently earned him the honor of being selected as a member of the 2018 Top 40 Under 40 list by Georgia State University as well as 2015 and 2016 Top 20 Entrepreneur of metro Atlanta by TiE Atlanta, Atlanta Business Chronicle’s 2016 Small Business Person of the Year,and the Digital Marketer of the Year by Technology Association of Georgia (TAG).