DFA Reporting API: Creating Table Relationships

[sean.d...@blitzmedia.com]

Hello,

Currently, I am working on a project to pull Display data using the DFA Reporting API and populating a local SQL Database. The data will be used for analytical purposes. However, due to the large size of the reports I am trying to avoid placing all of the data into one table. My attempt to reverse engineer the report to create a relational database with the data has failed. Is there a DFA Schema available or has anyone does this that maybe able to help? The fields I am attempting to pull are below. If you need more information please ask.

Advertiser

Advertiser ID

Date

State/Region

City

Activity

Activity ID

Campaign

Campaign ID

Creative

Creative ID

Creative Pixel Size

Ad ID

Ad Type

Placement

Placement ID

Placement Total Booked Units

Site (DFA)

Site ID (DFA)

Clicks

Impressions

Click-through Conversions

View-through Conversions

Effective CPM

Total Conversions

Media Cost

Cost Per Click

[Jonathon Imperiosi (DFA API Team)]

Hello,

Sorry, but I'm not entirely sure what you mean by "DFA Schema". Are you trying to identify the relationships between the various DFA objects? We have an image here that explains this at a high-level, which may be useful.

Regards,

- Jonathon Imperiosi, DFA API Team

[sean.d...@blitzmedia.com]

Jonathon,

Thank you for getting back to me. I was aware of the image I was just hoping to find more. I was able to build a working schema on my end. 

[dma...@gmail.com]

Did you ever make progress on this Sean? If so, would you mind sharing? Thanks!

On Thursday, February 6, 2014 2:03:42 PM UTC-5, sean.d...@blitzmedia.com wrote: