Pipelinica

How to automate reporting with Pipelinica and Google Data Studio

If You want to create a dashboard in Google Data Studio and show for example your Facebook Ads statistics – you can use Pipelinica. There are basic steps in order to create such a dashboard:

  1. In Pipelinica app – create a data pipeline with appropriate data source, and Google BigQuery or Google Sheets data destination. For example: from Facebook Ads to Google Sheets:
    A new pipeline from Facebook Ads to Google Sheets, ready to create
  2. As a result – You should get your Facebook Ads statistics in Google Sheets or BigQuery table:
    A Google Sheets table with exported Facebook Ads statistics
  3. Use default Data Studio connectors in order to create a data source with your statistics, for example use Google Sheets connector if you decided to export your data to Google Sheets:
    Creating a Data Studio data source with the Google Sheets connector
  4. Create charts and tables using recently created Google Sheets or BigQuery data source:
    A Data Studio chart built on Facebook Ads data

Pipelinica will keep refreshing your data according to selected schedule so your reports always will be up to date.
If you still have any questions – feel free to contact us HERE.