Power BI Connector for Google Ads

Build 24.0.9062

CreateReportSchema

Creates a schema file based on the specified report.

Use this stored procedure to create a new view, which will include all attributes, metrics, and segments from specific resources. These columns can be from resource attributes (ResourceName), from non-segmenting resources (AttributeResources), or from segmenting resources (SegmentingResources). Below are a few examples:

EXEC CreateReportSchema ResourceName = 'distance_view', ReportName = 'Distance 1', SegmentingResources = 'campaign', OutputFolder = 'C:/Users/Public/Desktop'
EXEC CreateReportSchema ResourceName = 'distance_view', ReportName = 'Distance 2', Description = 'Sample description.'
EXEC CreateReportSchema ResourceName = 'distance_view', ReportName = 'Distance 3', AttributeResources = 'customer', Description = 'Sample description.'
EXEC CreateReportSchema ResourceName = 'distance_view', ReportName = 'Distance 4', SegmentingResources = 'campaign', AttributeResources = 'customer', Description = 'Sample description.'

For the last example, you can not select all the columns in a query, because some metrics do not support some resources. You should instead specify a subset, for example:

SELECT DistanceViewResourceName, CustomerTimeZone, CampaignName, CampaignEndDate, Clicks, Impressions FROM [Distance 4]

Input

Name Type Description
ReportName String The name for the new view. If not set, the name will be generated based on ResourceName.
ResourceName String The API name of the resource you want to use, for example, campaign, ad_group, etc.
AttributeResources String A comma-separated list of API resource names to include in addition to the ResourceName. Fields from these resources may be selected along with ResourceName in your SELECT and WHERE clauses. These fields will not segment metrics in your SELECT clause.
SegmentingResources String A comma-separated list of API resource names to include in addition to the ResourceName. Fields from these resources, when selected along with ResourceName in your SELECT and WHERE clauses, will segment metrics.
Metrics String A comma-separated list of metrics to include in the schema file. For a list of possible metrics values, see https://developers.google.com/google-ads/api/fields/v11/metrics on the Google Ads API website.
Segments String A comma-separated list of segments to include in the schema file. For a list of possible segment values, see https://developers.google.com/google-ads/api/fields/v11/segments on the Google Ads API website.
Description String An optional description for this custom report.
WriteToFile Boolean If set to 'True', the schema file will be written to the directory specified by the Location connection property. If set to 'False', the schema data will either be written to the FileStream or be output as BASE64 encoded data. Defaults to 'True'.

デフォルト値はtrueです。

Result Set Columns

Name Type Description
Success String Whether or not the schema was created successfully.
SchemaFile String The generated schema file.
FileData String The schema's data in BASE64 encoding. Only used if WriteToFile is set to 'False' and FileStream is not set.

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