AdCampaignAnalytics
Get analytics for the specified campaigns in the specified AdAccountId
View-Specific Information
SELECT
The connector uses the Pinterest API to process WHERE clause conditions built with the following columns and operators. Any remaining filters are processed client-side within the connector.
| Column | Supported Operators |
| CampaignId | =, IN |
| AdAccountId | = |
| StartDate | =, >, >= |
| EndDate | =, <, <= |
| Granularity | = |
| ClickWindowDays | = |
| ViewWindowDays | = |
| ConversionReportTime | = |
| ReportingTimezone | = |
| EngagementWindowDays | = |
| AggregateReportRows | = |
For example:
SELECT * FROM AdCampaignAnalytics WHERE AdAccountId = '3457832451' AND CampaignId = '3457862457'
SELECT * FROM AdCampaignAnalytics WHERE AdAccountId = '3457832451' AND StartDate >= '2024-01-06' AND EndDate <= '2024-04-05'
Columns
| Name | Type | References | Description |
| CampaignId | String |
Campaigns.Id | The unique identifier of the campaign. |
| AdAccountId | String |
AdAccounts.Id | The unique identifier of the ad account. |
| Date | Date | Date the analytics row covers. | |
| CampaignEntityStatus | String | The current entity status of the campaign. | |
| AdGroupEntityStatus | String | Status of the ad group. | |
| SpendInDollar | Double | Total spend in dollars. | |
| EcpcInDollar | Double | The effective cost per click (ECPC), in dollars. | |
| Ctr | Double | The click-through rate (CTR), measured as clicks divided by impressions. | |
| Ectr | Double | The effective click-through rate (ECTR). | |
| EcpeInDollar | Double | The effective cost per engagement (ECPE), in dollars. | |
| EngagementRate | Double | The engagement rate. | |
| EengagementRate | Double | The effective engagement rate. | |
| RepinRate | Double | The repin rate. | |
| Ctr2 | Double | The organic click-through rate (CTR), measured as clicks divided by organic impressions. | |
| CpmInDollar | Double | The cost per mille (CPM), in dollars. | |
| WebCheckoutCostPerAction | Double | The cost per action for web checkout conversions. | |
| WebCheckoutRoas | Double | The return on ad spend (ROAS) for web checkout conversions. | |
| PageVisitCostPerAction | Double | The cost per action for page visit conversions. | |
| PageVisitRoas | Double | The return on ad spend (ROAS) for page visit conversions. | |
| CheckoutRoas | Double | The return on ad spend (ROAS) for checkout conversions. | |
| Video3secViews2 | Integer | The number of organic video views lasting at least 3 seconds. | |
| VideoP100Complete2 | Integer | The number of organic videos viewed to 100 percent completion. | |
| VideoP0Combined2 | Integer | The number of organic video views with any amount of content shown. | |
| VideoP25Combined2 | Integer | The number of organic videos viewed to at least 25 percent completion. | |
| VideoP50Combined2 | Integer | The number of organic videos viewed to at least 50 percent completion. | |
| VideoP75Combined2 | Integer | The number of organic videos viewed to at least 75 percent completion. | |
| VideoP95Combined2 | Integer | The number of organic videos viewed to at least 95 percent completion. | |
| VideoMrcViews2 | Integer | The number of organic video views meeting the MRC (Media Rating Council) viewability standard. | |
| EcpvInDollar | Double | The effective cost per video view (ECPV), in dollars. | |
| EcpcvInDollar | Double | The effective cost per completed video view (ECPCV), in dollars. | |
| EcpcvP95InDollar | Double | The effective cost per video view at 95 percent completion (ECPCV P95), in dollars. | |
| TotalClickthrough | Integer | The total number of paid and organic clickthroughs. | |
| TotalImpressionFrequency | Double | The total impression frequency, measured as impressions divided by unique users reached. | |
| TotalEngagementSignup | Integer | The total number of signup conversions attributed to engagement. | |
| TotalEngagementCheckout | Integer | The total number of checkout conversions attributed to engagement. | |
| TotalClickSignup | Integer | The total number of signup conversions attributed to a click. | |
| TotalClickCheckout | Integer | The total number of checkout conversions attributed to a click. | |
| TotalViewSignup | Integer | The total number of signup conversions attributed to a view. | |
| TotalViewCheckout | Integer | The total number of checkout conversions attributed to a view. | |
| TotalConversions | Integer | The total number of conversions. | |
| TotalEngagementSignupValueInMicroDollar | Double | The total value of signup conversions attributed to engagement, in microdollars. | |
| TotalEngagementCheckoutValueInMicroDollar | Double | The total value of checkout conversions attributed to engagement, in microdollars. | |
| TotalClickSignupValueInMicroDollar | Double | The total value of signup conversions attributed to a click, in microdollars. | |
| TotalClickCheckoutValueInMicroDollar | Double | The total value of checkout conversions attributed to a click, in microdollars. | |
| TotalViewSignupValueInMicroDollar | Double | The total value of signup conversions attributed to a view, in microdollars. | |
| TotalViewCheckoutValueInMicroDollar | Double | The total value of checkout conversions attributed to a view, in microdollars. | |
| TotalPageVisit | Integer | The total number of page visit conversions. | |
| TotalSignup | Integer | The total number of signup conversions. | |
| TotalCheckout | Integer | The total number of checkout conversions. | |
| TotalSignupValueInMicroDollar | Double | The total value of signup conversions, in microdollars. | |
| TotalCheckoutValueInMicroDollar | Double | The total value of checkout conversions, in microdollars. | |
| TotalVideo3secViews | Integer | The total number of video views lasting at least 3 seconds. | |
| TotalVideoP100Complete | Integer | The total number of videos viewed to 100 percent completion. | |
| TotalVideoP0Combined | Integer | The total number of video views with any amount of content shown. | |
| TotalVideoP25Combined | Integer | The total number of videos viewed to at least 25 percent completion. | |
| TotalVideoP50Combined | Integer | The total number of videos viewed to at least 50 percent completion. | |
| TotalVideoP75Combined | Integer | The total number of videos viewed to at least 75 percent completion. | |
| TotalVideoP95Combined | Integer | The total number of videos viewed to at least 95 percent completion. | |
| TotalVideoMrcViews | Integer | The total number of video views meeting the MRC (Media Rating Council) viewability standard. | |
| TotalVideoAvgWatchtimeInSecond | Integer | The average video watch time across all video views, in seconds. | |
| TotalRepinRate | Double | The total repin rate across paid and organic. | |
| TotalWebCheckout | Integer | The total number of web checkout conversions. | |
| TotalWebCheckoutValueInMicroDollar | Double | The total value of web checkout conversions, in microdollars. | |
| TotalWebClickCheckout | Integer | The total number of web checkout conversions attributed to a click. | |
| TotalWebClickCheckoutValueInMicroDollar | Double | The total value of web checkout conversions attributed to a click, in microdollars. | |
| TotalWebEngagementCheckout | Integer | The total number of web checkout conversions attributed to engagement. | |
| TotalWebEngagementCheckoutValueInMicroDollar | Double | The total value of web checkout conversions attributed to engagement, in microdollars. | |
| TotalWebViewCheckout | Integer | The total number of web checkout conversions attributed to a view. | |
| TotalWebViewCheckoutValueInMicroDollar | Double | The total value of web checkout conversions attributed to a view, in microdollars. | |
| Clickthrough1 | Integer | The number of paid clickthroughs. | |
| Clickthrough1Gross | Integer | The gross number of paid clickthroughs, including invalid clicks. | |
| Impression1 | Integer | The number of paid impressions. | |
| Impression1Gross | Integer | The gross number of paid impressions, including invalid impressions. | |
| AdId | String |
Ads.Id | The unique identifier of the ad. |
| CampaignBudgetOptimization | Boolean | Whether campaign budget optimization is enabled for the campaign. | |
| AdGroupBudgetInLocalCurrency | String | The budget allocated to the ad group in the local currency. | |
| AdGroupBudgetType | String | The type of budget applied to the ad group.
The allowed values are DAILY, LIFETIME, CBO_ADGROUP. The default value is CBO_ADGROUP. | |
| CostPerPaidOutboundClickInDollar | Decimal | Average cost per paid outbound click. | |
| PaidOutboundClicksPerImpression | Decimal | Paid outbound clicks divided by paid impressions. | |
| StartDate | Date | Metric report start date. | |
| EndDate | Date | Metric report end date. | |
| Granularity | String | The time granularity used to aggregate the analytics data.
The allowed values are TOTAL, DAY, WEEK, MONTH. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| ClickWindowDays | Integer | Number of days to use as the conversion attribution window for a pin click action.
The allowed values are 1, 7, 14, 30, 60. The default value is 30. | |
| ViewWindowDays | Integer | Number of days to use as the conversion attribution window for a view action.
The allowed values are 1, 7, 14, 30, 60. The default value is 1. | |
| ConversionReportTime | String | The date by which the conversion metrics returned from this endpoint will be reported.
The allowed values are TIME_OF_AD_ACTION, TIME_OF_CONVERSION. The default value is TIME_OF_AD_ACTION. | |
| ReportingTimezone | String | The timezone used when reporting analytics data.
The allowed values are PINTEREST_TIME_ZONE, AD_ACCOUNT_TIME_ZONE. | |
| EngagementWindowDays | Integer | Number of days to use as the conversion attribution window for an engagement action (saves, closeups, link clicks, and carousel card swipes).
The allowed values are 0, 1, 7, 14, 30, 60. The default value is 30. | |
| AggregateReportRows | Boolean | Determines whether report rows should be aggregated across all requested entities. This feature is currently in beta and is not available to all users.
The default value is false. |