ABCDE
1
2
You must make a copy of this sheet to use it:

1. File
2. Make a copy
3. Rename and pick location.
3
4
5
6
Click here for our video on UTMs and their application on GlobalComix
7
8
FunctionNote
9
10
Twitter Batch ToolGenerate formatted, indexable copy/hashtags/tracking links into a clickable URL that pre-fills a tweet on your logged in account.Default format for UTM tags is to make the 'term' the time of day, and the 'campaign' to include the name of the GlobalComix link + date.

Fill in the columns with the green header cell.
11
12
13
Reddit Content PostingGenerate formatted, indexable copy/tracking links into a clickable URL that pre-fills a Reddit post into a selected subreddit (Reddit community).Make the term the name of the subreddit, in the format 'r-subredditname', e.g. 'r-scifi'.

Fill in the columns with the green header cell.
14
15
Pivot TableAuto fills from Reddit Content Posting so you can navigate what posts have been made where. You can toggle which columns are present to analyze in different ways.
16
17
Subreddit CheckerCopy the link of the comic from GlobalComix into this sheet and it will automatically check if you've posted it before if it finds it in the Reddit Content Posting sheet/Pivot Table.
18
19
20
UTM Generator (General)Generate tracking links with any custom parameters, no pre-filled or default settings.
21
22
23