Looker Studio is a widely-used and free data visualization tool that transforms your data into customizable dashboards. With Two Minute Reports, you can connect over 30 data sources, uncover essential insights, and create impactful reports in Looker Studio within minutes.
Before you get started, ensure that you’ve integrated relevant data sources. Now, let me explain the step-by-step process of running a query in Looker Studio to streamline your data analysis and client reporting.
Step 1: Navigate to the Query Configs tab and click + Add New. A dialog box appears, as shown below.
| Query config lets you gather data from multiple accounts, making it easier to view centralized insights in your Looker Studio dashboard. |
Step 2: Name the query config and select the ad accounts. You can select only the “enabled accounts” from the dropdown. If you wish to enable a disabled account, you can click on the “Accounts” option from the popup, easily navigate back to the accounts page, and change the status.
If the accounts aren’t visible, you can create a connection to link accounts within a few clicks. Check out “How to create a connection in Looker Studio” to learn about streamlining account management.
Step 3: Once you’ve selected the list of enabled accounts, you can configure your Facebook Ads reporting options as shown below and click Save.
Step 4: You’ve successfully created a new query configuration. This approach brings your key connections and ad accounts under one dashboard to simplify client reporting and improve decision-making.
Step 5: After creating the query config, click Create Report at the top-right corner as shown below:
Step 6: Select the query config you created in Step 3. Click Next and choose Create report from scratch to open the Looker Studio dashboard. Refer to the screenshots below:
Note: To create Looker Studio reports more efficiently with templates, check out our article – “How to use templates for Looker Studio.”
Step 7: Once the Looker Studio dashboard opens, select the relevant team and the appropriate Query Config (KB Query). Then, click Connect at the top-right corner.
Here, you can view the list of available Facebook Ads metrics. Next, click the Create Report as shown:
Step 8: After completing the above steps, you’ll be directed to the Looker Studio dashboard.
Here, you can drag and drop metrics and dimensions for the selected accounts from the sidebar on the right and include different charts and visualizations for your Looker Studio reports to deliver a compelling narrative.
To add a chart, navigate to your Looker Studio dashboard and click “Add a chart”. You can choose from the list of options as shown below.
Step 9: For example, you can use table format for detailed data representation. Scorecards highlight critical metrics, and time series illustrate trends and pattern changes. Likewise, you can also add date range control to analyze performance during a specific period.
Here’s a breakdown of what works well in each format:
| Visualization type | Best suited for | Example |
| Graphs | Monitoring trends, changes over time, and comparisons. | A line graph showing the monthly website traffic over a year, highlighting the ups and downs in customer visits. |
| Tables | Representing granular information for precise reporting and analysis. | A table displaying impressions, clicks, and conversions categorized by month to track detailed campaign performance. |
| Charts | Present your data in various forms, such as pie charts, scatter plots, gauge charts, etc., to communicate key insights visually. | A pie chart showing the percentage of total conversions attributed to each social media platform. |
Note: When using excessive charts or other visualization types, Looker Studio might slow down in execution. Check out our five tips to increase the speed of your Looker Studio reports to optimize the performance of your Looker Studio dashboard.
Step 10: You can repeat the same steps to add the required tables/charts to your Looker Studio report by selecting the metrics and dimensions that reflect your crucial business goals. This way, you can get a clear picture of what works, what doesn’t, and the next steps with zero hassle.
Now that you’ve got an idea of creating connections and running queries in Looker Studio, it’s time to experience the results yourself. Sign up for a 14-day free trial and understand how TMR transforms your data into strategic business outcomes.
Note: We’ve also listed some of the prevalent issues marketers face while running reports on Looker Studio, along with actionable solutions to resolve them. Read the full article here.
We hope you found this guide useful. If you have any questions, please contact our support team via support@twominutereports.com.