Reference

Endpoint Get Report: Campaign Performance (By Date)

Name

get_report_campaign_performance_by_date

Description

Get campaign performance data by date. If you like to customize this report then use get_query_result endpoint.

Parameters

Parameter Required Options
Name: ReportStartDate

Label: Report Start Date (yyyy-MM-dd)

Server side filter for date 		YES
Option Value
today today
yesterday yesterday
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
2022-01-31 2022-01-31
Name: ReportEndDate

Label: Report End Date (yyyy-MM-dd)

Server side filter for date 		YES
Option Value
today today
yesterday yesterday
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
2022-01-31 2022-01-31
Name: CampaignId

Label: Campaign Id (Default: All)

Server side filter for campaign
Name: CampaignStatus

Label: Campaign Status (Default: All)
Option Value
ENABLED ENABLED
PAUSED PAUSED
REMOVED REMOVED
DRAFT DRAFT
PENDING PENDING
ARCHIVED ARCHIVED
Name: CustomerId

Label: CustomerId (without dash e.g. 2125557752)

Login to your Google Ads account and see top-right corner for your CustomerId

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Date DT_DBDATE date
Year DT_I4 int
Month DT_I4 int
Day DT_I4 int
Week DT_I4 int
Quarter DT_WSTR nvarchar(10) 10
DayOfWeek DT_WSTR nvarchar(10) 10
CampaignId DT_WSTR nvarchar(30) 30
CampaignName DT_WSTR nvarchar(1000) 1000
Clicks DT_R8 float
Conversions DT_R8 float
Cost DT_R8 float
CostMicros DT_I8 bigint
CostPerConversion DT_R8 float
CostPerConversionMicros DT_I8 bigint
Impressions DT_I8 bigint
InteractionRate DT_R8 float
Interactions DT_I8 bigint
AveragePageViews DT_R8 float
BounceRate DT_R8 float
SearchAbsoluteTopImpressionShare DT_R8 float
SearchBudgetLostAbsoluteTopImpressionShare DT_R8 float
SearchBudgetLostImpressionShare DT_R8 float
SearchBudgetLostTopImpressionShare DT_R8 float
SearchClickShare DT_R8 float
SearchExactMatchImpressionShare DT_R8 float
SearchImpressionShare DT_R8 float
SearchRankLostAbsoluteTopImpressionShare DT_R8 float
SearchRankLostImpressionShare DT_R8 float
SearchRankLostTopImpressionShare DT_R8 float
SearchTopImpressionShare DT_R8 float
TopImpressionPercentage DT_R8 float
VideoViews DT_I8 bigint
ViewThroughConversions DT_I8 bigint
Ctr DT_R8 float
Engagements DT_I8 bigint
AbsoluteTopImpressionPercentage DT_R8 float
ActiveViewImpressions DT_I8 bigint
AllConversions DT_R8 float
AverageCost DT_R8 float
AverageCostMicro DT_R8 float
AverageCpc DT_R8 float
AverageCpcMicro DT_R8 float
AverageCpm DT_R8 float
AverageCpmMicro DT_R8 float
AverageCpv DT_R8 float
AverageCpvMicro DT_R8 float
AverageCpe DT_R8 float
AverageCpeMicro DT_R8 float
InvalidClicks DT_I8 bigint
CostPerAllConversions DT_R8 float
CostPerAllConversionsMicro DT_I8 bigint
ContentImpressionShare DT_R8 float
ContentBudgetLostImpressionShare DT_R8 float
EngagementRate DT_R8 float
VideoviewRate DT_R8 float
VideoQuartileP75Rate DT_R8 float
VideoQuartileP50Rate DT_R8 float
VideoQuartileP25Rate DT_R8 float
VideoQuartileP100rate DT_R8 float
ActiveViewCpm DT_R8 float
ActiveViewCpmMicro DT_R8 float
ActiveViewCtr DT_R8 float
UniqueUsers DT_R8 float
AverageImpressionFrequencyPerUser DT_R8 float
If the column you are looking for is missing, consider customizing Google Ads Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Google Ads Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

API Source - Google Ads
Read / write Google Ads data inside your app (e.g. Campaigns, Ad Groups, Keywords, Spending, Performance); perform many Google Ads operations without coding, just using easy to use high performance API Connector for Google Ads
Google Ads
Get Report: Campaign Performance (By Date)
There are no parameters to configure.
SSIS API Source - Read from table or endpoint

API Destination

API Destination - Google Ads
Read / write Google Ads data inside your app (e.g. Campaigns, Ad Groups, Keywords, Spending, Performance); perform many Google Ads operations without coding, just using easy to use high performance API Connector for Google Ads
Google Ads
Get Report: Campaign Performance (By Date)
There are no parameters to configure.
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Get campaign performance report by date

Get campaign performance data, group by date and campaign 

SELECT * FROM get_report_campaign_performance_by_date WITH(ReportStartDate='monthstart', ReportEndDate='today-1d')

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Get campaign performance report by date

Get campaign performance data, group by date and campaign 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_report_campaign_performance_by_date WITH(ReportStartDate=''monthstart'', ReportEndDate=''today-1d'')';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_ADS_IN_GATEWAY];