...
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
...