Skip to main content
Ctrl+K
Adverity Documentation  documentation - Home

Getting started with Adverity

  • Glossary
  • Get started with Adverity
    • Get to know Adverity
    • Creating a datastream
    • Applying Data Mapping
    • Loading data into Adverity Data Storage, Explore & Present, and external destinations
    • Creating widgets and a dashboard
  • Migrating to Adverity
    • Adverity for Fivetran users
    • Adverity for Funnel users
    • Adverity for Improvado users
    • Adverity for Marketing Cloud Intelligence users

Data sources

  • Available data sources in Adverity

Connect Data

  • Datastreams
    • Creating a datastream
    • Collecting data
      • Manual, Smart, and Custom fetches
      • Configuring advanced datastream settings
      • Managing datastreams
      • Scaling datastreams
      • Working with data extracts
      • Combining data extracts using Bundle
      • Using datastream templates
      • Using placeholders to name objects
      • Viewing datastream issues
      • Collecting and visualizing non-aggregatable metrics
      • Working with duration data
    • Data Mapping
      • Applying Data Mapping to a datastream
      • Configuring advanced Data Mapping
    • Troubleshooting
      • Troubleshooting data discrepancies
      • Troubleshooting errors when collecting and loading data
  • Authorizations
    • Creating and viewing authorizations
    • Managing authorizations
    • Setting up authorizations to store data extracts
    • Configuring required permissions for data extract storage
    • Authorizing specific data sources
      • Setting up an authorization to Amazon Athena
      • Setting up an authorization to Marketo
      • Setting up an authorization to Partnerize
      • Setting up an authorization to Rakuten Advertising
      • Setting up an authorization to Salesforce Marketing Cloud
      • Setting up an authorization to SFTP server with a public key
      • Setting up an authorization to Web Connect
      • Setting up an authorization to X Public Basic OAuth2
      • Setting up an authorization to TikTok Business
  • Activity
    • Using the Performance Manager

Manage Data

  • Transformations
    • Transforming data in Adverity
    • Using standard transformations
      • Create or Edit Columns
      • Adding rules to the Create or Edit Columns transformation
      • Currency Conversion
      • Join Datastream
      • Match & Map
      • Smart Naming Convention
      • Executing Smart Naming Conventions on conditions
      • Translation
      • Unify Location Data
      • Previewing transformations
    • Using custom script transformations
      • Available custom script instructions
      • Using the Transformation Copilot
      • Creating geolocation transformation scripts
      • Creating ISO region codes for geo maps
      • Creating rounding transformation script
      • Repository of ISO region codes for geo maps
      • Using Python expressions in custom scripts
      • Using Python expressions to manage dates
        • Adding certain dates to data extracts
        • Converting dates from one format to another
        • Converting time data between time zones
    • Mapping tables
      • Creating and applying mapping tables
      • Advanced mapping table settings
      • Automatically populate a mapping table
    • Value tables
      • Creating value tables
      • Advanced value table settings
      • Automatically populate a value table
  • Data Quality
    • Working with universal monitors
    • Working with custom monitors
    • Viewing details of the Data Quality issues
  • Data Dictionary
    • Creating and editing target fields
    • Default Data Mapping
    • Data types and measures
  • dbt Projects (Beta)
    • Adding a dbt project
    • Running a dbt project

