AdAnalytics
Get analytics for the ads 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 |
| AdAccountId | = |
| AdId | =, IN |
| StartDate | =, >, >= |
| EndDate | =, <, <= |
| Granularity | = |
| ClickWindowDays | = |
| EngagementWindowDays | = |
| ViewWindowDays | = |
| ConversionReportTime | = |
For example:
SELECT * FROM AdAnalytics WHERE AdAccountId = '3457832451' AND AdId = '3457862457'
SELECT * FROM AdAnalytics WHERE AdAccountId = '3457832451' AND StartDate >= '2024-01-06' AND EndDate <= '2024-04-05'
Columns
| Name | Type | References | Description |
| AdId | String |
Ads.Id | The unique identifier of the ad. |
| AdAccountId | String |
AdAccounts.Id | The unique identifier of the ad account. |
| Date | Date | Current metrics date. Only returned when granularity is a time-based value. | |
| 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. | |
| CampaignId | String |
Campaigns.Id | The unique identifier of the campaign. |
| AdvertiserId | String | The unique identifier of the advertiser. | |
| AdGroupId | String |
AdGroups.Id | The unique identifier of the ad group. |
| CampaignDailySpendCap | Integer | The daily spending cap for the campaign, in microcurrency. | |
| CampaignLifetimeSpendCap | Integer | The lifetime spending cap for the campaign, in microcurrency. | |
| CampaignName | String | The name of the campaign. | |
| Clickthrough2 | Integer | The number of organic clickthroughs. | |
| CpcInMicroDollar | Decimal | The cost per click (CPC), in microdollars. | |
| CpmInMicroDollar | Decimal | The cost per mille (CPM), in microdollars. | |
| EcpcInMicroDollar | Decimal | The effective cost per click (ECPC), in microdollars. | |
| EcpmInMicroDollar | Decimal | The effective cost per mille (ECPM), in microdollars. | |
| Engagement1 | Integer | The number of paid engagements. | |
| Engagement2 | Integer | The number of organic engagements. | |
| IdeaPinProductTagVisit1 | Integer | The number of paid visits to a product page via an Idea Pin product tag. | |
| IdeaPinProductTagVisit2 | Integer | The number of organic visits to a product page via an Idea Pin product tag. | |
| Impression2 | Integer | The number of organic impressions. | |
| InAppCheckoutCostPerAction | Double | The cost per action for in-app checkout conversions. | |
| OutboundClick1 | Integer | The number of paid outbound clicks. | |
| OutboundClick2 | Integer | The number of organic outbound clicks. | |
| PaidImpression | Integer | The number of paid impressions served. | |
| PinId | String |
Pins.Id | The unique identifier of the pin. |
| Repin1 | Integer | The number of paid repins. | |
| Repin2 | Integer | The number of organic repins. | |
| SpendInMicroDollar | Decimal | The total spend, in microdollars. | |
| TotalClickAddToCart | Integer | The total number of add-to-cart conversions attributed to a click. | |
| TotalClickLead | Integer | The total number of lead conversions attributed to a click. | |
| TotalCustom | Integer | The total number of custom conversions. | |
| TotalEngagement | Integer | The total number of engagements across paid and organic. | |
| TotalEngagementLead | Integer | The total number of lead conversions attributed to engagement. | |
| TotalIdeaPinProductTagVisit | Integer | The total number of product page visits via an Idea Pin product tag. | |
| TotalImpressionUser | Integer | The total number of unique users who saw an impression. | |
| TotalLead | Integer | The total number of lead conversions. | |
| TotalOfflineCheckout | Integer | The total number of offline checkout conversions. | |
| TotalViewAddToCart | Integer | The total number of add-to-cart conversions attributed to a view. | |
| TotalViewLead | Integer | The total number of lead conversions attributed to a view. | |
| TotalWebSessions | Integer | The total number of web sessions attributed to the ad. | |
| VideoLength | Integer | The length of the video, in milliseconds. | |
| WebSessions1 | Integer | The number of paid web sessions. | |
| WebSessions2 | Integer | The number of organic web sessions. | |
| 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. |