Command Info

Name: voonix:import

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

Status: completed

Start Time: 2025-11-24 14:04:03

End Time: 2025-11-24 14:04:20

Total Time: 17 seconds

Dispatched Jobs Count: 0

Successful Jobs Count: 0

Failed Jobs Count: 0

Output

14:04:03 Lock acquired for command: voonix:import
14:04:03 DRY RUN MODE - No data will be imported
14:04:03 BACKFILL MODE - Processing last 14 days
14:04:03 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
14:04:03 Configurations: 1
14:04:03 Processing: Stake DML JP
14:04:03 Checking existing custom stats in Voonix...
14:04:03 Found 14 existing custom stat(s):
14:04:03 API Request used:
14:04:03 GET /api/?report=customstats&v3&list&advertiser_login=177&fk_ckey=custom_7532&start=2025-11-10&end=2025-11-23
14:04:06 ✓ 2025-11-10:
14:04:06 POST Payload (what would be sent to Voonix API):
14:04:06 <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
}
]</>
14:04:06 ⚠️ Would UPDATE existing record (custom_id: 4548)
14:04:07 ✓ 2025-11-11:
14:04:07 POST Payload (what would be sent to Voonix API):
14:04:07 <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
}
]</>
14:04:07 ⚠️ Would UPDATE existing record (custom_id: 4549)
14:04:08 ✓ 2025-11-12:
14:04:08 POST Payload (what would be sent to Voonix API):
14:04:08 <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
}
]</>
14:04:08 ⚠️ Would UPDATE existing record (custom_id: 4538)
14:04:09 ✓ 2025-11-13:
14:04:09 POST Payload (what would be sent to Voonix API):
14:04:09 <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
}
]</>
14:04:09 ⚠️ Would UPDATE existing record (custom_id: 4550)
14:04:10 ✓ 2025-11-14:
14:04:10 POST Payload (what would be sent to Voonix API):
14:04:10 <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
}
]</>
14:04:10 ⚠️ Would UPDATE existing record (custom_id: 4551)
14:04:11 ✓ 2025-11-15:
14:04:11 POST Payload (what would be sent to Voonix API):
14:04:11 <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
}
]</>
14:04:11 ⚠️ Would UPDATE existing record (custom_id: 4552)
14:04:13 ✓ 2025-11-16:
14:04:13 POST Payload (what would be sent to Voonix API):
14:04:13 <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
}
]</>
14:04:13 ⚠️ Would UPDATE existing record (custom_id: 4553)
14:04:14 ✓ 2025-11-17:
14:04:14 POST Payload (what would be sent to Voonix API):
14:04:14 <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
}
]</>
14:04:14 ⚠️ Would UPDATE existing record (custom_id: 4555)
14:04:15 ✓ 2025-11-18:
14:04:15 POST Payload (what would be sent to Voonix API):
14:04:15 <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
}
]</>
14:04:15 ⚠️ Would UPDATE existing record (custom_id: 4556)
14:04:16 ✓ 2025-11-19:
14:04:16 POST Payload (what would be sent to Voonix API):
14:04:16 <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
}
]</>
14:04:16 ⚠️ Would UPDATE existing record (custom_id: 4557)
14:04:17 ✓ 2025-11-20:
14:04:17 POST Payload (what would be sent to Voonix API):
14:04:17 <fg=cyan>[
{
"fk_login": 177,
"fk_ckey": "custom_7532",
"date": "2025-11-20",
"clicks": 11,
"signups": 3,
"ftds": 0,
"net_revenue": 12292,
"revshare": 6146
}
]</>
14:04:17 ⚠️ Would UPDATE existing record (custom_id: 4558)
14:04:18 ✓ 2025-11-21:
14:04:18 POST Payload (what would be sent to Voonix API):
14:04:18 <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
}
]</>
14:04:18 ⚠️ Would UPDATE existing record (custom_id: 4559)
14:04:19 ✓ 2025-11-22:
14:04:19 POST Payload (what would be sent to Voonix API):
14:04:19 <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
}
]</>
14:04:19 ⚠️ Would UPDATE existing record (custom_id: 4560)
14:04:20 ✓ 2025-11-23:
14:04:20 POST Payload (what would be sent to Voonix API):
14:04:20 <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
}
]</>
14:04:20 ⚠️ Would UPDATE existing record (custom_id: 4561)
14:04:20 Import complete:
14:04:20 Total imported: 14
14:04:20 Lock released for voonix:import