How to use the Google Ads Search Queries Tableau Template | Scribe

    How to use the Google Ads Search Queries Tableau Template

    • Victor Andrei Lupaescu |
    • 0 step |
    • 2 minutes
      Navigate to [https://onboard.windsor.ai/](https://onboard.windsor.ai/)
      Click "REGISTER"
      Enter your details and click on "Register / Start Free Trial"
      Choose "Google Ads" from the Data Sources panel
      Click "SIGN IN WITH GOOGLE", connect with your Google account and grant the required privileges.
      Choose the Google Ads account/s that you want to add
      Click "2. PREVIEW AND DESTINATION"
      Add all the fields that you want to include in your dashboard.
      Choose Tableau as a Data Destination
      Click "COPY". This will copy your API URL to clipboard and you'll use it later in Tableau Desktop.
      Open the template available on Tableau Public: [https://public.tableau.com/app/profile/victor.lupaescu/viz/WindsorMarketing-GoogleAdsSearchTerms/GoogleAds-SearchTermsPerformance](https://public.tableau.com/app/profile/victor.lupaescu/viz/WindsorMarketing-GoogleAdsSearchTerms/GoogleAds-SearchTermsPerformance)
      Click on the "Download" button
      Choose "Tableau Workbook"
      Choose the Tableau Desktop version that you're using and click "Download"
      Open the downloaded workbook in Tableau Desktop. Connect to your Google Analytics data by clicking on Data -> New Data Source. Choose Web Data Connector -> enter [https://tableau.windsor.ai](https://tableau.windsor.ai) -> enter the URL you’ve copied at step 10. Note: If you want exactly the same fields as in the template, you can use this URL (replacing <API key> with your key from step 10): [https://connectors.windsor.ai/google_ads?api_key=](https://connectors.windsor.ai/google_ads?api_key=)<your_API_here>&date_preset=last_365d&fields=account_name,ad_group_name,all_conversions,campaign,clicks,date,device,impressions,source,spend
      Once your data has been added, replace the existing data source with the newly created one (from Data – Replace Data Source).
      That’s it. Now you have your own Google Ads data in Tableau. You can find more templates here: [https://windsor.ai/templates/tableau/](https://windsor.ai/templates/tableau/)

      Want to make guides like this in seconds? Yes, it's really that fast.

      This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe