Adwords And Google Data Studio: Wordstream Alternative

I’ve been managing Google Adwords campaigns for political campaigns mostly but recently I stepped out into managing the Adwords campaigns for an IT consulting company. It’s a little bit of a challenge I’m not going to lie. More than just matching the search with the keyword I need to attract only business customer and cut out residential. So as you can image someone Googles “IT Help Desks” and they might be looking for a specific help desk, a personal help desk or a help desk to contract business services too.

Wordstream Free Alternative

In Ultimate SEO‘s  struggle to compete in this expensive market I tried Wordstream out for a week and a half of so and thats really not enough time to get much actionable help. I was pulled into a sales demo consultation and sure it seemed like it could offer insights but WOW … the expense associated with that out paced any other SEO tool I use. I felt the main task Wordstream was completing was organizing and presenting the data in a way that I could see the areas of need. Google Data Studio has been doing that for me in SEO for over a year now so I’ve tried my hand at making a Google Adwords Google Data Studio report with the aim to save about three hundred a month from getting Wordstream.

google data studio adwords

google data studio adwords

Data Studio Adwords Template

Google Data Studio also lets you copy reports that others make available and you can attach your own data respository to populate the report. Basically if you want a Google Data Studio Template for Adwords you’re welcome to copy this report in Google Data Studio.

I’ll come back in a month and let you know how this free product helped or didn’t help me rather than paying PPC software provides.

Ultimate SEO”Ultimate SEO”

Adwords Template With Search Console, Google Analytics In Data Studio

Adwords Template With Search Console, Google Analytics In Data Studio

SEO & PPC Data Studio Report Using Adwords, Google Analytics and Google Search Console All-In-One Template

Google Data Studio Reports are some fun things.  Here at Ultimate SEO you love visualizations and thats partially why we like Data Studio. Beyond the looks its also integrated easily with Google Sheets, Google Analytics and Search Console to name a few. These few though create a powerful free SEO PPC tool.

You can check out the report directly by clicking the link above, here is an embedded look at the nine pages of live data thats basically always right.  It’s nice to be able to pull in data from two very different Google tools.  Lots of people know of Google Analytics and think it covers Google Search Console but it doesn’t and I’ll discuss that more in another post but the unique data from these sources can all mix to form one handy live report.

You can check out all the information pulled here in this report and change the dates as needed using the drop down.  To personalize the report to your own site simply copy it and set the data sources to your own Google Analytics and Search Console sources.  Word of caution on the Search Console aspect there are two connections, one is the site and the other I believe is the page urls.  So make sure to connect those correctly.  Just like in electrical work it’s like to like.

Across these nine pages you’ll find insights into any site with an Adwords campaign including keywords, search terms, CTR and CPC.

Ultimate SEO”Ultimate SEO”