Rank Networks: Google Business Profile management and local link building
    Step-by-step guide

    Send your numbers to Google Sheets

    Make a private feed link, paste the Sheets formula for a dataset into a cell, and build Looker Studio reports on a table that keeps itself up to date.

    Read about Data feed

    What you need

    • A Google account with Google Sheets.
    • Looker Studio, only if you want dashboards.
    • Nothing from the monthly pool.
    Step by step
    1. 1

      Open Data feed

      In the Tools group, click Data feed.

      The Data feed page: one Sheets formula per dataset, each with a copy button and a revoke link.
    2. 2

      Make a feed link

      Type a name, such as Client dashboards, and press Make a feed link. The link is private to your account and read only. The formulas are shown only once, so copy what you need straight away. Each link in the list can be renamed or revoked.

      Your feed links: make a new one, and rename or revoke the ones you have.
    3. 3

      Copy the formula for a dataset

      Under Datasets, each one has a Sheets formula: Businesses, Performance by day, Map rankings, Reviews, Posts, Links and Tasks, each with its columns listed. Press Copy next to the one you want.

      The seven datasets, with the columns each table holds.
    4. 4

      Paste it into Google Sheets

      Open a sheet, click a cell and paste. The table fills in. Google refreshes an imported table on its own schedule, roughly every hour.

    5. 5

      Build a Looker Studio report

      In Looker Studio, add the sheet as a data source and build your report. The Use it in Looker Studio section on the page walks through it.

      Use it in Looker Studio: five steps from the feed link to a client dashboard.
    6. 6

      Revoke a link that leaked

      Anyone holding a link can read that data, including anyone who can edit the sheet. Press revoke on the page to stop it and make a new one.

    Tips

    • Each link is a plain CSV address, so any tool that reads a CSV link can use it, not only Sheets.
    • Treat the links like passwords. Do not put them in a sheet the client can edit.
    • The list of datasets grows as features are added.
    Questions
    Can I write data back?
    No. The feed is read only.
    Is the link secure?
    It is private and unguessable, but anyone who has it can read the data. Revoke it and make a new one if it is shared by mistake.
    How current is the data?
    The feed is current when it is read. Google Sheets re-reads it on its own schedule, roughly every hour.
    Was this guide helpful?