Google Ads Table and Schema Information

👤 This documentation is intended for Site Administrators and/or Database Administrators.

Connectors are Periscope Data’s built-in mechanisms for customers to connect to and ingest from popular data sources. The below information related to the Google Ads Connector.

Note: Connectors are supported for customers with Data Engine on your Warehouse or Warehouse infrastructure. Site administrators can contact their Account Manager if interested in enabling Connectors.

<div>
<UL>
<LI><a href="#GoogleAdsIngestion">Google Ads Ingestion</a></LI>
<LI><a href="#ColumnSelection">Column selection and Google compatibility rules</a></LI>
<LI><a href="#AboutReportTables">About Report Tables</a></LI>
<UL>
<LI><a href="#DataIngestion">Data ingestion and conversion windows</a></LI>
<LI><a href="#DataLoading">Data loading and append-only ingestion</a></LI>
<LI><a href="#Queryingr">Querying Google Ads Data</a></LI> <LI><a href="#Currency">Currency Values</a></LI>
<LI><a href="#ColumnSelectionAndStatisticAggregation">Column selection and statistic aggregation</a></LI>
</UL>
<LI><a href="#TableSchemas">Google Ads Table Schemas</a></LI>
</UL>
</div>
<HR>

<a name="GoogleAdsIngestion"></a>

Google Ads Ingestion

There are two types of tables in Periscope’s Google Ads integration: Core Object and Report.

  • Core Object tables contain foundational data that’s useful for analysis. These are the accounts, ad_groups, ads, and campaigns tables. These tables are ingested in full each time a job is run.
  • Report tables are the various Google Ads reports. These tables are extracted using a conversion window (a period of time after a customer clicks an ad that a conversion (ex: a purchase) is recorded in Google Ads) of 30 days. This means that data from the past 30 days will be ingested during every ingestion job. Report tables are loaded into the data warehouse using Append-Only ingestion (only new records are extracted and added to the table). 

<a name="ColumnSelection"></a>

<a href="#top">Back to top</a>

Column selection and Google compatibility rules

Because of Google’s compatibility rules, some columns (metrics and segments) can’t be tracked together. As columns are selected to track, incompatible fields will automatically be greyed out.

Additional Google Ads integrations can be created if there is a need to track incompatible columns. The resulting table names will still be the same (ex: account_performance_report) but the data will reside in different schemas in the data warehouse.

<a name="AboutReportTables"></a>

<a href="#top">Back to top</a>

About Report Tables:

<a name="DataIngestion"></a>

Data ingestion and conversion windows

Due to the Conversion Window, a high ingestion frequency may not be necessary because Periscope will ingest data from the past 30 days during every ingestion job. To avoid ingesting redundant data, consider setting the integration to ingest less frequently. For example: every 12 or 24 hours.

<a name="DataLoading"></a>

<a href="#top">Back to top</a>

Data loading and append-only ingestion

The number of rows loaded into the table during each ingestion job is dependent on the combination of unique values in the dimension columns that are tracked. 

For example, let’s say these columns are selected in the ad_performance_report table:

  • campaignId (dimension) - This is the ID associated with a campaign. In this example, there are two campaigns: 929007494 and 929599581
  • device (dimension) - The device type. There are two values for this example: Computer and Tablet
  • impressions (metric) - The total number of impressions.

Every time Periscope ingests and loads data, a row for each unique combination of the dimension columns will be appended to the end of the table:

<a name="Querying"></a>

<a href="#top">Back to top</a>

Querying Google Ads Data

Querying for the latest data in Report tables will require a different strategy than one might usually use. Periscope will add a column named _sdc_report_datetime to Report tables to help identify the most recent records in a table.

For Example: If only the most recently ingested data for any Google Ads Report table is desired, the sample query below can be used:

<body>
<blockquote>
<br>SELECT *,
<br>RANK() OVER (PARTITION BY day, customerid
<br>ORDER BY _sdc_report_datetime DESC)
<br>FROM ad_performance_report
<br>ORDER BY day ASC
<br>) AS latest
<br>WHERE latest.rank = 1
</blockquote>
</body>

