Command Info

Name: voonix:import

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

Status: completed

Start Time: 2025-11-24 11:25:09

End Time: 2025-11-24 11:25:23

Total Time: 14 seconds

Dispatched Jobs Count: 0

Successful Jobs Count: 0

Failed Jobs Count: 0

Output

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