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: Setup guide

Contents

  • Prerequisites
  • Creating a datastream to collect data from Google Ads
    • Authorization: Allow Adverity to access Google Ads
    • Configuration: Choose the data you want to collect from Google Ads
  • What’s next?
  • Troubleshooting Google Ads
    • I see an error message when fetching data from Google Ads
    • Accounts are missing from the data I have fetched from Google Ads
    • Customer statuses are missing in the authorization Customers

Google Ads: Setup guide#

This guide explains how to collect data from Google Ads.

Prerequisites#

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

  • Ensure that the account you use to connect to Google Ads has Read only or higher permissions. For more information, see the Google Ads documentation.

  • To collect invoice data, activate monthly invoicing in your Google Ads account. For more information, see the Google documentation.

Creating a datastream to collect data from Google Ads#

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.

Authorization: Allow Adverity to access Google Ads#

  1. If you choose Access using your credentials or Access using someone else’s credentials, in Set up or edit Customers, you or the person granting access must choose one of the following options:

    • Choose Grant access to all items, including those created in the future to give Adverity Customers to access all existing items and all items created in the future.

    • Choose Select specific items to which you want to grant access to only give Adverity Customers to access the selected items. Adverity will not automatically have access to items created in the future. You will need to grant Adverity access to any items created in the future.

    Warning

    If you use your credentials to grant Adverity access to Google Ads, all the items available to you using your credentials will be visible in the Authorizations page to all Adverity users with permission to edit this authorization.

    If someone else uses their credentials to grant Adverity access to Google Ads, the same applies to the items available using their credentials.

    This is important to consider if you do not want all Adverity users with permission to edit the authorization to be able to see the details of the authorization items. For more information about user permissions, see Managing user permissions.

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

Note

This connector reports data in the timezone of the authorized customer account.

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

  1. (Optional) Rename your datastream.

  2. In MCCs, Customers, and Campaigns, select the My Client Centers accounts (MCCs), customers, and campaigns 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.

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

  4. In Resource level, select a level in the hierarchy of Google Ads resources. Adverity generates a report for this level. For more information, see the Google documentation.

  5. In Segments, select the categories that Adverity uses to divide and group your data. You can only select one of the following date segments: Day, Week, Month, Quarter. The selected date segment determines the date range you can choose later when you fetch data. For more information, see Selecting the date range for a fetch.

  6. In Metrics and Attributes, change the list of fields that you want to see in your data extract.

    Note

    Google Ads considers some metrics to be attributes. If you cannot see a specific metric in the Metrics drop-down list, look in the Attributes drop-down list.

  7. In Billing Setups, select the billing setups for which to collect data. If you do not select any billing setups in a drop-down list, Adverity collects data for all items in the drop-down list.

    This field is visible if you select Invoice in Report type. The items selected in the MCCs and Customers fields determine which billing setups you can select.

  8. In Recommendation fields, change the list of fields that you want to see in your data extract.

    This field is visible if you select Recommendation in Report type.

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.

Troubleshooting Google Ads#

I see an error message when fetching data from Google Ads#

The Customer with ID [ID] has a policy to enforce 2-Step Verification, but the user is not enrolled error message appears when the user who has authorized the connection to Google Ads requires two-factor authentication.

To resolve this issue, the user who authorized the connection must log in to Google Ads and activate two-factor authentication for their account and any sub-accounts.

Accounts are missing from the data I have fetched from Google Ads#

Adverity synchronizes accounts daily around midnight UTC. This sycnhronization has lower priority than manual and scheduled fetches. As a result, if you perform or schedule a high number of fetches, accounts will not be synchronized until after these fetches are complete. Additionally, if you add an account after the daily synchronization and then fetch data, the newly added account will not appear in the data. It will only be included after the next synchronization.

To resolve this issue, manually synchronize the metadata for the authorization you are using to fetch data. For more information, see Synchronizing metadata.

Customer statuses are missing in the authorization Customers#

In the authorization Customers for Google Ads, customers have the status Active or Inactive. If a customer’s status is missing, this is due to Google Ads’s configuration and cannot be changed.

Contents
  • Prerequisites
  • Creating a datastream to collect data from Google Ads
    • Authorization: Allow Adverity to access Google Ads
    • Configuration: Choose the data you want to collect from Google Ads
  • What’s next?
  • Troubleshooting Google Ads
    • I see an error message when fetching data from Google Ads
    • Accounts are missing from the data I have fetched from Google Ads
    • Customer statuses are missing in the authorization Customers

By Adverity

© Copyright 2025, Adverity.