This query uses two columns - which are automatically included for every Report table - to return the latest data:

  • day - The day that the record pertains to.
  • _sdc_report_datetime - The starting time of the ingestion job that extracted the record.

The above query ca be used to get started, however alterations will need to be made based on the SQL syntax of the warehouse and the dimensions contained in a given table.

<a name="Currency"></a>

<a href="#top">Back to top</a>

Currency Values

Values in currency fields are extracted in micro currency units. This is how the Google Ads API formats currency. Micro amounts always refer to the Google Ads account’s local currency.

For example: The value of $2.25USD will be recorded as 2250000. To represent this value as 2.25 in a report, divide by one million: 2250000 / 1000000 = 2.25.

<a name="ColumnSelectionAndStatisticAggregation"></a>

<a href="#top">Back to top</a>

Column selection and statistic aggregation

The dimension columns selected for ingestion in Report tables can impact how performance statistics are aggregated. Additionally, this can also affect the number of rows ingested and loaded into the destination.

For example: if day, _sdc_customer_id, campaignId, device, and impressions were selected, the impressions column would contain the total number of impressions for the device type for that date:



<a name="TableSchemas"></a>

<a href="#top">Back to top</a>

Google Ads Table Schemas

Click on the arrow to dropdown the table.  Click on the link to be taken to the documentation. Column names in bold indicates primary key.

<details>
<summary><b><big><a href="https://developers.google.com/adwords/api/docs/appendix/reports/account-performance-report">account_performance_report</a></big></b></summary>
<body>
<table style="border-collapse:collapse;">
<tr>
<th style="width:200px;text-align:left">Column</th><th style="width:200px;text-align:left">Data-Type</th>
<th style="width:200px;text-align:left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><b>__sdc_primary_key</b></td>
<td>STRING</td><td>Applicable only if Periscope doesn’t detect a Primary Key in the source table. Periscope will use this column to remove duplicates</td>  
</tr>
<tr>
<td>day</td>
<td>DATE-TIME</td>
<td>The day the record pertains to.</td>
</tr>
<tr>
<td>_sdc_customer_id</td>
<td>INTEGER</td>
<td>The day the record pertains to.</td>
</tr>
<tr>
<td>_sdc_report_datetime</td>
<td>DATE-TIME</td>
<td>The start time of the job that ingested this record.</td>
</tr>
<tr>
<td>Custom fields</td>
<td></td>
<td>Columns (attributes/segments/metrics) selected. For descriptions of the available columns, see Google’s documentation.</td>
</tr>
</table>
</body>
</details>

<details>
<summary><b><big><a href="https://developers.google.com/adwords/api/docs/reference/v201809/ManagedCustomerService.ManagedCustomer">accounts</a></big></b></summary>
<body>
<table style="border-collapse:collapse;">
<tr>
<th style="width:200px;text-align:left">Column</th><th style="width:200px;text-align:left">Data-Type</th>
<th style="width:200px;text-align:left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><b>customerId</b></td>
<td>INTEGER</td><td>The ID of the AdWords account that the record belongs to.</td>  
</tr>
<tr>
<td>canManageClients</td>
<td>BOOLEAN</td>
<td>Indicates if the AdWords account can manage clients.</td>
</tr>
<tr>
<td>currencyCode</td>
<td>STRING</td>
<td>The currency code used by the AdWords account.</td>
</tr>
<tr>
<td>dateTimeZone</td>
<td>STRING</td>
<td>The local timezone used by the AdWords account.</td>
</tr>
<tr>
<td>name</td>
<td>STRING</td>
<td>The name used by the manager to refer to the client.</td>
</tr>
<tr>
<td>testAccount</td>
<td>BOOLEAN</td>
<td>Indicates if the managed customer’s account is a test account.</td>
</tr>
</table>
</body>
</details>

