1"use strict";(self.webpackChunk_N_E=self.webpackChunk_N_E||[]).push([[6285],{56285:(e,t,a)=>{a.r(t),a.d(t,{__rspack_esm_id:()=>l,__rspack_esm_ids:()=>i,__webpack_modules__:()=>o});let l="1330",i=["1330"],o={5465(e){e.exports=JSON.parse('{"id":"ce1ec023-5b86-4dcb-84a6-af12540f025d","code":"LZD_AUTO_AD","view":{"id":"default","name":"Default","isLock":false,"updatedAt":1777196000465,"combinator":{"sort":[{"sort":"desc","field":"cost","locked":false}],"filter":[],"groupBy":{},"currency":"USD","dateRange":{"dateTo":"2026-04-26","dateFrom":"2026-04-20"},"dimension":["object_name","excluded_products"],"properties":{"metric":["cost","ads_gmv","roas","cpc","clicks","impressions","aiv","atc","atc_rate","ads_order","ads_items_sold"],"attribute":["ads_object_status"],"dimension":["object_name"]},"columnOrder":["keyword","object_name","ads_object_status","cost","ads_gmv","roas","cpc","clicks","impressions","aiv","atc","atc_rate","ads_order","ads_items_sold","product_id","company_name","campaign_tool","campaign_timeline","ads_campaign_status","smart_creative","cpi","cr","aov","cir","ctr"],"columnWidth":[{"width":40,"columnField":"checkbox"},{"width":320,"columnField":"object_name"},{"width":200,"columnField":"ad_placement_name"},{"width":160,"columnField":"keyword_note"},{"width":160,"columnField":"ads_campaign_status"},{"width":160,"columnField":"ads_object_status"},{"width":160,"columnField":"keyword_match_type"},{"width":160,"columnField":"ads_campaign_daily_budget"},{"width":160,"columnField":"ads_campaign_total_budget"},{"width":160,"columnField":"ads_object_base_bidding_price"},{"width":160,"columnField":"keyword_bidding_price"},{"width":120,"columnField":"impression"},{"width":120,"columnField":"clicks"},{"width":200,"columnField":"ads_spend"},{"width":200,"columnField":"ads_gmv"},{"width":120,"columnField":"ads_item_sold"},{"width":181,"columnField":"campaign_tool"},{"width":200,"columnField":"keyword"}],"pinnedColumn":[],"groupDimension":[],"specialFilters":{},"cohortDateRange":null,"showVerticalLines":"yes","usePivotMultipleHeader":"yes"},"systemView":true,"description":"","initializedView":true},"views":[{"id":"default","name":"Default","isLock":false,"updatedAt":1777196000465,"combinator":{"sort":[{"sort":"desc","field":"cost","locked":false}],"filter":[],"groupBy":{},"currency":"USD","dateRange":{"dateTo":"2026-04-26","dateFrom":"2026-04-20"},"dimension":["object_name","excluded_products"],"properties":{"metric":["cost","ads_gmv","roas","cpc","clicks","impressions","aiv","atc","atc_rate","ads_order","ads_items_sold"],"attribute":["ads_object_status"],"dimension":["object_name"]},"columnOrder":["keyword","object_name","ads_object_status","cost","ads_gmv","roas","cpc","clicks","impressions","aiv","atc","atc_rate","ads_order","ads_items_sold","product_id","company_name","campaign_tool","campaign_timeline","ads_campaign_status","smart_creative","cpi","cr","aov","cir","ctr"],"columnWidth":[{"width":40,"columnField":"checkbox"},{"width":320,"columnField":"object_name"},{"width":200,"columnField":"ad_placement_name"},{"width":160,"columnField":"keyword_note"},{"width":160,"columnField":"ads_campaign_status"},{"width":160,"columnField":"ads_object_status"},{"width":160,"columnField":"keyword_match_type"},{"width":160,"columnField":"ads_campaign_daily_budget"},{"width":160,"columnField":"ads_campaign_total_budget"},{"width":160,"columnField":"ads_object_base_bidding_price"},{"width":160,"columnField":"keyword_bidding_price"},{"width":120,"columnField":"impression"},{"width":120,"columnField":"clicks"},{"width":200,"columnField":"ads_spend"},{"width":200,"columnField":"ads_gmv"},{"width":120,"columnField":"ads_item_sold"},{"width":181,"columnField":"campaign_tool"},{"width":200,"columnField":"keyword"}],"pinnedColumn":[],"groupDimension":[],"specialFilters":{},"cohortDateRange":null,"showVerticalLines":"yes","usePivotMultipleHeader":"yes"},"systemView":true,"description":"","initializedView":true}],"metric":["cost","ads_gmv","roas","cpc","aiv","atc","atc_rate","clicks","impressions","ads_order","ads_items_sold","ads_gmv_loss","ad_live_time","performance_time"],"system":{"updatedAt":1777196561853,"allowPivot":"no","headerIcon":"","allowExport":"yes","watchMeLink":"","defaultLimit":"","datetimeField":"created_datetime","monitorConfig":"","numberOfPivot":0,"useNextExport":"no","allowCalculate":"yes","changeCurrency":"no","externalFilters":[],"lockColumnWidth":"no","allowPivotMetric":"no","hiddenComponents":["search","search","search","search","search","majorButton","search"],"allowAccumulative":"no","maximumExportDays":90,"autoReloadInterval":"","externalProperties":[],"hideUpdatedAtLabel":"no","allowChangeCurrency":"no","allowKeepViewFilter":"no","allowedExportEmails":null,"defaultExpandedRows":0,"maximumChartsPerRow":"5,5,3,2,2","widthToShowExternal":650,"widthToShowShortcut":550,"externalFiltersOptions":[{"label":"Country","value":"country","isMultiple":true},{"label":"Storefront","value":"storefront","isMultiple":true},{"label":"Marketplace","value":"marketplace","isMultiple":true}
1,{"label":"Ad object","value":"object_name","isMultiple":true},{"label":"Company","value":"company_name","isMultiple":true},{"label":"Campaign","value":"campaign_name","isMultiple":true},{"label":"Ad tool","value":"campaign_tool","isMultiple":true},{"label":"Ad placement","value":"keyword","isMultiple":true},{"label":"Product ID","value":"product_id","isMultiple":true}],"useNextFooterCalculator":"no"},"version":1777196561853,"_runtime":{"dateRange":{"dateTo":"2024-06-27","dateFrom":"2024-06-20"},"cohortDateRange":null},"blockEid":"ce1ec023-5b86-4dcb-84a6-af12540f025d","_editorId":"table_hvqyQBWkqRhscdvjUSGZA","attribute":["cost_today","ads_gmv_today","roas_today"],"dateRange":{"dateTo":"2026-04-26","dateFrom":"2026-04-20"},"updatedAt":"2025-11-27T05:46:39.000Z","columnOrder":{"__cfg":"p967"},"primaryKeys":["ads_campaigns.id","ads_objects.id","ads_placements.id"],"defaultPagination":{"page":1,"limit":100,"total":0,"traceId":""},"__omit":["groupDimension","pinnedUntilColumn","usePivotMultipleHeader","calculation","blockType","chartLibId","_sessionId","adsActions","properties","customAttributes"],"__mappingFields":["cr","aiv","aov","atc","cir","cpc","cpi","ctr","cost","roas","clicks","ads_gmv","keyword","atc_rate","ads_order","product_id","impressions","object_name","company_name","ads_items_sold","ads_object_status","ads_gmv_loss","ad_live_time","performance_time","cost_today","ads_gmv_today","roas_today"],"mappingOverride":{"cr":{"menu":[],"title":"CR","actions":{"__cfg":"p663"},"useMock":{},"dataType":"float","menuItem":[],"createdAt":1740563938527,"sortField":"ads_objects.cr","cellFormat":"tractionElasticity","filterField":"ads_objects.cr","staticValue":{"period":"daily","displayChart":0},"valueGetter":{"label":"=IF(p(\\"value\\")==null,\\"-\\",CONCAT(TEXT(p(\\"value\\")*100,\\"#.##\\"), \'%\'))","value":"ads_objects.cr","showAs":"=\\"number\\"","dividedBy":"=100","aggregate.label":"=IF(p(\\"value\\") > 0, IF([\'SUM\', \'AVG\', \'MEDIAN\', \'MIN\', \'MAX\', \'NONE\'].includes(p(\\"aggregate.function\\")) || !p(\\"aggregate.function\\"), CONCAT(TEXT(p(\\"value\\")*100,\\"#.##\\"), \'%\')))"},"propertyType":"metric","propertyGroup":"","advancedFilter":{"__cfg":"p1352"},"defaultGroupBy":null,"systemSettings":{"properties.state":"=IF(p(\\"specialFilters.marketplace.queryValueLabel\\") != \'Rakuten\', \'allow\', \'hidden\')"},"initColumnWidth":"120","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","initGroupColumnWidth":"160"},"aiv":{"menu":[],"title":"AIV","actions":{"__cfg":"p1451"},"useMock":{},"dataType":"float","menuItem":[],"createdAt":1740563938527,"sortField":"ads_objects.average_item_value","cellFormat":"tractionElasticity","filterField":"ads_objects.average_item_value","staticValue":{"period":"daily","displayChart":0},"valueGetter":{"__cfg":"p659"},"propertyType":"metric","propertyGroup":"","advancedFilter":{"__cfg":"p1352"},"defaultGroupBy":null,"systemSettings":{"properties.state":"=IF(p(\\"specialFilters.marketplace.queryValueLabel\\") != \'Rakuten\', \'allow\', \'hidden\')"},"initColumnWidth":"120","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","initGroupColumnWidth":"160"},"atc":{"menu":[],"title":"ATC","actions":[{"id":"29bbd2d4-d4f0-4e93-aa85-aecbcb6cef92","icon":"calendar2","name":"Change period","category":"period","shortcut":{"key":"atc","index":0},"sourceType":"table-actions","configuration":{"__cfg":"p111"}}],"useMock":{},"dataType":"integer","menuItem":[],"createdAt":1740563938527,"sortField":"ads_objects.atc","cellFormat":"tractionElasticity","filterField":"ads_objects.atc","staticValue":{"period":"daily","displayChart":0},"valueGetter":{"label":"=IF(p(\\"value\\")==null,\\"-\\",TEXT(p(\\"value\\"), \'#,###\'))","value":"ads_objects.atc","showAs":"=\\"number\\"","dividedBy":"=100"},"propertyType":"metric","propertyGroup":"","advancedFilter":{"__cfg":"p1352"},"defaultGroupBy":null,"systemSettings":{"properties.state":"=IF(p(\\"specialFilters.marketplace.queryValueLabel\\") != \'Rakuten\', \'allow\', \'hidden\')"},"initColumnWidth":"120","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","
1initGroupColumnWidth":"160"},"cir":{"menu":[],"title":"CIR","actions":{"__cfg":"p1422"},"useMock":{},"dataType":"float","menuItem":[],"createdAt":1740563938527,"sortField":"ads_objects.cir","cellFormat":"tractionElasticity","filterField":"ads_objects.cir","staticValue":{"period":"daily","displayChart":0},"valueGetter":{"lim":"=\\"yes\\"","label":"=IF(p(\\"value\\")==null,\\"-\\",CONCAT(TEXT(p(\\"value\\")*100,\\"#.##\\"), \'%\'))","value":"ads_objects.cir","showAs":"=\\"number\\"","dividedBy":"=100","aggregate.label":"=IF(p(\\"value\\") > 0, IF([\'SUM\', \'AVG\', \'MEDIAN\', \'MIN\', \'MAX\', \'NONE\'].includes(p(\\"aggregate.function\\")) || !p(\\"aggregate.function\\"), CONCAT(TEXT(p(\\"value\\")*100,\\"#.##\\"), \'%\')))"},"propertyType":"metric","propertyGroup":"","advancedFilter":{"__cfg":"p1352"},"defaultGroupBy":null,"systemSettings":{"properties.state":"=IF(p(\\"specialFilters.marketplace.queryValueLabel\\") != \'Rakuten\', \'allow\', \'hidden\')"},"initColumnWidth":"120","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","initGroupColumnWidth":"160"},"cpc":{"menu":[],"title":"CPC","actions":{"__cfg":"p482"},"useMock":{},"dataType":"float","menuItem":[],"createdAt":1740563938527,"sortField":"ads_objects.cpc","cellFormat":"tractionElasticity","filterField":"ads_objects.cpc","staticValue":{"period":"daily","displayChart":0},"valueGetter":{"__cfg":"p288"},"propertyType":"metric","propertyGroup":"","advancedFilter":{"__cfg":"p1352"},"defaultGroupBy":null,"systemSettings":{"properties.state":"=IF(p(\\"specialFilters.marketplace.queryValueLabel\\") != \'Rakuten\', \'allow\', \'hidden\')"},"initColumnWidth":"120","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","initGroupColumnWidth":"160"},"cpi":{"menu":[],"title":"CPI","actions":{"__cfg":"p839"},"useMock":{},"dataType":"float","menuItem":[],"createdAt":1740563938527,"sortField":"ads_objects.cpi","cellFormat":"tractionElasticity","filterField":"ads_objects.cpi","staticValue":{"period":"daily","displayChart":0},"valueGetter":{"__cfg":"p611"},"propertyType":"metric","propertyGroup":"","advancedFilter":{"__cfg":"p1352"},"defaultGroupBy":null,"systemSettings":{"properties.state":"=IF(p(\\"specialFilters.marketplace.queryValueLabel\\") != \'Rakuten\', \'allow\', \'hidden\')"},"initColumnWidth":"120","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","initGroupColumnWidth":"160"},"ctr":{"menu":[],"title":"CTR","actions":{"__cfg":"p177"},"useMock":{},"dataType":"float","menuItem":[],"createdAt":1740563938527,"sortField":"ads_objects.ctr","cellFormat":"tractionElasticity","filterField":"ads_objects.ctr","staticValue":{"period":"daily","displayChart":0},"valueGetter":{"label":"=IF(p(\\"value\\")==null,\\"-\\",CONCAT(TEXT(p(\\"value\\")*100,\\"#.##\\"), \'%\'))","value":"ads_objects.ctr","showAs":"=\\"number\\"","dividedBy":"=100","aggregate.label":"=IF(p(\\"value\\") > 0, IF([\'SUM\', \'AVG\', \'MEDIAN\', \'MIN\', \'MAX\', \'NONE\'].includes(p(\\"aggregate.function\\")) || !p(\\"aggregate.function\\"), CONCAT(TEXT(p(\\"value\\")*100,\\"#.##\\"), \'%\')))"},"propertyType":"metric","propertyGroup":"","advancedFilter":{"__cfg":"p1352"},"defaultGroupBy":null,"systemSettings":{},"initColumnWidth":"120","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","initGroupColumnWidth":"160"},"cost":{"menu":[],"title":"Ads spend","actions":[{"id":"29bbd2d4-d4f0-4e93-aa85-aecbcb6cef92","icon":"calendar2","name":"Change period","category":"period","shortcut":{"key":"cost","index":0},"sourceType":"table-actions","configuration":{"__cfg":"p111"}}],"useMock":{},"dataType":"float","menuItem":[],"createdAt":1740563938527,"sortField":"ads_objects.cost","cellFormat":"tractionElasticity","filterField":"ads_objects.cost","staticValue":{"period":"daily","displayChart":0},"valueGetter":{"label":"=IF(p(\\"value\\")<=1000,TEXT(p(\\"value\\"),\\"#,###\\"),UPPER(TEXT(p(\\"value\\"), \\"#.##a\\")))","value":"ads_objects.cost","showAs":"=\\"number\\"","tooltip":"=TEXT(p(\\"value\\"),\\"#,###.##\\")","currency":"storefront.currency","dividedBy":"=100","aggregate.label":"=IF(p(\\"value\\") > 0, IF([\'SUM\', \'AVG\', \'MEDIAN\', \'MIN\', \'MAX\', \'NONE\'].includes(p(\\"aggregate.function\\")) || !p(\\"aggregate.function\\"), TEXT(p(\\"value\\"),\\"#,###\\"), \'\'), \'\')","style.fontWeight":"=500"},"propertyType":"metric","propertyGroup":"","advancedFilter":{"__cfg":"p1352"},"defaultGroupBy":null,"systemSettings":{},"initColumnWidth":"120","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","
1initGroupColumnWidth":"160"},"roas":{"menu":[],"title":"ROAS","actions":{"__cfg":"p892"},"useMock":{},"dataType":"float","menuItem":[],"createdAt":1740563938527,"sortField":"ads_objects.roas","cellFormat":"tractionElasticity","filterField":"ads_objects.roas","staticValue":{"period":"daily","displayChart":0},"valueGetter":{"label":"=IF(p(\\"value\\") == null, \\"-\\", CONCATENATE(TEXT(p(\\"value\\"), \'#,###.##\'),\\"x\\"))","value":"ads_objects.roas","showAs":"=\\"number\\"","dividedBy":"=100","aggregate.label":"=IF(p(\\"value\\") > 0, IF([\'SUM\', \'AVG\', \'MEDIAN\', \'MIN\', \'MAX\', \'NONE\'].includes(p(\\"aggregate.function\\")) || !p(\\"aggregate.function\\"), CONCATENATE(TEXT(p(\\"value\\"), \'#,###.##\'),\\"x\\"), \'\'))","style.fontWeight":"=500"},"propertyType":"metric","propertyGroup":"","advancedFilter":{"__cfg":"p1352"},"defaultGroupBy":null,"systemSettings":{"properties.state":"=IF(p(\\"specialFilters.marketplace.queryValueLabel\\") != \'Rakuten\', \'allow\', \'hidden\')"},"initColumnWidth":"120","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","initGroupColumnWidth":"160"},"clicks":{"menu":[],"title":"Clicks","actions":{"__cfg":"p1440"},"useMock":{},"dataType":"integer","menuItem":[],"createdAt":1740563938527,"sortField":"ads_objects.click","cellFormat":"tractionElasticity","filterField":"ads_objects.click","
1staticValue":{"period":"daily","displayChart":0},"valueGetter":{"label":"=IF(p(\\"value\\")<=1000,TEXT(p(\\"value\\"),\\"#,###\\"),UPPER(TEXT(p(\\"value\\"), \\"#.##a\\")))","value":"ads_objects.click","showAs":"=\\"number\\"","tooltip":"=TEXT(p(\\"value\\"),\\"#,###\\")","dividedBy":"=100","aggregate.label":"=IF(p(\\"value\\") > 0, IF([\'SUM\', \'AVG\', \'MEDIAN\', \'MIN\', \'MAX\', \'NONE\'].includes(p(\\"aggregate.function\\")) || !p(\\"aggregate.function\\"), TEXT(p(\\"value\\"),\\"#,###\\"), \'\'), \'\')","style.fontWeight":"=500"},"propertyType":"metric","propertyGroup":"","advancedFilter":{"__cfg":"p1352"},"defaultGroupBy":null,"systemSettings":{},"initColumnWidth":"120","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","initGroupColumnWidth":"160"},"ads_gmv":{"menu":[],"title":"Ads GMV","actions":{"__cfg":"p537"},"useMock":{},"dataType":"float","menuItem":[],"createdAt":1740563938527,"sortField":"ads_objects.ads_gmv","cellFormat":"tractionElasticity","filterField":"ads_objects.ads_gmv","staticValue":{"period":"daily","displayChart":0},"valueGetter":{"label":"=IF(p(\\"value\\")==null,\\"-\\",IF(p(\\"value\\")<1000,CONCATENATE(TEXT(p(\\"value\\"),\\"#,###\\"),\\" \\",p(\\"currency\\")),CONCATENATE(UPPER(TEXT(p(\\"value\\"),\\"#.##a\\")),\\" \\",p(\\"currency\\"))))","value":"ads_objects.ads_gmv","showAs":"=\\"number\\"","tooltip":"=TEXT(p(\\"value\\"),\\"#,###.##\\")","currency":"storefront.currency","dividedBy":"=100","style.fontWeight":"=500"},"propertyType":"metric","propertyGroup":"","advancedFilter":{"__cfg":"p1352"},"defaultGroupBy":null,"systemSettings":{"properties.state":"=IF(p(\\"specialFilters.marketplace.queryValueLabel\\") != \'Rakuten\', \'allow\', \'hidden\')"},"initColumnWidth":"120","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","initGroupColumnWidth":"160"},"keyword":{"menu":[],"title":"Ad placement","actions":[],"useMock":{},"dataType":"string","menuItem":[],"sortField":"ads_campaigns.name","cellFormat":"oneDimension","filterField":"ads_campaigns.name","staticValue":{},"valueGetter":{"id":"ads_campaigns.id","label":"=\\"Auto selected\\"","value":"ads_campaigns.id","status":"=\\"ic/material-symbols:location-on-rounded/\\"","ad_tool":"ads_tool.code","country":"country.code","campaign_id":"ads_campaigns.id","marketplace":"marketplace.code","style.fontWeight":"=500"},"propertyType":"dimension","propertyGroup":"","advancedFilter":{"__cfg":"p1352"},"defaultGroupBy":null,"systemSettings":{},"initColumnWidth":"200","lockColumnWidth":"","selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","initGroupColumnWidth":"200"},"ads_order":{"menu":[],"title":"Ads order","actions":{"__cfg":"p161"},"useMock":{},"dataType":"integer","menuItem":[],"createdAt":1740563938527,"sortField":"ads_objects.ads_order","cellFormat":"tractionElasticity","filterField":"ads_objects.ads_order","staticValue":{"period":"daily","displayChart":0},"valueGetter":{"label":"=IF(p(\\"value\\")<=1000,TEXT(p(\\"value\\"),\\"#,###\\"),UPPER(TEXT(p(\\"value\\"), \\"#.##a\\")))","value":"ads_objects.ads_order","showAs":"=\\"number\\"","tooltip":"=TEXT(p(\\"value\\"),\\"#,###\\")","dividedBy":"=100","aggregate.label":"=IF(p(\\"value\\") > 0, IF([\'SUM\', \'AVG\', \'MEDIAN\', \'MIN\', \'MAX\', \'NONE\'].includes(p(\\"aggregate.function\\")) || !p(\\"aggregate.function\\"), TEXT(p(\\"value\\"),\\"#,###\\"), \'\'), \'\')"},"propertyType":"metric","propertyGroup":"","advancedFilter":{"__cfg":"p1352"},"defaultGroupBy":null,"systemSettings":{"properties.state":"=IF(p(\\"specialFilters.marketplace.queryValueLabel\\") != \'Rakuten\', \'allow\', \'hidden\')"},"initColumnWidth":"120","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","initGroupColumnWidth":"160"},"impressions":{"menu":[],"title":"Impressions","actions":[{"id":"29bbd2d4-d4f0-4e93-aa85-aecbcb6cef92","icon":"calendar2","name":"Change period","category":"period","shortcut":{"key":"impressions","index":0},"sourceType":"table-actions","configuration":{"__cfg":"p111"}}],"useMock":{},"dataType":"integer","menuItem":[],"createdAt":1740563938527,"sortField":"ads_objects.impression","cellFormat":"tractionElasticity","filterField":"ads_objects.impression","staticValue":{"period":"daily","displayChart":0},"valueGetter":{"label":"=IF(p(\\"value\\")<=1000,TEXT(p(\\"value\\"),\\"#,###\\"),UPPER(TEXT(p(\\"value\\"), \\"#.##a\\")))","value":"ads_objects.impression","showAs":"=\\"number\\"","tooltip":"=TEXT(p(\\"value\\"),\\"#,###\\")","dividedBy":"=100","aggregate.label":"=IF(p(\\"value\\") > 0, IF([\'SUM\', \'AVG\', \'MEDIAN\', \'MIN\', \'MAX\', \'NONE\'].includes(p(\\"aggregate.function\\")) || !p(\\"aggregate.function\\"), TEXT(p(\\"value\\",\\"#,###\\"), \'\')))"},"propertyType":"metric","propertyGroup":"","advancedFilter":{"__cfg":"p1352"},"defaultGroupBy":null,"systemSettings":{"properties.state":"=IF(p(\\"specialFilters.marketplace.queryValueLabel\\") != \'Rakuten\', \'allow\', \'hidden\')"},"initColumnWidth":"120","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","
1initGroupColumnWidth":"160"},"object_name":{"menu":[],"title":"Ad object","actions":[],"useMock":{},"dataType":"string","menuItem":[],"sortField":"ads_campaigns.name","cellFormat":"oneDimension","filterField":"ads_campaigns.name","staticValue":{},"valueGetter":{"id":"ads_objects.id","label":"=IF(p(\\"id\\")==null, STYLE(\\"Auto selected\\",\\"#8C98A4\\"), p(\\"value\\"))","value":"ads_objects.name","status":"=IF(p(\\"object_status\\")==\\"ONGOING\\",\\"ic/tabler:circle-filled/mint\\",IF(p(\\"object_status\\")==\\"PAUSED\\",\\"ic/tabler:player-pause/#f0ad4e\\",IF(p(\\"object_status\\")==\\"DRAFT\\",\\"ic/tabler:circle-dashed/gray\\",IF(p(\\"object_status\\")==\\"PUBLISHING\\",\\"ic/tabler:circle-filled/#FFA500\\",\\"ic/tabler:circle-filled/lightgray\\"))))","ad_tool":"ads_tool.code","country":"country.code","campaign_id":"ads_campaigns.id","marketplace":"marketplace.code","exclude_product":"ads_campaigns.campaign_exclude","thumbnail_url":"product.thumbnail_url","avatar":"=IF(p(\\"ads_objects.id\\"), p(\\"thumbnail_url\\"), \\"\\")","object_status":"ads_objects.status"},"propertyType":"dimension","propertyGroup":"","advancedFilter":{"__cfg":"p1352"},"defaultGroupBy":null,"systemSettings":{},"initColumnWidth":"320","lockColumnWidth":"","selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","initGroupColumnWidth":"200"},"aov":{"menu":[],"title":"AOV","actions":[{"id":"29bbd2d4-d4f0-4e93-aa85-aecbcb6cef92","icon":"calendar2","name":"Change period","category":"period","shortcut":{"key":"aov","index":0},"sourceType":"table-actions","configuration":{"__cfg":"p111"}}],"useMock":{},"dataType":"float","menuItem":[],"createdAt":1740563938527,"sortField":"ads_objects.average_order_value","cellFormat":"tractionElasticity","filterField":"ads_objects.average_order_value","staticValue":{"period":"daily","displayChart":0},"valueGetter":{"__cfg":"p969"},"propertyType":"metric","propertyGroup":"","advancedFilter":{"__cfg":"p1352"},"defaultGroupBy":null,"systemSettings":{"properties.state":"=IF(p(\\"specialFilters.marketplace.queryValueLabel\\") != \'Rakuten\', \'allow\', \'hidden\')"},"initColumnWidth":"120","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","initGroupColumnWidth":"160"},"atc_rate":{"menu":[],"title":"ATC rate","actions":[{"id":"29bbd2d4-d4f0-4e93-aa85-aecbcb6cef92","icon":"calendar2","name":"Change period","category":"period","shortcut":{"key":"atc_rate","index":0},"sourceType":"table-actions","configuration":{"__cfg":"p111"}}],"useMock":{},"dataType":"float","menuItem":[],"createdAt":1740563938527,"sortField":"ads_objects.atc_rate","cellFormat":"tractionElasticity","filterField":"ads_objects.atc_rate","staticValue":{"period":"daily","displayChart":0},"valueGetter":{"label":"=IF(p(\\"value\\")==null,\\"-\\",CONCAT(TEXT(p(\\"value\\")*100,\\"#.##\\"), \'%\'))","value":"ads_objects.atc_rate","showAs":"=\\"number\\"","dividedBy":"=100","aggregate.label":"=IF(p(\\"value\\") > 0, IF([\'SUM\', \'AVG\', \'MEDIAN\', \'MIN\', \'MAX\', \'NONE\'].includes(p(\\"aggregate.function\\")) || !p(\\"aggregate.function\\"), CONCAT(TEXT(p(\\"value\\")*100,\\"#.##\\"), \'%\')))"},"propertyType":"metric","propertyGroup":"","advancedFilter":{"__cfg":"p1352"},"defaultGroupBy":null,"systemSettings":{"properties.state":"=IF(p(\\"specialFilters.marketplace.queryValueLabel\\") != \'Rakuten\', \'allow\', \'hidden\')"},"initColumnWidth":"120","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","initGroupColumnWidth":"160"},"ads_items_sold":{"menu":[],"title":"Ads items sold","actions":[{"id":"29bbd2d4-d4f0-4e93-aa85-aecbcb6cef92","icon":"calendar2","name":"Change period","category":"period","shortcut":{"key":"ads_items_sold","index":0},"sourceType":"table-actions","configuration":{"__cfg":"p111"}}],"useMock":{},"dataType":"integer","menuItem":[],"createdAt":1740563938527,"sortField":"ads_objects.ads_item_sold","cellFormat":"tractionElasticity","filterField":"ads_objects.ads_item_sold","staticValue":{"period":"daily","displayChart":0},"valueGetter":{"label":"=IF(p(\\"value\\")<=1000,TEXT(p(\\"value\\"),\\"#,###\\"),UPPER(TEXT(p(\\"value\\"), \\"#.##a\\")))","value":"ads_objects.ads_item_sold","showAs":"=\\"number\\"","tooltip":"=TEXT(p(\\"value\\"),\\"#,###\\")","dividedBy":"=100","aggregate.label":"=IF(p(\\"value\\") > 0, IF([\'SUM\', \'AVG\', \'MEDIAN\', \'MIN\', \'MAX\', \'NONE\'].includes(p(\\"aggregate.function\\")) || !p(\\"aggregate.function\\"), TEXT(p(\\"value\\"),\\"#,###\\"), \'\'), \'\')"},"propertyType":"metric","propertyGroup":"","advancedFilter":{"__cfg":"p1352"},"defaultGroupBy":null,"systemSettings":{"properties.state":"=IF(p(\\"specialFilters.marketplace.queryValueLabel\\") != \'Rakuten\', \'allow\', \'hidden\')"},"initColumnWidth":"120","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","
1initGroupColumnWidth":"160"},"ads_gmv_loss":{"menu":[],"title":"Missed GMV","actions":[],"useMock":{},"dataType":"float","menuItem":[],"createdAt":1773293964834,"sortField":"ads_objects.missed_ads_gmv","cellFormat":"tractionElasticity","filterField":"ads_objects.missed_ads_gmv","staticValue":{"period":"daily","chartStyle":"bar","displayChart":0},"valueGetter":{"lim":"=\\"yes\\"","label":"=IF(p(\\"value\\")==null,\\"-\\",IF(p(\\"value\\")<1000,CONCATENATE(TEXT(p(\\"value\\"),\\"#,###\\"),\\" \\",p(\\"storefront.currency\\")),CONCATENATE(UPPER(TEXT(p(\\"value\\"),\\"#.##a\\")),\\" \\",p(\\"storefront.currency\\"))))","value":"ads_objects.missed_ads_gmv","showAs":"=\\"number\\"","ads_gmv":"ads_objects.ads_gmv","hashtag":"= IF(p(\\"value\\") == \\"\\", \\"\\", \\n CONCATENATE(STYLE(TEXT(p(\\"value\\") / p(\\"ads_gmv\\"), \\"#%\\"),\\"#D4290D\\"), \\" potential uplift\\"))","tooltip":"=TEXT(p(\\"value\\"),\\"#,###.##\\")","currency":"storefront.currency","dividedBy":"=100","style.fontWeight":"=500"},"propertyType":"metric","propertyGroup":"","advancedFilter":[],"defaultGroupBy":null,"systemSettings":{"properties.state":"=IF(USER(\\"userEmail\\").endsWith(\'@epsilo.io\') || (USER(\\"2025_eai1m_redeemed_at\\") && (new Date().getTime() - (USER(\\"2025_eai1m_redeemed_at\\") + \\"000\\")) <= 86400 * 365000), \'allow\', \'hidden\')"},"initColumnWidth":"129","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"Estimated additional Ads GMV an ad campaign might have generated if it hadn\'t run out of budget","defaultCalculated":"","initGroupColumnWidth":""},"ad_live_time":{"menu":[],"title":"Ad live time","actions":[],"useMock":{},"dataType":"integer","menuItem":[],"createdAt":1773293964834,"sortField":"ads_objects.ad_live_time_pct","cellFormat":"tractionElasticity","filterField":"ads_objects.ad_live_time_pct","staticValue":{"period":"daily","chartStyle":"bar","displayChart":1,"value.yAxisID":"1","value2.yAxisID":"1","value2.chartStyle":"line","value2.displayChart":"no"},"valueGetter":{"label":"=IF(p(\\"value\\") == null, \\"-\\", TEXT(p(\\"value\\"), \\"#.##%\\"))","value":"ads_objects.ad_live_time_pct","value2":"ads_objects.ad_live_time","value2.label":"=CONCATENATE((p(\\"value2\\") / (1000 * 60 * 60)).toFixed(1), \\" hours\\")","tractionRangeMax":"=p(\'max\')","tractionRangeMin":"=p(\'min\')-0.1"},"propertyType":"metric","propertyGroup":"","advancedFilter":[],"defaultGroupBy":null,"systemSettings":{"properties.state":"=IF(USER(\\"userEmail\\").endsWith(\'@epsilo.io\') || (USER(\\"2025_eai1m_redeemed_at\\") && (new Date().getTime() - (USER(\\"2025_eai1m_redeemed_at\\") + \\"000\\")) <= 86400 * 365000), \'allow\', \'hidden\')"},"initColumnWidth":"129","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","initGroupColumnWidth":""},"performance_time":{"menu":[],"title":"Performing time","actions":[],"useMock":{},"dataType":"integer","menuItem":[],"createdAt":1773293964834,"sortField":"ads_objects.performance_time_pct","cellFormat":"tractionElasticity","filterField":"ads_objects.performance_time_pct","staticValue":{"period":"daily","chartStyle":"bar","displayChart":0,"value.yAxisID":"1","value2.yAxisID":"1","value2.chartStyle":"line","value2.displayChart":"no"},"valueGetter":{"label":"=IF(p(\\"value\\") == null, \\"-\\", TEXT(p(\\"value\\"), \\"#.##%\\"))","value":"ads_objects.performance_time_pct","value2":"ads_objects.performing_time_ms","value2.label":"=CONCATENATE((p(\\"value2\\") / (1000 * 60 * 60)).toFixed(1), \\" hours\\")","tractionRangeMax":"=p(\'max\')","tractionRangeMin":"=p(\'min\')-0.1"},"propertyType":"metric","propertyGroup":"","advancedFilter":[],"defaultGroupBy":null,"systemSettings":{"properties.state":"=IF(USER(\\"userEmail\\").endsWith(\'@epsilo.io\'), \'allow\', \'hidden\')"},"initColumnWidth":"129","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"Performing time is the percentage of the day when campaign was live and receiving impressions. It excludes periods when the campaign was paused, out of budget, or live but with zero impressions.","defaultCalculated":"","
1initGroupColumnWidth":""},"cost_today":{"menu":[],"title":"Ads spend today","actions":[],"useMock":{},"dataType":"float","menuItem":[],"sortField":"ads_objects_oltp.cost_today","cellFormat":"oneDimension","filterField":"ads_objects_oltp.cost_today","staticValue":{},"valueGetter":{"id":"ads_objects_oltp.cost_today","label":"=IF(p(\\"value\\")==null,\\"-\\",IF(p(\\"value\\")<1000,CONCATENATE(TEXT(p(\\"value\\"),\\"#,###\\"),\\" \\",p(\\"currency\\")),CONCATENATE(UPPER(TEXT(p(\\"value\\"),\\"#.##a\\")),\\" \\",p(\\"currency\\"))))","value":"ads_objects_oltp.cost_today","tooltip":"=IF(p(\\"updated_at\\")==null,\\"\\",CONCATENATE(TEXT(p(\\"updated_at\\"),\\"relative\\")))","currency":"storefront.currency","updated_at":"ads_objects_oltp.cost_today_updated_at"},"propertyType":"attribute","propertyGroup":"","advancedFilter":[],"defaultGroupBy":null,"systemSettings":{"properties.state":"=IF(p(\\"specialFilters.marketplace.queryValueLabel\\") != \'Rakuten\', \'allow\', \'hidden\')"},"initColumnWidth":"120","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","initGroupColumnWidth":"160"},"ads_gmv_today":{"menu":[],"title":"Ads GMV today","actions":[],"useMock":{},"dataType":"float","menuItem":[],"sortField":"ads_objects_oltp.ads_gmv_today","cellFormat":"oneDimension","filterField":"ads_objects_oltp.ads_gmv_today","staticValue":{},"valueGetter":{"id":"ads_objects_oltp.ads_gmv_today","label":"=IF(p(\\"value\\")==null,\\"-\\",IF(p(\\"value\\")<1000,CONCATENATE(TEXT(p(\\"value\\"),\\"#,###\\"),\\" \\",p(\\"currency\\")),CONCATENATE(UPPER(TEXT(p(\\"value\\"),\\"#.##a\\")),\\" \\",p(\\"currency\\"))))","value":"ads_objects_oltp.ads_gmv_today","tooltip":"=IF(p(\\"updated_at\\")==null,\\"\\",CONCATENATE(TEXT(p(\\"updated_at\\"),\\"relative\\")))","currency":"storefront.currency","updated_at":"ads_objects_oltp.ads_gmv_today_updated_at"},"propertyType":"attribute","propertyGroup":"","advancedFilter":[],"defaultGroupBy":null,"systemSettings":{"properties.state":"=IF(p(\\"specialFilters.marketplace.queryValueLabel\\") != \'Rakuten\', \'allow\', \'hidden\')"},"initColumnWidth":"120","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","initGroupColumnWidth":"160"},"roas_today":{"menu":[],"title":"ROAS today","actions":[],"useMock":{},"dataType":"float","menuItem":[],"createdAt":1734604516699,"sortField":"ads_objects_oltp.roas_today","cellFormat":"oneDimension","filterField":"ads_objects_oltp.roas_today","staticValue":{},"valueGetter":{"id":"ads_objects_oltp.roas_today","label":"=IF(p(\\"value\\") == null, \\"-\\", CONCATENATE(TEXT(p(\\"value\\"), \'#,###.##\'),\\"x\\"))","value":"ads_objects_oltp.roas_today","tooltip":"=IF(p(\\"updated_at\\")==null,\\"\\",CONCATENATE(TEXT(p(\\"updated_at\\"),\\"relative\\")))","updated_at":"ads_campaigns_oltp.ads_gmv_today_updated_at","aggregate.label":"=IF(p(\\"value\\") > 0, IF([\'SUM\', \'AVG\', \'MEDIAN\', \'MIN\', \'MAX\', \'NONE\'].includes(p(\\"aggregate.function\\")) || !p(\\"aggregate.function\\"), CONCATENATE(TEXT(p(\\"value\\"), \'#,###.##\'),\\"x\\"), \'\'))"},"propertyType":"attribute","propertyGroup":"","advancedFilter":[],"defaultGroupBy":null,"systemSettings":{"properties.state":"=IF(p(\\"specialFilters.marketplace.queryValueLabel\\") != \'Rakuten\', \'allow\', \'hidden\')"},"initColumnWidth":"120","lockColumnWidth":1,"selectionFilter":null,"pivotColumnWidth":"","columnDescription":"","defaultCalculated":"","initGroupColumnWidth":"160"}}}')}}}}]);
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.