How and why I built Data Studio Blended Data from AdWords and Analytics

About me

I have been developing for over 20 years. I always love learning new tech. I have been working at a small company as the lone IT person and I love the challenges that everyday the owner throws my way. Never a dull day. Looking for someone to help / assist / mentor for $ with Google Data Studio and a report I am trying to generate.

The problem I wanted to solve

I have a report that I built that has all of the transactions, by Campaign/AdGroup Keywords used, Order Amount for CPC. What I need help with is getting this report to show only transactions that occurred from a certain campaign or AdGroup Name. I have hit a wall...

What is Data Studio Blended Data from AdWords and Analytics?

https://datastudio.google.com/s/lda6RW9jZrE

Tech stack

AdWords |Goog Analytics | Goog Adwords
Campaign|Transaction# | AdGroup

The process of building Data Studio Blended Data from AdWords and Analytics

It has been a modg-podge of trial and error and not sure how I got where I did.

Challenges I faced

Cannot Filter the result set of data successfully by "AdGroup Name"

Key learnings

Tips and advice

Final thoughts and next steps

Need a helping hand.