WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 537 AND "platform_id" = 183 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 183 AND "api_data_customplatformstats"."date" >= '2023-01-01' AND "api_data_customplatformstats"."date" <= '2024-10-23' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));

Date: 2024-10-23 10:13:10
Duration: 5m42s
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.122.234

WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 2 AND "platform_id" = 290 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 290 AND "api_data_customplatformstats"."date" >= '2024-05-01' AND "api_data_customplatformstats"."date" <= '2025-08-18' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));

Date: 2024-10-23 14:08:26
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.35.117

x Hide

SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'session_source_medium' AS "~GA4-S3:session_source_medium:custom_platform_info:1", data ->> 'transaction_id' AS "~GA4-S3:transaction_id:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_23 scratch ON scratch.object_id = main.id;

Date: 2024-10-23 10:56:27
Duration: 9m12s
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.106.174

SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'session_source_medium' AS "~GA4-S3:session_source_medium:custom_platform_info:1", data ->> 'transaction_id' AS "~GA4-S3:transaction_id:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_23 scratch ON scratch.object_id = main.id;

Date: 2024-10-23 10:56:26
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.106.174

x Hide

SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'net_sales' AS "~SP0:net_sales:custom_platform_stats:1", data ->> 'discounts' AS "~SP0:discounts:custom_platform_stats:1", data ->> 'gross_sales' AS "~SP0:gross_sales:custom_platform_stats:1", data ->> 'total_sales' AS "~SP0:total_sales:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_38 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2021-11-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-23', 'YYYY-MM-DD');

Date: 2024-10-23 11:19:23
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.119.250

x Hide

SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'transactions' AS "~GA4-S3:transactions:custom_platform_stats:1", data ->> 'sessions' AS "~GA4-S3:sessions:custom_platform_stats:1", data ->> 'new_users' AS "~GA4-S3:new_users:custom_platform_stats:1", data ->> 'total_revenue' AS "~GA4-S3:total_revenue:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_23 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2021-08-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');

Date: 2024-10-23 11:00:16
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.106.174

x Hide

SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'total_sales' AS "~SP0:total_sales:custom_platform_stats:1", data ->> 'gross_sales' AS "~SP0:gross_sales:custom_platform_stats:1", data ->> 'discounts' AS "~SP0:discounts:custom_platform_stats:1", data ->> 'net_sales' AS "~SP0:net_sales:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_42 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2021-11-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-23', 'YYYY-MM-DD');

Date: 2024-10-23 14:14:40
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.62.217

x Hide

SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'gross_sales' AS "~SP0:gross_sales:custom_platform_stats:1", data ->> 'net_sales' AS "~SP0:net_sales:custom_platform_stats:1", data ->> 'discounts' AS "~SP0:discounts:custom_platform_stats:1", data ->> 'total_sales' AS "~SP0:total_sales:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_23 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2021-11-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-23', 'YYYY-MM-DD');

Date: 2024-10-23 10:04:18
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.114.62

x Hide

SELECT "api_data_ga_platform_object_to_fb_platform_object"."fb_platform_object_id", "api_data_ga_platform_object_to_fb_platform_object"."ga_platform_object_id" FROM "api_data_ga_platform_object_to_fb_platform_object" INNER JOIN "api_data_ga_platform_object_to_fb_platform_object_connectioef73" ON ("api_data_ga_platform_object_to_fb_platform_object"."id" = "api_data_ga_platform_object_to_fb_platform_object_connectioef73"."gaplatformobjecttofbplatformobject_id") WHERE "api_data_ga_platform_object_to_fb_platform_object_connectioef73"."connectionrule_id" IN (17);

Date: 2024-10-23 07:40:40
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.122.234

x Hide

SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_35 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-06-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-23', 'YYYY-MM-DD');

Date: 2024-10-23 10:19:58
Duration: 6m20s
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.36.36

SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_35 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-06-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-23', 'YYYY-MM-DD');

Date: 2024-10-23 10:11:29
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.36.36

x Hide

SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_17 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-06-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-23', 'YYYY-MM-DD');

Date: 2024-10-23 08:11:51
Duration: 15m42s
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.36.36

x Hide

SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_9 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-06-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-23', 'YYYY-MM-DD');

Date: 2024-10-23 08:29:28
Duration: 6m30s
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.34.220

x Hide

SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_4 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-06-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-23', 'YYYY-MM-DD');

Date: 2024-10-23 09:44:03
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.114.62

x Hide

CREATE INDEX index_5835425 ON repack.table_5815699 USING btree (portfolio_id);

Date: 2024-10-23 19:10:23
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: root
Remote: 10.24.110.39

x Hide

CREATE INDEX index_5835418 ON repack.table_5815699 USING btree (custom_platform_template_upload_id);

Date: 2024-10-23 19:09:14
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: root
Remote: 10.24.110.39

x Hide

CREATE INDEX index_22633304 ON repack.table_5815699 USING btree (new_unique_field_key_id);

Date: 2024-10-23 19:08:36
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: root
Remote: 10.24.110.39

x Hide

CREATE UNIQUE INDEX index_5837622 ON repack.table_5815699 USING btree (id);

Date: 2024-10-23 19:07:46
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: root
Remote: 10.24.110.39

x Hide

CREATE UNIQUE INDEX index_22656798 ON repack.table_5815699 USING btree (platform_id, portfolio_id, new_unique_field_key_id);

Date: 2024-10-23 19:08:51
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: root
Remote: 10.24.110.39

x Hide

CREATE UNIQUE INDEX index_5837620 ON repack.table_5815699 USING btree (gid);

Date: 2024-10-23 19:07:53
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: root
Remote: 10.24.110.39

x Hide

CREATE INDEX index_5835424 ON repack.table_5815699 USING btree (platform_id);

Date: 2024-10-23 19:09:45
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: root
Remote: 10.24.110.39

x Hide

SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'transaction_id' AS "~GA4-S6:transaction_id:custom_platform_info:1", data ->> 'first_user_source_medium' AS "~GA4-S6:first_user_source_medium:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_8 scratch ON scratch.object_id = main.id;

Date: 2024-10-23 08:12:04
Duration: 7m59s
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.34.220

SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'transaction_id' AS "~GA4-S6:transaction_id:custom_platform_info:1", data ->> 'first_user_source_medium' AS "~GA4-S6:first_user_source_medium:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_8 scratch ON scratch.object_id = main.id;

Date: 2024-10-23 08:12:04
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.34.220

x Hide

SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'transaction_id' AS "~GA4-S6:transaction_id:custom_platform_info:1", data ->> 'first_user_source_medium' AS "~GA4-S6:first_user_source_medium:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_7 scratch ON scratch.object_id = main.id;

Date: 2024-10-23 09:11:46
Duration: 10m
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.98.29

SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'transaction_id' AS "~GA4-S6:transaction_id:custom_platform_info:1", data ->> 'first_user_source_medium' AS "~GA4-S6:first_user_source_medium:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_7 scratch ON scratch.object_id = main.id;

Date: 2024-10-23 09:11:46
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.98.29

x Hide

SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'sale_kind' AS "~SP0:sale_kind:custom_platform_info:1", data ->> 'customer_type' AS "~SP0:customer_type:custom_platform_info:1", data ->> 'order_id' AS "~SP0:order_id:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_23 scratch ON scratch.object_id = main.id;

Date: 2024-10-23 10:00:32
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.114.62

x Hide

SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'first_user_manual_ad_content' AS "~GA4-S6:first_user_manual_ad_content:custom_platform_info:1", data ->> 'first_user_manual_term' AS "~GA4-S6:first_user_manual_term:custom_platform_info:1", data ->> 'first_user_source_medium' AS "~GA4-S6:first_user_source_medium:custom_platform_info:1", data ->> 'first_user_default_channel_group' AS "~GA4-S6:first_user_default_channel_group:custom_platform_info:1", data ->> 'first_user_campaign_name' AS "~GA4-S6:first_user_campaign_name:custom_platform_info:1", data ->> 'transaction_id' AS "~GA4-S6:transaction_id:custom_platform_info:1", data ->> 'page_path' AS "~GA4-S6:page_path:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_13 scratch ON scratch.object_id = main.id;

Date: 2024-10-23 10:14:43
Duration: 15m32s
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.98.29

SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'first_user_manual_ad_content' AS "~GA4-S6:first_user_manual_ad_content:custom_platform_info:1", data ->> 'first_user_manual_term' AS "~GA4-S6:first_user_manual_term:custom_platform_info:1", data ->> 'first_user_source_medium' AS "~GA4-S6:first_user_source_medium:custom_platform_info:1", data ->> 'first_user_default_channel_group' AS "~GA4-S6:first_user_default_channel_group:custom_platform_info:1", data ->> 'first_user_campaign_name' AS "~GA4-S6:first_user_campaign_name:custom_platform_info:1", data ->> 'transaction_id' AS "~GA4-S6:transaction_id:custom_platform_info:1", data ->> 'page_path' AS "~GA4-S6:page_path:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_13 scratch ON scratch.object_id = main.id;

Date: 2024-10-23 10:14:43
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.98.29

x Hide

SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'total_revenue' AS "~GA4-S3:total_revenue:custom_platform_stats:1", data ->> 'sessions' AS "~GA4-S3:sessions:custom_platform_stats:1", data ->> 'transactions' AS "~GA4-S3:transactions:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_44 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-06-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-23', 'YYYY-MM-DD');

Date: 2024-10-23 10:20:23
Duration: 10m55s
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.101.99

SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'total_revenue' AS "~GA4-S3:total_revenue:custom_platform_stats:1", data ->> 'sessions' AS "~GA4-S3:sessions:custom_platform_stats:1", data ->> 'transactions' AS "~GA4-S3:transactions:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_44 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-06-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-23', 'YYYY-MM-DD');

Date: 2024-10-23 10:20:23
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.101.99

x Hide

