Skip to content

Instantly share code, notes, and snippets.

@breadplop

breadplop/updatePaidUsersTab.md

Last active May 9, 2018 18:23
Show Gist options
  • Save breadplop/4ac245cb046388ab292781558cf50656 to your computer and use it in GitHub Desktop.
Save breadplop/4ac245cb046388ab292781558cf50656 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
updatePaidUsersTab.md

How To Update National Data Dashboard

Sam: Delete the old UpdatePaidUsersTab folder, download the new folder and remember to unzip it! (ensure that the filename is the same!)

Step 1 Update the Paid Users Tab

with Trial start date, acquisition source and utm_campaign from the db.

  1. Open Terminal [cmd + spacebar and Type terminal]
  2. Go into the directory where this folder is kept [copy and paste into terminal: cd Downloads/UpdatePaidUsersTab + enter ]
  3. copy and paste into terminal: python3 update_acquisitionSource_startTrialDate.py

Paid Users tab will automatically update.

Step 2 Update LinkedIn Data

  1. Open Google Spreadsheet and go to the dashboard tab (colored in blue)
  2. Open to LinkedIn Ads Manager
  3. Update cells M108 and M110 (linkedin paid spent and conversion number for current week) from above link.(M109 will update on its own)
  4. (Optional) Fill in 0 values by looking up email in fullstory

SaaS Metrics and Sales/Marketing Dashboard should all automatically update. Hooray!

If there are errors, it might be because some formula broke somewhere/someone added weird rows/columns. Will try to work out a solution so that doesnt happen when I'm back. Haha.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment