Skip to main content

​
Introduction

Save time with our collection of pre-built dashboard templates designed for Google Sheets. These templates are ready to use and can be customized to match your specific reporting needs. Each template includes:
  • Pre-configured queries optimized for performance
  • Professional layouts with data visualization best practices
  • Automatic refresh capabilities
  • Easy customization options
Simply select a template below, connect your data sources, and start generating insights immediately.

​
Special Events Hourly Report

This template is designed for monitoring and analyzing special events, campaigns, or time-sensitive activities with hourly granularity. Perfect for:
  • Black Friday/Cyber Monday campaigns
  • Product launches
  • Flash sales
  • Live events monitoring
  • Time-limited promotions

​
Key Features

  • Hourly Performance Tracking: Monitor key metrics updated every hour with automatic data refresh
  • Multi-channel Overview: Track performance across all connected advertising platforms (template includes Facebook/Meta Ads, Google Ads, and TikTok Ads by default, but more data sources can be added)
  • Flexible Data Views: Break down performance by individual days (like “today”), all days of the event combined, by individual channels, or view all channels together
  • Campaign-Level Analysis: Drill down to see all campaigns within a specific channel
  • Dynamic Setup: Filters to change channels and campaigns being analyzed
  • Automatic Alerts: Set up threshold-based notifications for critical metrics
Here’s what part of the final report looks like once set up:
Special Events Dashboard - Final Report View

​
How to Use This Template