SELECT cpgn_stats.date AS date, portfolio.id AS portfolio_id, REPLACE(portfolio.name, '|', '') AS portfolio_name, portfolio.archive_date AS portfolio_archive_date, portfolio.created AS portfolio_created_date, portfolio.active_date AS portfolio_active_date, REPLACE(clients_account.name, '|', '') AS account_name, platforms_platform.name AS platform_name, CONCAT(platforms_platform.name, '__', REPLACE(portfolio.name, '|', '')) AS platform_portfolio, platforms_platform.id AS tracer_platform_id, SUM(cpgn_stats.spend_micro/1000000) AS obj_spend, SUM((cpgn_stats.spend_micro/1000000)/CAST(CASE WHEN fx.value IS NULL THEN 1.0 ELSE fx.value/1000000.0 END AS FLOAT)) AS obj_spend_dollars, SUM(CAST(cpgn_stats.data::json->>'impressions' AS FLOAT)) AS obj_impressions, SUM(CAST( cpgn_stats.data::json->>'clicks' AS FLOAT )) AS obj_link_clicks, SUM(CAST( cpgn_stats.data::json->>'video_views' AS FLOAT )) AS obj_video_views, SUM(CAST( cpgn_stats.data::json->>'total_video_quartile_p_100_views' AS FLOAT )) AS obj_video_view_p100, CASE WHEN data_info.data::json->>'advertising_channel_type' IS NULL THEN CAST(data_info.data::json->>'advertising_channel' AS TEXT) ELSE CAST(data_info.data::json->>'advertising_channel_type' AS TEXT) END AS channel, CASE WHEN data_info.data::json->>'bidding_strategy_type' IS NULL THEN CAST(data_info.data::json->>'bid_strategy_type' AS TEXT) ELSE CAST(data_info.data::json->>'bidding_strategy_type' AS TEXT) END AS objective, clients_campaign.currency AS obj_currency_id, clients_campaign.id AS cpgn_id FROM api_data_go_campaign_stats AS cpgn_stats LEFT JOIN clients_campaign ON clients_campaign.id = cpgn_stats.campaign_id LEFT JOIN platforms_platform ON platforms_platform.id = clients_campaign.platform_id LEFT JOIN clients_account ON clients_campaign.account_id = clients_account.id LEFT JOIN vayner_portfolio AS portfolio ON portfolio.id = clients_account.portfolio_id LEFT JOIN api_data_go_platformobject AS object_id ON object_id.db_id_foreign = clients_campaign.db_id_foreign LEFT JOIN api_data_go_info AS data_info ON data_info.platform_object_id = object_id.id LEFT JOIN vayner_exchangerate AS fx ON cpgn_stats.date = fx.date AND clients_campaign.currency = fx.currency WHERE cpgn_stats.date > '2024-09-22' AND cpgn_stats.date <= '2024-10-22' GROUP BY cpgn_stats.date, platform_name, platform_portfolio, portfolio.id, portfolio_name, portfolio_archive_date, portfolio_created_date, portfolio_active_date, account_name, tracer_platform_id, channel, objective, obj_currency_id, cpgn_id UNION ALL SELECT cpgn_stats.date AS date, portfolio.id AS portfolio_id, REPLACE(portfolio.name, '|', '') AS portfolio_name, portfolio.archive_date AS portfolio_archive_date, portfolio.created AS portfolio_created_date, portfolio.active_date AS portfolio_active_date, REPLACE(clients_account.name, '|', '') AS account_name, platforms_platform.name AS platform_name, CONCAT(platforms_platform.name, '__', REPLACE(portfolio.name, '|', '')) AS platform_portfolio, platforms_platform.id AS tracer_platform_id, SUM(cpgn_stats.spend_micro/1000000) AS obj_spend, SUM((cpgn_stats.spend_micro/1000000)/CAST(CASE WHEN fx.value IS NULL THEN 1.0 ELSE fx.value/1000000.0 END AS FLOAT)) AS obj_spend_dollars, SUM(CAST(cpgn_stats.data::json->>'impressions' AS FLOAT)) AS obj_impressions, SUM(CAST( cpgn_stats.data::json->>'clicks' AS FLOAT )) AS obj_link_clicks, SUM(CAST( cpgn_stats.data::json->>'video_watched_2_s' AS FLOAT )) AS obj_video_views, SUM(CAST( cpgn_stats.data::json->>'video_views_p_100' AS FLOAT )) AS obj_video_view_p100, CAST(data_info.data::json->>'advertising_channel_type' AS TEXT) AS channel, CAST(data_info.data::json->>'objective_type' AS TEXT) AS objective, clients_campaign.currency AS obj_currency_id, clients_campaign.id AS cpgn_id FROM api_data_tt_campaign_stats AS cpgn_stats LEFT JOIN clients_campaign ON clients_campaign.id = cpgn_stats.campaign_id LEFT JOIN platforms_platform ON platforms_platform.id = clients_campaign.platform_id LEFT JOIN clients_account ON clients_campaign.account_id = clients_account.id LEFT JOIN vayner_portfolio AS portfolio ON portfolio.id = clients_account.portfolio_id LEFT JOIN api_data_tt_platformobject AS object_id ON object_id.db_id_foreign = clients_campaign.db_id_foreign LEFT JOIN api_data_tt_info AS data_info ON data_info.platform_object_id = object_id.id LEFT JOIN vayner_exchangerate AS fx ON cpgn_stats.date = fx.date AND clients_campaign.currency = fx.currency WHERE cpgn_stats.date > '2024-09-22' AND cpgn_stats.date <= '2024-10-22' GROUP BY cpgn_stats.date, platform_name, platform_portfolio, portfolio.id, portfolio_name, portfolio_archive_date, portfolio_created_date, portfolio_active_date, account_name, tracer_platform_id, channel, objective, obj_currency_id, cpgn_id UNION ALL SELECT cpgn_stats.date AS date, portfolio.id AS portfolio_id, REPLACE(portfolio.name, '|', '') AS portfolio_name, portfolio.archive_date AS portfolio_archive_date, portfolio.created AS portfolio_created_date, portfolio.active_date AS portfolio_active_date, REPLACE(clients_account.name, '|', '') AS account_name, platforms_platform.name AS platform_name, CONCAT(platforms_platform.name, '__', REPLACE(portfolio.name, '|', '')) AS platform_portfolio, platforms_platform.id AS tracer_platform_id, SUM(cpgn_stats.spend_micro/1000000) AS obj_spend, SUM((cpgn_stats.spend_micro/1000000)/CAST(CASE WHEN fx.value IS NULL THEN 1.0 ELSE fx.value/1000000.0 END AS FLOAT)) AS obj_spend_dollars, SUM(CAST(cpgn_stats.data::json->>'impressions' AS FLOAT)) AS obj_impressions, SUM(CAST( cpgn_stats.data::json->>'OUTBOUND_CLICK_1' AS FLOAT )) AS obj_link_clicks, SUM(CAST( cpgn_stats.data::json->>'VIDEO_3SEC_VIEWS_1' AS FLOAT )) AS obj_video_views, SUM(CAST( cpgn_stats.data::json->>'VIDEO_P100_COMPLETE_1' AS FLOAT )) AS obj_video_view_p100, NULL AS channel, CAST(data_info.data::json->>'objective_type' AS TEXT) AS objective, clients_campaign.currency AS obj_currency_id, clients_campaign.id AS cpgn_id FROM api_data_pi_campaign_stats AS cpgn_stats LEFT JOIN clients_campaign ON clients_campaign.id = cpgn_stats.campaign_id LEFT JOIN platforms_platform ON platforms_platform.id = clients_campaign.platform_id LEFT JOIN clients_account ON clients_campaign.account_id = clients_account.id LEFT JOIN vayner_portfolio AS portfolio ON portfolio.id = clients_account.portfolio_id LEFT JOIN api_data_pi_platformobject AS object_id ON object_id.db_id_foreign = clients_campaign.db_id_foreign LEFT JOIN api_data_pi_info AS data_info ON data_info.platform_object_id = object_id.id LEFT JOIN vayner_exchangerate AS fx ON cpgn_stats.date = fx.date AND clients_campaign.currency = fx.currency WHERE cpgn_stats.date > '2024-09-22' AND cpgn_stats.date <= '2024-10-22' GROUP BY cpgn_stats.date, platform_name, platform_portfolio, portfolio.id, portfolio_name, portfolio_archive_date, portfolio_created_date, portfolio_active_date, account_name, tracer_platform_id, channel, objective, obj_currency_id, cpgn_id UNION ALL SELECT cpgn_stats.date AS date, portfolio.id AS portfolio_id, REPLACE(portfolio.name, '|', '') AS portfolio_name, portfolio.archive_date AS portfolio_archive_date, portfolio.created AS portfolio_created_date, portfolio.active_date AS portfolio_active_date, REPLACE(clients_account.name, '|', '') AS account_name, platforms_platform.name AS platform_name, CONCAT(platforms_platform.name, '__', REPLACE(portfolio.name, '|', '')) AS platform_portfolio, platforms_platform.id AS tracer_platform_id, SUM(cpgn_stats.spend_micro/1000000) AS obj_spend, SUM((cpgn_stats.spend_micro/1000000)/CAST(CASE WHEN fx.value IS NULL THEN 1.0 ELSE fx.value/1000000.0 END AS FLOAT)) AS obj_spend_dollars, SUM(CAST(cpgn_stats.data::json->>'impressions' AS FLOAT)) AS obj_impressions, SUM(CAST( cpgn_stats.data::json->>'landing_page_clicks' AS FLOAT )) AS obj_link_clicks, SUM(CAST( cpgn_stats.data::json->>'video_views' AS FLOAT )) AS obj_video_views, SUM(CAST( cpgn_stats.data::json->>'video_completions' AS FLOAT )) AS obj_video_view_p100, NULL AS channel, CAST(data_info.data::json->>'objective_type' AS TEXT) AS objective, clients_campaign.currency AS obj_currency_id, clients_campaign.id AS cpgn_id FROM api_data_li_campaign_stats AS cpgn_stats LEFT JOIN clients_campaign ON clients_campaign.id = cpgn_stats.campaign_id LEFT JOIN platforms_platform ON platforms_platform.id = clients_campaign.platform_id LEFT JOIN clients_account ON clients_campaign.account_id = clients_account.id LEFT JOIN vayner_portfolio AS portfolio ON portfolio.id = clients_account.portfolio_id LEFT JOIN api_data_li_platformobject AS object_id ON object_id.db_id_foreign = clients_campaign.db_id_foreign LEFT JOIN api_data_li_info AS data_info ON data_info.platform_object_id = object_id.id LEFT JOIN vayner_exchangerate AS fx ON cpgn_stats.date = fx.date AND clients_campaign.currency = fx.currency WHERE cpgn_stats.date > '2024-09-22' AND cpgn_stats.date <= '2024-10-22' GROUP BY cpgn_stats.date, platform_name, platform_portfolio, portfolio.id, portfolio_name, portfolio_archive_date, portfolio_created_date, portfolio_active_date, account_name, tracer_platform_id, channel, objective, obj_currency_id, cpgn_id UNION ALL SELECT cpgn_stats.date AS date, portfolio.id AS portfolio_id, REPLACE(portfolio.name, '|', '') AS portfolio_name, portfolio.archive_date AS portfolio_archive_date, portfolio.created AS portfolio_created_date, portfolio.active_date AS portfolio_active_date, REPLACE(clients_account.name, '|', '') AS account_name, platforms_platform.name AS platform_name, CONCAT(platforms_platform.name, '__', REPLACE(portfolio.name, '|', '')) AS platform_portfolio, platforms_platform.id AS tracer_platform_id, SUM(cpgn_stats.spend_micro/1000000) AS obj_spend, SUM((cpgn_stats.spend_micro/1000000)/CAST(CASE WHEN fx.value IS NULL THEN 1.0 ELSE fx.value/1000000.0 END AS FLOAT)) AS obj_spend_dollars, SUM(CAST(cpgn_stats.data::json->>'impressions' AS FLOAT)) AS obj_impressions, SUM(CAST( cpgn_stats.data::json->>'swipes' AS FLOAT )) AS obj_link_clicks, SUM(CAST( cpgn_stats.data::json->>'video_views' AS FLOAT )) AS obj_video_views, SUM(CAST( cpgn_stats.data::json->>'view_completion' AS FLOAT )) AS obj_video_view_p100, NULL AS channel, CAST(data_info.data::json->>'objective' AS TEXT) AS objective, clients_campaign.currency AS obj_currency_id, clients_campaign.id AS cpgn_id FROM api_data_sc_campaign_stats AS cpgn_stats LEFT JOIN clients_campaign ON clients_campaign.id = cpgn_stats.campaign_id LEFT JOIN platforms_platform ON platforms_platform.id = clients_campaign.platform_id LEFT JOIN clients_account ON clients_campaign.account_id = clients_account.id LEFT JOIN vayner_portfolio AS portfolio ON portfolio.id = clients_account.portfolio_id LEFT JOIN api_data_sc_platformobject AS object_id ON object_id.db_id_foreign = clients_campaign.db_id_foreign LEFT JOIN api_data_sc_info AS data_info ON data_info.sc_platform_object_id = object_id.id LEFT JOIN vayner_exchangerate AS fx ON cpgn_stats.date = fx.date AND clients_campaign.currency = fx.currency WHERE cpgn_stats.date > '2024-09-22' AND cpgn_stats.date <= '2024-10-22' GROUP BY cpgn_stats.date, platform_name, platform_portfolio, portfolio.id, portfolio_name, portfolio_archive_date, portfolio_created_date, portfolio_active_date, account_name, tracer_platform_id, channel, objective, obj_currency_id, cpgn_id UNION ALL SELECT cpgn_stats.date AS date, portfolio.id AS portfolio_id, REPLACE(portfolio.name, '|', '') AS portfolio_name, portfolio.archive_date AS portfolio_archive_date, portfolio.created AS portfolio_created_date, portfolio.active_date AS portfolio_active_date, REPLACE(clients_account.name, '|', '') AS account_name, platforms_platform.name AS platform_name, CONCAT(platforms_platform.name, '__', REPLACE(portfolio.name, '|', '')) AS platform_portfolio, platforms_platform.id AS tracer_platform_id, SUM(cpgn_stats.spend_micro/1000000) AS obj_spend, SUM((cpgn_stats.spend_micro/1000000)/CAST(CASE WHEN fx.value IS NULL THEN 1.0 ELSE fx.value/1000000.0 END AS FLOAT)) AS obj_spend_dollars, SUM(CAST(cpgn_stats.data::json->>'impressions' AS FLOAT)) AS obj_impressions, SUM(CAST( cpgn_stats.data::json->>'clicks' AS FLOAT )) AS obj_link_clicks, SUM(CAST( cpgn_stats.data::json->>'video_views' AS FLOAT )) AS obj_video_views, SUM(CAST( cpgn_stats.data::json->>'view_completion' AS FLOAT )) AS obj_video_view_p100, CAST(data_info.data::json->>'campaign_type' AS TEXT) AS channel, CASE WHEN CAST(CAST(data_info.data::json->>'bidding_scheme' AS JSON)::json->>'type' AS TEXT) IS NULL THEN 'ManualCpc' ELSE CAST(CAST(data_info.data::json->>'bidding_scheme' AS JSON)::json->>'type' AS TEXT) END AS objective, clients_campaign.currency AS obj_currency_id, clients_campaign.id AS cpgn_id FROM api_data_bn_campaign_stats AS cpgn_stats LEFT JOIN clients_campaign ON clients_campaign.id = cpgn_stats.campaign_id LEFT JOIN platforms_platform ON platforms_platform.id = clients_campaign.platform_id LEFT JOIN clients_account ON clients_campaign.account_id = clients_account.id LEFT JOIN vayner_portfolio AS portfolio ON portfolio.id = clients_account.portfolio_id LEFT JOIN api_data_bn_platformobject AS object_id ON object_id.db_id_foreign = clients_campaign.db_id_foreign LEFT JOIN api_data_bn_info AS data_info ON data_info.platform_object_id = object_id.id LEFT JOIN vayner_exchangerate AS fx ON cpgn_stats.date = fx.date AND clients_campaign.currency = fx.currency WHERE cpgn_stats.date > '2024-09-22' AND cpgn_stats.date <= '2024-10-22' GROUP BY cpgn_stats.date, platform_name, platform_portfolio, portfolio.id, portfolio_name, portfolio_archive_date, portfolio_created_date, portfolio_active_date, account_name, tracer_platform_id, channel, objective, obj_currency_id, cpgn_id UNION ALL SELECT cpgn_stats.date AS date, portfolio.id AS portfolio_id, REPLACE(portfolio.name, '|', '') AS portfolio_name, portfolio.archive_date AS portfolio_archive_date, portfolio.created AS portfolio_created_date, portfolio.active_date AS portfolio_active_date, REPLACE(clients_account.name, '|', '') AS account_name, platforms_platform.name AS platform_name, CONCAT(platforms_platform.name, '__', REPLACE(portfolio.name, '|', '')) AS platform_portfolio, platforms_platform.id AS tracer_platform_id, SUM(cpgn_stats.spend_micro/1000000) AS obj_spend, SUM((cpgn_stats.spend_micro/1000000)/CAST(CASE WHEN fx.value IS NULL THEN 1.0 ELSE fx.value/1000000.0 END AS FLOAT)) AS obj_spend_dollars, SUM(CAST(cpgn_stats.data::json->>'impressions' AS FLOAT)) AS obj_impressions, SUM(CAST( cpgn_stats.data::json->>'clicks' AS FLOAT )) AS obj_link_clicks, SUM(CAST( cpgn_stats.data::json->>'starts_(video)' AS FLOAT )) AS obj_video_views, SUM(CAST( cpgn_stats.data::json->>'complete_views_(video)' AS FLOAT )) AS obj_video_view_p100, NULL AS channel, CAST(data_info.data::json->>'performance_goal_type' AS TEXT) AS objective, clients_campaign.currency AS obj_currency_id, clients_campaign.id AS cpgn_id FROM api_data_dbm_campaign_stats AS cpgn_stats LEFT JOIN clients_campaign ON clients_campaign.id = cpgn_stats.campaign_id LEFT JOIN platforms_platform ON platforms_platform.id = clients_campaign.platform_id LEFT JOIN clients_account ON clients_campaign.account_id = clients_account.id LEFT JOIN vayner_portfolio AS portfolio ON portfolio.id = clients_account.portfolio_id LEFT JOIN api_data_dbm_platformobject AS object_id ON object_id.db_id_foreign = clients_campaign.db_id_foreign LEFT JOIN api_data_dbm_info AS data_info ON data_info.platform_object_id = object_id.id LEFT JOIN vayner_exchangerate AS fx ON cpgn_stats.date = fx.date AND clients_campaign.currency = fx.currency WHERE cpgn_stats.date > '2024-09-22' AND cpgn_stats.date <= '2024-10-22' GROUP BY cpgn_stats.date, platform_name, platform_portfolio, portfolio.id, portfolio_name, portfolio_archive_date, portfolio_created_date, portfolio_active_date, account_name, tracer_platform_id, channel, objective, obj_currency_id, cpgn_id UNION ALL SELECT cpgn_stats.date AS date, portfolio.id AS portfolio_id, REPLACE(portfolio.name, '|', '') AS portfolio_name, portfolio.archive_date AS portfolio_archive_date, portfolio.created AS portfolio_created_date, portfolio.active_date AS portfolio_active_date, REPLACE(clients_account.name, '|', '') AS account_name, platforms_platform.name AS platform_name, CONCAT(platforms_platform.name, '__', REPLACE(portfolio.name, '|', '')) AS platform_portfolio, platforms_platform.id AS tracer_platform_id, SUM(cpgn_stats.spend_micro/1000000) AS obj_spend, SUM((cpgn_stats.spend_micro/1000000)/CAST(CASE WHEN fx.value IS NULL THEN 1.0 ELSE fx.value/1000000.0 END AS FLOAT)) AS obj_spend_dollars, SUM(CAST(cpgn_stats.data::json->>'impressions' AS FLOAT)) AS obj_impressions, SUM(CAST( cpgn_stats.data::json->>'clicks' AS FLOAT )) AS obj_link_clicks, SUM(CAST( cpgn_stats.data::json->>'video_views' AS FLOAT )) AS obj_video_views, SUM(CAST( cpgn_stats.data::json->>'view_completion' AS FLOAT )) AS obj_video_view_p100, NULL AS channel, CASE WHEN CAST(data_info.data::json ->> 'bidding_strategy' AS TEXT) IS NULL THEN 'ruleBased' ELSE CAST(data_info.data::json ->> 'bidding_strategy' AS TEXT) END AS objective, clients_campaign.currency AS obj_currency_id, clients_campaign.id AS cpgn_id FROM api_data_am_campaign_stats AS cpgn_stats LEFT JOIN clients_campaign ON clients_campaign.id = cpgn_stats.campaign_id LEFT JOIN platforms_platform ON platforms_platform.id = clients_campaign.platform_id LEFT JOIN clients_account ON clients_campaign.account_id = clients_account.id LEFT JOIN vayner_portfolio AS portfolio ON portfolio.id = clients_account.portfolio_id LEFT JOIN api_data_am_platformobject AS object_id ON object_id.db_id_foreign = clients_campaign.db_id_foreign LEFT JOIN api_data_am_info AS data_info ON data_info.platform_object_id = object_id.id LEFT JOIN vayner_exchangerate AS fx ON cpgn_stats.date = fx.date AND clients_campaign.currency = fx.currency WHERE cpgn_stats.date > '2024-09-22' AND cpgn_stats.date <= '2024-10-22' GROUP BY cpgn_stats.date, platform_name, platform_portfolio, portfolio.id, portfolio_name, portfolio_archive_date, portfolio_created_date, portfolio_active_date, account_name, tracer_platform_id, channel, objective, obj_currency_id, cpgn_id UNION ALL SELECT cpgn_stats.date AS date, portfolio.id AS portfolio_id, REPLACE(portfolio.name, '|', '') AS portfolio_name, portfolio.archive_date AS portfolio_archive_date, portfolio.created AS portfolio_created_date, portfolio.active_date AS portfolio_active_date, REPLACE(clients_account.name, '|', '') AS account_name, platforms_platform.name AS platform_name, CONCAT(platforms_platform.name, '__', REPLACE(portfolio.name, '|', '')) AS platform_portfolio, platforms_platform.id AS tracer_platform_id, SUM(cpgn_stats.spend_micro/1000000) AS obj_spend, SUM((cpgn_stats.spend_micro/1000000)/CAST(CASE WHEN fx.value IS NULL THEN 1.0 ELSE fx.value/1000000.0 END AS FLOAT)) AS obj_spend_dollars, SUM(CAST(cpgn_stats.data::json->>'impressions' AS FLOAT)) AS obj_impressions, SUM(CAST( cpgn_stats.data::json->>'click_throughs' AS FLOAT )) AS obj_link_clicks, SUM(CAST( cpgn_stats.data::json->>'video_start' AS FLOAT )) AS obj_video_views, SUM(CAST( cpgn_stats.data::json->>'view_complete' AS FLOAT )) AS obj_video_view_p100, NULL AS channel, CAST(CAST(data_info.data::json->>'optimization' AS JSON)::json->>'goal' AS TEXT) AS objective, clients_campaign.currency AS obj_currency_id, clients_campaign.id AS cpgn_id FROM api_data_amd_campaign_stats AS cpgn_stats LEFT JOIN clients_campaign ON clients_campaign.id = cpgn_stats.campaign_id LEFT JOIN platforms_platform ON platforms_platform.id = clients_campaign.platform_id LEFT JOIN clients_account ON clients_campaign.account_id = clients_account.id LEFT JOIN vayner_portfolio AS portfolio ON portfolio.id = clients_account.portfolio_id LEFT JOIN api_data_amd_platformobject AS object_id ON object_id.db_id_foreign = clients_campaign.db_id_foreign LEFT JOIN api_data_amd_info AS data_info ON data_info.platform_object_id = object_id.id LEFT JOIN vayner_exchangerate AS fx ON cpgn_stats.date = fx.date AND clients_campaign.currency = fx.currency WHERE cpgn_stats.date > '2024-09-22' AND cpgn_stats.date <= '2024-10-22' GROUP BY cpgn_stats.date, platform_name, platform_portfolio, portfolio.id, portfolio_name, portfolio_archive_date, portfolio_created_date, portfolio_active_date, account_name, tracer_platform_id, channel, objective, obj_currency_id, cpgn_id UNION ALL SELECT line_stats.date AS date, portfolio.id AS portfolio_id, REPLACE(portfolio.name, '|', '') AS portfolio_name, portfolio.archive_date AS portfolio_archive_date, portfolio.created AS portfolio_created_date, portfolio.active_date AS portfolio_active_date, REPLACE(account.name, '|', '') AS account_name, platform.name AS platform_name, CONCAT(platform.name, '__', REPLACE(portfolio.name, '|', '')) AS platform_portfolio, platform.id AS tracer_platform_id, SUM(line_stats.spend) AS obj_spend, SUM(line_stats.spend / CAST(CASE WHEN fx.value IS NULL THEN 1.0 ELSE fx.value/1000000.0 END AS FLOAT)) AS obj_spend_dollars, SUM(line_stats.Impressions) AS obj_impressions, SUM(line_stats.link_clicks) AS obj_link_clicks, SUM(line_stats.video_views) AS obj_video_views, SUM(line_stats.video_view_p100) AS obj_video_view_p100, NULL AS channel, CAST(data_info.data::json->>'objective' AS TEXT) AS objective, camp_info.currency AS obj_currency_id, camp_info.id AS cpgn_id FROM (SELECT tweet_stats.date AS date, SUM(tweet_stats.spend_micro/1000000) AS spend, SUM(CAST(tweet_stats.data::json->>'impressions' AS FLOAT)) AS Impressions, SUM(CAST(tweet_stats.data::json->>'url_clicks' AS FLOAT)) AS link_clicks, SUM(CAST(tweet_stats.data::json->>'video_total_views' AS FLOAT)) AS video_views, SUM(CAST(tweet_stats.data::json->>'video_views_100' AS FLOAT)) AS video_view_p100, line_object_id.id AS line_id, tweet_stats.campaign_id AS campaign_id FROM api_data_tw_stats AS tweet_stats LEFT JOIN api_data_tw_platformobject AS object_id ON tweet_stats.platform_object_id = object_id.id LEFT JOIN api_data_tw_map AS tweet_map ON tweet_map.level_1_id = object_id.id LEFT JOIN api_data_tw_platformobject AS line_object_id ON tweet_map.level_2_id = line_object_id.id GROUP BY line_id, date, campaign_id) AS line_stats LEFT JOIN api_data_tw_info AS data_info ON data_info.platform_object_id = line_stats.line_id LEFT JOIN clients_campaign AS camp_info ON camp_info.id = line_stats.campaign_id LEFT JOIN clients_account AS account ON account.id = camp_info.account_id LEFT JOIN platforms_platform AS platform ON platform.id = camp_info.platform_id LEFT JOIN vayner_portfolio AS portfolio ON portfolio.id = account.portfolio_id LEFT JOIN vayner_exchangerate AS fx ON line_stats.date = fx.date AND camp_info.currency = fx.currency WHERE line_stats.date > '2024-09-22' AND line_stats.date <= '2024-10-22' GROUP BY line_stats.date, platform_name, platform_portfolio, portfolio.id, portfolio_name, portfolio_archive_date, portfolio_created_date, portfolio_active_date, account_name, tracer_platform_id, channel, objective, obj_currency_id, cpgn_id UNION ALL SELECT cpgn_stats.date AS date, portfolio.id AS portfolio_id, REPLACE(portfolio.name, '|', '') AS portfolio_name, portfolio.archive_date AS portfolio_archive_date, portfolio.created AS portfolio_created_date, portfolio.active_date AS portfolio_active_date, REPLACE(clients_account.name, '|', '') AS account_name, platforms_platform.name AS platform_name, CONCAT(platforms_platform.name, '__', REPLACE(portfolio.name, '|', '')) AS platform_portfolio, platforms_platform.id AS tracer_platform_id, SUM(cpgn_stats.spend_micro/1000000) AS obj_spend, SUM((cpgn_stats.spend_micro/1000000)/CAST(CASE WHEN fx.value IS NULL THEN 1.0 ELSE fx.value/1000000.0 END AS FLOAT)) AS obj_spend_dollars, SUM(CAST(cpgn_stats.data::json->>'impressions' AS FLOAT)) AS obj_impressions, SUM(CAST(cpgn_stats.data::json->>'link_click' AS FLOAT)) AS obj_link_clicks, SUM(CAST(cpgn_stats.data::json->>'video_view' AS FLOAT)) AS obj_video_views, SUM(CAST(cpgn_stats.data::json->>'video_view_p100' AS FLOAT)) AS obj_video_view_p100, REPLACe(breakdown_bucket.name, '|', '') AS channel, CAST(data_info.data::json->>'objective' AS TEXT) AS objective, clients_campaign.currency AS obj_currency_id, clients_campaign.id AS cpgn_id FROM api_data_fb_campaign_stats_platformbreakdown_placement AS cpgn_stats LEFT JOIN platforms_platformbreakdownbucket AS breakdown_bucket ON breakdown_bucket.id = cpgn_stats.platform_breakdown_bucket_id LEFT JOIN clients_campaign ON clients_campaign.id = cpgn_stats.campaign_id LEFT JOIN platforms_platform ON platforms_platform.id = clients_campaign.platform_id LEFT JOIN clients_account ON clients_campaign.account_id = clients_account.id LEFT JOIN vayner_portfolio AS portfolio ON portfolio.id = clients_account.portfolio_id LEFT JOIN api_data_platformobject AS object_id ON object_id.db_id_foreign = clients_campaign.db_id_foreign LEFT JOIN api_data_info AS data_info ON data_info.platform_object_id = object_id.id LEFT JOIN vayner_exchangerate AS fx ON cpgn_stats.date = fx.date AND clients_campaign.currency = fx.currency WHERE cpgn_stats.date > '2024-09-22' AND cpgn_stats.date <= '2024-10-22' GROUP BY cpgn_stats.date, platform_name, platform_portfolio, portfolio.id, portfolio_name, portfolio_archive_date, portfolio_created_date, portfolio_active_date, account_name, tracer_platform_id, channel, objective, obj_currency_id, cpgn_id UNION ALL SELECT cp_stats.date AS date, portfolio.id AS portfolio_id, REPLACE(portfolio.name, '|', '') AS portfolio_name, portfolio.archive_date AS portfolio_archive_date, portfolio.created AS portfolio_created_date, portfolio.active_date AS portfolio_active_date, 'custom_platform' AS account_name, platform.name AS platform_name, CONCAT(platform.name, '__', REPLACE(portfolio.name, '|', '')) AS platform_portfolio, platform.id AS tracer_platform_id, SUM(CAST(cp_stats.spend_micro AS FLOAT)/1000000.0) AS obj_spend, SUM((cp_stats.spend_micro/1000000)/CAST(CASE WHEN fx.value IS NULL THEN 1.0 ELSE fx.value/1000000.0 END AS FLOAT)) AS obj_spend_dollars, SUM(CAST(cp_stats.data::json->>'impressions' AS FLOAT)) AS obj_impressions, SUM(CAST(cp_stats.data::json->>'clicks' AS FLOAT)) AS obj_link_clicks, SUM(CAST(cp_stats.data::json->>'video_views' AS FLOAT)) AS obj_video_views, SUM(CAST(cp_stats.data::json->>'video_completions' AS FLOAT)) AS obj_video_view_p100, NULL AS channel, 'custom_platform' AS objective, cp_info.currency AS currency_id, cp_info.id AS cpgn_id FROM api_data_customplatformstats AS cp_stats LEFT JOIN api_data_customplatforminfo AS cp_info ON cp_stats.custom_platform_info_id = cp_info.id LEFT JOIN platforms_platform AS platform ON platform.id = cp_info.platform_id LEFT JOIN vayner_portfolio AS portfolio ON portfolio.id = cp_info.portfolio_id LEFT JOIN vayner_exchangerate AS fx ON cp_stats.date = fx.date AND cp_info.currency = fx.currency WHERE cp_stats.date > '2024-09-22' AND cp_stats.date <= '2024-10-22' AND cp_stats.spend_micro > 0 GROUP BY cp_stats.date, portfolio.id, portfolio_name, portfolio_archive_date, portfolio_created_date, portfolio_active_date, tracer_platform_id, platform.name, channel, objective, currency_id, cpgn_id ;

