SSIS Components for Google Ads

Build 24.0.9062

AccountBudget

An account-level budget. It contains information about the budget itself, as well as the most recently approved changes to the budget and proposed changes that are pending approval. The proposed changes that are pending approval, if any, are found in 'pending_proposal'. Effective details about the budget are found in fields prefixed 'approved_', 'adjusted_' and those without a prefix. Since some effective details may differ from what the user had originally requested (for example, spending limit), these differences are juxtaposed through 'proposed_', 'approved_', and possibly 'adjusted_' fields. This resource is mutated using AccountBudgetProposal and cannot be mutated directly. A budget may have at most one pending proposal at any given time. It is read through pending_proposal. Once approved, a budget may be subject to adjustments, such as credit adjustments. Adjustments create differences between the 'approved' and 'adjusted' fields, which would otherwise be identical.

Columns

Name Type Behavior Description
AccountBudgetAdjustedSpendingLimitMicros Long ATTRIBUTE Output only. The adjusted spending limit in micros. One million is equivalent to one unit. If the approved spending limit is finite, the adjusted spending limit may vary depending on the types of adjustments applied to this budget, if applicable. The different kinds of adjustments are described here: https://support.google.com/google-ads/answer/1704323 For example, a debit adjustment reduces how much the account is allowed to spend.
AccountBudgetAdjustedSpendingLimitType String ATTRIBUTE Output only. The adjusted spending limit as a well-defined type, for example, INFINITE. This will only be populated if the adjusted spending limit is INFINITE, which is guaranteed to be true if the approved spending limit is INFINITE.

使用できる値は次のとおりです。INFINITE, UNKNOWN, UNSPECIFIED

AccountBudgetAmountServedMicros Long ATTRIBUTE Output only. The value of Ads that have been served, in micros. This includes overdelivery costs, in which case a credit might be automatically applied to the budget (see total_adjustments_micros).
AccountBudgetApprovedEndDateTime Datetime ATTRIBUTE Output only. The approved end time in yyyy-MM-dd HH:mm:ss format.
AccountBudgetApprovedEndTimeType String ATTRIBUTE Output only. The approved end time as a well-defined type, for example, FOREVER.

使用できる値は次のとおりです。FOREVER, NOW, UNKNOWN, UNSPECIFIED

AccountBudgetApprovedSpendingLimitMicros Long ATTRIBUTE Output only. The approved spending limit in micros. One million is equivalent to one unit. This will only be populated if the proposed spending limit is finite, and will always be greater than or equal to the proposed spending limit.
AccountBudgetApprovedSpendingLimitType String ATTRIBUTE Output only. The approved spending limit as a well-defined type, for example, INFINITE. This will only be populated if the approved spending limit is INFINITE.

使用できる値は次のとおりです。INFINITE, UNKNOWN, UNSPECIFIED

AccountBudgetApprovedStartDateTime Datetime ATTRIBUTE Output only. The approved start time of the account-level budget in yyyy-MM-dd HH:mm:ss format. For example, if a new budget is approved after the proposed start time, the approved start time is the time of approval.
AccountBudgetBillingSetup String ATTRIBUTE Output only. The resource name of the billing setup associated with this account-level budget. BillingSetup resource names have the form: customers/{customer_id}/billingSetups/{billing_setup_id}
AccountBudgetId Long ATTRIBUTE Output only. The ID of the account-level budget.
AccountBudgetName String ATTRIBUTE Output only. The name of the account-level budget.
AccountBudgetNotes String ATTRIBUTE Output only. Notes associated with the budget.
AccountBudgetPendingProposalAccountBudgetProposal String ATTRIBUTE Output only. The resource name of the proposal. AccountBudgetProposal resource names have the form: customers/{customer_id}/accountBudgetProposals/{account_budget_proposal_id}
AccountBudgetPendingProposalCreationDateTime Datetime ATTRIBUTE Output only. The time when this account-level budget proposal was created. Formatted as yyyy-MM-dd HH:mm:ss.
AccountBudgetPendingProposalEndDateTime Datetime ATTRIBUTE Output only. The end time in yyyy-MM-dd HH:mm:ss format.
AccountBudgetPendingProposalEndTimeType String ATTRIBUTE Output only. The end time as a well-defined type, for example, FOREVER.

使用できる値は次のとおりです。FOREVER, NOW, UNKNOWN, UNSPECIFIED

AccountBudgetPendingProposalName String ATTRIBUTE Output only. The name to assign to the account-level budget.
AccountBudgetPendingProposalNotes String ATTRIBUTE Output only. Notes associated with this budget.
AccountBudgetPendingProposalProposalType String ATTRIBUTE Output only. The type of this proposal, for example, END to end the budget associated with this proposal.

使用できる値は次のとおりです。CREATE, END, REMOVE, UNKNOWN, UNSPECIFIED, UPDATE

AccountBudgetPendingProposalPurchaseOrderNumber String ATTRIBUTE Output only. A purchase order number is a value that helps users reference this budget in their monthly invoices.
AccountBudgetPendingProposalSpendingLimitMicros Long ATTRIBUTE Output only. The spending limit in micros. One million is equivalent to one unit.
AccountBudgetPendingProposalSpendingLimitType String ATTRIBUTE Output only. The spending limit as a well-defined type, for example, INFINITE.

使用できる値は次のとおりです。INFINITE, UNKNOWN, UNSPECIFIED

AccountBudgetPendingProposalStartDateTime Datetime ATTRIBUTE Output only. The start time in yyyy-MM-dd HH:mm:ss format.
AccountBudgetProposedEndDateTime Datetime ATTRIBUTE Output only. The proposed end time in yyyy-MM-dd HH:mm:ss format.
AccountBudgetProposedEndTimeType String ATTRIBUTE Output only. The proposed end time as a well-defined type, for example, FOREVER.

使用できる値は次のとおりです。FOREVER, NOW, UNKNOWN, UNSPECIFIED

AccountBudgetProposedSpendingLimitMicros Long ATTRIBUTE Output only. The proposed spending limit in micros. One million is equivalent to one unit.
AccountBudgetProposedSpendingLimitType String ATTRIBUTE Output only. The proposed spending limit as a well-defined type, for example, INFINITE.

使用できる値は次のとおりです。INFINITE, UNKNOWN, UNSPECIFIED

AccountBudgetProposedStartDateTime Datetime ATTRIBUTE Output only. The proposed start time of the account-level budget in yyyy-MM-dd HH:mm:ss format. If a start time type of NOW was proposed, this is the time of request.
AccountBudgetPurchaseOrderNumber String ATTRIBUTE Output only. A purchase order number is a value that helps users reference this budget in their monthly invoices.
AccountBudgetResourceName String ATTRIBUTE Output only. The resource name of the account-level budget. AccountBudget resource names have the form: customers/{customer_id}/accountBudgets/{account_budget_id}
AccountBudgetStatus String ATTRIBUTE Output only. The status of this account-level budget.

使用できる値は次のとおりです。APPROVED, CANCELLED, PENDING, UNKNOWN, UNSPECIFIED

AccountBudgetTotalAdjustmentsMicros Long ATTRIBUTE Output only. The total adjustments amount. An example of an adjustment is courtesy credits.
CustomerId Long ATTRIBUTE Output only. The ID of the customer.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
ManagerId Long Id of the manager account on behalf of which you are requesting customer data.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062