Command Info

Name: voonix:import

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

Status: completed

Start Time: 2025-11-24 11:26:43

End Time: 2025-11-24 11:26:54

Total Time: 11 seconds

Dispatched Jobs Count: 0

Successful Jobs Count: 0

Failed Jobs Count: 0

Output

11:26:43 Lock acquired for command: voonix:import
11:26:43 DRY RUN MODE - No data will be imported
11:26:43 BACKFILL MODE - Processing last 14 days
11:26:43 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:26:43 Configurations: 1
11:26:43 Processing: Stake DML JP
11:26:43 Checking existing custom stats in Voonix...
11:26:43 Found 14 existing custom stat(s):
11:26:43 API Request used:
11:26:43 GET /api/?report=customstats&v3&list&advertiser_login=177&fk_ckey=custom_7532&start=2025-11-10&end=2025-11-23
11:26:44 ✓ 2025-11-10:
11:26:44 POST Payload (what would be sent to Voonix API):
11:26:44 <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:26:44 ⚠️ Would UPDATE existing record (custom_id: 4548)
11:26:45 ✓ 2025-11-11:
11:26:45 POST Payload (what would be sent to Voonix API):
11:26:45 <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:26:45 ⚠️ Would UPDATE existing record (custom_id: 4549)
11:26:45 ✓ 2025-11-12:
11:26:45 POST Payload (what would be sent to Voonix API):
11:26: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
}
]</>
11:26:45 ⚠️ Would UPDATE existing record (custom_id: 4538)
11:26:46 ✓ 2025-11-13:
11:26:46 POST Payload (what would be sent to Voonix API):
11:26:46 <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:26:46 ⚠️ Would UPDATE existing record (custom_id: 4550)
11:26:47 ✓ 2025-11-14:
11:26:47 POST Payload (what would be sent to Voonix API):
11:26: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
}
]</>
11:26:47 ⚠️ Would UPDATE existing record (custom_id: 4551)
11:26:48 ✓ 2025-11-15:
11:26:48 POST Payload (what would be sent to Voonix API):
11:26: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
}
]</>
11:26:48 ⚠️ Would UPDATE existing record (custom_id: 4552)
11:26:49 ✓ 2025-11-16:
11:26:49 POST Payload (what would be sent to Voonix API):
11:26: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
}
]</>
11:26:49 ⚠️ Would UPDATE existing record (custom_id: 4553)
11:26:49 ✓ 2025-11-17:
11:26:49 POST Payload (what would be sent to Voonix API):
11:26:49 <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:26:49 ⚠️ Would UPDATE existing record (custom_id: 4555)
11:26:50 ✓ 2025-11-18:
11:26:50 POST Payload (what would be sent to Voonix API):
11:26:50 <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:26:50 ⚠️ Would UPDATE existing record (custom_id: 4556)
11:26:51 ✓ 2025-11-19:
11:26:51 POST Payload (what would be sent to Voonix API):
11:26:51 <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:26:51 ⚠️ Would UPDATE existing record (custom_id: 4557)
11:26:52 ✓ 2025-11-20:
11:26:52 POST Payload (what would be sent to Voonix API):
11:26:52 <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:26:52 ⚠️ Would UPDATE existing record (custom_id: 4558)
11:26:52 ✓ 2025-11-21:
11:26:52 POST Payload (what would be sent to Voonix API):
11:26:52 <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:26:52 ⚠️ Would UPDATE existing record (custom_id: 4559)
11:26:53 ✓ 2025-11-22:
11:26:53 POST Payload (what would be sent to Voonix API):
11:26:53 <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:26:53 ⚠️ Would UPDATE existing record (custom_id: 4560)
11:26:54 ✓ 2025-11-23:
11:26:54 POST Payload (what would be sent to Voonix API):
11:26:54 <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:26:54 ⚠️ Would UPDATE existing record (custom_id: 4561)
11:26:54 Import complete:
11:26:54 Total imported: 14
11:26:54 Lock released for voonix:import