<details>
<summary><b><big><a href="https://developers.google.com/adwords/api/docs/reference/v201809/AdGroupService.AdGroup">ad_groups</a></big></b></summary>
<body>
<table style="border-collapse:collapse;">
<tr>
<th style="width:200px;text-align:left">Column</th><th style="width:200px;text-align:left">Data-Type</th>
<th style="width:200px;text-align:left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><b>id</b></td>
<td>INTEGER</td><td>The ID of the ad group.</td>  
</tr>
<tr>
<td>adGroupType</td>
<td>STRING</td>
<td>The type of the ad group.</td>
</tr>
<tr>
<td>baseAdGroupId</td>
<td>INTEGER</td>
<td>The ID of the base ad group from which the draft/trial ad group was created. This field will be NULL if the ad group was created in the draft or trial and has no corresponding base ad group.</td>
</tr>
<tr>
<td>baseCampaignId</td>
<td>INTEGER</td>
<td>The ID of the base campaign from which the draft/trial ad group was created.</td>
</tr>
<tr>
<td>biddingStrategyConfiguration</td>
<td>OBJECT</td>
<td>Details about the configuration of the bidding strategy associated with the ad group.</td>
</tr>
<tr>
<td>campaignId</td>
<td>INTEGER</td>
<td>The ID of the campaign associated with the ad group.</td>
</tr>
<tr>
<td>campaignName</td>
<td>STRING</td>
<td>The name of the campaign associated with the ad group.</td>
</tr>
<tr>
<td>customerId</td>
<td>INTEGER</td>
<td>The ID of the AdWords account that the record belongs to.</td>
</tr>
<tr>
<td>labels</td>
<td>ARRAY</td>
<td>Details about the labels applied to the ad.</td>
</tr>
<tr>
<td>name</td>
<td>STRING</td>
<td>The name of the ad group</td>
</tr>
<tr>
<td>status</td>
<td>STRING</td>
<td>The status of the ad group.</td>
</tr>
<tr>
<td>settings</td>
<td>ARRAY</td>
<td>Details about the settings defined for the ad group.</td>
</table>
</body>
</details>

<details>
<summary><b><big><a href="https://developers.google.com/adwords/api/docs/appendix/reports/ad-performance-report">ad_performance_report</a></big></b></summary>
<body>
<table style="border-collapse:collapse;">
<tr>
<th style="width:200px;text-align:left">Column</th><th style="width:200px;text-align:left">Data-Type</th>
<th style="width:200px;text-align:left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><b>__sdc_primary_key</b></td>
<td>STRING</td><td>Applicable only if Periscope doesn’t detect a Primary Key in the source table. Periscope will use this column to remove duplicates.</td>  
</tr>
<tr>
<td>day</td>
<td>DATE-TIME</td>
<td>The day the record pertains to.</td>
</tr>
<tr>
<td>_sdc_customer_id</td>
<td>INTEGER</td>
<td>The ID of the AdWords account that the record belongs to.</td>
</tr>
<tr>
<td>_sdc_report_datetime</td>
<td>DATE-TIME</td>
<td>The start time of the job that ingested this record.</td>
</tr>
<tr>
<td>Custom fields</td>
<td></td>
<td>Columns (attributes/segments/metrics) selected. For descriptions of the available columns, see Google’s documentation.</td>
</tr>
</table>
</body>
</details>

<details>
<summary><b><big><a href="https://developers.google.com/adwords/api/docs/appendix/reports/adgroup-performance-report">adgroup_performance_report</a></big></b></summary>
<body>
<table style="border-collapse:collapse;">
<tr>
<th style="width:200px;text-align:left">Column</th><th style="width:200px;text-align:left">Data-Type</th>
<th style="width:200px;text-align:left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><b>__sdc_primary_key</b></td>
<td>STRING</td><td>Applicable only if Periscope doesn’t detect a Primary Key in the source table. Periscope will use this column to remove duplicates.</td>  
</tr>
<tr>
<td>day</td>
<td>DATE-TIME</td>
<td>The day the record pertains to.</td>
</tr>
<tr>
<td>_sdc_customer_id</td>
<td>INTEGER</td>
<td>The ID of the AdWords account that the record belongs to.</td>
</tr>
<tr>
<td>_sdc_report_datetime</td>
<td>DATE-TIME</td>
<td>The start time of the job that ingested this record.</td>
</tr>
<tr>
<td>Custom fields</td>
<td></td>
<td>Columns (attributes/segments/metrics) selected. For descriptions of the available columns, see Google’s documentation.</td>
</tr>
</table>
</body>
</details>

