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