Access Google Adsense in Excel

Accounts

List all accounts available to this AdSense account.

Fields

  • Id - Unique identifier of this account.
  • Creation Time - Timestamp of last test (if any)
  • Name - Name of this account.
  • Premium - Whether this account is premium.
  • Subaccounts - Sub accounts of the this account.
  • Timezone - AdSense timezone of this account.

Ad Clients

List all ad clients in the specified account.

Parameters

  • Account Id - Account ID.

Fields

  • Id - Unique identifier of this ad client.
  • ARC Optin - Whether this ad client is opted in to ARC.
  • Product Code - This ad client's product code, which corresponds to the PRODUCT_CODE report dimension.
  • Supports Reporting - Whether this ad client supports being reported on.

Ad Units

Parameters

  • Account Id
  • Ad Client Id
  • Include Inactive - Whether to include inactive ad units.

Fields

  • Id - Unique identifier of this ad unit. This should be considered an opaque identifier; it is not safe to rely on it being in any particular format.
  • Code - Identity code of this ad unit, not necessarily unique across ad clients.
  • Name - Name of this ad unit.
  • Saved Style Id - ID of the saved ad style which holds this ad unit's style information.
  • Status - Status of this ad unit.
  • Size - Size of this ad unit.
  • Type - Type of this ad unit.
  • Backup Option Color - Color to use when type is set to COLOR.
  • Backup Option Type - Type of the backup option.
  • Backup Option Url - URL to use when type is set to URL.
  • Custom Style Background - The color of the ad background.
  • Custom Style Border - The color of the ad border.
  • Custom Style Text - The color of the ad text.
  • Custom Style Title - The color of the ad title.
  • Custom Style Url - The color of the ad url.
  • Custom Style Corners - The style of the corners in the ad.
  • Custom Style Font Family - The family of the font.
  • Custom Style Font Size - The size of the font.
  • Custom Style Kind - Kind this is, in this case adsense#adStyle.
  • Feed Ad Position - The position of the ads relative to the feed entries.
  • Feed Ad Frequency - The frequency at which ads should appear in the feed (i.e. every N entries).
  • Feed Ad Minimum Word Count - The minimum length an entry should be in order to have attached ads.
  • Feed Ad Type - The type of ads which should appear.

Alerts

List all ad units in the specified ad client for the specified account.

Parameters

  • Account Id

Fields

  • NextToken
  • Id - Unique identifier of this alert.
  • Severity - Severity of this alert.
  • Type - Type of this alert.
  • Message - The localized alert message.
  • Dismissible - Whether this alert can be dismissed.

Custom Channels By Account

List all custom channels which the specified ad unit belongs to.

Parameters

  • Account Id
  • Ad Client Id

Fields

  • Code - Code of this custom channel, not necessarily unique across ad clients.
  • Id - Unique identifier of this custom channel. This should be considered an opaque identifier; it is not safe to rely on it being in any particular format.
  • Name - Name of this custom channel.
  • Targetinginfo Adsappearon - The name used to describe this channel externally.
  • Targetinginfo Description - The external description of the channel.
  • Targetinginfo Location - The locations in which ads appear.

Payments

List the payments for the specified AdSense account.

Parameters

  • Account Id

Fields

  • Id - Unique identifier of this Payment.
  • Date - The date this payment was/will be credited to the user, or none if the payment threshold has not been met.
  • Amount - The amount to be paid.

Saved Ad Styles

List all saved ad styles in the specified account.

Parameters

  • Account Id

Fields

  • Id - Unique identifier of this saved ad style.
  • Name - The user selected name of this SavedAdStyle.
  • Background Color - The color of the ad background.
  • Adstyle Colors Border - The color of the ad border.
  • Text Color - The color of the ad text.
  • Title Color - The color of the ad title.
  • Url Color - The color of the ad url.
  • Corners Color - The style of the corners in the ad.
  • Font Family - The family of the font.
  • Font Size - The size of the font.

URL Channels

List all URL channels in the specified ad client for the specified account.

Parameters

  • Account Id
  • Ad Client Id

Fields

  • NextToken
  • Id - Unique identifier of this URL channel. This should be considered an opaque identifier; it is not safe to rely on it being in any particular format.
  • Url Pattern - URL Pattern of this URL channel.

Generate a Report

Generate an AdSense report based on the report request sent in the query parameters. Fields are generated automatically depending on chosen metrics and dimensions.

Parameters

  • Account Id
  • Date Interval
  • Metrics (one per line) - The numeric columns to include in the report. List of available metrics
  • Dimensions (one per line) - The dimensions on which to base the report. List of available dimensions
  • Currency - Currency to use when reporting on monetary metrics. Defaults to the account's currency if not set.

Saved Reports

List all saved reports in the specified AdSense account.

Parameters

  • Account Id

Fields

  • Id - Unique identifier of this saved report.
  • Name - This saved report's name.

Generate a Saved Report

Generate an AdSense report based on the saved report ID sent in the query parameters. Fields are generated automatically depending on chosen metrics and dimensions.

Parameters

  • Account Id
  • Saved Report Id

Access

To use the Connector you need an account connected to Google+. Clicking the Login button in the connector will prompt you to give Adsense account permissions to SeoTools.

Add from Manager

The Google Adsense Connector is available in the Connectors Manager in the top ribbon:

Select the Ads category and install Google Adsense:


Contribute

This connector suite is open-sourced on GitHub.


See

Official Documentation

Google Adsense API


Get help with this function in the community →