<details>
<summary><b><big><a href="https://developers.google.com/adwords/api/docs/reference/v201809/AdGroupAdService.AdGroupAd">ads</a></big></b></summary>
<body>
<table style="border-collapse:collapse;">
<tr>
<th style="width:200px;text-align:left">Column</th><th style="width:200px;text-align:left">Data-Type</th>
<th style="width:200px;text-align:left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><b>adGroupId</b></td>
<td>INTEGER</td><td>The ID of the ad group containing the ad.</td>  
</tr>
<tr>
<td>adGroupAdDisapprovalReasons</td>
<td>ARRAY</td>
<td>The list of disapproval reasons applicable to the ad.</td>
</tr>
<tr>
<td>adGroupCreativeApprovalStatus</td>
<td>STRING</td>
<td>The approval status of the ad.</td>
</tr>
<tr>
<td>baseAdGroupId</td>
<td>INTEGER</td>
<td>The ID of the base ad group from which the draft/trial ad was created.</td>
</tr>
<tr>
<td>baseCampaignId</td>
<td>INTEGER</td>
<td>The ID of the base campaign from which the draft/trial ad was created.</td>
</tr>
<tr>
<td>customerId</td>
<td>INTEGER</td>
<td>The ID of the AdWords account that the record belongs to.</td>
</tr>
<tr>
<td>policySummary</td>
<td>OBJECT</td>
<td>Summary of policy findings for the ad.</td>
</tr>
<tr>
<td>status</td>
<td>STRING</td>
<td>The status of the ad</td>
</tr>
<tr>
<td>trademarks</td>
<td>ARRAY</td>
<td>The trademarked items that were found in the ad.</td>
</tr>
<tr>
<td>trademarkDisapproved</td>
<td>INTEGER</td>
<td>Indicates if the ad isn’t serving because it doesn’t meet trademark policy.</td>
</tr>
</table>
</body>
</details>

<details>
<summary><b><big><a href="https://developers.google.com/adwords/api/docs/appendix/reports/age-range-performance-report">age_range_performance_report</a></big></b></summary>
<body>
<table style="border-collapse:collapse;">
<tr>
<th style="width:200px;text-align:left">Column</th><th style="width:200px;text-align:left">Data-Type</th>
<th style="width:200px;text-align:left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><b>__sdc_primary_key</b></td>
<td>STRING</td><td>Applicable only if Periscope doesn’t detect a Primary Key in the source table. Periscope will use this column to remove duplicates.</td>  
</tr>
<tr>
<td>day</td>
<td>DATE-TIME</td>
<td>The day the record pertains to.</td>
</tr>
<tr>
<td>_sdc_customer_id</td>
<td>INTEGER</td>
<td>The ID of the AdWords account that the record belongs to.</td>
</tr>
<tr>
<td>_sdc_report_datetime</td>
<td>DATE-TIME</td>
<td>The start time of the job that ingested this record.</td>
</tr>
<tr>
<td>Custom fields</td>
<td></td>
<td>Columns (attributes/segments/metrics) selected. For descriptions of the available columns, see Google’s documentation.</td>
</tr>
</table>
</body>
</details>

<details>
<summary><b><big><a href="https://developers.google.com/adwords/api/docs/appendix/reports/audience-performance-report">audience_performance_report</a></big></b></summary>
<body>
<table style="border-collapse:collapse;">
<tr>
<th style="width:200px;text-align:left">Column</th><th style="width:200px;text-align:left">Data-Type</th>
<th style="width:200px;text-align:left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><b>__sdc_primary_key</b></td>
<td>STRING</td><td>Applicable only if Periscope doesn’t detect a Primary Key in the source table. Periscope will use this column to remove duplicates.</td>  
</tr>
<tr>
<td>day</td>
<td>DATE-TIME</td>
<td>The day the record pertains to.</td>
</tr>
<tr>
<td>_sdc_customer_id</td>
<td>INTEGER</td>
<td>The ID of the AdWords account that the record belongs to.</td>
</tr>
<tr>
<td>_sdc_report_datetime</td>
<td>DATE-TIME</td>
<td>The start time of the job that ingested this record.</td>
</tr>
<tr>
<td>Custom fields</td>
<td></td>
<td>Columns (attributes/segments/metrics) selected. For descriptions of the available columns, see Google’s documentation.</td>
</tr>
</table>
</body>
</details>

