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
Updated 29 days ago