Advanced Settings

Advanced Settings

We do not recommend changing advanced settings unless you are an experienced Panoply user.

For users who have some experience working with their data in Panoply, there are a number of items that can be customized for this data source.

  1. Destination Schema: This is the name of the target schema to save the data. The default schema is Public. This cannot be changed once a source had been collected.
  2. Destination: The default destination is adwords_<reportName>, where <reportName> is a variable. Each report has its own destination table, prefixed with adwords_.
  3. Primary Key: The default is built out of fields from each report, as shown here:

    Report Fields that create the primary key
    Criteria Performance Report Campaign ID
    Ad group ID
    Keyword ID
    Day
    AdGroup Performance Report Campaign ID
    Ad group ID
    Device
    Day
    Ad Performance Report Campaign ID
    Ad group ID
    Ad ID
    Day
    Search Query Performance Report Campaign ID
    Ad group ID
    Ad ID
    Day
    Display Keyword Performance Report Campaign ID
    Base Campaign ID
    Ad group ID
    Base Ad group ID
    Keyword ID
    Customer ID
    Geo Performance Report Campaign ID
    City
    Country/Territory
    Customer ID
    Metro area
    Most specific location
    Region
    Ad type
    Ad group ID
    Ad group state
    Network
    Network (with search partners)
    Day
    Device
    Location type

4. Exclude: The Exclude option allows you to exclude certain data, such as names, addresses, or other personally identifiable information. Enter the column names of the data to exclude.

5. Parse String: If the data to be collected contains JSON, include the JSON text attributes to be parsed.

6. Truncate: Truncate deletes all the current data stored in the destination tables, but not the tables themselves. Afterwards Panoply will recollect all the available data for this data source.

7. Click Save Changes and then click Collect

  • The data source appears grayed out while the collection runs.
  • You may add additional data sources while this collection runs.
  • You can monitor this collection from the Jobs page or the Data Sources page. 
  • After a successful collection, navigate to the Tables page to review the data results.

Next Steps

Getting started is easy! Get all your data in one place in minutes.
Try Free