Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , I do not see any table or column with the name search query in the file. am I missing something

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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