<details>
<summary><b><big><a href="https://developers.google.com/adwords/api/docs/appendix/reports/call-metrics-call-details-report">call_metrics_call_details_report</a></big></b></summary>
<body>
<table style="border-collapse:collapse;">
<tr>
<th style="width:200px;text-align:left">Column</th><th style="width:200px;text-align:left">Data-Type</th>
<th style="width:200px;text-align:left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><b>__sdc_primary_key</b></td>
<td>STRING</td><td>Applicable only if Periscope doesn’t detect a Primary Key in the source table. Periscope will use this column to remove duplicates.</td>  
</tr>
<tr>
<td>day</td>
<td>DATE-TIME</td>
<td>The day the record pertains to.</td>
</tr>
<tr>
<td>_sdc_customer_id</td>
<td>INTEGER</td>
<td>The ID of the AdWords account that the record belongs to.</td>
</tr>
<tr>
<td>_sdc_report_datetime</td>
<td>DATE-TIME</td>
<td>The start time of the job that ingested this record.</td>
</tr>
<tr>
<td>Custom fields</td>
<td></td>
<td>Columns (attributes/segments/metrics) selected. For descriptions of the available columns, see Google’s documentation.</td>
</tr>
</table>
</body>
</details>

<details>
<summary><b><big><a href="https://developers.google.com/adwords/api/docs/appendix/reports/campaign-performance-report">campaign_performance_report</a></big></b></summary>
<body>
<table style="border-collapse:collapse;">
<tr>
<th style="width:200px;text-align:left">Column</th><th style="width:200px;text-align:left">Data-Type</th>
<th style="width:200px;text-align:left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><b>__sdc_primary_key</b></td>
<td>STRING</td><td>Applicable only if Periscope doesn’t detect a Primary Key in the source table. Periscope will use this column to remove duplicates.</td>  
</tr>
<tr>
<td>day</td>
<td>DATE-TIME</td>
<td>The day the record pertains to.</td>
</tr>
<tr>
<td>_sdc_customer_id</td>
<td>INTEGER</td>
<td>The ID of the AdWords account that the record belongs to.</td>
</tr>
<tr>
<td>_sdc_report_datetime</td>
<td>DATE-TIME</td>
<td>The start time of the job that ingested this record.</td>
</tr>
<tr>
<td>Custom fields</td>
<td></td>
<td>Columns (attributes/segments/metrics) selected. For descriptions of the available columns, see Google’s documentation.</td>
</tr>
</table>
</body>
</details>

<details>
<summary><b><big><a href="https://developers.google.com/adwords/api/docs/reference/v201809/CampaignService.Campaign">campaigns</a></big></b></summary>
<body>
<table style="border-collapse:collapse;">
<tr>
<th style="width:200px;text-align:left">Column</th><th style="width:200px;text-align:left">Data-Type</th>
<th style="width:200px;text-align:left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><b>id</b></td>
<td>INTEGER</td><td>The ID of the campaign.</td>  
</tr>
<tr>
<td>adServingOptimizationStatus</td>
<td>STRING</td>
<td>The campaign’s ad serving optimization status.</td>
</tr>
<tr>
<td>advertisingChannelType</td>
<td>STRING</td>
<td>The primary serving target for ads within the campaign.</td>
</tr>
<tr>
<td>baseCampaignId</td>
<td>INTEGER</td>
<td>The ID of the base campaign of the draft or trial campaign.</td>
</tr>
<tr>
<td>conversionOptimizerEligibility</td>
<td>OBJECT</td>
<td>Eligibility data for the campaign to transition to Conversion Optimizer.</td>
</tr>
<tr>
<td><a href="https://developers.google.com/adwords/api/docs/reference/v201809/CampaignService.CampaignTrialType">campaignTrialType</a></td>
<td>STRING</td>
<td>Indicates the campaign type.</td>
</tr>
<tr>
<td>customerId</td>
<td>INTEGER</td>
<td>The ID of the AdWords account that the record belongs to.</td>
</tr>
<tr>
<td>endDate</td>
<td>DATE-TIME</td>
<td>The date the campaign ends.</td>
</tr>
<tr>
<td>frequencyCap</td>
<td>OBJECT</td>
<td>Details about the frequency cap for the campaign.</td>
</tr>
<tr>
<td>labels</td>
<td>ARRAY</td>
<td>Labels attached to the campaign.</td>
</tr>
<tr>
<td>name</td>
<td>STRING</td>
<td>The name of the campaign.</td>
</tr>
<tr>
<td>networkSetting</td>
<td>OBJECT</td>
<td>Network settings for the campaign.</td>
</tr>
<tr>
<td>settings</td>
<td>OBJECT</td>
<td>List of settings for the campaign.</td>
</tr>
<tr>
<td>startDate</td>
<td>DATE-TIME</td>
<td>The date the campaign starts.</td>
</tr>
<tr>
<td>status</td>
<td>STRING</td>
<td>The status of the campaign.</td>
</tr>
</table>
</body>
</details>

