SSIS Components for Google Ads

Build 26.0.9655

CampaignGroup

A campaign group.

Columns

Name Type Behavior Description
CampaignGroupId Long ATTRIBUTE Output only. The ID of the campaign group.
CampaignGroupName String ATTRIBUTE The name of the campaign group.
CampaignGroupResourceName String ATTRIBUTE Immutable. The resource name of the campaign group.
CampaignGroupStatus String ATTRIBUTE The status of the campaign group.

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

CustomerId Long ATTRIBUTE Output only. The ID of the customer.
AverageCost Double METRIC The average amount you pay per interaction. This amount is the total cost
Conversions Double METRIC The number of conversions. This only includes conversion actions which
CostPerConversion Double METRIC The cost of ad interactions divided by conversions. This only includes
InteractionRate Double METRIC How often people interact with your ad after it is shown to them.
Interactions Long METRIC The number of interactions.
TrueviewAverageCpv Double METRIC The average amount you pay each time someone views your ad.
AdDestinationType String SEGMENT Ad Destination type.

使用できる値は次のとおりです。APP_DEEP_LINK, APP_STORE, LEAD_FORM, LOCATION_LISTING, MAP_DIRECTIONS, MESSAGE, NOT_APPLICABLE, PHONE_CALL, UNKNOWN, UNMODELED_FOR_CONVERSIONS, WEBSITE, YOUTUBE

Date Date SEGMENT Date to which metrics apply.
Device String SEGMENT Device to which metrics apply.

使用できる値は次のとおりです。CONNECTED_TV, DESKTOP, MOBILE, OTHER, TABLET, UNKNOWN

Hour Int SEGMENT Hour of day as a number between 0 and 23, inclusive.
Month Date SEGMENT Month as represented by the date of the first day of a month. Formatted as
Period String SEGMENT Predefined date range.

使用できる値は次のとおりです。TODAY, YESTERDAY, LAST_7_DAYS, LAST_BUSINESS_WEEK, THIS_MONTH, LAST_MONTH, LAST_14_DAYS, LAST_30_DAYS, THIS_WEEK_SUN_TODAY, THIS_WEEK_MON_TODAY, LAST_WEEK_SUN_SAT, LAST_WEEK_MON_SUN

Quarter Date SEGMENT Quarter as represented by the date of the first day of a quarter.
Week Date SEGMENT Week as defined as Monday through Sunday, and represented by the date of
Year Int SEGMENT Year, formatted as yyyy.

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) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655