Google Ads reporting template for Power BI
Optimize your campaigns with data-driven insights using this Google Ads reporting template for Power BI. See instructions below and start using the template!
Data sources:
Use cases:
Paid media
Insights at a glance
Deep dive into campaigns
Optimize your spend
How to use the template
To get started, make sure that you’ve got access to Google Ads and that you're logged in to Power BI.
- Log in to Supermetrics Hub.
- Click "Connect to Power BI", download the connector, and follow the installation steps.
- On the Power BI page in Supermetrics Hub, click "Create new query", pick Google Ads as the data source, and log in. You have now connected Supermetrics to Power BI.
- Next, you have to download the template. Click ‘Get the template’ below. The download will start automatically.
- Open the template in Power BI. Click 'Refresh' in Home Tab.
- If prompted, sign in to the same account you used in Supermetrics Hub. After this, the template will fetch all your data in the report, ready for you to derive insights.
Questions you can answer with this template
Overall campaign performance
- What is the total spend of each channel?
- What are the overall impressions during last month?
- How is your ROAS?
- What is the overall CTR, COM, CPC, and CPA during the period of time?
Search
- What are the top campaigns by clicks?
- How did your key metrics look like by campaign or ad group?
- What are the top keywords people search for by clicks?
- What keywords do people look for by clicks?
Display
- What are the top display campaigns?
- How much did you spend on display campaigns? What’s the CPC?
- What format of display ads is most popular?
- Which ads attract most clicks or views?
YouTube
- How do your YouTube videos perform throughout the funnel?
- How many people watched 50% of the video?
- What are your video views, impressions, and VTR?
- What are the top-performing video campaigns by views?
- What are the top ad groups by video views and their cost?
Cross-network
- Which campaign brings us the best ROAS?
- What is the ad performance by funnel?
Get started with Google Ads report template for Power BI
Try our free template and experience the power of insights with a 14-day free trial. No credit card required.
