Question

The campaign report table in dataset tmo_pinterest shows different impression and click fields. Which one corresponds to the impressions and link clicks given in the Pinterest business manager?

Environment

Connector: Pinterest

Answer

From the Pinterest reporting documentation, it informs:

• 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, they also mention

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

This indicates the "_1" are likely the values that represent the UI data.