<details>
<summary><b><big><a href="https://developers.google.com/adwords/api/docs/appendix/reports/click-performance-report">click_performance_report</a></big></b></summary>
<body>
<table style="border-collapse:collapse;">
<tr>
<th style="width:200px;text-align:left">Column</th><th style="width:200px;text-align:left">Data-Type</th>
<th style="width:200px;text-align:left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><b>__sdc_primary_key</b></td>
<td>STRING</td><td>Applicable only if Periscope doesn’t detect a Primary Key in the source table. Periscope will use this column to remove duplicates.</td>  
</tr>
<tr>
<td>day</td>
<td>DATE-TIME</td>
<td>The day the record pertains to.</td>
</tr>
<tr>
<td>_sdc_customer_id</td>
<td>INTEGER</td>
<td>The ID of the AdWords account that the record belongs to.</td>
</tr>
<tr>
<td>_sdc_report_datetime</td>
<td>DATE-TIME</td>
<td>The start time of the job that ingested this record.</td>
</tr>
<tr>
<td>Custom fields</td>
<td></td>
<td>Columns (attributes/segments/metrics) selected. For descriptions of the available columns, see Google’s documentation.</td>
</tr>
</table>
</body>
</details>

<details>
<summary><b><big><a href="https://developers.google.com/adwords/api/docs/appendix/reports/criteria-performance-report">criteria_performance_report</a></big></b></summary>
<body>
<table style="border-collapse:collapse;">
<tr>
<th style="width:200px;text-align:left">Column</th><th style="width:200px;text-align:left">Data-Type</th>
<th style="width:200px;text-align:left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><b>__sdc_primary_key</b></td>
<td>STRING</td><td>Applicable only if Periscope doesn’t detect a Primary Key in the source table. Periscope will use this column to remove duplicates.</td>  
</tr>
<tr>
<td>day</td>
<td>DATE-TIME</td>
<td>The day the record pertains to.</td>
</tr>
<tr>
<td>_sdc_customer_id</td>
<td>INTEGER</td>
<td>The ID of the AdWords account that the record belongs to.</td>
</tr>
<tr>
<td>_sdc_report_datetime</td>
<td>DATE-TIME</td>
<td>The start time of the job that ingested this record.</td>
</tr>
<tr>
<td>Custom fields</td>
<td></td>
<td>Columns (attributes/segments/metrics) selected. For descriptions of the available columns, see Google’s documentation.</td>
</tr>
</table>
</body>
</details>

