ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
Creative Performance Dashboard
3
4
Instructions
5
6
NOTE: THIS TEMPLATE HAS BEEN MOVED.
7
NEW VERSION HERE: https://docs.google.com/spreadsheets/d/1V9lFV1RNv-FzD1Bgcpw7Q2oqW5_QaRESyPPJbFVuwVo/edit#gid=989727843
8
Before you proceed, DON'T TRY TO EDIT OR REQUEST ACCESS TO THIS SHEET. Click on "File" > "Make a copy" and edit the new version.
9
10
Thank you for requesting the Creative Performance Tracker template! 🎉
11
Please make sure you follow the instructions below carefully. For any questions, please reach out to @almeidalexandr on Twitter
12
13
This spreadsheet updates with a single click so you can track every new ad you launch without having to edit anything in the spreadsheet.
14
15
16
17
18
19
20
21
22
23
24
25
WHAT YOU'LL NEED
26
1. Install 'Data Slayer'. This is a FREE Google Sheets extension that allows you to import data from different channels.
27
28
BEFORE YOU BEGIN
29
Make sure to follow these instructions exactly as described, otherwise this template won't work.
30
31
INSTRUCTIONS
32
1. Install DataSlayer.
33
2. Head over to tab '3. YOUR DATA HERE'. Click 'Extensions' at the top, and launch DataSlayer.
34
3. Click on 'Facebook Ads'.
35
4. Connect your account by following the prompts.
36
5. Once you've selected which account you want to import data from, select the following fields in the exact same order as shown in the images below.
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
6. Select your starting date and end dates as per your preferences.
56
57
58
59
60
61
62
63
64
65
66
67
68
69
7. Click 'Generate Table' and wait until it loads. IMPORTANT: Make sure to select cell A1 in tab '3. YOUR DATA HERE' before you click 'Generate Table'.
70
8. Open tab '4. Dashboard'. Your data should be automatically displayed.
71
9. If some ads aren't displaying data, select the last row of data and click on the blue circle on the bottom right of the last cell. Click and drag until the last row with data.
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
10. Whenever you want to update your data, simply open DataSlayer and refresh your queries. If you purchase the premium version, you can create a schedule so it updates automatically every hour/day/week/month.
87
11. ENJOY!
88
89
Important: note that DataSlayer's free version only allows for 5 FREE data pulls per day. For more data pulls, you will need a pro account.
90
91
Follow me on Twitter!
92
93
94
95
96
97
98
99
100