Question

The campaign report table in the dataset, tmo_pinterest, shows various fields for impressions and clicks. Which one corresponds to the impressions and link clicks provided in the Pinterest Business Manager?

Environment

Connector: Pinterest

Answer

Please see the below explanation from Pinterest's Reporting Documentation:

• Metric names ending in _1 represent first-order ad events. For example, CLICKTHROUGH_1 is the number of direct clicks on a Promoted Pin.
• Metric names ending in _2 represent downstream (“earned”) events. These are actions taken on saved instances of Promoted Pins. Advertisers are not billed for earned activity.

In the Campaign Keyword Metrics Documentation, it is also mentioned:

You might see conversion metrics suffixed with "_1". Those are being deprecated.

This indicates the metrics ending in _1 are likely the values that represent the UI data.