Transferring Voluum data to Google Sheets and Looker Studio

Voluum offers its users a robust reporting engine with a graph as a visualization tool. Some more advanced users may want or need to go beyond that and extend Voluum's data presentation options with an external tool. For example, they may want to push Voluum data to Looker Studio and analyze it there.

How Does it Work?

Voluum has the Shared Reports feature that generates a link that is accessible to non-Voluum users. This link presents live Voluum data; the scope has been outlined by the user who created the report. You can configure data transfer from Shared Reports to Google Sheets using a free plugin, and then use this Google Sheet spreadsheet as a data source for Looker Studio.

Once data is present in Looker Studio, you can create advanced visual dashboards.

Step 1: Get API Request URL from Voluum

Standard API request URLs have a fixed time range. To generate a dynamic URL that will update every day, it is possible to utilize the Voluum Shared Reports link as a URL request.

  1. Create a Shared Report with the desired time range and data scope. To learn more, read the Shared Reports: Overview article.
  2. Open Developer Tools of your web browser (F12 on Google Chrome).
  3. Open the Shared Report.
  4. Go to the Network tab.
  5. Select an appropriate element.

  6. Get the request URL.

Step 2: Move Voluum Data to Google Sheets

  1. To unpack JSON in Google Sheets, the user has to install the free API to Sheets addon in Google Workspace Marketplace. Here's the link: https://workspace.google.com/marketplace/app/api_to_sheets/245778206812?hl=pl

  2. In Google Sheets, choose Create New API Request in the Extensions tab.

  3. In the side menu, paste the Request link in API URL Path input field and choose GET option from the Method drop-down menu.

  4. In the Request Headers field, paste:

    Name

    Value

    Access-control-allow-credentials

    true

    Content-type

    application/json

  5. Set up Sheets for data update: choose Replace from the dropdown, name the request and run the addon.

  6. In the Schedule tab, choose the update frequency and time. After saving, the Sheet will update at the time selected.

Step 3: Present Voluum data in LookerStudio

  1. Create a new Report in Looker Studio.
  2. Click the Add data button.
  3. Choose Google Sheets.
  4. Find the created spreadsheet.
  5. The columns should be recognized.
Frequently Asked Questions

Track & optimize
your campaigns with ease!

Sign up now