Date: 2024-10-23 10:28:47
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.118.81

x Hide

SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'first_user_manual_term' AS "~GA4-S6:first_user_manual_term:custom_platform_info:1", data ->> 'first_user_manual_ad_content' AS "~GA4-S6:first_user_manual_ad_content:custom_platform_info:1", data ->> 'first_user_default_channel_group' AS "~GA4-S6:first_user_default_channel_group:custom_platform_info:1", data ->> 'first_user_campaign_name' AS "~GA4-S6:first_user_campaign_name:custom_platform_info:1", data ->> 'first_user_source_medium' AS "~GA4-S6:first_user_source_medium:custom_platform_info:1", data ->> 'page_path' AS "~GA4-S6:page_path:custom_platform_info:1", data ->> 'transaction_id' AS "~GA4-S6:transaction_id:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_24 scratch ON scratch.object_id = main.id;

Date: 2024-10-23 08:07:21
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.46.1

x Hide

SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'first_user_campaign_name' AS "~GA4-S6:first_user_campaign_name:custom_platform_info:1", data ->> 'first_user_manual_ad_content' AS "~GA4-S6:first_user_manual_ad_content:custom_platform_info:1", data ->> 'first_user_manual_term' AS "~GA4-S6:first_user_manual_term:custom_platform_info:1", data ->> 'first_user_source_medium' AS "~GA4-S6:first_user_source_medium:custom_platform_info:1", data ->> 'first_user_default_channel_group' AS "~GA4-S6:first_user_default_channel_group:custom_platform_info:1", data ->> 'page_path' AS "~GA4-S6:page_path:custom_platform_info:1", data ->> 'transaction_id' AS "~GA4-S6:transaction_id:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_46 scratch ON scratch.object_id = main.id;

