Log Final Campaign KPIs

Search on Reddit platform for 10 mentions of '[Keyword]' from past week, collect posts and user information, and store the data in the database [Notion Database Link].

Get my posts from the last 7 days. For each, look up its details to find the like and repost count. Add the post text, like count, and repost count to a new row in my Google Sheet at '[Sheet Link]'.

Get the posts from the latest 7 days from the X user '[@CompetitorHandle]'. For each post, add a new row to the Google Sheet at '[Google Sheet Link]', sheet '[Sheet Name]', with the post text, link, and timestamp.

Check the Google Sheet at '[Google Sheet Link]', sheet name '[Sheet Name]'. For any row where 'Status' is 'Ready', create a post on X using the text from the 'Post Copy' column. Update 'Status' to 'Posted'.

From my Google Sheet at [Sheet Link] and worksheet [Worksheet Name], take each row where 'LinkedIn Info Updated' is 'No'. Use the 'Company Domain' to get the company's info from LinkedIn. Update the 'Industry', 'Employee Count', and 'Location' columns with the results.