Command Info

Name: voonix:import

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

Status: completed

Start Time: 2025-11-24 08:25:55

End Time: 2025-11-24 08:26:10

Total Time: 15 seconds

Dispatched Jobs Count: 0

Successful Jobs Count: 0

Failed Jobs Count: 0

Output

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