AdAccountTargetingAnalytics
Get targeting analytics for an ad account.
View-Specific Information
SELECT
The add-in 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 add-in.
| Column | Supported Operators |
| AdAccountId | = |
| StartDate | =, >, >= |
| EndDate | =, <, <= |
| Granularity | = |
| ClickWindowDays | = |
| EngagementWindowDays | = |
| ViewWindowDays | = |
| TargetingTypes | = |
For example:
SELECT * FROM AdAccountTargetingAnalytics WHERE AdAccountId = '3457832451'
SELECT * FROM AdAccountTargetingAnalytics WHERE AdAccountId = '3457832451' AND StartDate >= '2024-01-06' AND EndDate <= '2024-04-05'
Columns
| Name | Type | References | Description |
| AdAccountId | String |
AdAccounts.Id | Unique identifier of an ad account. |
| AdGroupId | String |
AdGroups.Id | The ID of the ad group associated with this row. |
| TargetingType | String | The type of targeting used for this analytics row.
The allowed values are KEYWORD, APPTYPE, GENDER, LOCATION, PLACEMENT, COUNTRY, TARGETED_INTEREST, PINNER_INTEREST, AUDIENCE_INCLUDE, GEO, AGE_BUCKET, REGION, AGE_BUCKET_AND_GENDER. | |
| TargetingValues | String | The value corresponding to the targeting type for this analytics row. | |
| Date | Date | Date the analytics row covers. | |
| SpendInDollar | Decimal | Total spend in dollars. | |
| AdvertiserId | Double | The ID of the advertiser. | |
| AdGroupEntityStatus | Double | The entity status of the ad group. | |
| AdId | Double | The ID of the ad. | |
| CampaignId | String |
Campaigns.Id | The ID of the campaign. |
| CampaignDailySpendCap | String | The daily spending cap for the campaign in microcurrency. | |
| CampaignEntityStatus | String | The entity status of the campaign. | |
| CampaignLifetimeSpendCap | Integer | The lifetime spending cap for the campaign in microcurrency. | |
| Ctr | Double | The click-through rate for paid impressions. | |
| Ctr2 | Double | The click-through rate for organic impressions. | |
| CheckoutRoas | Double | The return on ad spend for checkout conversions. | |
| Clickthrough1 | Integer | The number of paid clickthroughs. | |
| Clickthrough2 | Integer | The number of organic clickthroughs. | |
| Clickthrough1Gross | Integer | The total number of paid clickthroughs, including repeat clicks. | |
| CpcInMicroDollar | Decimal | The cost per click in microdollars. | |
| CpmInMicroDollar | Decimal | The cost per thousand impressions in microdollars. | |
| Ectr | Decimal | The effective click-through rate. | |
| EcpeInDollar | Decimal | The effective cost per engagement in dollars. | |
| EngagementRate | Double | The engagement rate. | |
| EengagementRate | Double | The effective engagement rate. | |
| EcpvInDollar | Decimal | The effective cost per video view in dollars. | |
| EcpcvInDollar | Decimal | The effective cost per completed video view in dollars. | |
| EcpcvP95InDollar | Decimal | The effective cost per video view completed at 95% in dollars. | |
| EcpcInMicroDollar | Decimal | The effective cost per click in microdollars. | |
| EcpmInMicroDollar | Decimal | The effective cost per thousand impressions in microdollars. | |
| Engagement1 | Integer | The number of paid engagements. | |
| Engagement2 | Integer | The number of organic engagements. | |
| Impression1 | Integer | The number of paid impressions. | |
| Impression1Gross | Integer | The total number of paid impressions, including repeat views. | |
| Impression2 | Integer | The number of organic impressions. | |
| IdeaPinProductTagVisit1 | Integer | The number of paid visits from Idea Pin product tag clicks. | |
| IdeaPinProductTagVisit2 | Integer | The number of organic visits from Idea Pin product tag clicks. | |
| InAppCheckoutCostPerAction | Double | The cost per in-app checkout conversion. | |
| OutboundClick1 | Integer | The number of paid outbound clicks. | |
| OutboundClick2 | Integer | The number of organic outbound clicks. | |
| PinId | String |
Pins.Id | The ID of the Pin. |
| PageVisitCostPerAction | Double | Page visit cost per action. | |
| PageVisitRoas | Double | The return on ad spend for page visit conversions. | |
| PaidImpression | Integer | The number of paid impressions served. | |
| Repin1 | Integer | The number of paid repins (saves). | |
| Repin2 | Integer | The number of organic repins (saves). | |
| RepinRate | Double | The repin rate. | |
| TotalClickthrough | Integer | The total number of clickthroughs across paid and organic. | |
| TotalEngagementSignup | Integer | The total number of signups driven by engagement. | |
| TotalEngagementCheckout | Integer | The total number of checkouts driven by engagement. | |
| TotalClickSignup | Integer | The total number of signups driven by clicks. | |
| TotalClickCheckout | Integer | The total number of checkouts driven by clicks. | |
| TotalViewSignup | Integer | The total number of signups driven by views. | |
| TotalViewCheckout | Integer | The total number of checkouts driven by views. | |
| TotalConversions | Integer | The total number of conversions across all attribution types. | |
| TotalEngagementSignupValueInMicroDollar | Decimal | The total value of signups driven by engagement, in microdollars. | |
| TotalEngagementCheckoutValueInMicroDollar | Decimal | The total value of checkouts driven by engagement, in microdollars. | |
| TotalClickSignupValueInMicroDollar | Decimal | The total value of signups driven by clicks, in microdollars. | |
| TotalClickCheckoutValueInMicroDollar | Decimal | The total value of checkouts driven by clicks, in microdollars. | |
| TotalViewSignupValueInMicroDollar | Decimal | The total value of signups driven by views, in microdollars. | |
| TotalViewCheckoutValueInMicroDollar | Decimal | The total value of checkouts driven by views, in microdollars. | |
| TotalPageVisit | Integer | The total number of page visits attributed to the ad. | |
| TotalSignup | Integer | The total number of signups attributed to the ad. | |
| TotalCheckout | Integer | The total number of checkouts attributed to the ad. | |
| TotalSignupValueInMicroDollar | Decimal | The total value of signups attributed to the ad, in microdollars. | |
| TotalCheckoutValueInMicroDollar | Decimal | The total value of checkouts attributed to the ad, in microdollars. | |
| TotalVideo3secViews | Integer | Total Video 3 second Views. | |
| TotalVideoP100Complete | Integer | Total Video 100 percent Complete. | |
| TotalVideoP0Combined | Integer | Total Video 0 percent Combined. | |
| TotalVideoP25Combined | Integer | Total Video 25 percent Combined. | |
| TotalVideoP50Combined | Integer | Total Video 50 percent Combined. | |
| TotalVideoP75Combined | Integer | Total Video 75 percent Combined. | |
| TotalVideoP95Combined | Integer | Total Video 95 percent Combined. | |
| TotalVideoMrcViews | Integer | The total number of video views meeting the MRC viewability standard. | |
| TotalVideoAvgWatchtimeInSecond | Integer | The average watch time per video view, in seconds. | |
| TotalRepinRate | Double | The overall rate at which users repin the ad. | |
| TotalWebCheckout | Integer | The total number of web checkout conversions. | |
| TotalWebCheckoutValueInMicroDollar | Decimal | The total value of web checkout conversions, in microdollars. | |
| TotalWebClickCheckout | Integer | The total number of web checkout conversions driven by clicks. | |
| TotalWebClickCheckoutValueInMicroDollar | Decimal | The total value of web checkout conversions driven by clicks, in microdollars. | |
| TotalWebEngagementCheckout | Integer | The total number of web checkout conversions driven by engagement. | |
| TotalWebEngagementCheckoutValueInMicroDollar | Decimal | The total value of web checkout conversions driven by engagement, in microdollars. | |
| TotalWebViewCheckout | Integer | The total number of web checkout conversions driven by views. | |
| TotalWebViewCheckoutValueInMicroDollar | Decimal | The total value of web checkout conversions driven by views, in microdollars. | |
| Video3secViews2 | Integer | The number of organic video views lasting at least 3 seconds. | |
| VideoLength | Integer | The length of the video in seconds. | |
| VideoMrcViews2 | Integer | The number of organic video views meeting the MRC viewability standard. | |
| VideoP0Combined2 | Integer | Video 0 percent Combined Views. | |
| VideoP100Complete2 | Integer | Video 100 percent Complete Views. | |
| VideoP25Combined2 | Integer | Video 25 percent Complete Views. | |
| VideoP50Combined2 | Integer | Video 50 percent Complete Views. | |
| VideoP75Combined2 | Integer | Video 75 percent Complete Views. | |
| VideoP95Combined2 | Integer | Video 95 percent Complete Views. | |
| WebCheckoutCostPerAction | Double | Web checkout cost per action. | |
| WebCheckoutRoas | Double | The return on ad spend for web checkout conversions. | |
| 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 | |
| AttributionTypes | String | List of types of attribution for the conversion report.
The allowed values are INDIVIDUAL, HOUSEHOLD. | |
| 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 | Integer | 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. |