Forum Discussion
Building a Google Adwords Query in Power BI
Super UserAnonymous , 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
amitchandak no you are not missing anything, I do not have the "search query" column in the keywords table because it throws off the totals in the table visual. I did leave permissions enabled for the google analytics connector, in case you wanted to add the "search query" dimension to the keywords table from the AdWords folder in the google analytics connector. Adding the "search query" dimension to the keywords table will cause the total values in the table visual to drop by about half
amitchandak the path to the "search query" dimension is
-Google Analytics Connector-owlcyberdefense|analytics account [4]
-https://owlcyberdefense.com
-https://owlcyberdefense.com(main)
-adwords
-Search Query
V-lianl-msftCommunity Support
Hope this thread will help you:
https://community.powerbi.com/t5/Desktop/Google-adwords/m-p/643727