the problem❓
Measurment
Gauging the effectiveness of advertising campaigns across platforms has become increasingly challenging. To address this, Twitter introduced a server-side, 1st party pixel that advertisers can integrate into their websites.
Advertisers on Twitter want to know the investment they are making in advertising results in a positive ROI. For lower funnel conversions (purchases on their website) advertisers need to know if seeing an ad led to a purchase.
👉 code for this project 👈
Gauging the effectiveness of advertising campaigns across platforms has become increasingly challenging. To address this, Twitter introduced a server-side, 1st party pixel that advertisers can integrate into their websites.
The initial phase involved creating a test dataset segmented by iOS and Android devices and further categorized by advertiser. The causal sequence was:
1. A user views an ad.
2. A user clicks on the ad.
3. The user reaches the website's landing page.
4. The user navigates to the checkout page.
5. The user completes a transaction.
I constructed a dataset comparing 'before' and 'after' scenarios and applied ordinary least squares (OLS) regression using Python's statsmodels.api.
Once the model was established, I applied it to Twitter's actual data pulled from BigQuery. I used SQL to extract data that closely mirrored the constructed model, then applied the algorithm to understand the potential percentage lift for advertisers
☝️
By implementing Twitter's first-party pixel, advertisers could see a ~15% boost in lower funnel conversion tracking.
✌️
A ~20% increase in customer adoption
👉 code for this project 👈