Follow these steps to set up and use the Special Events Hourly Report template:
Go to this template file and then File > Make a Copy > Name your file > Make a Copy
If you’ve never installed Detrics before, install it first. If you’ve already installed Detrics, continue.In your new file, navigate to Extensions > Detrics > Launch Detrics in the menu bar
Open Detrics Sidebar
If it’s the first time you open Detrics, connect at least 1 data source by clicking the “Connect Data Source” button. Select one data source from all the available options and complete the authentication process. If you have used Detrics in the past, go to the next step.Note: The images below are illustrative. You can connect as many data sources as you’d like.
Connect Data Source
Select Data Source
Select “Connect Data Source” again, scroll down and select Google Sheets.
Connect Google Sheets
Copy the following code:
[{"spreadsheet":{"spreadsheetGoogleId":"1yXgyR0XXvJy9-WV5cy5E1pqCVGFlhoM4pfaVLlvauvc","sheetId":"1654721591","spreadsheetName":"Copy of Cyber daily report","dataplugId":"f941e03d-1dbe-4e89-a279-046f02909a20","sheetName":"DB_Meta","timezone":"America/Buenos_Aires"},"trigger":{"paused":false,"timezone":"America/Buenos_Aires","lastExecutionErrorList":[],"triggerId":"fef728aa-af59-4381-83db-537f0391a333","regularity":"hourly","notificationEmail":"","userId":"","errorNotificationPreference":"none","pauses":[],"executions":[],"dayOfWeek":[0,1,2,3,4,5,6],"dataplugId":"f941e03d-1dbe-4e89-a279-046f02909a20","timeInterval":1},"automationStatus":{"isPaused":false,"statusSource":"TRIGGER","nextScheduledExecutionTime":"2025-10-20 07:14","timezone":"America/Buenos_Aires","connectionStatus":{"isConnected":true,"wasRecentlyReconnected":false},"lastStatusUpdate":"2025-10-20 07:14","primaryStatus":"NEWLY_CREATED","nextUpdate":{"days":0,"hours":16}},"user":{"createdAt":"2023-01-30T10:08:59.000Z","isDeleted":false,"pictureUrl":"https://lh3.googleusercontent.com/a/ACg8ocJZbO_vflt4h-V0yczLXeedGxEEX3OCW0AQlUAeTOHJlQu0IR8=s96-c","name":"ABN Digital","isAdminUser":false,"id":"","stripeCustomerId":"cus_OgVgFs4AVB5EGG","email":"team@abndigital.com.ar","isEmailVerified":true},"dataplug":{"timeframeEndDate":"today","timeAggregation":"hourly","timeframeStartDate":"2025-10-15","destinationOptions":{"appendData":false,"targetCell":""},"splitDimensions":[],"columnsOrder":["date_start","date_stop","hourly_stats_aggregated_by_advertiser_time_zone","campaign_name","spend","inline_link_clicks","impressions","offsite_conversion.fb_pixel_purchase","offsite_conversion.fb_pixel_purchase.value"],"timeframeType":"CUSTOM","filters":[],"timeframePreset":"","userId":"","platform":"facebook","executions":[{"errorMessages":[],"dataplugExecutionId":"aa3fd2ef-7e0b-4de8-a80f-be27311bee0f","dataplugId":"f941e03d-1dbe-4e89-a279-046f02909a20","executionStartTime":"2025-10-14T22:31:57.000Z","executionSource":"google-sheets","executionEndTime":"2025-10-14 19:32","userId":"","status":"OK"},{"errorMessages":[],"dataplugExecutionId":"942172d5-b518-4d2a-ad4a-96e21b563bb0","dataplugId":"f941e03d-1dbe-4e89-a279-046f02909a20","executionStartTime":"2025-10-14T22:01:54.000Z","executionEndTime":"2025-10-14 19:02","executionSource":"google-sheets","userId":"","status":"OK"}],"sorting":[{"sortingPriority":1,"fieldDisplayName":"Date Start","sorting":"desc","fieldId":"date_start"},{"sortingPriority":2,"fieldDisplayName":"Hour","sorting":"asc","fieldId":"hourly_stats_aggregated_by_advertiser_time_zone"}],"platformApiSpecificOptions":{},"dataplugId":"f941e03d-1dbe-4e89-a279-046f02909a20","platformApi":"facebook-ads","metrics":["spend","inline_link_clicks","impressions","offsite_conversion.fb_pixel_purchase","offsite_conversion.fb_pixel_purchase.value"],"platformIds":["200894091059858"],"dataplugName":"Meta_Raw","dimensions":["campaign_name"]}},{"spreadsheet":{"spreadsheetGoogleId":"1yXgyR0XXvJy9-WV5cy5E1pqCVGFlhoM4pfaVLlvauvc","dataplugId":"b5a61b99-f532-4783-aa5a-26fbc9550579","sheetId":"294751110","spreadsheetName":"Copy of Cyber daily report","sheetName":"DB_Google","timezone":"America/Buenos_Aires"},"trigger":{"paused":false,"timezone":"America/Buenos_Aires","triggerId":"6f3fe569-f3be-432e-8788-1f6f88d980b1","lastExecutionErrorList":[],"regularity":"hourly","userId":"","notificationEmail":"","errorNotificationPreference":"none","pauses":[],"executions":[],"dayOfWeek":[0,1,2,3,4,5,6],"timeInterval":1,"dataplugId":"b5a61b99-f532-4783-aa5a-26fbc9550579"},"automationStatus":{"isPaused":false,"statusSource":"TRIGGER","nextScheduledExecutionTime":"2025-10-20 07:14","timezone":"America/Buenos_Aires","connectionStatus":{"isConnected":true,"wasRecentlyReconnected":false},"lastStatusUpdate":"2025-10-20 07:14","primaryStatus":"NEWLY_CREATED","nextUpdate":{"days":0,"hours":16}},"user":{"createdAt":"2023-01-30T10:08:59.000Z","isDeleted":false,"pictureUrl":"https://lh3.googleusercontent.com/a/ACg8ocJZbO_vflt4h-V0yczLXeedGxEEX3OCW0AQlUAeTOHJlQu0IR8=s96-c","name":"ABN Digital","isAdminUser":false,"id":"","stripeCustomerId":"cus_OgVgFs4AVB5EGG","isEmailVerified":true,"email":"team@abndigital.com.ar"},"dataplug":{"timeframeEndDate":"","timeframeStartDate":"","timeAggregation":"hourly","destinationOptions":{"appendData":false,"targetCell":""},"splitDimensions":[],"timeframeType":"PRESET","columnsOrder":["date","hour","campaign.name","cost_micros","impressions","clicks","conversions","conversions_value"],"filters":[],"timeframePreset":"yesterday","userId":"","platform":"google","executions":[{"errorMessages":[],"dataplugExecutionId":"0bb28edd-5690-4fe0-9228-6d2068934512","dataplugId":"b5a61b99-f532-4783-aa5a-26fbc9550579","executionStartTime":"2025-10-14T22:29:14.000Z","executionSource":"google-sheets","executionEndTime":"2025-10-14 19:29","userId":"","status":"OK"},{"errorMessages":["No data was found! Try removing some filters, switch account or expanding the time frame."],"dataplugExecutionId":"3f902dda-ee32-4598-ba39-7f9fdc580f35","dataplugId":"b5a61b99-f532-4783-aa5a-26fbc9550579","executionStartTime":"2025-10-14T22:01:43.000Z","executionEndTime":"2025-10-14 19:01","executionSource":"google-sheets","userId":"","status":"REQUIRE_PARAMETER_CHANGE"}],"platformApiSpecificOptions":{},"sorting":[{"sortingPriority":1,"fieldDisplayName":"Date","sorting":"desc","fieldId":"date"},{"sortingPriority":2,"fieldDisplayName":"Hour","sorting":"asc","fieldId":"hour"}],"platformApi":"google-ads","dataplugId":"b5a61b99-f532-4783-aa5a-26fbc9550579","platformIds":["6021809624"],"metrics":["cost_micros","impressions","clicks","conversions","conversions_value"],"dataplugName":"Google_Raw","dimensions":["campaign.name"]}},{"spreadsheet":{"spreadsheetGoogleId":"1yXgyR0XXvJy9-WV5cy5E1pqCVGFlhoM4pfaVLlvauvc","dataplugId":"78bf5d36-ccc6-4dda-b141-9044367d5d00","sheetId":"550413206","spreadsheetName":"Copy of Cyber daily report","sheetName":"DB_TikTok","timezone":"America/Buenos_Aires"},"trigger":{"paused":false,"timezone":"America/Buenos_Aires","lastExecutionErrorList":[],"triggerId":"b862e2fa-1dac-4ce8-82bb-d11ec512d35e","regularity":"hourly","userId":"","notificationEmail":"","errorNotificationPreference":"none","pauses":[],"executions":[],"dayOfWeek":[0,1,2,3,4,5,6],"timeInterval":1,"dataplugId":"78bf5d36-ccc6-4dda-b141-9044367d5d00"},"automationStatus":{"isPaused":false,"statusSource":"TRIGGER","nextScheduledExecutionTime":"2025-10-20 07:14","timezone":"America/Buenos_Aires","connectionStatus":{"isConnected":true,"wasRecentlyReconnected":false},"lastStatusUpdate":"2025-10-20 07:14","primaryStatus":"NEWLY_CREATED","nextUpdate":{"days":0,"hours":16}},"user":{"createdAt":"2023-01-30T10:08:59.000Z","isDeleted":false,"pictureUrl":"https://lh3.googleusercontent.com/a/ACg8ocJZbO_vflt4h-V0yczLXeedGxEEX3OCW0AQlUAeTOHJlQu0IR8=s96-c","name":"ABN Digital","isAdminUser":false,"id":"","stripeCustomerId":"cus_OgVgFs4AVB5EGG","isEmailVerified":true,"email":"team@abndigital.com.ar"},"dataplug":{"timeframeEndDate":"2025-10-01","timeAggregation":"hourly","timeframeStartDate":"2025-10-01","destinationOptions":{"appendData":false,"targetCell":""},"splitDimensions":[],"columnsOrder":["stat_time_hour","campaign_name","spend","impressions","clicks","complete_payment","total_complete_payment_rate"],"timeframeType":"CUSTOM","filters":[],"timeframePreset":"","userId":"","platform":"tiktok","executions":[{"errorMessages":[],"dataplugExecutionId":"50e51dae-6a8d-4192-b787-b1e28f097459","dataplugId":"78bf5d36-ccc6-4dda-b141-9044367d5d00","executionStartTime":"2025-10-16T15:13:12.000Z","executionEndTime":"2025-10-16 12:13","executionSource":"google-sheets","userId":"","status":"OK"},{"errorMessages":[],"dataplugExecutionId":"aee6054f-0b57-4ede-937c-0b2581a3600c","dataplugId":"78bf5d36-ccc6-4dda-b141-9044367d5d00","executionStartTime":"2025-10-16T15:11:00.000Z","executionSource":"google-sheets","executionEndTime":"2025-10-16 12:11","userId":"","status":"OK"},{"errorMessages":[],"dataplugExecutionId":"29cbe469-7ebb-4e14-945c-2dbb201daec0","dataplugId":"78bf5d36-ccc6-4dda-b141-9044367d5d00","executionStartTime":"2025-10-14T22:35:23.000Z","executionSource":"google-sheets","executionEndTime":"2025-10-14 19:35","userId":"","status":"OK"},{"errorMessages":[],"dataplugExecutionId":"f4c36279-9914-42b1-90e8-b0fa59146a9d","dataplugId":"78bf5d36-ccc6-4dda-b141-9044367d5d00","executionStartTime":"2025-10-14T22:32:56.000Z","executionEndTime":"2025-10-14 19:34","executionSource":"google-sheets","userId":"","status":"OK"},{"errorMessages":[],"dataplugExecutionId":"54046c34-293b-4073-9772-faddf5d9bd65","dataplugId":"78bf5d36-ccc6-4dda-b141-9044367d5d00","executionStartTime":"2025-10-14T22:30:46.000Z","executionSource":"google-sheets","executionEndTime":"2025-10-14 19:31","userId":"","status":"OK"},{"errorMessages":[],"dataplugExecutionId":"fb3993fc-71c8-4798-b9f1-045f5d601d6b","dataplugId":"78bf5d36-ccc6-4dda-b141-9044367d5d00","executionStartTime":"2025-10-14T22:29:51.000Z","executionEndTime":"2025-10-14 19:30","executionSource":"google-sheets","userId":"","status":"OK"},{"errorMessages":[],"dataplugExecutionId":"2c009200-4f67-4717-9de7-7ec0fc5590cc","dataplugId":"78bf5d36-ccc6-4dda-b141-9044367d5d00","executionStartTime":"2025-10-14T22:01:09.000Z","executionSource":"google-sheets","executionEndTime":"2025-10-14 19:01","userId":"","status":"OK"}],"platformApiSpecificOptions":{},"sorting":[{"sortingPriority":1,"fieldDisplayName":"Datetime","sorting":"asc","fieldId":"stat_time_hour"}],"dataplugId":"78bf5d36-ccc6-4dda-b141-9044367d5d00","platformApi":"tiktok-ads","metrics":["spend","impressions","clicks","complete_payment","total_complete_payment_rate"],"platformIds":["7367448039964917761"],"dataplugName":"TikTok_Raw","dimensions":["campaign_name"]}}]
In the Detrics navigation menu, go to “See Queries” and then select “Import”. Queries will be created for Facebook (Meta) Ads, Google Ads and TikTok Ads.
See Queries
If any of the data sources mentioned above have not been connected to Detrics, a pop-up will showcase which ones need to be connected. Connect by clicking “Connect Data Source” from the pop-up. If you don’t want to connect, click “Proceed Anyway”.
Connect new data source
For each data source, select the account from which you want to download data. If you don’t have accounts for any data source, ignore it.
Run the queries by clicking the blue box next to the search bar inside the “See Queries” menu
Run Queries
In the “See Queries” section of the Detrics navigation bar, select the pencil icon to enter “edit” mode. Select the “Time Frame” dropdown and choose the “Start date” you want (we recommend it being the day the event starts) and select “Today” as the end date
Edit timeframe start date
Edit timeframe end date