--- title: "Example data mapping: Looker Studio" description: Walk through an example data mapping for a Looker Studio data source. Use filters and lookups to select the correct data. --- [Skip to content](https://helpcenter.slideform.co/example-data-mapping-looker-studio#main-content) English Show submenu for translations ![Slideform\_logo\_master-1.png\]](https://helpcenter.slideform.co/hs-fs/hubfs/Slideform_logo_master-1.png?width=50&height=50&name=Slideform_logo_master-1.png) - [Home](https://slideform.co/index.html) - [Integrations](https://slideform.co/integrations.html) - [Pricing](https://slideform.co/solutions.html) - [Blog](https://slideform.co/blog/) - [Log In](https://app.slideform.co/) Open main navigation Close main navigation - [Home](https://slideform.co/index.html) - [Integrations](https://slideform.co/integrations.html) - [Pricing](https://slideform.co/solutions.html) - [Blog](https://slideform.co/blog/) - [Log In](https://app.slideform.co/) - English Show submenu for translations - [Go to slideform.co](http://slideform.co/) [Go to slideform.co](http://slideform.co/?hsLang=en) How can we help you? - There are no suggestions because the search field is empty. 1. [Slideform Help Center](https://helpcenter.slideform.co/?hsLang=en) 2. [Getting started](https://helpcenter.slideform.co/getting-started?hsLang=en) 3. [Pull data from a Dashboard](https://helpcenter.slideform.co/getting-started?hsLang=en#pull-data-from-a-dashboard) # Example data mapping: Looker Studio ## Walk through an example data mapping for a Looker Studio data source. Use filters and lookups to select the correct data. Let's examine how to match each placeholder in the slide deck template to the correct data from a Looker Studio dashboard.  ![dashboard\_to\_slides\_lookerstudio](https://helpcenter.slideform.co/hs-fs/hubfs/dashboard_to_slides_lookerstudio.png?width=400&height=410&name=dashboard_to_slides_lookerstudio.png) ### Slide Template Here is a slide template. Remember, you must [create a slide template](https://helpcenter.slideform.co/how-to-create-a-slide-deck-template?hsLang=en) in Google Slides or PowerPoint and enter it as a New Project before you proceed. ![Screenshot 2024-06-28 at 2.10.19 PM](https://helpcenter.slideform.co/hs-fs/hubfs/Screenshot%202024-06-28%20at%202.10.19%20PM.png?width=688&height=146&name=Screenshot%202024-06-28%20at%202.10.19%20PM.png)This template has placeholders for text, charts, tables, and numeric KPI values that will be filled in. ### Match a dashboard chart to the template Let's begin by mapping charts to the chart placeholders in the template.  Navigate to the data source and click **Configure** to open it. ![](https://helpcenter.slideform.co/hs-fs/hubfs/Screenshot%202024-06-28%20at%202-27-23%E2%80%AFPM-png.png?width=300&height=162&name=Screenshot%202024-06-28%20at%202-27-23%E2%80%AFPM-png.png) In the charts section, select your worksheet (dashboard page) and click Preview to view all the charts from that page. To stay organized, you can rename or favorite the charts that you want to use in your slides. Click on one of the charts and then Preview to see a larger version. To match a chart to one of your placeholders, click the **Send icon** ![](https://helpcenter.slideform.co/hs-fs/hubfs/Screenshot%202024-06-28%20at%202-30-26%E2%80%AFPM-png.png?width=40&height=30&name=Screenshot%202024-06-28%20at%202-30-26%E2%80%AFPM-png.png).  A window will open where you can select the project (template) and the specific placeholder (pragma) where the chart should be placed. Click OK. ![Screenshot 2024-06-28 at 2.30.55 PM](https://helpcenter.slideform.co/hs-fs/hubfs/Screenshot%202024-06-28%20at%202.30.55%20PM.png?width=600&height=263&name=Screenshot%202024-06-28%20at%202.30.55%20PM.png)Repeat this for all the charts in your deck.  Charts and tables can also be mapped to placeholders on the Configure page for the project. ### Match a dashboard table to the template The process to embed a data table is very similar to that for a chart. In the Tables section of the Data Source page, select your worksheet and click preview to see all the data behind each dashboard element. Click on one of the tables and then **Preview** to see a larger version. ![](https://helpcenter.slideform.co/hs-fs/hubfs/Screenshot%202024-06-28%20at%202-38-51%E2%80%AFPM-png.png?width=600&height=94&name=Screenshot%202024-06-28%20at%202-38-51%E2%80%AFPM-png.png) If you want a subset of the table, you can set the columns to view or filter the data by any column value, or simply limit the number of rows to display. To match a table to one of your placeholders, click the **Send icon** ![](https://helpcenter.slideform.co/hs-fs/hubfs/Screenshot%202024-06-28%20at%202-30-26%E2%80%AFPM-png.png?width=40&height=30&name=Screenshot%202024-06-28%20at%202-30-26%E2%80%AFPM-png.png). In the next screen, select the correct placeholder and click OK. ### Fill in a KPI value from a dashboard table To select a numeric value from the dashboard and embed it in the slide as text, go to the project and click **Configure Data**. Find the blue box for the KPI and click **Preset a Value.** **![](https://helpcenter.slideform.co/hs-fs/hubfs/Screenshot%202024-06-28%20at%202-42-50%E2%80%AFPM-png.png?width=400&height=190&name=Screenshot%202024-06-28%20at%202-42-50%E2%80%AFPM-png.png)** Next, **select the data source** and choose Query From Table. This means you will pull the KPI value from the data behind one of the dashboard elements. Select the worksheet and table. **Choose the column** that contains this metric. For example, if I want to get the value of the Strength Index for Non-Sponsored Ads, I'd choose Strength Index here. Finally, **Add a filter** to select the exact value that you want to pull from the table. Click Preview to see the value and make sure it is correct. Scroll down to the end of the data mapping section and click **Save** to save the mapping.   ### Example Output Once all data is mapped to the template, click Generate on the project to get the results! ![Screenshot 2024-06-28 at 2.09.50 PM](https://helpcenter.slideform.co/hs-fs/hubfs/Screenshot%202024-06-28%20at%202.09.50%20PM.png?width=688&height=141&name=Screenshot%202024-06-28%20at%202.09.50%20PM.png)   - [Getting started](https://helpcenter.slideform.co/getting-started?hsLang=en#main-content) - [Pull data from a Dashboard](https://helpcenter.slideform.co/getting-started?hsLang=en#pull-data-from-a-dashboard) - [Pull data from a Spreadsheet](https://helpcenter.slideform.co/getting-started?hsLang=en#pull-data-from-a-spreadsheet) - [Pull data from a CRM](https://helpcenter.slideform.co/getting-started?hsLang=en#pull-data-from-a-crm) - [Pull data from a Database](https://helpcenter.slideform.co/getting-started?hsLang=en#pull-data-from-a-database) - [Data Sources](https://helpcenter.slideform.co/data-sources?hsLang=en#main-content) - [Data Source Setup](https://helpcenter.slideform.co/data-sources?hsLang=en#data-source-setup) - [Advanced Data Source Configuration](https://helpcenter.slideform.co/data-sources?hsLang=en#advanced-data-source-configuration) - [Templates](https://helpcenter.slideform.co/templates?hsLang=en#main-content) - [Create a template](https://helpcenter.slideform.co/templates?hsLang=en#create-a-template) - [Manage templates](https://helpcenter.slideform.co/templates?hsLang=en#manage-templates) - [Projects](https://helpcenter.slideform.co/projects?hsLang=en#main-content) - [Output Settings](https://helpcenter.slideform.co/projects?hsLang=en#output-settings) - [Bulk Mode](https://helpcenter.slideform.co/projects?hsLang=en#bulk-mode) - [Account](https://helpcenter.slideform.co/account?hsLang=en#main-content) - [Personal account settings](https://helpcenter.slideform.co/account?hsLang=en#personal-account-settings) - [Admin settings](https://helpcenter.slideform.co/account?hsLang=en#admin-settings) - [AI Analyst](https://helpcenter.slideform.co/ai-analyst?hsLang=en) - [Home](https://slideform.co/index.html) - [Blog](https://slideform.co/blog/) - [Help Center](https://helpcenter.slideform.co/) - [Security](https://trust.slideform.co/) - [Terms of Service](https://slideform.co/terms.html) - [Privacy](https://slideform.co/privacy.html) [![slideform logo](https://helpcenter.slideform.co/hs-fs/hubfs/Slideform_logo_text_black.png?width=223&height=50&name=Slideform_logo_text_black.png "slideform logo")](https://slideform.co?hsLang=en) slideform.co Help Center Copyright © 2025, Slideform Inc.