rachelannelise

{
  "action": "conversion",
  "apikey": "mashable.com",
  "campaign_id": "facebook",
  "channel": "website",
  "display": true,
  "display_avail_height": 735,
  "display_avail_width": 1280,
  "display_pixel_depth": 24,
  "display_total_height": 800,

rachelannelise

SELECT AP.name AS AP_publisher,
       AP.id AS AP_publisher_id,
       APA.publisher_id AS APA_publisher_id,
       SFA.name AS SF_account_name,
       SFA.django_publisher_name_c AS SF_django_account_name,
       SFA.id AS SF_account_id,
       APA.key AS apikey,
       APA.id AS apikey_id,
       APA.is_active AS is_active,
       SFA.type AS TYPE,

rachelannelise

WITH pages_viewed AS (
SELECT *,
    CASE WHEN action = 'pageview' AND action_data =     'apikey.listing.items.s'           THEN CONCAT('listing|', dash_aspect)
         WHEN action = 'pageview' AND action_data =     'apikey.info.s'                    THEN CONCAT('info|', dash_aspect)
         WHEN action = 'pageview' AND action_data =     'apikey.meta-info.s'               THEN CONCAT('info|', dash_aspect)
         WHEN action = 'pageview' AND action_data =     'apikey.campaign-info.s'           THEN 'info|campaign'
         WHEN action = 'pageview' AND action_data =     'apikey.overview'                  THEN 'overview|'
         WHEN action = 'pageview' AND action_data =     'overlay'                          THEN 'overlay|'
         WHEN action = 'pageview' AND action_data =     'apikey.post-info.s'               THEN CONCAT('info|', dash_aspect)
         WHEN action = 'pageview' AND action_data =     'apikey.referrer-info.s'           THEN 'info|referrer'

rachelannelise

{
  "action":"pageview",
  "apikey":"example.com",
  "campaign_id":"facebook",
  "channel":"website",
  "display":true,
  "display_avail_height":735,
  "display_avail_width":1280,
  "display_pixel_depth":24,
  "display_total_height":800,

rachelannelise

Customer Support Engineer

What's Parse.ly?

We've built a real-time content measurement layer for the entire web.

Our analytics platform helps digital storytellers at some of the web's best sites, such as Arstechnica, The New Yorker, TechCrunch, The Intercept, and many more. In total, our analytics system needs to handle over 100 billion monthly events from over 1 billion monthly unique visitors.

Our entire stack is in Python and JavaScript, and our team has innovated in areas related to real-time analytics, building some of the best open source tools for working with modern stream processing technologies. Our UX/design team has also built one of the best-looking dashboards on the planet, using AngularJS and d3.js. You can see some screenshots: https://www.parse.ly/dashboard/

rachelannelise

CREATE EXTERNAL TABLE `tablename` (
  `action` string, 
  `apikey` string, 
  `campaign_id` string, 
  `display_avail_height` int, 
  `display_avail_width` int, 
  `display_pixel_depth` int, 
  `display_total_height` int, 
  `display_total_width` int, 
  `display` boolean, 

rachelannelise

# -*- coding: utf-8
import datetime as dt
import unittest
from io import BytesIO

from mock import MagicMock, patch
from parselyutils.apikey_utils import ApikeyConfigFetcher
from parselyutils.event import Event, VisitorInfo, TimestampInfo

from casterisk.lib.deliverymetrics import DatadogMetric, DeliveryMetric

rachelannelise

from __future__ import division
from mage.client import MageClient
from settings import MAGE_CONF
from dateutil import parser as dt_parser

from six import iteritems
from redis import Redis
from elasticsearch import Elasticsearch
import datetime as dt
from dateutil.relativedelta import relativedelta as rd

rachelannelise

# custom_campaign.py

from __future__ import division
from mage import MageClient
from deployment import hack as settings

from six import iteritems
from redis import Redis
from elasticsearch import Elasticsearch
import datetime as dt

rachelannelise

{
"action": "pageview",
"apikey": "mashable.com",
"campaign_id": "facebook",
"display": true,
"display_avail_height": 735,
"display_avail_width": 1280,
"display_pixel_depth": 24,
"display_total_height": 800,
"display_total_width": 1280,