crockhill@marketing-etl-prod-m5jc:~$ sudo docker run -l routine=fbar us.gcr.io/marketing-data/marketing-etl fbar
Beginning the Facebook Ads ETL @ 2019-09-04 11:31:20
Triggering creation of Facebook Ads Report @ 2019-09-04 11:31:21
Report status is still: [Job Not Started] at 0% @ 2019-09-04 11:31:22
Report status is still: [Job Started] at 0% @ 2019-09-04 11:31:23
Report status is still: [Job Running] at 0% @ 2019-09-04 11:31:25
Report status is still: [Job Running] at 8% @ 2019-09-04 11:31:29
Unhandled rejection Job Failed
crockhill@marketing-etl-prod-m5jc:~$ sudo docker run -l routine=fbar us.gcr.io/marketing-data/marketing-etl fbar
Beginning the Facebook Ads ETL @ 2019-09-04 11:36:15
Triggering creation of Facebook Ads Report @ 2019-09-04 11:36:16
Report status is still: [Job Not Started] at 0% @ 2019-09-04 11:36:17
Report status is still: [Job Running] at 0% @ 2019-09-04 11:36:18
Report status is still: [Job Running] at 0% @ 2019-09-04 11:36:20
Report status is still: [Job Running] at 0% @ 2019-09-04 11:36:24
Report status is still: [Job Running] at 8% @ 2019-09-04 11:36:33
Report status is still: [Job Running] at 100% @ 2019-09-04 11:36:49
Report has completed processing with a status of [Job Completed], preparing to download @ 2019-09-04 11:37:21
Writing CSV data to disk @ 2019-09-04 11:37:33
Finished writing CSV to disk @ 2019-09-04 11:37:33
Invalid record detected:
Reporting Starts,Reporting Ends,Campaign ID,Campaign Name,Ad Name,Ad ID,Ad Set ID,Ad Set Name,Ad Delivery,Reach,Fre
quency,Amount Spent (USD),Clicks (All),Link Clicks,Impressions,Page Likes,Page Engagement,Post Shares,Post Comments
,Post Engagement,Post Reactions,2-Second Continuous Video Views,3-Second Video Views,Video Watches at 25%,Video Wat
ches at 50%,Video Watches at 75%,Video Watches at 100%,Video Percentage Watched,Leads (Form),Offline Leads [1 Day A
fter Viewing],Offline Leads [28 Days After Clicking],actions_1d_view:offsite_conversion.custom.1757606910965761,act
ions_28d_click:offsite_conversion.custom.1757606910965761,actions_1d_view:offsite_conversion.custom.184882968980699
,actions_28d_click:offsite_conversion.custom.184882968980699,actions_1d_view:offsite_conversion.custom.140507346786
275,actions_28d_click:offsite_conversion.custom.140507346786275,actions_1d_view:offsite_conversion.custom.566251767
077956,actions_28d_click:offsite_conversion.custom.566251767077956,actions_1d_view:offsite_conversion.custom.418112
241974397,actions_28d_click:offsite_conversion.custom.418112241974397,actions_1d_view:offsite_conversion.custom.209
7643350473087,actions_28d_click:offsite_conversion.custom.2097643350473087,actions_1d_view:offsite_conversion.custo
m.2054738634851794,actions_28d_click:offsite_conversion.custom.2054738634851794,actions_1d_view:offsite_conversion.
custom.2120616214620935,actions_28d_click:offsite_conversion.custom.2120616214620935,actions_1d_view:offsite_conver
sion.custom.546467742414327,actions_28d_click:offsite_conversion.custom.546467742414327,actions_1d_view:offsite_con
version.custom.1753000671422720,actions_28d_click:offsite_conversion.custom.1753000671422720,actions_1d_view:offsit
e_conversion.custom.249396638961666,actions_28d_click:offsite_conversion.custom.249396638961666,actions_1d_view:off
site_conversion.custom.1914635208578148,actions_28d_click:offsite_conversion.custom.1914635208578148,actions_1d_vie
w:offsite_conversion.custom.157543488269180,actions_28d_click:offsite_conversion.custom.157543488269180,actions_1d_
view:offsite_conversion.custom.211799489416030,actions_28d_click:offsite_conversion.custom.211799489416030,actions_
1d_view:offsite_conversion.custom.595736027460755,actions_28d_click:offsite_conversion.custom.595736027460755,actio
ns_1d_view:offsite_conversion.custom.451812975240227,actions_28d_click:offsite_conversion.custom.451812975240227,ac
tions_1d_view:offsite_conversion.custom.617334468600760,actions_28d_click:offsite_conversion.custom.617334468600760
13490 rows ETL'd for the Facebook Ads Report ETL @ 2019-09-04 11:37:38
Starting replication ETL to BigQuery @ 2019-09-04 11:37:38
Polling job for status...
Import job status for [facebook_ad_perf] is still: RUNNING @ 2019-09-04 11:38:51
Import job status for [facebook_ad_perf] is still: RUNNING @ 2019-09-04 11:38:52
Import job status for [facebook_ad_perf] is still: RUNNING @ 2019-09-04 11:38:55
Import job status for [facebook_ad_perf] is still: RUNNING @ 2019-09-04 11:38:59
Import job status for [facebook_ad_perf] is still: RUNNING @ 2019-09-04 11:39:07
Import job status for [facebook_ad_perf] is still: RUNNING @ 2019-09-04 11:39:23
The import of [facebook_ad_perf] (job_rTQZZF7_e6_6LIa0Zmxg6WoG8XlD) has completed successfully @ 2019-09-04 11:39:5
3
All tables have finished exporting @ 2019-09-04 11:39:53
Total Duration: 2 minutes
Tables Exported: 0
Rows Processed: 396372