Skip to content

MariiaChernysh/Useful-R-scripts

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

18 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Useful-R-scripts

Here are my ordinary scripts for solving daily tasks, updating marketing stats, exploring etc.

DailyTable.R

This script provides .csv output containing a non-formatted pivot table with several groupings. The output presents a summary on Managers' KPIs divided by traffic sources they use. The tricky part is that different Managers can work with the same Traffic Sources and their stats should be calculated considering this issue. Data sample can be found here.

AutoGSTable.R

This script is designed to insert chosen data to Google Sheets automatically. Although it's not the fastest way to fill in the report, one can just launch it and deal with the other stuff while it's working. The main disadvantage of this script is its dependency on certain data structure. All values are anchored to the relevant cells and if the order of values is changed, one should change the cells' positioning accordingly. Output example can be found here. Data sample can be found here

URLnav.R

URL navigation script was designed literally to browse through websites ^_^. Personally I needed this to check flows of ad campaigns my agency is running. So I wrote a function that navigates through the number of campaigns (it's pretty helpful when n=500+)

About

Handy scripts solving marketing tasks

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages