How to Use Google Data Studio Templates

Google Data Studio is an easy to use system that lets you create custom visualizations of your Copper data. To make things even easier, we’ve created Data Studio templates for some of our most popular reports.

This article will walk you through the simple steps to copy a Data Studio reporting template and connect your own data sources so you can gain insights from your Copper data. 

After walking through this example, you’ll be able to apply the same steps to for other Data Studio report templates.

Let's get started.

For our example we will use the template for Opportunity by Close Quarter report. This report will show Total Value of Opportunities over time, breakdown by owner, and All Opportunities.

  1. Start by opening the ‘View Only’ report template. This example report will include example data that you will switch out for your own data. You can open the template here - Opportunities by Close Quarter
  2. In Copper, create an API key. You’ll need this key in a moment.
    • Navigate to Settings > Integrations > API Keys and click ‘Generate’
    • Please note, only Copper Admin can generate API keys.
      Screen_Recording_2019-09-27_at_02.28_PM.gif
  3. In the example report that opened in Step 1, click the Copy icon in the top right to create your own copy.
  4. Follow the prompt to select a new data source.
    • Click ‘Select a Data Source
    • Select ‘Create New Data Source
    • Search for and select ‘Copper
      Screen_Recording_2019-09-27_at_02.26_PM.gif
  5. Enter your email and Copper API Key from Step 2.
  6. Select the record type
    • This will vary and be specified by template.
    • For this example, select Opportunities.
  7. Click Connect
  8. Verify the fields that will be imported and click ‘Add To Report’ in the upper right corner.
    • If you're following the template, no changes are necessary here.
      Screen_Shot_2019-09-27_at_2_40_03_PM.png
  9. Click ‘Copy Report
    Screen_Shot_2019-09-27_at_2_42_59_PM.png
  10. That’s it! The report will populate with your Copper data. Make any adjustments to the template and click ‘View’ when you’re ready to view your new report. 

Screen_Recording_2019-09-27_at_02.44_PM.gif

Was this article helpful? 0 out of 0 found this helpful