Twitter Conversions (Purchases)

conversions

Overview

Twitter Conversions (Purchases) represent the total number of purchases as reported by Twitter Ads.

📘

Twitter Conversions = Number of Twitter Reported by Pinterest

The calculation is based on data from the Ads table.

Detailed Breakdown

The formula above is derived from the following components:

Conversions = SUM(conversions) --> Ads table
Twitter Ads = where channel = 'twitter-ads'

Insights and Actions

Example Use

Prompt

How many Twitter-reported conversions were there yesterday?

Response

Query

SELECT pjt.channel AS channel, SUM(pjt.channel_reported_conversions) AS twitter_reported_conversions FROM pixel_joined_tvf () AS pjt WHERE pjt.channel = 'twitter-ads' AND pjt.event_date = CURRENT_DATE() - 1 GROUP BY pjt.channel

Did this page help you?