Command Info

Name: voonix:import

Description: Import Google Sheets data to Voonix for all active configurations

Status: completed

Start Time: 2025-11-24 16:15:41

End Time: 2025-11-24 16:15:57

Total Time: 16 seconds

Dispatched Jobs Count: 0

Successful Jobs Count: 0

Failed Jobs Count: 0

Output

16:15:41 Lock acquired for command: voonix:import
16:15:41 DRY RUN MODE - No data will be imported
16:15:41 BACKFILL MODE - Processing last 14 days
16:15:41 Dates: 2025-11-10, 2025-11-11, 2025-11-12, 2025-11-13, 2025-11-14, 2025-11-15, 2025-11-16, 2025-11-17, 2025-11-18, 2025-11-19, 2025-11-20, 2025-11-21, 2025-11-22, 2025-11-23
16:15:41 Configurations: 1
16:15:41 Processing: Stake DML JP
16:15:41 Checking existing custom stats in Voonix...
16:15:41 Found 14 existing custom stat(s):
16:15:41 API Request used:
16:15:41 GET /api/?report=customstats&v3&list&advertiser_login=177&fk_ckey=custom_7532&start=2025-11-10&end=2025-11-23
16:15:43 ✓ 2025-11-10:
16:15:43 POST Payload (what would be sent to Voonix API):
16:15:43 <fg=cyan>[
{
"fk_login": 177,
"fk_ckey": "custom_7532",
"date": "2025-11-10",
"clicks": 5,
"signups": 2,
"ftds": 0,
"net_revenue": 2992.26,
"revshare": 1496.13
}
]</>
16:15:43 ⚠️ Would DELETE AND RECREATE existing record (custom_id: 4548)
16:15:44 ✓ 2025-11-11:
16:15:44 POST Payload (what would be sent to Voonix API):
16:15:44 <fg=cyan>[
{
"fk_login": 177,
"fk_ckey": "custom_7532",
"date": "2025-11-11",
"clicks": 6,
"signups": 4,
"ftds": 0,
"net_revenue": 4018.85,
"revshare": 2009.42
}
]</>
16:15:44 ⚠️ Would DELETE AND RECREATE existing record (custom_id: 4549)
16:15:45 ✓ 2025-11-12:
16:15:45 POST Payload (what would be sent to Voonix API):
16:15:45 <fg=cyan>[
{
"fk_login": 177,
"fk_ckey": "custom_7532",
"date": "2025-11-12",
"clicks": 14,
"signups": 3,
"ftds": 2,
"net_revenue": 5338.43,
"revshare": 2669.22
}
]</>
16:15:45 ⚠️ Would DELETE AND RECREATE existing record (custom_id: 4538)
16:15:45 ✓ 2025-11-13:
16:15:45 POST Payload (what would be sent to Voonix API):
16:15:45 <fg=cyan>[
{
"fk_login": 177,
"fk_ckey": "custom_7532",
"date": "2025-11-13",
"clicks": 4,
"signups": 3,
"ftds": 2,
"net_revenue": -3449.78,
"revshare": -1724.89
}
]</>
16:15:45 ⚠️ Would DELETE AND RECREATE existing record (custom_id: 4550)
16:15:47 ✓ 2025-11-14:
16:15:47 POST Payload (what would be sent to Voonix API):
16:15:47 <fg=cyan>[
{
"fk_login": 177,
"fk_ckey": "custom_7532",
"date": "2025-11-14",
"clicks": 5,
"signups": 2,
"ftds": 0,
"net_revenue": 6449.48,
"revshare": 3224.74
}
]</>
16:15:47 ⚠️ Would DELETE AND RECREATE existing record (custom_id: 4551)
16:15:48 ✓ 2025-11-15:
16:15:48 POST Payload (what would be sent to Voonix API):
16:15:48 <fg=cyan>[
{
"fk_login": 177,
"fk_ckey": "custom_7532",
"date": "2025-11-15",
"clicks": 6,
"signups": 3,
"ftds": 1,
"net_revenue": 9225.13,
"revshare": 4612.57
}
]</>
16:15:48 ⚠️ Would DELETE AND RECREATE existing record (custom_id: 4552)
16:15:49 ✓ 2025-11-16:
16:15:49 POST Payload (what would be sent to Voonix API):
16:15:49 <fg=cyan>[
{
"fk_login": 177,
"fk_ckey": "custom_7532",
"date": "2025-11-16",
"clicks": 6,
"signups": 3,
"ftds": 1,
"net_revenue": -379.57,
"revshare": -189.79
}
]</>
16:15:49 ⚠️ Would DELETE AND RECREATE existing record (custom_id: 4553)
16:15:50 ✓ 2025-11-17:
16:15:50 POST Payload (what would be sent to Voonix API):
16:15:50 <fg=cyan>[
{
"fk_login": 177,
"fk_ckey": "custom_7532",
"date": "2025-11-17",
"clicks": 9,
"signups": 2,
"ftds": 2,
"net_revenue": 30635.44,
"revshare": 15317.72
}
]</>
16:15:50 ⚠️ Would DELETE AND RECREATE existing record (custom_id: 4555)
16:15:51 ✓ 2025-11-18:
16:15:51 POST Payload (what would be sent to Voonix API):
16:15:51 <fg=cyan>[
{
"fk_login": 177,
"fk_ckey": "custom_7532",
"date": "2025-11-18",
"clicks": 6,
"signups": 4,
"ftds": 2,
"net_revenue": 3454.79,
"revshare": 1727.39
}
]</>
16:15:51 ⚠️ Would DELETE AND RECREATE existing record (custom_id: 4556)
16:15:52 ✓ 2025-11-19:
16:15:52 POST Payload (what would be sent to Voonix API):
16:15:52 <fg=cyan>[
{
"fk_login": 177,
"fk_ckey": "custom_7532",
"date": "2025-11-19",
"clicks": 12,
"signups": 3,
"ftds": 0,
"net_revenue": 4354.28,
"revshare": 2177.14
}
]</>
16:15:52 ⚠️ Would DELETE AND RECREATE existing record (custom_id: 4557)
16:15:53 ✓ 2025-11-20:
16:15:53 POST Payload (what would be sent to Voonix API):
16:15:53 <fg=cyan>[
{
"fk_login": 177,
"fk_ckey": "custom_7532",
"date": "2025-11-20",
"clicks": 11,
"signups": 3,
"ftds": 0,
"net_revenue": 12292,
"revshare": 6146
}
]</>
16:15:53 ⚠️ Would DELETE AND RECREATE existing record (custom_id: 4558)
16:15:55 ✓ 2025-11-21:
16:15:55 POST Payload (what would be sent to Voonix API):
16:15:55 <fg=cyan>[
{
"fk_login": 177,
"fk_ckey": "custom_7532",
"date": "2025-11-21",
"clicks": 7,
"signups": 3,
"ftds": 1,
"net_revenue": 23518.16,
"revshare": 11759.08
}
]</>
16:15:55 ⚠️ Would DELETE AND RECREATE existing record (custom_id: 4559)
16:15:56 ✓ 2025-11-22:
16:15:56 POST Payload (what would be sent to Voonix API):
16:15:56 <fg=cyan>[
{
"fk_login": 177,
"fk_ckey": "custom_7532",
"date": "2025-11-22",
"clicks": 5,
"signups": 4,
"ftds": 0,
"net_revenue": -13090.29,
"revshare": -6545.14
}
]</>
16:15:56 ⚠️ Would DELETE AND RECREATE existing record (custom_id: 4560)
16:15:56 ✓ 2025-11-23:
16:15:56 POST Payload (what would be sent to Voonix API):
16:15:56 <fg=cyan>[
{
"fk_login": 177,
"fk_ckey": "custom_7532",
"date": "2025-11-23",
"clicks": 8,
"signups": 5,
"ftds": 0,
"net_revenue": 24808.95,
"revshare": 12404.48
}
]</>
16:15:56 ⚠️ Would DELETE AND RECREATE existing record (custom_id: 4561)
16:15:56 Import complete:
16:15:56 Total imported: 14
16:15:56 Lock released for voonix:import