...
| Code Block | ||
|---|---|---|
| ||
SELECT performedAt, updatedAt, conversionId, advertiserId, conversionTargetId, ratingStatus
FROM `i19s-insights.insights.insights_conversion`
WHERE DATE(performedAt) = current_date()
AND conversionId in ('abc123','def456','ghi789') |
...
Touchpoint
Conversions and
...
touchpoint
Single list of todays conversions and touchpoint list
| Code Block | ||
|---|---|---|
| ||
SELECT performedAt, updatedAt, conversionId, advertiserId, conversionTargetId, ratingStatus, userJourney FROM `i19s-insights.insights.insights_conversion` WHERE DATE(performedAt) = current_date() |
...
Conversions and
...
touchpoint object
Single list of todays conversions and single touchpoint object
| Code Block | ||
|---|---|---|
| ||
SELECT performedAt, updatedAt, conversionId, advertiserId, conversionTargetId, ratingStatus, userJourney[OFFSET(0)] as touchpoint FROM `i19s-insights.insights.insights_conversion` WHERE DATE(performedAt) = current_date() AND attributionStatus='ATTRIBUTED' |
...
Conversions and
...
touchpoint fields
Single list of todays conversions and single touchpoint fields
| Code Block | ||
|---|---|---|
| ||
SELECT performedAt, updatedAt, conversionId, advertiserId, conversionTargetId, ratingStatus, userJourney[OFFSET(0)].admediaCode as touchpointAdmediaCode FROM `i19s-insights.insights.insights_conversion` WHERE DATE(performedAt) = current_date() AND attributionStatus='ATTRIBUTED' |
...
Conversions with total revenue, commission from
...
touchpoint
Single list of todays conversions and totals for revenue, commission and fee from touchpoint list
...
| Code Block | ||
|---|---|---|
| ||
SELECT performedAt, updatedAt, conversionId, advertiserId, conversionTargetId, ratingStatus, currencyCode,
(
SELECT AS STRUCT
SUM(price) AS price,
SUM(quantity) AS quantity,
SUM(revenue) AS revenue,
FROM UNNEST(positions)
WHERE status IN( 'OPEN', 'CONFIRMED','REJECTED')
) as totals,
FROM `i19s-insights.insights.insights_conversion`
WHERE DATE(performedAt) = current_date()
AND attributionStatus='ATTRIBUTED' |
...
Free parameters
Attributed
...
conversions having pattern 'Madrid' in
...
user value 3
Single list of todays conversions
...