Use Data

  • Data Conversations
    • Prompting Data Conversations
    • Setting up your data flow to use Data Conversations
  • Loading data into Explore & Present
  • Explore
    • Creating widgets and adding them to a dashboard
      • Selecting data to add to a widget
      • Configuring data tables
      • Configuring fields in data tables
      • Creating identical or similar widgets
      • Creating widgets comparing data over time
      • Filtering the data shown in widgets
      • Using Calculated KPIs and adding them to widgets
    • Creating visualization widgets
      • Configuring bar, line, and scatter chart widgets
      • Creating a bar chart to visualize potential impressions
      • Creating a Sankey diagram to visualize duration data
      • Creating custom data sets in widgets
      • Creating geo map widgets
      • Customizing KPI box widgets
      • Displaying images in data tables and KPI boxes
  • Present
    • Creating dashboards in Present
      • Adding widgets to a dashboard
      • Adding images to a dashboard
      • Adding websites and YouTube videos to a dashboard
      • Using dashboard templates
      • Using the Custom Library of widgets
      • Working with widget filter templates in Present
    • Managing dashboards
      • Adding filters to a dashboard
      • Cloning dashboards
      • Confirming data completeness
      • Deleting dashboards
      • Freezing dashboards
      • Optimizing dashboard performance
      • Switching the dimensions and metrics shown in widgets
      • Using dashboard labels
      • Using dashboard pages
      • Using dashboard themes
    • Sharing dashboards
      • Displaying dashboards in TV-screen mode
      • Embedding dashboards and widgets in Microsoft PowerPoint
      • Exporting dashboards
      • Publishing dashboards
      • Sharing dashboards and widgets
  • Destinations
    • Setting up destinations
    • Destination guides
    • Asking someone to set up an authorization to a destination
    • Configuring data loading settings
    • Data types across different database engines
    • Analyzing data with ChatGPT

Administration

  • Adverity core connectors and destinations
  • Understanding your Adverity usage
    • Measuring Adverity usage with unique data rows
    • Viewing resource usage
  • Managing workspaces
    • Creating and deleting workspaces
    • Configuring workspace settings
    • Best practices for workspace structure
    • Cloning workspaces
    • Selecting workspaces
    • Configuring data warehouses for workspaces
    • Setting up storage for data extracts
  • Managing users
    • Adding and deleting Adverity users
    • Changing user settings and passwords
    • Managing user notifications
    • Managing user permissions
    • Configuring Single Sign-On
    • Using two-factor authentication
  • Connecting an external data warehouse
    • Connecting a Google BigQuery warehouse
    • Connecting a Snowflake warehouse
  • Providing Adverity Support with a browser log
  • Administration in Explore and Present
    • Workspace
      • Creating and deleting workspaces in Explore & Present
      • Configuring workspace settings in Explore & Present
      • Configuring the default color palette for Explore and Present
      • White labeling in Explore & Present
    • Users & roles
      • Getting an overview of users in Explore & Present
      • Adding and deleting Explore & Present users
      • Roles and permissions in Explore & Present
      • Changing your user settings in Explore & Present
      • Using role-based filters in Explore & Present
    • Manage
      • Configuring columns settings
      • Managing your dashboards
      • Configuring visualisation settings
      • Using alerts in Explore & Present
    • Security
      • Security settings in Explore & Present
      • Viewing activity audits in Explore & Present

Management API

  • Getting Started
  • Authorization
  • Managing workspaces
    • Creating workspaces
    • Configuring workspaces
  • Creating and configuring authorizations
  • Managing datastreams
    • Creating datastreams
    • Configuring datastreams
  • Collecting data
    • Collecting data
    • Scheduling fetches
  • Configuring Data Mapping
  • Transforming data
    • Creating and configuring transformations
    • Configuring mapping tables
  • Transferring data
    • Creating and deleting destinations
    • Assigning destinations to datastreams
  • Administration
    • Managing jobs
    • Listing issues
    • Managing users
    • Configuring notifications

What's new?

  • Release notes
  • Announcements
  • Incidents

AI & Automation

  • LLM-Ready Documentation

Google Ads Keyword Planner: Setup guide

Contents

  • Introduction
  • Limitations
  • Prerequisites
  • Creating a datastream to collect data from Google Ads Keyword Planner
    • Configuration: Choose the data you want to collect from Google Ads Keyword Planner
  • What’s next?

Google Ads Keyword Planner: Setup guide#

This guide explains how to collect data from Google Ads Keyword Planner.

Introduction#

For a list of the fields that you can collect from Google Ads Keyword Planner, see Google Ads Keyword Planner.

