Forum Discussion
Building a Google Adwords Query in Power BI
Hi Everyone,
I am building an AdWords query in Power BI. The query contains all the dimensions and metrics I am looking for, but when I add the "search query" dimension, the data changes. Before I add the "search query" dimension the value for my total cost is $7,635.08. After I add the search query dimension the value for my total cost becomes $3,669.80. Below is a before and after photo. The first photo is before the search query dimension is added. These values are accurate. The second photo is after the search query dimension is added. These values are not accurate. Any help or advice on this issue is greatly appreciated.
Thank you,
Joshua Cortigiano
7 Replies
- amitchandak
Super User
Anonymous , need to check to join with the search query, is it many to many? Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi amitchandak ,
Here is the file without any sensitive data https://drive.google.com/file/d/1nfLPxCqK3Oqh7SUw9MPzfZcCq_uJMTtv/view?usp=sharing
I do not think I have a join with the search query because I was just trying to import the search query dimension into a preexisting keywords query as a column, to go along with the other columns, this way everything is in a single table.
- amitchandak
Anonymous , I do not see any table or column with the name search query in the file. am I missing something
ReportBuilder07Helper III
Hi, since there’s no built-in connector for Google Ads to PBI anymore, you would have to use another option. As a workaround, maybe you can use a 3rd party connector, it can save you a lot of time compared to the other options. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Google Ads connector in the data sources list:
After that, just grant access to your Google Ads account using your credentials, then on preview and destination page you will see a preview of your Gads fields:
There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.