<details>
<summary><b><big><a href="https://developers.google.com/adwords/api/docs/appendix/reports/display-keyword-performance-report">display_keyword_performance_report</a></big></b></summary>
<body>
<table style="border-collapse:collapse;">
<tr>
<th style="width:200px;text-align:left">Column</th><th style="width:200px;text-align:left">Data-Type</th>
<th style="width:200px;text-align:left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><b>__sdc_primary_key</b></td>
<td>STRING</td><td>Applicable only if Periscope doesn’t detect a Primary Key in the source table. Periscope will use this column to remove duplicates.</td>  
</tr>
<tr>
<td>day</td>
<td>DATE-TIME</td>
<td>The day the record pertains to.</td>
</tr>
<tr>
<td>_sdc_customer_id</td>
<td>INTEGER</td>
<td>The ID of the AdWords account that the record belongs to.</td>
</tr>
<tr>
<td>_sdc_report_datetime</td>
<td>DATE-TIME</td>
<td>The start time of the job that ingested this record.</td>
</tr>
<tr>
<td>Custom fields</td>
<td></td>
<td>Columns (attributes/segments/metrics) selected. For descriptions of the available columns, see Google’s documentation.</td>
</tr>
</table>
</body>
</details>

<details>
<summary><b><big><a href="https://developers.google.com/adwords/api/docs/appendix/reports/display-topics-performance-report">display_topics_performance_report</a></big></b></summary>
<body>
<table style="border-collapse:collapse;">
<tr>
<th style="width:200px;text-align:left">Column</th><th style="width:200px;text-align:left">Data-Type</th>
<th style="width:200px;text-align:left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><b>__sdc_primary_key</b></td>
<td>STRING</td><td>Applicable only if Periscope doesn’t detect a Primary Key in the source table. Periscope will use this column to remove duplicates.</td>  
</tr>
<tr>
<td>day</td>
<td>DATE-TIME</td>
<td>The day the record pertains to.</td>
</tr>
<tr>
<td>_sdc_customer_id</td>
<td>INTEGER</td>
<td>The ID of the AdWords account that the record belongs to.</td>
</tr>
<tr>
<td>_sdc_report_datetime</td>
<td>DATE-TIME</td>
<td>The start time of the job that ingested this record.</td>
</tr>
<tr>
<td>Custom fields</td>
<td></td>
<td>Columns (attributes/segments/metrics) selected. For descriptions of the available columns, see Google’s documentation.</td>
</tr>
</table>
</body>
</details>

<details>
<summary><b><big><a href="https://developers.google.com/adwords/api/docs/appendix/reports/final-url-report">final_url_report</a></big></b></summary>
<body>
<table style="border-collapse:collapse;">
<tr>
<th style="width:200px;text-align:left">Column</th><th style="width:200px;text-align:left">Data-Type</th>
<th style="width:200px;text-align:left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><b>__sdc_primary_key</b></td>
<td>STRING</td><td>Applicable only if Periscope doesn’t detect a Primary Key in the source table. Periscope will use this column to remove duplicates.</td>  
</tr>
<tr>
<td>day</td>
<td>DATE-TIME</td>
<td>The day the record pertains to.</td>
</tr>
<tr>
<td>_sdc_customer_id</td>
<td>INTEGER</td>
<td>The ID of the AdWords account that the record belongs to.</td>
</tr>
<tr>
<td>_sdc_report_datetime</td>
<td>DATE-TIME</td>
<td>The start time of the job that ingested this record.</td>
</tr>
<tr>
<td>Custom fields</td>
<td></td>
<td>Columns (attributes/segments/metrics) selected. For descriptions of the available columns, see Google’s documentation.</td>
</tr>
</table>
</body>
</details>

<details>
<summary><b><big><a href="https://developers.google.com/adwords/api/docs/appendix/reports/gender-performance-report">gender_performance_report</a></big></b></summary>
<body>
<table style="border-collapse:collapse;">
<tr>
<th style="width:200px;text-align:left">Column</th><th style="width:200px;text-align:left">Data-Type</th>
<th style="width:200px;text-align:left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><b>__sdc_primary_key</b></td>
<td>STRING</td><td>Applicable only if Periscope doesn’t detect a Primary Key in the source table. Periscope will use this column to remove duplicates.</td>  
</tr>
<tr>
<td>day</td>
<td>DATE-TIME</td>
<td>The day the record pertains to.</td>
</tr>
<tr>
<td>_sdc_customer_id</td>
<td>INTEGER</td>
<td>The ID of the AdWords account that the record belongs to.</td>
</tr>
<tr>
<td>_sdc_report_datetime</td>
<td>DATE-TIME</td>
<td>The start time of the job that ingested this record.</td>
</tr>
<tr>
<td>Custom fields</td>
<td></td>
<td>Columns (attributes/segments/metrics) selected. For descriptions of the available columns, see Google’s documentation.</td>
</tr>
</table>
</body>
</details>

