COVID-19 Diagnostic Dashboard

COVID-19 Diagnostic dashboard shows you how your campaigns and conversions perform during the lockdown. Most importantly, the dashboard includes:

  • Trending purchases during the lockdown
  • Trending categories
  • Best converting products during the lockdown
  • Best converting categories during the lockdown

Moreover, it shows you comparisons of your pre-lockdown and current:

  • Revenue
  • Purchases
  • Sessions
  • Campaign pen-rate
  • Unsubscribe rate
1440

Importing the package

In order to import the package, copy the following JSON code into a text file and import it following the guide in the Initiatives article.

{"files":[],"initiative":{"archived":false,"cloned_from_id":"5e45757caac8a93726e50e45","color":"rgb(150, 217, 43)","description":"See how COVID19 situation is impacting your business and specific products","name":"CV19 Diagnostic Dashboard","pinned":false,"prevent_archivation":false},"items":[{"data":{"all_exposing_properties":[],"archived":false,"client":{"chart_type":"column","color_theme":0,"display":"table","items_per_page":50,"order_column":2,"order_direction":"desc","page":1,"report_type":"report","series_settings":[]},"cloned_from_id":"5e457c11599faa5720d89333","description":null,"is_global_object":false,"name":"Trending purchases during lockdown","prevent_archivation":false,"server":{"attributes_use_global_events":false,"columns":[],"customer_filter":{"filters":[],"formula":""},"event_filters":{"attributes":[{"filter":[],"type":"purchase_item"}],"date":{"absolute":null,"duration":null,"enabled":false,"from_date":null,"offset":null,"to_date":null}},"metrics":[{"_id":null,"event_types":null,"format":"round(0)","formula":"A","is_formula":false,"members":[{"aggregation":"count","attribute":null,"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":false,"duration":{"count":7,"units":"days"},"enabled":true,"from_date":null,"offset":{"count":1,"units":"days"},"to_date":null},"event":{"filter":[],"type":"purchase_item"},"name":"count(view_item)","occurrence_per_customer":"last","type":"event"}],"modifiers":{"display":"default","summarize":{"average":false,"max":false,"min":false,"stddev":false,"sum":false,"variance":false},"visualization":{"type":"default"}},"name":"This week","type":"embedded_metric","value_filter":{"filters":[{"operands":[10],"operator":"greater than"}],"formula":"F0"}},{"_id":null,"event_types":null,"format":"percent","formula":"((A/B)-C)*D","is_formula":true,"members":[{"aggregation":"count","attribute":null,"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":false,"duration":{"count":7,"units":"days"},"enabled":true,"from_date":null,"offset":{"count":1,"units":"days"},"to_date":null},"event":{"filter":[],"type":"purchase_item"},"name":"This week buyers","occurrence_per_customer":"last","type":"event"},{"aggregation":"count","attribute":null,"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":true,"duration":null,"enabled":true,"from_date":1583017200,"offset":null,"to_date":1583621999},"event":{"filter":[],"type":"purchase_item"},"name":"1st week of March","occurrence_per_customer":"last","type":"event"},{"converted_value":1,"is_constant":true,"type":"constant","value":1},{"converted_value":100,"is_constant":true,"type":"constant","value":100}],"modifiers":{"display":"default","summarize":{"average":false,"max":false,"min":false,"stddev":false,"sum":false,"variance":false},"visualization":{"type":"default"}},"name":"Change vs pre-lockdown","type":"embedded_metric","value_filter":{"filters":[],"formula":""}}],"rows":[{"attribute":{"property":"title","type":"property"},"event_type":"purchase_item","expand_lists":false,"format":"none","grouping":{"ascending":false,"number":20,"type":"top"},"hide_null":true,"modifiers":[],"name":null,"type":"event"}]},"show_description_in_view":false,"tags":[]},"id":"5e7e767abc28383025f12b27","type":"report"},{"data":{"aggregation":"count_distinct","all_exposing_properties":[],"archived":false,"attribute":{"property":"action_id","type":"property"},"cloned_from_id":null,"date_filter":{"absolute":false,"duration":{"count":7,"units":"days"},"enabled":true,"from_date":null,"offset":null,"to_date":null},"description":null,"event":{"filter":[{"attribute":{"property":"action_type","type":"property"},"constraint":{"operands":[{"type":"constant","value":"email"}],"operator":"equals","type":"string"}},{"attribute":{"property":"status","type":"property"},"constraint":{"operands":[{"type":"constant","value":"delivered"}],"operator":"equals","type":"string"}}],"type":"campaign"},"exposing_properties":null,"format":"number","independent_if_reused":true,"is_global_object":false,"max_values":1,"name":"Delivered emails last 7d","prevent_archivation":false,"show_description_in_view":false,"skip":0,"tags":[],"type":"count_distinct"},"id":"5e850a56e09124f934ddbcef","type":"aggregate"},{"data":{"all_exposing_properties":[],"archived":false,"client":{"chart_type":"column","color_theme":0,"display":"table","items_per_page":50,"order_column":2,"order_direction":"desc","page":1,"report_type":"report","series_settings":[]},"cloned_from_id":"5e457be13eb530c1bf42d674","description":null,"is_global_object":false,"name":"Trending categories","prevent_archivation":false,"server":{"attributes_use_global_events":false,"columns":[],"customer_filter":{"filters":[],"formula":""},"event_filters":{"attributes":[{"filter":[],"type":"purchase_item"}],"date":{"absolute":null,"duration":null,"enabled":false,"from_date":null,"offset":null,"to_date":null}},"metrics":[{"_id":null,"event_types":null,"format":"round(0)","formula":"A","is_formula":false,"members":[{"aggregation":"count","attribute":null,"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":false,"duration":{"count":7,"units":"days"},"enabled":true,"from_date":null,"offset":{"count":1,"units":"days"},"to_date":null},"event":{"filter":[],"type":"purchase_item"},"name":"count(view_item)","occurrence_per_customer":"last","type":"event"}],"modifiers":{"display":"default","summarize":{"average":false,"max":false,"min":false,"stddev":false,"sum":false,"variance":false},"visualization":{"type":"default"}},"name":"This week viewers","type":"embedded_metric","value_filter":{"filters":[],"formula":""}},{"_id":null,"event_types":null,"format":"percent","formula":"((A/B)-C)*D","is_formula":true,"members":[{"aggregation":"count","attribute":null,"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":false,"duration":{"count":7,"units":"days"},"enabled":true,"from_date":null,"offset":{"count":1,"units":"days"},"to_date":null},"event":{"filter":[],"type":"purchase_item"},"name":"This week viewers","occurrence_per_customer":"last","type":"event"},{"aggregation":"count","attribute":null,"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":true,"duration":null,"enabled":true,"from_date":1583017200,"offset":null,"to_date":1583621999},"event":{"filter":[],"type":"purchase_item"},"name":"March 1st week","occurrence_per_customer":"last","type":"event"},{"converted_value":1,"is_constant":true,"type":"constant","value":1},{"converted_value":100,"is_constant":true,"type":"constant","value":100}],"modifiers":{"display":"default","summarize":{"average":false,"max":false,"min":false,"stddev":false,"sum":false,"variance":false},"visualization":{"type":"default"}},"name":"Increase vs last week","type":"embedded_metric","value_filter":{"filters":[],"formula":""}}],"rows":[{"attribute":{"property":"category_2","type":"property"},"event_type":"purchase_item","expand_lists":false,"format":"none","grouping":{"ascending":false,"number":10,"type":"top"},"hide_null":true,"modifiers":[],"name":null,"type":"event"}]},"show_description_in_view":false,"tags":[]},"id":"5e7e767abc28383025f12b21","type":"report"},{"data":{"ab_test":[],"all_exposing_properties":[],"archived":false,"cloned_from_id":"5e457545e1990baf085ff85f","customer_filter":{"filters":[],"formula":""},"description":null,"drill_down":{"attribute":{"property":"category_1","type":"property"},"format":"none","max_branches":50,"max_per_customer":20,"step":0,"type":"step"},"format":"value","funnel_steps":{"date_filter":{"absolute":false,"duration":{"count":7,"units":"days"},"enabled":true,"from_date":null,"offset":null,"to_date":null},"duration_filter":{"duration":{"count":12,"units":"hours"},"enabled":true},"independent_if_reused":true,"steps":[{"filter":[{"attribute":{"property":"category_1","type":"property"},"constraint":{"operands":[{"type":"constant","value":""}],"operator":"has value","type":"string"}}],"name":"view_item","type":"view_item"},{"filter":[],"name":"purchase","type":"purchase"}]},"is_global_object":false,"metric":null,"name":"Best converting categories during lockdown","order":{"column":1,"direction":"desc"},"prevent_archivation":false,"show_description_in_view":false,"shown_drilled_series":["Shoes"],"tags":[],"total_shown":true},"id":"5e7e767abc28383025f12b1b","type":"funnel"},{"data":{"aggregation":"count_distinct","all_exposing_properties":[],"archived":false,"attribute":{"property":"action_id","type":"property"},"cloned_from_id":null,"date_filter":{"absolute":false,"duration":{"count":7,"units":"days"},"enabled":true,"from_date":null,"offset":null,"to_date":null},"description":null,"event":{"filter":[{"attribute":{"property":"action_type","type":"property"},"constraint":{"operands":[{"type":"constant","value":"email"}],"operator":"equals","type":"string"}},{"attribute":{"property":"status","type":"property"},"constraint":{"operands":[{"type":"constant","value":"opened"}],"operator":"equals","type":"string"}}],"type":"campaign"},"exposing_properties":null,"format":"number","independent_if_reused":true,"is_global_object":false,"max_values":1,"name":"Opened emails last 7d","prevent_archivation":false,"show_description_in_view":false,"skip":0,"tags":[],"type":"count_distinct"},"id":"5e850a63afc47153a2c646a4","type":"aggregate"},{"data":{"all_exposing_properties":[],"archived":false,"client":{"chart_type":"line","color_theme":0,"display":"both","items_per_page":50,"order_column":null,"order_direction":"","page":1,"report_type":"report","series_settings":[{"index":1,"label":null,"type":null,"y_axis":1}]},"cloned_from_id":null,"description":null,"is_global_object":false,"name":"Sessions & Purchases","prevent_archivation":false,"server":{"attributes_use_global_events":true,"columns":[],"customer_filter":{"filters":[],"formula":""},"event_filters":{"attributes":[{"filter":[],"type":"session_start"},{"filter":[],"type":"purchase"},{"filter":[],"type":"merge"},{"filter":[],"type":"consent"},{"filter":[],"type":"ab test"},{"filter":[],"type":"checkout"},{"filter":[],"type":"bandit_helper"},{"filter":[],"type":"experiment"},{"filter":[],"type":"order_update"},{"filter":[],"type":"sold_out_item"},{"filter":[],"type":"double_opt_in"},{"filter":[],"type":"update_cart"},{"filter":[],"type":"campaign"},{"filter":[],"type":"bandit_decision"},{"filter":[],"type":"session_end"},{"filter":[],"type":"page_visit"},{"filter":[],"type":"bandits"},{"filter":[],"type":"pw_reset"},{"filter":[],"type":"invalid_contact"},{"filter":[],"type":"score"},{"filter":[],"type":"click"},{"filter":[],"type":"first_session"},{"filter":[],"type":"order_complete"},{"filter":[],"type":"view_size_table"},{"filter":[],"type":"fail"},{"filter":[],"type":"view_item"},{"filter":[],"type":"t_info"},{"filter":[],"type":"wh_update_item"},{"filter":[],"type":"add_to_wishlist"},{"filter":[],"type":"purchase_be"},{"filter":[],"type":"cart_update"},{"filter":[],"type":"outfit"},{"filter":[],"type":"recommendation"},{"filter":[],"type":"view_category"},{"filter":[],"type":"legitimate interest"},{"filter":[],"type":"bandit"},{"filter":[],"type":"purchase_item"},{"filter":[],"type":"registration"},{"filter":[],"type":"wheelOfFortune"},{"filter":[],"type":"watchdog_item_in_stock"},{"filter":[],"type":"banner"},{"filter":[],"type":"wh_update"},{"filter":[],"type":"landing_page"}],"date":{"absolute":true,"duration":null,"enabled":true,"from_date":1582758000,"offset":null,"to_date":null}},"metrics":[{"_id":null,"event_types":null,"format":"round(2)","formula":"A","is_formula":false,"members":[{"aggregation":"count","attribute":null,"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":false,"duration":{"count":30,"units":"days"},"enabled":false,"from_date":null,"offset":null,"to_date":null},"event":{"filter":[],"type":"session_start"},"name":"count(session_start)","occurrence_per_customer":"all","type":"event"}],"modifiers":{"display":"default","summarize":{"average":false,"max":false,"min":false,"stddev":false,"sum":false,"variance":false},"visualization":{"type":"default"}},"name":"Sessions","type":"embedded_metric","value_filter":{"filters":[],"formula":""}},{"_id":null,"event_types":null,"format":"round(2)","formula":"A","is_formula":false,"members":[{"aggregation":"count","attribute":null,"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":false,"duration":{"count":30,"units":"days"},"enabled":false,"from_date":null,"offset":null,"to_date":null},"event":{"filter":[],"type":"purchase"},"name":"count(purchase)","occurrence_per_customer":"all","type":"event"}],"modifiers":{"display":"default","summarize":{"average":false,"max":false,"min":false,"stddev":false,"sum":false,"variance":false},"visualization":{"type":"default"}},"name":"Purchases","type":"embedded_metric","value_filter":{"filters":[],"formula":""}}],"rows":[{"attribute":{"type":"timestamp"},"event_type":null,"expand_lists":false,"format":"year month day","grouping":{"type":"none"},"hide_null":true,"modifiers":[],"name":null,"type":"event"}]},"show_description_in_view":false,"tags":[]},"id":"5e7e77ef5a6a44fa0539e50a","type":"report"},{"data":{"all_exposing_properties":[],"archived":false,"cloned_from_id":null,"description":null,"event_types":["purchase"],"format":"percent","formula":"(A-B)/C","is_formula":true,"is_global_object":false,"members":[{"aggregation":"sum","attribute":{"property":"total_price","type":"property"},"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":false,"duration":{"count":7,"units":"days"},"enabled":true,"from_date":null,"offset":null,"to_date":null},"event":{"filter":[{"attribute":{"property":"purchase_status","type":"property"},"constraint":{"operands":[{"type":"constant","value":"success"}],"operator":"equals","type":"string"}},{"attribute":{"property":"total_price","type":"property"},"constraint":{"operands":[{"type":"constant","value":"0"}],"operator":"greater than","type":"number"}}],"type":"purchase"},"name":"Last 7d","occurrence_per_customer":"all","type":"event"},{"aggregation":"sum","attribute":{"property":"total_price","type":"property"},"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":true,"duration":null,"enabled":true,"from_date":1583017200,"offset":null,"to_date":1583621999},"event":{"filter":[{"attribute":{"property":"purchase_status","type":"property"},"constraint":{"operands":[{"type":"constant","value":"success"}],"operator":"equals","type":"string"}},{"attribute":{"property":"total_price","type":"property"},"constraint":{"operands":[{"type":"constant","value":"0"}],"operator":"greater than","type":"number"}}],"type":"purchase"},"name":"1st week of March","occurrence_per_customer":"all","type":"event"},{"aggregation":"sum","attribute":{"property":"total_price","type":"property"},"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":true,"duration":null,"enabled":true,"from_date":1583017200,"offset":null,"to_date":1583621999},"event":{"filter":[{"attribute":{"property":"total_price","type":"property"},"constraint":{"operands":[{"type":"constant","value":"0"}],"operator":"greater than","type":"number"}},{"attribute":{"property":"purchase_status","type":"property"},"constraint":{"operands":[{"type":"constant","value":"success"}],"operator":"equals","type":"string"}}],"type":"purchase"},"name":"1st week of March","occurrence_per_customer":"all","type":"event"}],"name":"Change vs pre-lockdown","prevent_archivation":false,"show_description_in_view":false,"tags":[]},"id":"5e7e7cedd4bfbb42d875b9cb","type":"metric"},{"data":{"all_exposing_properties":[],"archived":false,"cloned_from_id":null,"description":null,"event_types":["session_start"],"format":"round(0)","formula":"A","is_formula":false,"is_global_object":false,"members":[{"aggregation":"count","attribute":null,"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":false,"duration":{"count":30,"units":"days"},"enabled":false,"from_date":null,"offset":null,"to_date":null},"event":{"filter":[],"type":"session_start"},"name":"count(session_start)","occurrence_per_customer":"first","type":"event"}],"name":"7d unique sessions","prevent_archivation":false,"show_description_in_view":false,"tags":[]},"id":"5e7e7d4adc48ff319952ef2c","type":"metric"},{"data":{"aggregation":"count_distinct","all_exposing_properties":[],"archived":false,"attribute":{"property":"action_id","type":"property"},"cloned_from_id":null,"date_filter":{"absolute":false,"duration":{"count":7,"units":"days"},"enabled":true,"from_date":null,"offset":null,"to_date":null},"description":null,"event":{"filter":[{"attribute":{"property":"action_type","type":"property"},"constraint":{"operands":[{"type":"constant","value":"email"}],"operator":"equals","type":"string"}},{"attribute":{"property":"status","type":"property"},"constraint":{"operands":[{"type":"constant","value":"clicked"}],"operator":"equals","type":"string"}}],"type":"campaign"},"exposing_properties":null,"format":"number","independent_if_reused":true,"is_global_object":false,"max_values":1,"name":"Clicked emails last 7d","prevent_archivation":false,"show_description_in_view":false,"skip":0,"tags":[],"type":"count_distinct"},"id":"5e850d5aee146e8995d9b778","type":"aggregate"},{"data":{"aggregation":"count_distinct","all_exposing_properties":[],"archived":false,"attribute":{"property":"action_id","type":"property"},"cloned_from_id":null,"date_filter":{"absolute":true,"duration":null,"enabled":true,"from_date":1583017200,"offset":null,"to_date":1583621999},"description":null,"event":{"filter":[{"attribute":{"property":"action_type","type":"property"},"constraint":{"operands":[{"type":"constant","value":"email"}],"operator":"equals","type":"string"}},{"attribute":{"property":"status","type":"property"},"constraint":{"operands":[{"type":"constant","value":"clicked"}],"operator":"equals","type":"string"}}],"type":"campaign"},"exposing_properties":null,"format":"number","independent_if_reused":true,"is_global_object":false,"max_values":1,"name":"Clicked emails March 1st week","prevent_archivation":false,"show_description_in_view":false,"skip":0,"tags":[],"type":"count_distinct"},"id":"5e850d68273842f70565f9a3","type":"aggregate"},{"data":{"all_exposing_properties":[],"archived":false,"cloned_from_id":null,"description":null,"event_types":["purchase"],"format":"percent","formula":"((A-B)/C)*D","is_formula":true,"is_global_object":false,"members":[{"aggregation":"count","attribute":null,"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":false,"duration":{"count":7,"units":"days"},"enabled":true,"from_date":null,"offset":null,"to_date":null},"event":{"filter":[{"attribute":{"property":"purchase_status","type":"property"},"constraint":{"operands":[{"type":"constant","value":"success"}],"operator":"equals","type":"string"}}],"type":"purchase"},"name":"Last 7d purchases","occurrence_per_customer":"all","type":"event"},{"aggregation":"count","attribute":null,"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":true,"duration":null,"enabled":true,"from_date":1583017200,"offset":null,"to_date":1583621999},"event":{"filter":[{"attribute":{"property":"purchase_status","type":"property"},"constraint":{"operands":[{"type":"constant","value":"success"}],"operator":"equals","type":"string"}}],"type":"purchase"},"name":"1st week of March","occurrence_per_customer":"all","type":"event"},{"aggregation":"count","attribute":null,"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":true,"duration":null,"enabled":true,"from_date":1583017200,"offset":null,"to_date":1583621999},"event":{"filter":[{"attribute":{"property":"purchase_status","type":"property"},"constraint":{"operands":[{"type":"constant","value":"success"}],"operator":"equals","type":"string"}}],"type":"purchase"},"name":"1st week of March","occurrence_per_customer":"all","type":"event"},{"converted_value":100,"is_constant":true,"type":"constant","value":100}],"name":"Change vs pre-lockdown","prevent_archivation":false,"show_description_in_view":false,"tags":[]},"id":"5e7e7bf086fea23831ba018f","type":"metric"},{"data":{"aggregation":"count_distinct","all_exposing_properties":[],"archived":false,"attribute":{"property":"action_id","type":"property"},"cloned_from_id":null,"date_filter":{"absolute":true,"duration":null,"enabled":true,"from_date":1583017200,"offset":null,"to_date":1583621999},"description":null,"event":{"filter":[{"attribute":{"property":"action_type","type":"property"},"constraint":{"operands":[{"type":"constant","value":"email"}],"operator":"equals","type":"string"}},{"attribute":{"property":"status","type":"property"},"constraint":{"operands":[{"type":"constant","value":"delivered"}],"operator":"equals","type":"string"}}],"type":"campaign"},"exposing_properties":null,"format":"number","independent_if_reused":true,"is_global_object":false,"max_values":1,"name":"Delivered emails March 1st week","prevent_archivation":false,"show_description_in_view":false,"skip":0,"tags":[],"type":"count_distinct"},"id":"5e850ab8b9fc1d8cd0fa1453","type":"aggregate"},{"data":{"aggregation":"count_distinct","all_exposing_properties":[],"archived":false,"attribute":{"property":"action_id","type":"property"},"cloned_from_id":null,"date_filter":{"absolute":true,"duration":null,"enabled":true,"from_date":1583017200,"offset":null,"to_date":1583621999},"description":null,"event":{"filter":[{"attribute":{"property":"action_type","type":"property"},"constraint":{"operands":[{"type":"constant","value":"email"}],"operator":"equals","type":"string"}},{"attribute":{"property":"status","type":"property"},"constraint":{"operands":[{"type":"constant","value":"opened"}],"operator":"equals","type":"string"}}],"type":"campaign"},"exposing_properties":null,"format":"number","independent_if_reused":true,"is_global_object":false,"max_values":1,"name":"Opened emails March 1st week","prevent_archivation":false,"show_description_in_view":false,"skip":0,"tags":[],"type":"count_distinct"},"id":"5e850aabf537b062172d8a2f","type":"aggregate"},{"data":{"all_exposing_properties":[],"archived":false,"cloned_from_id":null,"description":null,"event_types":["purchase"],"format":"round(0)","formula":"A","is_formula":false,"is_global_object":false,"members":[{"aggregation":"count","attribute":null,"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":null,"duration":null,"enabled":false,"from_date":null,"offset":null,"to_date":null},"event":{"filter":[{"attribute":{"property":"purchase_status","type":"property"},"constraint":{"operands":[{"type":"constant","value":"success"}],"operator":"equals","type":"string"}}],"type":"purchase"},"name":"count(purchase)","occurrence_per_customer":"all","type":"event"}],"name":"7d purchases","prevent_archivation":false,"show_description_in_view":false,"tags":[]},"id":"5e7e79bc2e1828ca6ceddbbf","type":"metric"},{"data":{"all_exposing_properties":[],"archived":false,"cloned_from_id":null,"description":null,"event_types":["session_start"],"format":"percent","formula":"(A-B)/C","is_formula":true,"is_global_object":false,"members":[{"aggregation":"count","attribute":null,"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":false,"duration":{"count":7,"units":"days"},"enabled":true,"from_date":null,"offset":null,"to_date":null},"event":{"filter":[],"type":"session_start"},"name":"Last 7d","occurrence_per_customer":"first","type":"event"},{"aggregation":"count","attribute":null,"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":true,"duration":null,"enabled":true,"from_date":1583017200,"offset":null,"to_date":1583621999},"event":{"filter":[],"type":"session_start"},"name":"1st week of March","occurrence_per_customer":"first","type":"event"},{"aggregation":"count","attribute":null,"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":true,"duration":null,"enabled":true,"from_date":1583017200,"offset":null,"to_date":1583621999},"event":{"filter":[],"type":"session_start"},"name":"1st week of March","occurrence_per_customer":"first","type":"event"}],"name":"Change vs pre-lockdown","prevent_archivation":false,"show_description_in_view":false,"tags":[]},"id":"5e7e7d9f70e62cb7f66a13a8","type":"metric"},{"data":{"all_exposing_properties":[],"archived":false,"cloned_from_id":null,"description":null,"event_types":["purchase"],"format":"round(0)","formula":"A","is_formula":false,"is_global_object":false,"members":[{"aggregation":"sum","attribute":{"property":"total_price","type":"property"},"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":null,"duration":null,"enabled":false,"from_date":null,"offset":null,"to_date":null},"event":{"filter":[{"attribute":{"property":"total_price","type":"property"},"constraint":{"operands":[{"type":"constant","value":"0"}],"operator":"greater than","type":"number"}},{"attribute":{"property":"purchase_status","type":"property"},"constraint":{"operands":[{"type":"constant","value":"success"}],"operator":"equals","type":"string"}}],"type":"purchase"},"name":"sum(purchase.total_price)","occurrence_per_customer":"all","type":"event"}],"name":"7d revenue","prevent_archivation":false,"show_description_in_view":false,"tags":[]},"id":"5e7e7a75c122fee36d097c67","type":"metric"},{"data":{"ab_test":[],"all_exposing_properties":[],"archived":false,"cloned_from_id":"5e457534cbb085a75dc7d23a","customer_filter":{"filters":[],"formula":""},"description":null,"drill_down":{"attribute":{"property":"title","type":"property"},"format":"none","max_branches":50,"max_per_customer":20,"step":0,"type":"step"},"format":"value","funnel_steps":{"date_filter":{"absolute":false,"duration":{"count":7,"units":"days"},"enabled":true,"from_date":null,"offset":null,"to_date":null},"duration_filter":{"duration":{"count":12,"units":"hours"},"enabled":true},"independent_if_reused":true,"steps":[{"filter":[{"attribute":{"property":"title","type":"property"},"constraint":{"operands":[{"type":"constant","value":""}],"operator":"has value","type":"string"}}],"name":"view_item","type":"view_item"},{"filter":[],"name":"purchase","type":"purchase"}]},"is_global_object":false,"metric":null,"name":"Best converting products during lockdown","order":{"column":1,"direction":"desc"},"prevent_archivation":false,"show_description_in_view":false,"shown_drilled_series":["Nike Manteau d'Hiver Academy 18 - Noir/Blanc","Nike Trainingsbroek Tech Fleece - Zwart","Nike Manteau d'Hiver Academy 18 - Noir/Blanc Enfant","Nike Mercurial Vapor 13 Elite FG Under The Radar - Sort/Sølv","Nike Trainingsbroek Tech Fleece - Grijs","Nike Joggebukse Tech Fleece - Grå","Nike Hoodie NSW Tech Fleece - Zwart","Nike Mercurial Vapor 13 Elite FG New Lights - Blue Hero/White","Sverige Hemmatröja 2020/21","Nike Joggebukse Tech Fleece - Sort"],"tags":[],"total_shown":true},"id":"5e7e767abc28383025f12b15","type":"funnel"},{"data":{"all_exposing_properties":[],"archived":false,"cloned_from_id":null,"description":null,"event_types":[],"format":"percent","formula":"(A/B)*C","is_formula":true,"is_global_object":false,"members":[{"aggregation":"sum","attribute":{"id":"5e850d5aee146e8995d9b778","type":"aggregate"},"customer_filter":{"filters":[],"formula":""},"name":"Delivered","type":"customer"},{"aggregation":"sum","attribute":{"id":"5e850a63afc47153a2c646a4","type":"aggregate"},"customer_filter":{"filters":[],"formula":""},"name":"Opened","type":"customer"},{"converted_value":100,"is_constant":true,"type":"constant","value":100}],"name":"CTR","prevent_archivation":false,"show_description_in_view":false,"tags":[]},"id":"5e850d9e3d6c6411f2c6bb08","type":"metric"},{"data":{"all_exposing_properties":[],"archived":false,"cloned_from_id":null,"description":null,"event_types":[],"format":"percent","formula":"(A/B)*C","is_formula":true,"is_global_object":false,"members":[{"aggregation":"sum","attribute":{"id":"5e850d68273842f70565f9a3","type":"aggregate"},"customer_filter":{"filters":[],"formula":""},"name":"sum(Clicked emails March 1st week)","type":"customer"},{"aggregation":"sum","attribute":{"id":"5e850aabf537b062172d8a2f","type":"aggregate"},"customer_filter":{"filters":[],"formula":""},"name":"sum(Opened emails March 1st week)","type":"customer"},{"converted_value":100,"is_constant":true,"type":"constant","value":100}],"name":"Pre-lockdown CTR","prevent_archivation":false,"show_description_in_view":false,"tags":[]},"id":"5e850dd4151c63d215772fa6","type":"metric"},{"data":{"all_exposing_properties":[],"archived":false,"cloned_from_id":null,"description":null,"event_types":[],"format":"percent","formula":"(A/B)*C","is_formula":true,"is_global_object":false,"members":[{"aggregation":"sum","attribute":{"id":"5e850aabf537b062172d8a2f","type":"aggregate"},"customer_filter":{"filters":[],"formula":""},"name":"sum(Opened emails March 1st week)","type":"customer"},{"aggregation":"sum","attribute":{"id":"5e850ab8b9fc1d8cd0fa1453","type":"aggregate"},"customer_filter":{"filters":[],"formula":""},"name":"sum(Delivered emails March 1st week)","type":"customer"},{"converted_value":100,"is_constant":true,"type":"constant","value":100}],"name":"Pre-lockdown open rate","prevent_archivation":false,"show_description_in_view":false,"tags":[]},"id":"5e8497f51fabe3adfe2b623f","type":"metric"},{"data":{"all_exposing_properties":[],"archived":false,"cloned_from_id":null,"description":null,"event_types":["consent"],"format":"percent","formula":"(A/B)*C","is_formula":true,"is_global_object":false,"members":[{"aggregation":"count","attribute":null,"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":false,"duration":{"count":7,"units":"days"},"enabled":true,"from_date":null,"offset":null,"to_date":null},"event":{"filter":[{"attribute":{"property":"action","type":"property"},"constraint":{"operands":[{"type":"constant","value":"reject"}],"operator":"equals","type":"string"}}],"type":"consent"},"name":"count(consent)","occurrence_per_customer":"first","type":"event"},{"aggregation":"sum","attribute":{"id":"5e850a56e09124f934ddbcef","type":"aggregate"},"customer_filter":{"filters":[],"formula":""},"name":"sum(Delivered emails last 7d)","type":"customer"},{"converted_value":100,"is_constant":true,"type":"constant","value":100}],"name":"Unsubscribe rate","prevent_archivation":false,"show_description_in_view":false,"tags":[]},"id":"5e8510aa34f9f60d8d677d05","type":"metric"},{"data":{"all_exposing_properties":[],"archived":false,"cloned_from_id":null,"description":null,"event_types":["consent"],"format":"percent","formula":"(A/B)*C","is_formula":true,"is_global_object":false,"members":[{"aggregation":"count","attribute":null,"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":true,"duration":null,"enabled":true,"from_date":1583017200,"offset":null,"to_date":1583621999},"event":{"filter":[{"attribute":{"property":"action","type":"property"},"constraint":{"operands":[{"type":"constant","value":"reject"}],"operator":"equals","type":"string"}}],"type":"consent"},"name":"count(consent)","occurrence_per_customer":"first","type":"event"},{"aggregation":"sum","attribute":{"id":"5e850ab8b9fc1d8cd0fa1453","type":"aggregate"},"customer_filter":{"filters":[],"formula":""},"name":"sum(Delivered emails March 1st week)","type":"customer"},{"converted_value":100,"is_constant":true,"type":"constant","value":100}],"name":"Pre-lockdown unsubscribe rate","prevent_archivation":false,"show_description_in_view":false,"tags":[]},"id":"5e851111a6203edc345faa82","type":"metric"},{"data":{"all_exposing_properties":[],"archived":false,"cloned_from_id":null,"description":null,"event_types":[],"format":"percent","formula":"(A/B)*C","is_formula":true,"is_global_object":false,"members":[{"aggregation":"sum","attribute":{"id":"5e850a63afc47153a2c646a4","type":"aggregate"},"customer_filter":{"filters":[],"formula":""},"name":"Opened","type":"customer"},{"aggregation":"sum","attribute":{"id":"5e850a56e09124f934ddbcef","type":"aggregate"},"customer_filter":{"filters":[],"formula":""},"name":"Delivered","type":"customer"},{"converted_value":100,"is_constant":true,"type":"constant","value":100}],"name":"Open rate","prevent_archivation":false,"show_description_in_view":false,"tags":[]},"id":"5e849679e980835d017c3287","type":"metric"},{"data":{"all_exposing_properties":[],"archived":false,"client":{"chart_type":"column","color_theme":0,"display":"table","items_per_page":50,"order_column":2,"order_direction":"asc","page":1,"report_type":"report","series_settings":[]},"cloned_from_id":"5e457c11599faa5720d89333","description":null,"is_global_object":false,"name":"Decreasing purchases during lockdown","prevent_archivation":false,"server":{"attributes_use_global_events":false,"columns":[],"customer_filter":{"filters":[],"formula":""},"event_filters":{"attributes":[{"filter":[],"type":"purchase_item"}],"date":{"absolute":null,"duration":null,"enabled":false,"from_date":null,"offset":null,"to_date":null}},"metrics":[{"_id":null,"event_types":null,"format":"round(0)","formula":"A","is_formula":false,"members":[{"aggregation":"count","attribute":null,"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":false,"duration":{"count":7,"units":"days"},"enabled":true,"from_date":null,"offset":{"count":1,"units":"days"},"to_date":null},"event":{"filter":[],"type":"purchase_item"},"name":"count(view_item)","occurrence_per_customer":"last","type":"event"}],"modifiers":{"display":"default","summarize":{"average":false,"max":false,"min":false,"stddev":false,"sum":false,"variance":false},"visualization":{"type":"default"}},"name":"This week","type":"embedded_metric","value_filter":{"filters":[],"formula":""}},{"_id":null,"event_types":null,"format":"percent","formula":"((A/B)-C)*D","is_formula":true,"members":[{"aggregation":"count","attribute":null,"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":false,"duration":{"count":7,"units":"days"},"enabled":true,"from_date":null,"offset":{"count":1,"units":"days"},"to_date":null},"event":{"filter":[],"type":"purchase_item"},"name":"This week buyers","occurrence_per_customer":"last","type":"event"},{"aggregation":"count","attribute":null,"customer_filter":{"filters":[],"formula":""},"date_filter":{"absolute":true,"duration":null,"enabled":true,"from_date":1583017200,"offset":null,"to_date":1583621999},"event":{"filter":[],"type":"purchase_item"},"name":"1st week of March","occurrence_per_customer":"last","type":"event"},{"converted_value":1,"is_constant":true,"type":"constant","value":1},{"converted_value":100,"is_constant":true,"type":"constant","value":100}],"modifiers":{"display":"default","summarize":{"average":false,"max":false,"min":false,"stddev":false,"sum":false,"variance":false},"visualization":{"type":"default"}},"name":"Change vs pre-lockdown","type":"embedded_metric","value_filter":{"filters":[],"formula":""}}],"rows":[{"attribute":{"property":"title","type":"property"},"event_type":"purchase_item","expand_lists":false,"format":"none","grouping":{"ascending":false,"number":10,"type":"top"},"hide_null":true,"modifiers":[],"name":null,"type":"event"}]},"show_description_in_view":false,"tags":[]},"id":"5e7fc976da74a89e30339fa3","type":"report"},{"data":{"archived":false,"cloned_from_id":null,"components":[{"position":{"height":{"type":"fixed","value":4},"width":12,"x":0,"y":0},"text":"CV19 Diagnostic Dashboard","type":"text"},{"evaluate":false,"position":{"height":{"type":"fixed","value":28},"width":12,"x":0,"y":4},"project_id":null,"text":"<p>The only asset you need for this use case is the Diagnostic Dashboard itself</p>\n\n<p><img alt=\"\" src=\"https://cdn.exponea.com/factcool/f/04efa6b898ff429e2251d1370233e73e8d5cd5cdbe11229ff2cdb7cf042d2133\" /></p>\n","type":"html"}],"filters":{"attributes":[],"date_filter":{"absolute":false,"duration":{"count":30,"units":"days"},"enabled":false,"from_date":null,"offset":null,"to_date":null},"date_filter_override":false},"is_global_object":false,"name":"README","prevent_archivation":false,"tags":[],"used_project_ids":["f0ddd9fe-6751-11e9-aed1-0a580a203507"]},"id":"5e823bf1ab5e266e8fb13c8e","type":"dashboard"},{"data":{"archived":false,"cloned_from_id":"5e45a880f18343e3bb4cfae9","components":[{"display":"table","id":"5e7e767abc28383025f12b27","position":{"height":{"type":"fixed","value":23},"width":12,"x":0,"y":76},"project_id":"f0ddd9fe-6751-11e9-aed1-0a580a203507","show_description":false,"type":"report"},{"display":"table","id":"5e7e767abc28383025f12b21","position":{"height":{"type":"fixed","value":25},"width":12,"x":0,"y":99},"project_id":"f0ddd9fe-6751-11e9-aed1-0a580a203507","show_description":false,"type":"report"},{"position":{"height":{"type":"fixed","value":4},"width":12,"x":0,"y":0},"text":"Business Trends","type":"text"},{"position":{"height":{"type":"fixed","value":4},"width":12,"x":0,"y":124},"text":"Conversion","type":"text"},{"display":"new","display_new":{"chart":false,"table":true,"trend":false},"id":"5e7e767abc28383025f12b15","position":{"height":{"type":"fixed","value":19},"width":12,"x":0,"y":128},"project_id":"f0ddd9fe-6751-11e9-aed1-0a580a203507","show_description":false,"type":"funnel"},{"display":"new","display_new":{"chart":false,"table":true,"trend":false},"id":"5e7e767abc28383025f12b1b","position":{"height":{"type":"fixed","value":17},"width":12,"x":0,"y":147},"project_id":"f0ddd9fe-6751-11e9-aed1-0a580a203507","show_description":false,"type":"funnel"},{"display":"chart","id":"5e7e77ef5a6a44fa0539e50a","position":{"height":{"type":"fixed","value":25},"width":12,"x":0,"y":22},"project_id":"f0ddd9fe-6751-11e9-aed1-0a580a203507","show_description":false,"type":"report"},{"comparison":{"type":"previous_period"},"date_filter":{"absolute":false,"duration":{"count":7,"units":"days"},"enabled":true,"from_date":null,"offset":null,"to_date":null},"goal":null,"id":"5e7e79bc2e1828ca6ceddbbf","position":{"height":{"type":"fixed","value":7},"width":3,"x":0,"y":4},"project_id":"f0ddd9fe-6751-11e9-aed1-0a580a203507","show_description":false,"type":"metric"},{"comparison":{"type":"previous_period"},"date_filter":{"absolute":false,"duration":{"count":7,"units":"days"},"enabled":true,"from_date":null,"offset":null,"to_date":null},"goal":null,"id":"5e7e7a75c122fee36d097c67","position":{"height":{"type":"fixed","value":7},"width":3,"x":3,"y":4},"project_id":"f0ddd9fe-6751-11e9-aed1-0a580a203507","show_description":false,"type":"metric"},{"evaluate":false,"position":{"height":{"type":"fixed","value":4},"width":9,"x":0,"y":18},"project_id":null,"text":"<p>Note: Pre-lockdown period assumed as the first 7 days of March</p>\n","type":"html"},{"comparison":null,"date_filter":null,"goal":null,"id":"5e7e7bf086fea23831ba018f","position":{"height":{"type":"fixed","value":7},"width":3,"x":0,"y":11},"project_id":"f0ddd9fe-6751-11e9-aed1-0a580a203507","show_description":false,"type":"metric"},{"comparison":null,"date_filter":null,"goal":null,"id":"5e7e7cedd4bfbb42d875b9cb","position":{"height":{"type":"fixed","value":7},"width":3,"x":3,"y":11},"project_id":"f0ddd9fe-6751-11e9-aed1-0a580a203507","show_description":false,"type":"metric"},{"comparison":{"type":"previous_period"},"date_filter":{"absolute":false,"duration":{"count":7,"units":"days"},"enabled":true,"from_date":null,"offset":null,"to_date":null},"goal":null,"id":"5e7e7d4adc48ff319952ef2c","position":{"height":{"type":"fixed","value":7},"width":3,"x":6,"y":4},"project_id":"f0ddd9fe-6751-11e9-aed1-0a580a203507","show_description":false,"type":"metric"},{"comparison":null,"date_filter":null,"goal":null,"id":"5e7e7d9f70e62cb7f66a13a8","position":{"height":{"type":"fixed","value":7},"width":3,"x":6,"y":11},"project_id":"f0ddd9fe-6751-11e9-aed1-0a580a203507","show_description":false,"type":"metric"},{"position":{"height":{"type":"fixed","value":4},"width":12,"x":0,"y":72},"text":"Product Trends","type":"text"},{"position":{"height":{"type":"fixed","value":4},"width":12,"x":0,"y":47},"text":"Emailing Trends","type":"text"},{"comparison":null,"date_filter":{"absolute":false,"duration":{"count":7,"units":"days"},"enabled":true,"from_date":null,"offset":null,"to_date":null},"goal":null,"id":"5e849679e980835d017c3287","position":{"height":{"type":"fixed","value":8},"width":3,"x":0,"y":51},"project_id":"f0ddd9fe-6751-11e9-aed1-0a580a203507","show_description":false,"type":"metric"},{"comparison":null,"date_filter":{"absolute":true,"duration":null,"enabled":true,"from_date":1583017200,"offset":null,"to_date":1583621999},"goal":null,"id":"5e8497f51fabe3adfe2b623f","position":{"height":{"type":"fixed","value":8},"width":3,"x":0,"y":59},"project_id":"f0ddd9fe-6751-11e9-aed1-0a580a203507","show_description":false,"type":"metric"},{"comparison":null,"date_filter":{"absolute":false,"duration":{"count":7,"units":"days"},"enabled":true,"from_date":null,"offset":null,"to_date":null},"goal":null,"id":"5e850d9e3d6c6411f2c6bb08","position":{"height":{"type":"fixed","value":8},"width":3,"x":3,"y":51},"project_id":"f0ddd9fe-6751-11e9-aed1-0a580a203507","show_description":false,"type":"metric"},{"comparison":null,"date_filter":{"absolute":true,"duration":null,"enabled":true,"from_date":1583017200,"offset":null,"to_date":1583621999},"goal":null,"id":"5e850dd4151c63d215772fa6","position":{"height":{"type":"fixed","value":8},"width":3,"x":3,"y":59},"project_id":"f0ddd9fe-6751-11e9-aed1-0a580a203507","show_description":false,"type":"metric"},{"comparison":null,"date_filter":{"absolute":false,"duration":{"count":7,"units":"days"},"enabled":true,"from_date":null,"offset":null,"to_date":null},"goal":null,"id":"5e8510aa34f9f60d8d677d05","position":{"height":{"type":"fixed","value":8},"width":4,"x":6,"y":51},"project_id":"f0ddd9fe-6751-11e9-aed1-0a580a203507","show_description":false,"type":"metric"},{"comparison":null,"date_filter":{"absolute":true,"duration":null,"enabled":true,"from_date":1583017200,"offset":null,"to_date":1583621999},"goal":null,"id":"5e851111a6203edc345faa82","position":{"height":{"type":"fixed","value":8},"width":4,"x":6,"y":59},"project_id":"f0ddd9fe-6751-11e9-aed1-0a580a203507","show_description":false,"type":"metric"},{"evaluate":false,"position":{"height":{"type":"fixed","value":5},"width":12,"x":0,"y":67},"project_id":"f0ddd9fe-6751-11e9-aed1-0a580a203507","text":"<p>We're seeing many businesses having higher open rates due to people having more time to check their emails at home, however lower click-through rates due to people hesitating to shop with economic anxiety.</p>\n","type":"html"}],"filters":{"attributes":[],"date_filter":{"absolute":false,"duration":{"count":30,"units":"days"},"enabled":false,"from_date":null,"offset":null,"to_date":null},"date_filter_override":false},"is_global_object":false,"name":"CV19 Diagnostic Dashboard","prevent_archivation":false,"tags":[],"used_project_ids":["f0ddd9fe-6751-11e9-aed1-0a580a203507"]},"id":"5e7e767abc28383025f12b33","type":"dashboard"}],"version":"v1.164.11"}

🚧

It might not be possible to import the JSON file if your Exponea instance has not gone through the release 1.164 yet.