Date: 2024-10-23 09:02:19
Duration: 23m20s
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.96.255

SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'first_user_campaign_name' AS "~GA4-S6:first_user_campaign_name:custom_platform_info:1", data ->> 'first_user_manual_ad_content' AS "~GA4-S6:first_user_manual_ad_content:custom_platform_info:1", data ->> 'first_user_manual_term' AS "~GA4-S6:first_user_manual_term:custom_platform_info:1", data ->> 'first_user_source_medium' AS "~GA4-S6:first_user_source_medium:custom_platform_info:1", data ->> 'first_user_default_channel_group' AS "~GA4-S6:first_user_default_channel_group:custom_platform_info:1", data ->> 'page_path' AS "~GA4-S6:page_path:custom_platform_info:1", data ->> 'transaction_id' AS "~GA4-S6:transaction_id:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_46 scratch ON scratch.object_id = main.id;

Date: 2024-10-23 09:02:19
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.96.255

x Hide

INSERT INTO api_data_go_stats AS orig ("date","spend_micro","campaign_id","platform_object_id","data","created","updated") VALUES ('2024-09-27',0,1530822,8273143,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-09-29',2190000,1530822,8273143,'{"cost_micros": 2190000, "impressions": 1, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 1.0, "all_conversions_value": 300.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 2.19}','NOW()','NOW()'), ('2024-10-01',0,1530822,8273143,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-03',0,1530822,8273143,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-06',0,1530822,8273143,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-11',0,1530822,8273143,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-13',0,1530822,8273143,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-05',3490000,1530822,8273144,'{"cost_micros": 3490000, "impressions": 1, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 1.0, "all_conversions_value": 300.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 3.49}','NOW()','NOW()'), ('2024-10-09',0,1530822,8273144,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-09-24',0,1530822,8273145,'{"cost_micros": 0, "impressions": 2, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-09-26',4320000,1530822,8273145,'{"cost_micros": 4320000, "impressions": 4, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 2.0, "all_conversions_value": 300.742905755, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 4.32}','NOW()','NOW()'), ('2024-09-27',0,1530822,8273145,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-09-28',0,1530822,8273145,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-01',470000,1530822,8273145,'{"cost_micros": 470000, "impressions": 2, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.47}','NOW()','NOW()'), ('2024-10-03',0,1530822,8273145,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-06',0,1530822,8273145,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-10',5620000,1530822,8273145,'{"cost_micros": 5620000, "impressions": 2, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 5.62}','NOW()','NOW()'), ('2024-10-12',2340000,1530822,8273145,'{"cost_micros": 2340000, "impressions": 1, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 2.34}','NOW()','NOW()'), ('2024-10-13',0,1530822,8273145,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-18',10000,1530822,8273145,'{"cost_micros": 10000, "impressions": 1, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.01}','NOW()','NOW()'), ('2024-10-21',0,1530822,8273145,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-22',2850000,1530822,8273145,'{"cost_micros": 2850000, "impressions": 2, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 2.85}','NOW()','NOW()'), ('2024-09-23',0,1530822,8273146,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-09-24',6170000,1530822,8273146,'{"cost_micros": 6169100, "impressions": 3, "clicks": 3, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 1.0, "all_conversions_value": 300.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 3, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 6.17}','NOW()','NOW()'), ('2024-09-25',8680000,1530822,8273146,'{"cost_micros": 8680000, "impressions": 11, "clicks": 4, "video_views": 0, "engagements": 0, "conversions": 0.5, "conversions_value": 62.5, "all_conversions": 1.5, "all_conversions_value": 362.5, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 4, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 8.68}','NOW()','NOW()'), ('2024-09-26',120000,1530822,8273146,'{"cost_micros": 115513, "impressions": 9, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.12}','NOW()','NOW()'), ('2024-09-27',2330000,1530822,8273146,'{"cost_micros": 2330000, "impressions": 7, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 1.0, "all_conversions_value": 300.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 2.33}','NOW()','NOW()'), ('2024-09-28',14000000,1530822,8273146,'{"cost_micros": 14000000, "impressions": 3, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 1.0, "all_conversions_value": 300.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 14.0}','NOW()','NOW()'), ('2024-09-29',11450000,1530822,8273146,'{"cost_micros": 11450000, "impressions": 9, "clicks": 3, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 3, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 11.45}','NOW()','NOW()'), ('2024-09-30',8810000,1530822,8273146,'{"cost_micros": 8811252, "impressions": 4, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 3.0, "all_conversions_value": 725.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 8.81}','NOW()','NOW()'), ('2024-10-01',20250000,1530822,8273146,'{"cost_micros": 20250000, "impressions": 11, "clicks": 3, "video_views": 0, "engagements": 0, "conversions": 0.962359, "conversions_value": 120.294875, "all_conversions": 3.962359, "all_conversions_value": 321.775540989, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 3, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 20.25}','NOW()','NOW()'), ('2024-10-02',13520000,1530822,8273146,'{"cost_micros": 13520000, "impressions": 8, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 5.052751, "conversions_value": 631.593875, "all_conversions": 5.052751, "all_conversions_value": 631.593875, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 13.52}','NOW()','NOW()'), ('2024-10-03',11220000,1530822,8273146,'{"cost_micros": 11220000, "impressions": 14, "clicks": 4, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 2.0, "all_conversions_value": 600.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 4, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 11.22}','NOW()','NOW()'), ('2024-10-04',2029999,1530822,8273146,'{"cost_micros": 2030000, "impressions": 4, "clicks": 3, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 6.0, "all_conversions_value": 128.692674384, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 3, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 2.03}','NOW()','NOW()'), ('2024-10-05',6310000,1530822,8273146,'{"cost_micros": 6310000, "impressions": 2, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 6.31}','NOW()','NOW()'), ('2024-10-06',7630000,1530822,8273146,'{"cost_micros": 7630000, "impressions": 3, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 7.63}','NOW()','NOW()'), ('2024-10-07',1550000,1530822,8273146,'{"cost_micros": 1550000, "impressions": 3, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 1.55}','NOW()','NOW()'), ('2024-10-08',5450000,1530822,8273146,'{"cost_micros": 5450000, "impressions": 8, "clicks": 4, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 1.0, "all_conversions_value": 300.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 4, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 5.45}','NOW()','NOW()'), ('2024-10-09',420000,1530822,8273146,'{"cost_micros": 420000, "impressions": 4, "clicks": 4, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 4, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.42}','NOW()','NOW()'), ('2024-10-11',0,1530822,8273146,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-12',2029999,1530822,8273146,'{"cost_micros": 2030000, "impressions": 3, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 2.0, "all_conversions_value": 600.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 2.03}','NOW()','NOW()'), ('2024-10-13',0,1530822,8273146,'{"cost_micros": 0, "impressions": 2, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-14',520000,1530822,8273146,'{"cost_micros": 520000, "impressions": 3, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 1.0, "all_conversions_value": 125.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.52}','NOW()','NOW()'), ('2024-10-15',6260000,1530822,8273146,'{"cost_micros": 6260000, "impressions": 2, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 6.26}','NOW()','NOW()'), ('2024-10-16',4030000,1530822,8273146,'{"cost_micros": 4030000, "impressions": 1, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 4.03}','NOW()','NOW()'), ('2024-10-17',4490000,1530822,8273146,'{"cost_micros": 4490000, "impressions": 2, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 4.49}','NOW()','NOW()'), ('2024-10-18',6640000,1530822,8273146,'{"cost_micros": 6640000, "impressions": 5, "clicks": 4, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 4, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 6.64}','NOW()','NOW()'), ('2024-10-19',20000,1530822,8273146,'{"cost_micros": 20000, "impressions": 3, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.02}','NOW()','NOW()'), ('2024-10-20',2320000,1530822,8273146,'{"cost_micros": 2320000, "impressions": 1, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 2.32}','NOW()','NOW()'), ('2024-10-21',1730000,1530822,8273146,'{"cost_micros": 1730000, "impressions": 1, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 1.73}','NOW()','NOW()'), ('2024-10-22',2180000,1530822,8273146,'{"cost_micros": 2180000, "impressions": 4, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 1.0, "all_conversions_value": 125.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 2.18}','NOW()','NOW()'), ('2024-09-25',1620000,1530822,8273149,'{"cost_micros": 1620000, "impressions": 1, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 1.62}','NOW()','NOW()'), ('2024-09-26',5000000,1530822,8273149,'{"cost_micros": 5000000, "impressions": 2, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 1.0, "all_conversions_value": 125.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 5.0}','NOW()','NOW()'), ('2024-10-03',10000,1530822,8273149,'{"cost_micros": 10000, "impressions": 1, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 2.0, "all_conversions_value": 300.740976485, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.01}','NOW()','NOW()'), ('2024-10-04',1320000,1530822,8273149,'{"cost_micros": 1320000, "impressions": 1, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 3.0, "all_conversions_value": 2.215604631, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 1.32}','NOW()','NOW()'), ('2024-10-09',10000,1530822,8273149,'{"cost_micros": 10000, "impressions": 1, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 1.0, "all_conversions_value": 0.732572949, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.01}','NOW()','NOW()'), ('2024-10-12',2320000,1530822,8273149,'{"cost_micros": 2320000, "impressions": 1, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 2.32}','NOW()','NOW()'), ('2024-10-14',0,1530822,8273149,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-09-26',0,1530822,8273150,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-09-23',0,1530822,8273151,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-09-25',2830000,1530822,8273151,'{"cost_micros": 2830000, "impressions": 1, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 2.83}','NOW()','NOW()'), ('2024-09-26',0,1530822,8273151,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-09-27',3560000,1530822,8273151,'{"cost_micros": 3560000, "impressions": 1, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 3.56}','NOW()','NOW()'), ('2024-09-28',1380000,1530822,8273151,'{"cost_micros": 1380000, "impressions": 1, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 1.0, "all_conversions_value": 300.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 1.38}','NOW()','NOW()'), ('2024-09-29',0,1530822,8273151,'{"cost_micros": 0, "impressions": 2, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-09-30',0,1530822,8273151,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-02',0,1530822,8273151,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-03',0,1530822,8273151,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-05',0,1530822,8273151,'{"cost_micros": 0, "impressions": 2, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-11',0,1530822,8273151,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-12',0,1530822,8273151,'{"cost_micros": 0, "impressions": 2, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-14',0,1530822,8273151,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-15',0,1530822,8273151,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-17',0,1530822,8273151,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-09-26',990000,1530822,8273152,'{"cost_micros": 990000, "impressions": 3, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 1.0, "all_conversions_value": 125.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.99}','NOW()','NOW()'), ('2024-09-27',0,1530822,8273152,'{"cost_micros": 0, "impressions": 4, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-01',180000,1530822,8273152,'{"cost_micros": 180000, "impressions": 1, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 4.0, "all_conversions_value": 352.219068512, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.18}','NOW()','NOW()'), ('2024-10-09',0,1530822,8273152,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-17',0,1530822,8273152,'{"cost_micros": 0, "impressions": 1, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-10-18',4320000,1530822,8273152,'{"cost_micros": 4320000, "impressions": 5, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 4.32}','NOW()','NOW()'), ('2024-10-19',4920000,1530822,8273152,'{"cost_micros": 4920000, "impressions": 5, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 1.0, "all_conversions_value": 125.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 4.92}','NOW()','NOW()'), ('2024-10-22',3000000,1530822,8273152,'{"cost_micros": 3000000, "impressions": 2, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 3.0}','NOW()','NOW()'), ('2024-09-23',4820000,1530822,8273155,'{"cost_micros": 4820000, "impressions": 12, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 1.0, "all_conversions_value": 300.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 4.82}','NOW()','NOW()'), ('2024-09-24',10800000,1530822,8273155,'{"cost_micros": 10803788, "impressions": 16, "clicks": 9, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 39.0, "all_conversions_value": 2345.036515244, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 9, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 10.8}','NOW()','NOW()'), ('2024-09-25',6780000,1530822,8273155,'{"cost_micros": 6780000, "impressions": 11, "clicks": 6, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 2.0, "all_conversions_value": 1.485524782, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 6, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 6.78}','NOW()','NOW()'), ('2024-09-26',4460000,1530822,8273155,'{"cost_micros": 4461449, "impressions": 13, "clicks": 7, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 5.0, "all_conversions_value": 1125.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 7, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 4.46}','NOW()','NOW()'), ('2024-09-27',0,1530822,8273155,'{"cost_micros": 0, "impressions": 11, "clicks": 0, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 0, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.0}','NOW()','NOW()'), ('2024-09-28',10880000,1530822,8273155,'{"cost_micros": 10877719, "impressions": 9, "clicks": 3, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 3.0, "all_conversions_value": 500.740727616, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 3, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 10.88}','NOW()','NOW()'), ('2024-09-29',6200000,1530822,8273155,'{"cost_micros": 6196383, "impressions": 18, "clicks": 6, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 2.0, "all_conversions_value": 500.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 6, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 6.2}','NOW()','NOW()'), ('2024-09-30',830000,1530822,8273155,'{"cost_micros": 830000, "impressions": 11, "clicks": 3, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 2.0, "all_conversions_value": 1.47651012, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 3, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.83}','NOW()','NOW()'), ('2024-10-01',4200000,1530822,8273155,'{"cost_micros": 4200000, "impressions": 10, "clicks": 5, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 1.0, "all_conversions_value": 0.740496503, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 5, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 4.2}','NOW()','NOW()'), ('2024-10-02',5650000,1530822,8273155,'{"cost_micros": 5650000, "impressions": 16, "clicks": 8, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 2.0, "all_conversions_value": 200.726430297, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 8, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 5.65}','NOW()','NOW()'), ('2024-10-03',8420000,1530822,8273155,'{"cost_micros": 8422478, "impressions": 16, "clicks": 6, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 27.47574, "all_conversions_value": 20.467793577, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 6, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 8.42}','NOW()','NOW()'), ('2024-10-04',13440000,1530822,8273155,'{"cost_micros": 13440000, "impressions": 16, "clicks": 7, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 5.0, "all_conversions_value": 327.477069754, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 7, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 13.44}','NOW()','NOW()'), ('2024-10-05',5150000,1530822,8273155,'{"cost_micros": 5146999, "impressions": 19, "clicks": 11, "video_views": 0, "engagements": 0, "conversions": 0.333334, "conversions_value": 41.66675, "all_conversions": 7.479803, "all_conversions_value": 633.592038576, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 11, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 5.15}','NOW()','NOW()'), ('2024-10-06',8950000,1530822,8273155,'{"cost_micros": 8952552, "impressions": 16, "clicks": 7, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 4.0, "all_conversions_value": 725.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 7, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 8.95}','NOW()','NOW()'), ('2024-10-07',2270000,1530822,8273155,'{"cost_micros": 2270000, "impressions": 11, "clicks": 3, "video_views": 0, "engagements": 0, "conversions": 0.963438, "conversions_value": 120.42975, "all_conversions": 1.963438, "all_conversions_value": 121.154734325, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 3, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 2.27}','NOW()','NOW()'), ('2024-10-08',2250000,1530822,8273155,'{"cost_micros": 2250000, "impressions": 12, "clicks": 5, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 5.0, "all_conversions_value": 925.735284594, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 5, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 2.25}','NOW()','NOW()'), ('2024-10-09',6640000,1530822,8273155,'{"cost_micros": 6640000, "impressions": 8, "clicks": 4, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 4.0, "all_conversions_value": 302.465145899, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 4, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 6.64}','NOW()','NOW()'), ('2024-10-10',550000,1530822,8273155,'{"cost_micros": 550000, "impressions": 4, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.55}','NOW()','NOW()'), ('2024-10-11',3430000,1530822,8273155,'{"cost_micros": 3430000, "impressions": 12, "clicks": 4, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 5.0, "all_conversions_value": 402.182499734, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 4, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 3.43}','NOW()','NOW()'), ('2024-10-12',260000,1530822,8273155,'{"cost_micros": 260000, "impressions": 12, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.26}','NOW()','NOW()'), ('2024-10-13',3840000,1530822,8273155,'{"cost_micros": 3840000, "impressions": 11, "clicks": 5, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 5, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 3.84}','NOW()','NOW()'), ('2024-10-14',3030000,1530822,8273155,'{"cost_micros": 3030000, "impressions": 12, "clicks": 3, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 3.249142, "all_conversions_value": 89.378990892, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 3, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 3.03}','NOW()','NOW()'), ('2024-10-15',1620000,1530822,8273155,'{"cost_micros": 1619251, "impressions": 12, "clicks": 6, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 2.0, "all_conversions_value": 1.451526013, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 6, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 1.62}','NOW()','NOW()'), ('2024-10-16',3570000,1530822,8273155,'{"cost_micros": 3570000, "impressions": 13, "clicks": 5, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 5.0, "all_conversions_value": 526.449602242, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 5, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 3.57}','NOW()','NOW()'), ('2024-10-17',1090000,1530822,8273155,'{"cost_micros": 1090000, "impressions": 12, "clicks": 3, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 5.0, "all_conversions_value": 601.452595069, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 3, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 1.09}','NOW()','NOW()'), ('2024-10-18',11250000,1530822,8273155,'{"cost_micros": 11250000, "impressions": 10, "clicks": 9, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 7.961311, "all_conversions_value": 603.860082268, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 9, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 11.25}','NOW()','NOW()'), ('2024-10-19',7980000,1530822,8273155,'{"cost_micros": 7980000, "impressions": 19, "clicks": 8, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 7.0, "all_conversions_value": 473.112641873, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 8, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 7.98}','NOW()','NOW()'), ('2024-10-20',4250000,1530822,8273155,'{"cost_micros": 4251357, "impressions": 16, "clicks": 7, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 1.0, "all_conversions_value": 125.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 7, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 4.25}','NOW()','NOW()'), ('2024-10-21',4840000,1530822,8273155,'{"cost_micros": 4840000, "impressions": 12, "clicks": 6, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 6, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 4.84}','NOW()','NOW()'), ('2024-10-22',5110000,1530822,8273155,'{"cost_micros": 5110000, "impressions": 16, "clicks": 7, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 7, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 5.11}','NOW()','NOW()'), ('2024-09-23',2940000,1530822,8273156,'{"cost_micros": 2940000, "impressions": 6, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 2.0, "all_conversions_value": 1.478056559, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 2.94}','NOW()','NOW()'), ('2024-09-24',7940000,1530822,8273156,'{"cost_micros": 7943609, "impressions": 8, "clicks": 3, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 1.0, "all_conversions_value": 300.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 3, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 7.94}','NOW()','NOW()'), ('2024-09-25',5430000,1530822,8273156,'{"cost_micros": 5430000, "impressions": 5, "clicks": 4, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 5.0, "all_conversions_value": 502.485238055, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 4, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 5.43}','NOW()','NOW()'), ('2024-09-26',710000,1530822,8273156,'{"cost_micros": 710000, "impressions": 9, "clicks": 3, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 9.0, "all_conversions_value": 2000.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 3, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.71}','NOW()','NOW()'), ('2024-09-27',2390000,1530822,8273156,'{"cost_micros": 2390000, "impressions": 6, "clicks": 4, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 7.974046, "all_conversions_value": 1127.716276667, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 4, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 2.39}','NOW()','NOW()'), ('2024-09-28',2160000,1530822,8273156,'{"cost_micros": 2160000, "impressions": 4, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 1.0, "all_conversions_value": 200.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 2.16}','NOW()','NOW()'), ('2024-09-29',3020000,1530822,8273156,'{"cost_micros": 3020000, "impressions": 6, "clicks": 4, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 22.0, "all_conversions_value": 813.31848297, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 4, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 3.02}','NOW()','NOW()'), ('2024-09-30',3940000,1530822,8273156,'{"cost_micros": 3940000, "impressions": 4, "clicks": 3, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 4.0, "all_conversions_value": 202.479850275, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 3, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 3.94}','NOW()','NOW()'), ('2024-10-01',5180000,1530822,8273156,'{"cost_micros": 5180000, "impressions": 6, "clicks": 3, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 1.0, "all_conversions_value": 200.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 3, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 5.18}','NOW()','NOW()'), ('2024-10-02',2720000,1530822,8273156,'{"cost_micros": 2720000, "impressions": 7, "clicks": 4, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 3.0, "all_conversions_value": 700.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 4, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 2.72}','NOW()','NOW()'), ('2024-10-03',4370000,1530822,8273156,'{"cost_micros": 4370000, "impressions": 8, "clicks": 4, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 5.0, "all_conversions_value": 519.305957092, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 4, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 4.37}','NOW()','NOW()'), ('2024-10-04',190000,1530822,8273156,'{"cost_micros": 188888, "impressions": 4, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.19}','NOW()','NOW()'), ('2024-10-05',5440000,1530822,8273156,'{"cost_micros": 5440000, "impressions": 8, "clicks": 3, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 1.997434, "all_conversions_value": 200.997434, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 3, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 5.44}','NOW()','NOW()'), ('2024-10-06',1470000,1530822,8273156,'{"cost_micros": 1470000, "impressions": 6, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 1.0, "all_conversions_value": 200.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 1.47}','NOW()','NOW()'), ('2024-10-07',590000,1530822,8273156,'{"cost_micros": 590000, "impressions": 5, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 2.0, "all_conversions_value": 1.470569187, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.59}','NOW()','NOW()'), ('2024-10-08',890000,1530822,8273156,'{"cost_micros": 890000, "impressions": 8, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 1.0, "all_conversions_value": 200.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.89}','NOW()','NOW()'), ('2024-10-09',240000,1530822,8273156,'{"cost_micros": 240000, "impressions": 5, "clicks": 1, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 1, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.24}','NOW()','NOW()'), ('2024-10-10',7930000,1530822,8273156,'{"cost_micros": 7930000, "impressions": 6, "clicks": 3, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 2.0, "all_conversions_value": 500.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 3, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 7.93}','NOW()','NOW()'), ('2024-10-11',1200000,1530822,8273156,'{"cost_micros": 1200000, "impressions": 6, "clicks": 3, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 2.0, "all_conversions_value": 200.727499911, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 3, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 1.2}','NOW()','NOW()'), ('2024-10-12',7610000,1530822,8273156,'{"cost_micros": 7610000, "impressions": 12, "clicks": 5, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 8.0, "all_conversions_value": 404.631644686, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 5, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 7.61}','NOW()','NOW()'), ('2024-10-13',4210000,1530822,8273156,'{"cost_micros": 4210000, "impressions": 5, "clicks": 3, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 50.0, "all_conversions_value": 634.42166052, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 3, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 4.21}','NOW()','NOW()'), ('2024-10-14',4080000,1530822,8273156,'{"cost_micros": 4080000, "impressions": 4, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 4.08}','NOW()','NOW()'), ('2024-10-15',1230000,1530822,8273156,'{"cost_micros": 1230000, "impressions": 7, "clicks": 3, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 3.0, "all_conversions_value": 401.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 3, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 1.23}','NOW()','NOW()'), ('2024-10-16',840000,1530822,8273156,'{"cost_micros": 840000, "impressions": 4, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 6.0, "all_conversions_value": 203.624005605, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 0.84}','NOW()','NOW()'), ('2024-10-17',2520000,1530822,8273156,'{"cost_micros": 2520000, "impressions": 7, "clicks": 3, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 18.0, "all_conversions_value": 13.054112617, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 3, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 2.52}','NOW()','NOW()'), ('2024-10-18',1470000,1530822,8273156,'{"cost_micros": 1470000, "impressions": 8, "clicks": 3, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 4.0, "all_conversions_value": 2.898771268, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 3, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 1.47}','NOW()','NOW()'), ('2024-10-19',3380000,1530822,8273156,'{"cost_micros": 3380000, "impressions": 7, "clicks": 4, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 1.0, "all_conversions_value": 200.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 4, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 3.38}','NOW()','NOW()'), ('2024-10-20',1310000,1530822,8273156,'{"cost_micros": 1310000, "impressions": 5, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 1.31}','NOW()','NOW()'), ('2024-10-21',1480000,1530822,8273156,'{"cost_micros": 1480000, "impressions": 8, "clicks": 4, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 1.0, "all_conversions_value": 1.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 4, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 1.48}','NOW()','NOW()'), ('2024-10-22',1250000,1530822,8273156,'{"cost_micros": 1249509, "impressions": 6, "clicks": 2, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 1.0, "all_conversions_value": 1.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 2, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 1.25}','NOW()','NOW()'), ('2024-09-23',21210000,1530822,8273157,'{"cost_micros": 21209465, "impressions": 49, "clicks": 19, "video_views": 0, "engagements": 0, "conversions": 1.471199, "conversions_value": 183.899875, "all_conversions": 8.970695, "all_conversions_value": 1087.610611223, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 19, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 21.21}','NOW()','NOW()'), ('2024-09-24',15220000,1530822,8273157,'{"cost_micros": 15216000, "impressions": 37, "clicks": 19, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 12.0, "all_conversions_value": 1330.434416411, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 19, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 15.22}','NOW()','NOW()'), ('2024-09-25',17340000,1530822,8273157,'{"cost_micros": 17336923, "impressions": 42, "clicks": 22, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 9.0, "all_conversions_value": 1303.227857083, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 22, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 17.34}','NOW()','NOW()'), ('2024-09-26',19170000,1530822,8273157,'{"cost_micros": 19166250, "impressions": 51, "clicks": 15, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 5.292033, "all_conversions_value": 726.767511704, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 15, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 19.17}','NOW()','NOW()'), ('2024-09-27',13280000,1530822,8273157,'{"cost_micros": 13280000, "impressions": 40, "clicks": 16, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 3.0, "all_conversions_value": 425.740727616, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 16, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 13.28}','NOW()','NOW()'), ('2024-09-28',13540000,1530822,8273157,'{"cost_micros": 13540000, "impressions": 50, "clicks": 24, "video_views": 0, "engagements": 0, "conversions": 2.0, "conversions_value": 250.0, "all_conversions": 31.666667, "all_conversions_value": 2864.257363711, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 24, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 13.54}','NOW()','NOW()'), ('2024-09-29',29940000,1530822,8273157,'{"cost_micros": 29939099, "impressions": 58, "clicks": 26, "video_views": 0, "engagements": 0, "conversions": 1.960626, "conversions_value": 245.07825, "all_conversions": 28.960626, "all_conversions_value": 2459.136386894, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 26, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 29.94}','NOW()','NOW()'), ('2024-09-30',21460000,1530822,8273157,'{"cost_micros": 21460892, "impressions": 41, "clicks": 17, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 12.0, "all_conversions_value": 432.638571437, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 17, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 21.46}','NOW()','NOW()'), ('2024-10-01',16510000,1530822,8273157,'{"cost_micros": 16505224, "impressions": 49, "clicks": 20, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 32.94063, "all_conversions_value": 1171.488163895, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 20, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 16.51}','NOW()','NOW()'), ('2024-10-02',32830000,1530822,8273157,'{"cost_micros": 32830000, "impressions": 49, "clicks": 22, "video_views": 0, "engagements": 0, "conversions": 2.0, "conversions_value": 250.0, "all_conversions": 32.87144, "all_conversions_value": 1668.903339544, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 22, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 32.83}','NOW()','NOW()'), ('2024-10-03',35310000,1530822,8273157,'{"cost_micros": 35306040, "impressions": 57, "clicks": 17, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 6.204211, "all_conversions_value": 304.671617782, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 17, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 35.31}','NOW()','NOW()'), ('2024-10-04',17980000,1530822,8273157,'{"cost_micros": 17980000, "impressions": 39, "clicks": 17, "video_views": 0, "engagements": 0, "conversions": 0.011633, "conversions_value": 1.454125, "all_conversions": 26.625071, "all_conversions_value": 2015.355990606, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 17, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 17.98}','NOW()','NOW()'), ('2024-10-05',23890000,1530822,8273157,'{"cost_micros": 23894085, "impressions": 45, "clicks": 23, "video_views": 0, "engagements": 0, "conversions": 3.0, "conversions_value": 375.0, "all_conversions": 7.0, "all_conversions_value": 876.473187979, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 23, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 23.89}','NOW()','NOW()'), ('2024-10-06',22290000,1530822,8273157,'{"cost_micros": 22287296, "impressions": 54, "clicks": 19, "video_views": 0, "engagements": 0, "conversions": 2.992045, "conversions_value": 374.005625, "all_conversions": 10.992045, "all_conversions_value": 1576.742209982, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 19, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 22.29}','NOW()','NOW()'), ('2024-10-07',10360000,1530822,8273157,'{"cost_micros": 10360000, "impressions": 43, "clicks": 19, "video_views": 0, "engagements": 0, "conversions": 0.963436, "conversions_value": 120.4295, "all_conversions": 10.963436, "all_conversions_value": 1623.362503442, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 19, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 10.36}','NOW()','NOW()'), ('2024-10-08',23570000,1530822,8273157,'{"cost_micros": 23568089, "impressions": 43, "clicks": 20, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 7.0, "all_conversions_value": 927.186566453, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 20, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 23.57}','NOW()','NOW()'), ('2024-10-09',12240000,1530822,8273157,'{"cost_micros": 12240000, "impressions": 32, "clicks": 14, "video_views": 0, "engagements": 0, "conversions": 3.0, "conversions_value": 375.0, "all_conversions": 13.0, "all_conversions_value": 1080.122102787, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 14, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 12.24}','NOW()','NOW()'), ('2024-10-10',6660000,1530822,8273157,'{"cost_micros": 6660000, "impressions": 31, "clicks": 10, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 10.0, "all_conversions_value": 7.27286273, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 10, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 6.66}','NOW()','NOW()'), ('2024-10-11',8520000,1530822,8273157,'{"cost_micros": 8520000, "impressions": 29, "clicks": 8, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 4.0, "all_conversions_value": 1073.18254, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 8, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 8.52}','NOW()','NOW()'), ('2024-10-12',22210000,1530822,8273157,'{"cost_micros": 22210000, "impressions": 53, "clicks": 22, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 34.0, "all_conversions_value": 649.439961928, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 22, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 22.21}','NOW()','NOW()'), ('2024-10-13',10520000,1530822,8273157,'{"cost_micros": 10520000, "impressions": 36, "clicks": 10, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 1.0, "all_conversions_value": 0.726430297, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 10, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 10.52}','NOW()','NOW()'), ('2024-10-14',7320000,1530822,8273157,'{"cost_micros": 7320000, "impressions": 43, "clicks": 12, "video_views": 0, "engagements": 0, "conversions": 2.003149, "conversions_value": 250.393625, "all_conversions": 10.003149, "all_conversions_value": 555.475745136, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 12, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 7.32}','NOW()','NOW()'), ('2024-10-15',2049999,1530822,8273157,'{"cost_micros": 2050000, "impressions": 39, "clicks": 13, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 4.0, "all_conversions_value": 326.44996865, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 13, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 2.05}','NOW()','NOW()'), ('2024-10-16',20490000,1530822,8273157,'{"cost_micros": 20489051, "impressions": 53, "clicks": 19, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 11.625182, "all_conversions_value": 1259.018874218, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 19, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 20.49}','NOW()','NOW()'), ('2024-10-17',18860000,1530822,8273157,'{"cost_micros": 18859484, "impressions": 39, "clicks": 20, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 6.0, "all_conversions_value": 702.178892604, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 20, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 18.86}','NOW()','NOW()'), ('2024-10-18',6680000,1530822,8273157,'{"cost_micros": 6678356, "impressions": 28, "clicks": 10, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 7.991625, "all_conversions_value": 6.617767394, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 10, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 6.68}','NOW()','NOW()'), ('2024-10-19',42640000,1530822,8273157,'{"cost_micros": 42638260, "impressions": 44, "clicks": 22, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 4.0, "all_conversions_value": 202.449383012, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 22, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 42.64}','NOW()','NOW()'), ('2024-10-20',23730000,1530822,8273157,'{"cost_micros": 23726585, "impressions": 58, "clicks": 27, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 0.0, "all_conversions_value": 0.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 27, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 23.73}','NOW()','NOW()'), ('2024-10-21',11470000,1530822,8273157,'{"cost_micros": 11474590, "impressions": 47, "clicks": 15, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 3.0, "all_conversions_value": 127.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 15, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 11.47}','NOW()','NOW()'), ('2024-10-22',14490000,1530822,8273157,'{"cost_micros": 14490000, "impressions": 48, "clicks": 15, "video_views": 0, "engagements": 0, "conversions": 1.0, "conversions_value": 125.0, "all_conversions": 2.0, "all_conversions_value": 126.0, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 15, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 14.49}','NOW()','NOW()'), ('2024-09-23',12160000,1530822,8273158,'{"cost_micros": 12161128, "impressions": 88, "clicks": 24, "video_views": 0, "engagements": 0, "conversions": 2.0, "conversions_value": 250.0, "all_conversions": 36.0, "all_conversions_value": 6557.661887256, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 24, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 12.16}','NOW()','NOW()'), ('2024-09-24',30040000,1530822,8273158,'{"cost_micros": 30035000, "impressions": 142, "clicks": 45, "video_views": 0, "engagements": 0, "conversions": 2.815839, "conversions_value": 351.979875, "all_conversions": 43.815839, "all_conversions_value": 5268.783134245, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 45, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 30.04}','NOW()','NOW()'), ('2024-09-25',43800000,1530822,8273158,'{"cost_micros": 43800000, "impressions": 121, "clicks": 40, "video_views": 0, "engagements": 0, "conversions": 3.0, "conversions_value": 375.0, "all_conversions": 43.560589, "all_conversions_value": 5292.121244025, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 40, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 43.8}','NOW()','NOW()'), ('2024-09-26',26910000,1530822,8273158,'{"cost_micros": 26910000, "impressions": 113, "clicks": 31, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 37.763514, "all_conversions_value": 3205.193737271, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 31, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 26.91}','NOW()','NOW()'), ('2024-09-27',6390000,1530822,8273158,'{"cost_micros": 6390000, "impressions": 81, "clicks": 17, "video_views": 0, "engagements": 0, "conversions": 0.0, "conversions_value": 0.0, "all_conversions": 30.0, "all_conversions_value": 1717.057106281, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 17, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 6.39}','NOW()','NOW()'), ('2024-09-28',16840000,1530822,8273158,'{"cost_micros": 16840000, "impressions": 134, "clicks": 33, "video_views": 0, "engagements": 0, "conversions": 4.052052, "conversions_value": 506.5065, "all_conversions": 99.355617, "all_conversions_value": 4914.846091428, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 33, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 16.84}','NOW()','NOW()'), ('2024-09-29',37320000,1530822,8273158,'{"cost_micros": 37320000, "impressions": 106, "clicks": 32, "video_views": 0, "engagements": 0, "conversions": 5.039374, "conversions_value": 629.92175, "all_conversions": 35.039374, "all_conversions_value": 4241.54036997, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 32, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 37.32}','NOW()','NOW()'), ('2024-09-30',19670000,1530822,8273158,'{"cost_micros": 19670000, "impressions": 102, "clicks": 23, "video_views": 0, "engagements": 0, "conversions": 1.5, "conversions_value": 187.5, "all_conversions": 8.5, "all_conversions_value": 990.460271916, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 23, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 19.67}','NOW()','NOW()'), ('2024-10-01',42160000,1530822,8273158,'{"cost_micros": 42160179, "impressions": 114, "clicks": 33, "video_views": 0, "engagements": 0, "conversions": 4.0, "conversions_value": 500.0, "all_conversions": 61.0, "all_conversions_value": 3447.437711152, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 33, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 42.16}','NOW()','NOW()'), ('2024-10-02',49510000,1530822,8273158,'{"cost_micros": 49509500, "impressions": 132, "clicks": 47, "video_views": 0, "engagements": 0, "conversions": 2.0, "conversions_value": 250.0, "all_conversions": 31.0, "all_conversions_value": 5157.176031948, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 47, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 49.51}','NOW()','NOW()'), ('2024-10-03',41260000,1530822,8273158,'{"cost_micros": 41261646, "impressions": 131, "clicks": 36, "video_views": 0, "engagements": 0, "conversions": 0.769948, "conversions_value": 96.2435, "all_conversions": 29.767984, "all_conversions_value": 2611.545578491, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 36, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 41.26}','NOW()','NOW()'), ('2024-10-04',29450000,1530822,8273158,'{"cost_micros": 29450000, "impressions": 101, "clicks": 28, "video_views": 0, "engagements": 0, "conversions": 0.783946, "conversions_value": 97.99325, "all_conversions": 34.783946, "all_conversions_value": 2814.473359156, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 28, "active_view_impressions": 0, "total_video_quartile_p_25_views": 0.0, "total_video_quartile_p_50_views": 0.0, "total_video_quartile_p_75_views": 0.0, "total_video_quartile_p_100_views": 0.0, "spend": 29.45}','NOW()','NOW()'), ('2024-10-05',28370000,1530822,8273158,'{"cost_micros": 28366113, "impressions": 98, "clicks": 25, "video_views": 0, "engagements": 0, "conversions": 2.105009, "conversions_value": 263.126125, "all_conversions": 46.105009, "all_conversions_value": 3883.734535941, "view_through_conversions": 0, "gmail_secondary_clicks": 0, "interactions": 25, "active_vi[...]

Date: 2024-10-23 07:14:09
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.174.133

x Hide

SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'first_user_source_medium' AS "~GA4-S6:first_user_source_medium:custom_platform_info:1", data ->> 'first_user_manual_term' AS "~GA4-S6:first_user_manual_term:custom_platform_info:1", data ->> 'first_user_manual_ad_content' AS "~GA4-S6:first_user_manual_ad_content:custom_platform_info:1", data ->> 'first_user_campaign_name' AS "~GA4-S6:first_user_campaign_name:custom_platform_info:1", data ->> 'first_user_default_channel_group' AS "~GA4-S6:first_user_default_channel_group:custom_platform_info:1", data ->> 'transaction_id' AS "~GA4-S6:transaction_id:custom_platform_info:1", data ->> 'page_path' AS "~GA4-S6:page_path:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = main.id;

Date: 2024-10-23 08:42:52
Duration: 8m10s
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.59.250

SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'first_user_source_medium' AS "~GA4-S6:first_user_source_medium:custom_platform_info:1", data ->> 'first_user_manual_term' AS "~GA4-S6:first_user_manual_term:custom_platform_info:1", data ->> 'first_user_manual_ad_content' AS "~GA4-S6:first_user_manual_ad_content:custom_platform_info:1", data ->> 'first_user_campaign_name' AS "~GA4-S6:first_user_campaign_name:custom_platform_info:1", data ->> 'first_user_default_channel_group' AS "~GA4-S6:first_user_default_channel_group:custom_platform_info:1", data ->> 'transaction_id' AS "~GA4-S6:transaction_id:custom_platform_info:1", data ->> 'page_path' AS "~GA4-S6:page_path:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = main.id;

Date: 2024-10-23 08:42:52
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.59.250

x Hide

SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'transaction_id' AS "~GA4-S6:transaction_id:custom_platform_info:1", data ->> 'first_user_source_medium' AS "~GA4-S6:first_user_source_medium:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_18 scratch ON scratch.object_id = main.id;

Date: 2024-10-23 10:14:43
Duration: 7m57s
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.106.174

SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'transaction_id' AS "~GA4-S6:transaction_id:custom_platform_info:1", data ->> 'first_user_source_medium' AS "~GA4-S6:first_user_source_medium:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_18 scratch ON scratch.object_id = main.id;

Date: 2024-10-23 10:14:43
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.106.174

x Hide

SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'total_revenue' AS "~GA4-S3:total_revenue:custom_platform_stats:1", data ->> 'sessions' AS "~GA4-S3:sessions:custom_platform_stats:1", data ->> 'transactions' AS "~GA4-S3:transactions:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_22 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-06-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-23', 'YYYY-MM-DD');

Date: 2024-10-23 08:16:24
Duration: 0ms
Database: vcomm_df2k5udqn4tqeo
User: u3b8n76p6efp5p
Remote: 10.24.106.174

x Hide