...
Total number of successfully processed conversions for a given advertiser
| Code Block | ||
|---|---|---|
| ||
SELECT sum(cntcount) count FROM `i19s-insights.insights.trailinsights_untrackedconversion_cnt`hourly` WHERE DATE(requestDateperformanceHour) = current_date() AND advertiserId = <advertiserId> |
...
Total number of attributed conversions for a given advertiser
| Code Block | ||
|---|---|---|
| ||
SELECT count(*) AND requestType = 'Conversion' count FROM `i19s-insights.insights.insights_conversion` WHERE DATE(performedAt) = current_date() AND advertiserId = <advertiserId> AND processing.totalWinnerCount > 0 |
...
Partnerships
Find email addresses of key account managers
...