Connect Stripe to Google Data Studio

Connect Stripe to Google Data Studio

What We’ll Cover

  • Connecting to Stripe via the SyncWith data studio connector
  • Example of how to pull in order data from Stripe
  • Additional details on how to create your own custom connections and reports or your orders
notion image

What You’ll Need

  • Data Studio account setup under your google account

Install and configure the Stripe connector

  1. Click here to go directly to our connector in Data Studio
    1. If you’ve never setup Data Studio before you will be required to complete your signup before installing the connector, if that’s the case you’ll see a dialogue like the one to the left, fill in your info and then continue.
    2. If you have multiple google accounts open in chrome at once sometimes you’ll see this dialogue open or email preferences
notion image
  1. Install the connector (if you haven’t already)
    1. notion image
  1. You be required to provide OAuth Permissions
    1. If you’re signed into multiple google accounts you may have to try this twice as sometimes google will show the first OAuth screen and not the second, be sure to try until you see 2nd screen (as shown below) and authorize SyncWith.
notion image
notion image
  1. You’ll know you’ve properly OAuthed when you see the service dropdown (shown in the below screenshot). The dropdown exists because you can use SyncWith to pull from a wide range of APIs into Data Studio - not just Stripe. For example you can choose from Facebook Ads, Notion, Shopify Orders, Stripe Charges, WooCommerce Orders and Zendesk tickets.
  1. Choose Stripe Charges as your service and click next
    1. notion image
  1. After pushing Next a drop down will appear to select an Ad Account, Initially the list will be empty:
notion image
  1. To get your Stripe account to show we need to connect a Stripe Account, we do this by following the link to SyncWith which will ensure we get the appropriate permissions to sync your Stripe Charges Data to Data Studio
notion image
  1. You’ll be prompted by Stripe to provide permissions and select an account:
    1. notion image
  1. Once you complete the Stripe authorization click next and this will force the account dropdown to populate, choose an account and then click the Next button and then finally click the Add button.
    1. notion image

Want your Stripe Data Somewhere else?

SyncWith supports pushing your Shopoify ads data to other destinations if Data Studio isn’t what you were expecting:
  • Stripe to Databases (S3, BigQuery, MySQL, Postgres) - contact support to join our beta
 

Setting Up Stripe in Data Studio

Now that we have SyncWith setup and Stripe authorized with a Stripe account chosen we can configure our report.

Choose a Reporting Time Frame

  • Data studio lets you pick an Auto range which defaults to 28days or a Custom range
    • notion image
  • If you choose custom a calendar widget will come up and you’ll also see a drop down in the top right with a list of defaults, looks like this:
    • notion image
  • If you click the dropdown you’ll get a long list of options you can scroll through
    • notion image
  • You can also choose advanced which lets you choose two arbitrary and relative start and end dates
notion image

Choosing Your Dimensions & Metrics

The Stripe Charges API has the concept of fields. Every row returned corresponds to an order so there is a cardinality of 1 and no additional dimensions to expand across.

Choosing Dimensions in Data Studio

  • Data studio uses a alphabetical listing by default which hides the most popular dimensions you’d want - see a summary of popular dimensions below
  • Use the search feature to find the fields you want
notion image

Available Dimensions & Metrics

notion image

Need Help Getting Started?

  • Looking for paid consultation on building out your data studio dashboards? Contact SyncWith support and we’ll book time in to help whatever you need done