Using Airboxr with Google Data Studio

Using Airboxr with Google Data Studio

Salima Nadira

Salima Nadira

Reporting & Analysis

May 12, 2022

Download our free DTC financial model.

Download our free financial model template to guide your 2025. You can even automate it with Airboxr.

Automate your internal reports

Connect your Shopify store and start running your reports on auto-pilot.

Create free account
Create free account

TLDR

You can easily create data visualizations from your data analysis in Airboxr by using Google Data Studio. First, connect Google Data Studio to Google Sheets, select your data source, configure data source options, and connect. Then, create your report in Google Data Studio to generate charts and graphs based on your data. Additionally, you can schedule data analysis in Airboxr to automatically update your graphs and charts in Google Data Studio at specific times.

Data analysis often goes hand in hand with data visualization. There will be times when you need to see a visual representation of your data, either for reporting purposes, or to better see for yourself how your business is trending. Here’s the good news - as Airboxr works on Google Sheets, you can easily set up data visualizations from your data analysis by using Airboxr with Google Data Studio. Here’s how.

Step One: Connect Google Data Studio to Google Sheets

On the top left hand corner of Google Data Studio, click Create, then select Data Source.

Select the Google Sheets connector.

You may need to authorize your connection before you can use it.

Step Two: Select your data source

From here, you can select a spreadsheet (file), and worksheet (page within the file) to use as a data source.

You can select spreadsheets which are owned by you or that have been shared with you. You can also paste in the URL of a Google Sheet which you have access to, as seen below:

Step Three: Configure data source options

Keep the boxes checked if they apply; otherwise, uncheck them.

Automate your Shopify reports.

Automate your Shopify reports.

Automate your Shopify reports.

Step Four: Connect

Once you’re satisfied, click Connect. Then, you will be brought to this page showing your data source. Your data is ready to be used in graphical representations.

Step Five: Create Report

Click on the Create Report button on the top right hand corner. You will be taken to another page where you will be able to create charts and graphs using your data.

And that’s it! 🎉 Now you can easily create beautiful visualizations of your data analysis and insights.

Improve your DTC game. Sign up for weekly tips.

Bonus: Schedule your analysis for automatically updated graphs

With the Airboxr app, you can run data analysis and schedule them so they run automatically. Here’s how you do it:

  1. Log in to the Airboxr app - get your invitation to our private beta (Shopify stores only)

  2. Go to the Hops Marketplace.

  3. Select the Hop ‘Ad Performance by Date’. Click ‘Add to My Hops’.

4. Go to My Sheets and create a new spreadsheet. Your Hop will show on the left sidebar; select it, then click Schedule.

5. Select location where you want the data to be shown. Click Next.

6. Select time frame for your schedule. Click Schedule Hop.

7. Link your spreadsheet with the scheduled Hop to Google Data Studio (see the steps above) and create your required graphs and charts.

That’s all! Your sheet will update at the time you selected, and so will the graphs and charts in Google Data Studio.

Also read: Graphic design trends in data visualization for 2022

Salima Nadira

About the Author

Salima is Head of Product Marketing at Airboxr. She works with leading DTC brands to help them make sense of their data for better decision-making. She is also a professional musician with an avid following on Spotify.

Try it now

Automate your Shopify marketing, revenue, and operational reports.

Try it now

Automate your Shopify marketing, revenue, and operational reports.