Google-analytics-and-search-console

These script can scrape Google analytics and the Google search console for info about your websites.

Usage

NewDownloads.py

usage: NewDownloads.py [-h] [-t {image,video,web}] [-d DIMENSIONS] [-n NAME]
                       [-g GOOGLEACCOUNT]
                       start_date end_date

positional arguments:
  start_date            start date in format yyyy-mm-dd or 'yesterday'
                        '7DaysAgo'
  end_date              start date in format yyyy-mm-dd or 'today'

optional arguments:
  -h, --help            show this help message and exit
  -t {image,video,web}, --type {image,video,web}
                        Search types for the returned data, default is web
  -d DIMENSIONS, --dimensions DIMENSIONS
                        The dimensions are the left hand side of the table,
                        default is page. Options are date, query, page,
                        country, device. Combine two by specifying -d
                        page,query
  -n NAME, --name NAME  File name for final output, default is search-console-
                        + the current date. You do NOT need to add file
                        extension
  -g GOOGLEACCOUNT, --googleaccount GOOGLEACCOUNT
                        Name of a google account; does not have to literally
                        be the account name but becomes a token to access that
                        particular set of secrets. Client secrets will have to
                        be in this a file that is this string concatenated
                        with client_secret.json. OR if this is the name of a
                        text file then every line in the text file is
                        processed as one user and all results appended
                        together into a file file

GACombined2.py

This script download from Google Analytics but ONLY views which are marked as starred/fav

usage: GACombined2.py [-h] [-f FILTERS] [-d DIMENSIONS] [-m METRICS] [-n NAME] [-t [TEST]] [-g GOOGLEACCOUNT]
                      start_date end_date

positional arguments:
  start_date            start date in format yyyy-mm-dd or 'yesterday' '7DaysAgo'
  end_date              start date in format yyyy-mm-dd or 'today'

optional arguments:
  -h, --help            show this help message and exit
  -f FILTERS, --filters FILTERS
                        Filter, default is 'ga:pageviews>2'
  -d DIMENSIONS, --dimensions DIMENSIONS
                        The dimensions are the left hand side of the table, default is pagePath. YOU HAVE TO
                        ADD 'ga:' before your dimension
  -m METRICS, --metrics METRICS
                        The metrics are the things on the left, default is pageviews. YOU HAVE TO ADD 'ga:'
                        before your metric
  -n NAME, --name NAME  File name for final output, default is analytics- + the current date. You do NOT need
                        to add file extension.
  -t [TEST], --test [TEST]
                        Test option which makes the script output only n results, default is 3.
  -g GOOGLEACCOUNT, --googleaccount GOOGLEACCOUNT
                        Name of a google account; does not have to literally be the account name but becomes
                        a token to access that particular set of secrets. Client secrets will have to be in
                        this a file that is this string concatenated with client_secret.json. OR if this is
                        the name of a text file then every line in the text file is processed as one user and
                        all results appended together into a file file

#pip commands copy and paste these into the terminal

pip install argparse datetime win_unicode_console google-api-python-client pandas openpyxl progress oauth2client httplib2 progress urllib3

You need a Oauth2 account and put clients_secrets.json in same folder as script https://developers.google.com/webmaster-tools/search-console-api-original/v3/quickstart/quickstart-python

If you are using multiple google accounts then for every google account "email@example.com" create a secrets file called email@example.com-clients_secrets.json

For detailed instructions see the file: google-client-secrets-instructions.md