| order_nr | order_month | order_date | country | affiliate_name | code | order_st | tot_items | return_items | net_items | sale_price_aed | sale_price_egp | coupon_money_value_aed | gmv_aed | gmv_tag | order_tag | cost | Unnamed: 17 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| NEGDB0097659411 | 11.0 | 2021-11-01 | EG | arabclicks | ALM2 | delivered | 1.0 | 0.0 | 1.0 | 47.688672 | 204.0 | 4.7688672 | 42.9198048 | above200 | repeat | 6.0 | nan |
| NEGDB0022553761 | 11.0 | 2021-11-01 | EG | arabclicks | ALM2 | delivered | 27.0 | 0.0 | 27.0 | 183.858532 | 786.5 | 11.69073768 | 172.1677943 | above200 | new | 6.0 | nan |
| NEGDB0011613723 | 11.0 | 2021-11-01 | EG | arabclicks | AT49 | delivered | 8.0 | 0.0 | 8.0 | 66.0277716 | 282.45 | 2.805216 | 63.2225556 | above200 | repeat | 6.0 | nan |
| NEGDA0092181006 | 11.0 | 2021-11-01 | EG | arabclicks | AT49 | delivered | 1.0 | 0.0 | 1.0 | 22.49783232 | 96.24 | 2.24884816 | 20.24898416 | below200 | repeat | 1.0 | nan |
| id | offer_id | offer | goal_id | goal | affiliate_id | affiliate | date_time | status_message | revenue | sale_amount | session_ip | transaction_id | affiliate_sub_id_5 | advertiser_sub_id_1 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1778432.0 | 235.0 | Noon - Egypt - Coupons | 575.0 | Order amount > 200 EGP | 44489.0 | Digizag | 11/30/2021 12:00 | nan | 12.0 | 45.24279 | Orders:2 | 235444895751638230400AN471 | AN471 | Nov 30, 2021AN471EG575 |
| 1758464.0 | 235.0 | Noon - Egypt - Coupons | 575.0 | Order amount > 200 EGP | 44489.0 | Digizag | 11/30/2021 12:00 | nan | 12.0 | 43.80525 | Orders:2 | 235444895751638230400EXTRA427 | EXTRA427 | Nov 30, 2021EXTRA427EG575 |
| 1758720.0 | 235.0 | Noon - Egypt - Coupons | 575.0 | Order amount > 200 EGP | 35092.0 | mohamed ali | 11/30/2021 12:00 | nan | 6.0 | 39.78219 | Orders:1 | 235350925751638230400AZ94 | AZ94 | Nov 30, 2021AZ94EG575 |