<details>
<summary><b><big><a href="https://developers.google.com/adwords/api/docs/appendix/reports/keywordless-query-report">keywordless_query_report</a></big></b></summary>
<body>
<table style="border-collapse:collapse;">
<tr>
<th style="width:200px;text-align:left">Column</th><th style="width:200px;text-align:left">Data-Type</th>
<th style="width:200px;text-align:left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><b>__sdc_primary_key</b></td>
<td>STRING</td><td>Applicable only if Periscope doesn’t detect a Primary Key in the source table. Periscope will use this column to remove duplicates.</td>  
</tr>
<tr>
<td>day</td>
<td>DATE-TIME</td>
<td>The day the record pertains to.</td>
</tr>
<tr>
<td>_sdc_customer_id</td>
<td>INTEGER</td>
<td>The ID of the AdWords account that the record belongs to.</td>
</tr>
<tr>
<td>_sdc_report_datetime</td>
<td>DATE-TIME</td>
<td>The start time of the job that ingested this record.</td>
</tr>
<tr>
<td>Custom fields</td>
<td></td>
<td>Columns (attributes/segments/metrics) selected. For descriptions of the available columns, see Google’s documentation.</td>
</tr>
</table>
</body>
</details>

<details>
<summary><b><big><a href="https://developers.google.com/adwords/api/docs/appendix/reports/search-query-performance-report">search_query_performance_report</a></big></b></summary>
<body>
<table style="border-collapse:collapse;">
<tr>
<th style="width:200px;text-align:left">Column</th><th style="width:200px;text-align:left">Data-Type</th>
<th style="width:200px;text-align:left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><b>__sdc_primary_key</b></td>
<td>STRING</td><td>Applicable only if Periscope doesn’t detect a Primary Key in the source table. Periscope will use this column to remove duplicates.</td>  
</tr>
<tr>
<td>day</td>
<td>DATE-TIME</td>
<td>The day the record pertains to.</td>
</tr>
<tr>
<td>_sdc_customer_id</td>
<td>INTEGER</td>
<td>The ID of the AdWords account that the record belongs to.</td>
</tr>
<tr>
<td>_sdc_report_datetime</td>
<td>DATE-TIME</td>
<td>The start time of the job that ingested this record.</td>
</tr>
<tr>
<td>Custom fields</td>
<td></td>
<td>Columns (attributes/segments/metrics) selected. For descriptions of the available columns, see Google’s documentation.</td>
</tr>
</table>
</body>
</details>

<details>
<summary><b><big><a href="https://developers.google.com/adwords/api/docs/appendix/reports/video-performance-report">video_performance_report</a></big></b></summary>
<body>
<table style="border-collapse:collapse;">
<tr>
<th style="width:200px;text-align:left">Column</th><th style="width:200px;text-align:left">Data-Type</th>
<th style="width:200px;text-align:left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><b>__sdc_primary_key</b></td>
<td>STRING</td><td>Applicable only if Periscope doesn’t detect a Primary Key in the source table. Periscope will use this column to remove duplicates.</td>  
</tr>
<tr>
<td>day</td>
<td>DATE-TIME</td>
<td>The day the record pertains to.</td>
</tr>
<tr>
<td>_sdc_customer_id</td>
<td>INTEGER</td>
<td>The ID of the AdWords account that the record belongs to.</td>
</tr>
<tr>
<td>_sdc_report_datetime</td>
<td>DATE-TIME</td>
<td>The start time of the job that ingested this record.</td>
</tr>
<tr>
<td>Custom fields</td>
<td></td>
<td>Columns (attributes/segments/metrics) selected. For descriptions of the available columns, see Google’s documentation.</td>
</tr>
</table>
</body>
</details>

<a href="#top">Back to top</a>

Our support team is ready to help