CREATE SALES REPORTS WITH GOOGLE DATA STUDIO

Accelerate your business with these expert tips on "Create sales reports with Google Data Studio". Analyse and discover this TIP!

Google Data Studio is a fast and powerful data visualisation tool, which will allow you to link different traffic sources to create multiple dashboards that fit your visualisation needs, schedule sales reports, graphs and even create marketing funnels linked to aggregated data sources. In this tip you will learn how to create sales reports in Google Data Studio.

Data Studio is a free tool available at this link (+).

To start using it and exploit the potential of your data you will need to log in with your personal or corporate Google account, and then as it is your first report I recommend you start with an empty report. Immediately after that, Google Data Studio will ask you to link some data source according to your needs. Here you will find multiple possibilities, such as, linking to a Google spreadsheet, Google Analytics, Google Ads, YouTube (+) among others.

Once you have added your traffic source, you will be able to choose the theme that fits your needs in the right sidebar, search for the data source and import it with the view configuration of your choice. This can be a graph, a pivot table, a scorecard, among other options that will appear in the dropdown.

Once you have entered your data, your report will be linked to your data source. It is advisable to incorporate in your data panel a filter by period, which you will find in the . With this, your data will be displayed according to the date you want.

If you want to further improve the display of your data, it is advisable to select the data on your page and try different styles in the toolbar that will be enabled on the right side of the screen.

If you need to correct the added traffic source, look for the "Resource, manage added data sources" option at the top. Here you can add a new data source or edit the existing one.

Schedule periodic reporting

One of the options that Data Studio will give you is to schedule a report to your email. This option can be found at the top of the screen by clicking on the "share" button. There you can select the recipients, the subject of the email, the message in the body of the email and attach the PDF format at the same time.