Limitations#

Collecting data from Google Ads Keyword Planner comes with the following limitations:

  • You cannot fetch data for the current month using the Google Ads Keyword Planner API. This may also result in an error in the first three days of a month when trying to fetch data for the previous month.

Prerequisites#

Before you start collecting data from Google Ads Keyword Planner, perform all of the following actions:

Creating a datastream to collect data from Google Ads Keyword Planner#

The basics of creating a datastream to collect data from any data source are explained in our guide to Collecting data in Adverity. This guide contains information about the specific steps to create a datastream to fetch data from Google Ads Keyword Planner.

Configuration: Choose the data you want to collect from Google Ads Keyword Planner#

To choose what data to collect and customize the Google Ads Keyword Planner datastream configuration, follow these steps:

  1. (Optional) Rename your datastream.

  2. In Report type, select the type of data to collect from Google Ads Keyword Planner. The selected report type determines the additional fields to populate.

  3. In Customers, select the customers for which to collect data. If you do not select any items in a drop-down list, Adverity collects data for all items in the drop-down list.

  4. In Sites URLs, choose how you want to specify the site URLs on which to collect data:

    Type in

    Select this option to manually enter the site URLs for the sites on which you want to collect data.

    If you select this option, in Type in, type in the site URLs on which you want to collect data, separated by commas.

    Value table

    Select this option to provide a value table containing the site URLs on which you want to collect data.

    If you select this option, in Sites value table, select the value table containing the site URLs on which you want to collect data.

  5. In Keywords, choose how you want to specify the keywords on which to collect data:

    Type in

    Select this option to manually enter the keywords on which you want to collect data.

    If you select this option, in Type in, type in the keywords on which you want to collect data, separated by commas.

    Value table

    Select this option to provide a value table containing the keywords on which you want to collect data.

    If you select this option, in Keywords value table, select the value table containing the keywords on which you want to collect data.

    Keyword plans

    Select this option to retrieve saved keywords from Google Ads UI. If left empty, all keyword plans will be used to retrieve the saved keywords.

    If you select this option, in Keyword plans, select the keyword plans on which you want to collect data.

  6. In Bid strategy, select the bidding strategy on which you want to collect data.

  7. In Max CPC bid, enter the maximum cost per click bid on which to base the performance forecast.

  8. In Biddable keywords, enter comma-separated keywords to be used in the ad group for the forecast.

    You can specify the match type by entering the keywords in the following format:

    • Enter the keyword without additional formatting to use broad matching, for example keyword.

    • Enter the keyword in single quotes to use phrase matching, for example 'keyword'.

    • Enter the keyword in square brackets to use exact matching, for example [keyword].

  9. In Negative keywords, enter comma-separated negative keywords to be used in the ad group for the forecast.

    Use the same formatting rules as for the Biddable keywords.

  10. In Conversion rate, enter the conversion rate for the forecast as a percentage. If this field is left empty, an estimated conversion rate will be used.

  11. In Plan Network, choose to collect keywords data for either Google Search or Google Search and Partners.

  12. In Match Type, select how close the keyword needs to match the user’s query for data to be collected. For more information about the match types, see the Google documentation.

  13. In Language, select the language on which you want to collect data.

    For the Forecast metrics report type, you can select multiple languages.

  14. In Locations, select the locations on which you want to collect data.

  15. In Max CPC, enter the maximum cost per click.

What’s next?#

  • Apply Data Mapping to your collected data to harmonize data collected from different sources in Adverity.

  • Transform your data to meet your needs by creating and applying transformations to your datastream.

  • Load your data into Explore & Present to visualize your data in Adverity.

  • Load your data into an external destination of your choice.

Contents
  • Introduction
  • Limitations
  • Prerequisites
  • Creating a datastream to collect data from Google Ads Keyword Planner
    • Configuration: Choose the data you want to collect from Google Ads Keyword Planner
  • What’s next?

By Adverity

© Copyright 2025, Adverity.