Name: SW_Digital_and_Traditional_Ad_Activity_Table
Display Field: A_ID
Type: Table
Geometry Type: N/A
Description: null
Service Item Id: fa8a01e4acf447838e0ee1dab2757577
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 2000
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
A_ID
(
type: esriFieldTypeString, alias: A_ID, length: 25
)
-
SumCode
(
type: esriFieldTypeString, alias: SumCode, length: 25
, Coded Values:
[NEW: New]
, [DG: Digital Ad]
, [TR: Traditional Ad]
, ...4 more...
)
-
A_Type
(
type: esriFieldTypeString, alias: A_Type, length: 25
, Coded Values:
[NEW: New]
, [BB: BillBoard]
, [DG_S: Digital-Social]
, ...12 more...
)
-
Publisher
(
type: esriFieldTypeString, alias: Publisher, length: 50
, Coded Values:
[NEW: New]
, [CM: Contemporary Media]
, [CLM: Clean Memphis]
, ...9 more...
)
-
Campaign_AdDescription
(
type: esriFieldTypeString, alias: Campaign_AdDescription, length: 50
, Coded Values:
[NEW: New]
, [SP: Scoop the Poop]
, [DBI: Don't Blow It]
, ...31 more...
)
-
Description
(
type: esriFieldTypeString, alias: Description, length: 200
)
-
Metric
(
type: esriFieldTypeString, alias: Metric, length: 100
)
-
Dg_Link
(
type: esriFieldTypeString, alias: Dg_Link, length: 200
)
-
Tr_QR
(
type: esriFieldTypeString, alias: Tr_QR, length: 200
)
-
Start_Date
(
type: esriFieldTypeDate, alias: Start Date, length: 8
)
-
End_Date
(
type: esriFieldTypeDate, alias: End_Date, length: 8
)
-
Total_TV_Ads
(
type: esriFieldTypeDouble, alias: Total_TV_Ads
)
-
DMA_RTG_less1
(
type: esriFieldTypeDouble, alias: DMA_RTG_less1
)
-
DMA_RTG_1to2
(
type: esriFieldTypeDouble, alias: DMA.RTG_1-1.9
)
-
DMA_RTG_2to3
(
type: esriFieldTypeDouble, alias: DMA_RTG_2-2.9
)
-
DMA_RTG_3to4
(
type: esriFieldTypeDouble, alias: DMA_RTG_3-3.9
)
-
DMA_RTG_4to5
(
type: esriFieldTypeDouble, alias: DMA_RTG_4-4.9
)
-
DMA_RTG_5andUp
(
type: esriFieldTypeDouble, alias: DMA_RTG_5andUp
)
-
Dg_Impressions
(
type: esriFieldTypeDouble, alias: Dg_Impressions
)
-
Dg_Clicks
(
type: esriFieldTypeDouble, alias: Dg_Clicks
)
-
Dg_CTR
(
type: esriFieldTypeDouble, alias: Dg_CTR
)
-
Dg_Engagement
(
type: esriFieldTypeDouble, alias: Dg_Engagement
)
-
Dg_Likes
(
type: esriFieldTypeDouble, alias: Dg_Likes
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, length: 38
)
-
created_user
(
type: esriFieldTypeString, alias: created_user, length: 255
)
-
created_date
(
type: esriFieldTypeDate, alias: created_date, length: 8
)
-
last_edited_user
(
type: esriFieldTypeString, alias: last_edited_user, length: 255
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, length: 8
)
Relationships:
Supported Operations:
Query
Query Attachments
Query Analytic
Query Related Records
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata