This dasboard is the first part of a series of blog posts on how to track and improve adwords performance.
In Part 1, we will start tracking our Ads to understand which ones are performing well and which ones we need to: either cancel or modify.
On coming series, once we have identified which Ads are underperforming, we will learn how to modify them to increase their performance.
What insights can we get with this dashboard?
In this dashbord you will be able to understand:
Which Ads are most successful
Which Network has performed best
Cost of your Ads and revenues
What needs to be improved to achieve more goals.
Watch it on
If you would like to see a live version of the dashboard, you can watch it in our YouTube Channel, but if you prefer text, continue reading.
Download the Power BI file & Dashboard guide
Don't want to create the Power BI file? If you are a member on our site (it's free), you can download it by following this link. You will also get there an indepth explanation on how to use/interprete the dashboard.
You are running Ads because you want to achieve something: Want to increase traffic to your website? Or increase sales, conversions, or ROI? Raise brand awareness?
Depending on which Goal you want to track, you will need to download the specific goal metric into power bi.
This site is running ads to get more member signups, and those goals are tracked in Goal 2 in google analytics. To keep a close eye on the member signups, we will dowload them and track them separately.
Rename the table “AdWords” and click on “Close and Apply”
Building the Dashboard
Now that we have all the data we need, lets start building the dashboard.
For this dashboard we don’t need to create any measure (amazing, eh?).