Last modified by steven@one-count_com on 2018/07/10 16:42
Show last authors
1 {{layout}}
2 {{layout-section ac:type="two_right_sidebar"}}
3 {{layout-cell}}
4
5
6 {{id name="Start ScreenSteps Content"/}}
7 Creating a Feed Report allows you to create custom mappings for advertiser-specific reporting, save the feed criteria as jobs, automatically generate specified reports at a set frequency, and automatically upload the reports via ftp.
8
9 **BECAUSE THESE FEED REPORTS ARE THIRD PARTY-SPECIFIC, YOU WILL NEED TO CREATE QUESTION(DATA FIELD)/REPONSE AND TRANSACTIONAL DATA MAPPINGS PRIOR TO RUNNING THE DASHBOARD AND CREATING THE FEED REPORT.**
10
11 This mapping is done in the Mapping Builder. See [[UTILITIES - Mapper >>doc:Utilities - DExTr]]documentation for detail on creating mappings.
12
13 === RUN DASHBOARD ===
14
15 See [[Run Dashboard >>doc:Run Dashboard -- Select, Save, View and Use Saved Selections]]documentation for details on how to make selections for dashboard reporting.
16
17 === CREATE FEED REPORT ===
18
19 [[image:attach:media_1467313656507.png||align="center"]]
20
21 Once you've set the date range and made your selections, click on "Create Feed Report". When you do, a pop-up as shown below will be presented. This is where you'll make your selections for the report.
22
23 Note that you will select a time period for the feed report separate than that selected for the dashboard.
24
25 ==== Set Feed Criteria ====
26
27 [[image:attach:media_1467726658809.png||align="center"]]
28
29 Feed Criteria is in four parts. Detail on each section is provided below.
30 ~1. Feed Job List – Listing of existing/scheduled jobs.
31 2. Mapping and frequency selections and date range for the feed report.
32 3. FTP/SFTP transfer information
33 4. Desired format/output of the report.
34 5. Add or Update Template based on criteria selected.
35
36 (% style="margin-left: 30.0px;" %)
37 ===== 1 – Feed Job List =====
38
39 (% style="margin-left: 30.0px;" %)
40 [[image:attach:media_1467727533167.png||align="center"]]
41
42 (% style="margin-left: 30.0px;" %)
43 All existing Feed Jobs are displayed here. If there are none listed, then none have been created.
44
45 (% style="margin-left: 30.0px;" %)
46 Once a job is created and scheduled, you can Suspend, Edit, or Delete it.
47 \\ **Suspend:** This will suspend the job from running. Once a job is suspended, the "Suspend" button will change to "Activate", so you can edit and/or activate it at another time.
48 \\ **Edit:** All feed criteria for that job will be pre-populated and you can change the mapping selection and frequency selections, transfer information, report format selections, and name and description of the job in Section 5 shown in the screenshot above. **YOU MUST SELECT "Update" in the Add or Update section (Section 5 in screenshot above), or a new job will be created and placed in the queue to run.
49 **
50 **Delete:** This deletes the job.
51
52 (% style="margin-left: 30.0px;" %)
53 (% style="color: rgb(0,0,0);" %)** **(%%)**[[doc:||anchor="Create a New Job"]](% style="color: rgb(0,0,0);" %)To Create a New Job(%%)[[doc:||anchor="Create a New Job"]]:**
54 \\ 1. Skip the Feed Job List.
55 2. Set mapping and frequency selections, and date range.
56 3. Enter transfer information.
57 4. Select format(s) for the report.
58 5. Select "New" in the "Add or Update" drop-down. Give the job a name (required) and description (optional).
59 6. Click "Schedule".
60
61 (% style="margin-left: 30.0px;" %)
62 Further detail on Steps 2-5 is provided below.
63
64 (% style="margin-left: 30.0px;" %)
65 ===== 2 – Mapping and Frequency Selections and Date Range for the Feed Report =====
66
67 (% style="margin-left: 30.0px;" %)
68 [[image:attach:media_1467316345172.png||align="center"]]
69
70 (% style="margin-left: 30.0px;" %)
71 **Mapping Selection:** Select the data mapping to use for the feed report.*
72 *Because the feed reports are third party-specific, questions (data fields)/responses and transactional data need to be mapped before running the dashboard and creating the feed report. This mapping is done in the Mapping Builder. See Mapping Builder documentation for detail on creating mappings.
73
74 (% style="margin-left: 30.0px;" %)
75 **Frequency Selection**: Options are Daily, Weekly, Monthly. Daily allows you to select what time of day to run the reports, Weekly allows you to select what day of the week to run, and Monthly allows you to select what day of the month to run the report on. Note that if you select 31 for Monthly, the day run will be the last day of the month if that month doesn't have 31 days (i.e. February, April, June, September, November)
76
77 (% style="margin-left: 30.0px;" %)
78 **Enter Range:** Options are Last 7 Days, Previous Month, and Enter Days. Enter Days = number of days back from current date, e.g. if the date is the 15th and you enter 10, the report contain data for the 10 days prior to the 15th.
79
80 (% style="margin-left: 30.0px;" %)
81 ===== 3 – Transfer Information =====
82
83 (% style="margin-left: 30.0px;" %)
84 [[image:attach:media_1467317821099.png||align="center"]]
85
86 (% style="margin-left: 30.0px;" %)
87 Enter the FTP/SFTP URL and credentials (Username and Password).
88 Enter the email you want the system to send alert to when upload completed.
89
90 (% style="margin-left: 30.0px;" %)
91 ===== 4 – Desired Format(s)/Report(s) Output =====
92
93 (% style="margin-left: 30.0px;" %)
94 [[image:attach:media_1467318214733.png||align="center"]]
95
96 (% style="margin-left: 30.0px;" %)
97 **Control File:** Contains file name, number of records, date
98
99 (% style="margin-left: 30.0px;" %)
100 **User/Contact File:** Contains designated demo fields for each record
101
102 (% style="margin-left: 30.0px;" %)
103 **Activity File:** Contains all collected activities (i.e. banner, e-newsletter, web)
104
105 (% style="margin-left: 30.0px;" %)
106 ===== 5 – Add or Update Job =====
107
108 (% style="margin-left: 30.0px;" %)
109 [[image:attach:media_1467728371417.png||align="center"]]
110
111 (% style="margin-left: 30.0px;" %)
112 **New:** After making all selections and completing ftp information, select "New" from the drop-down and enter the name and description of the job. When you click the "Schedule" button, a new job will be created and placed in the queue.
113 **Update:** Select "Update" from the drop-down when you are editing an existing job. When you click the "Schedule" button, the job will be updated with any changes you've made and re-placed in the queue.
114
115 ==== Schedule ====
116
117 [[image:attach:media_1467728599394.png||align="center"]]
118
119 To save the criteria you've selected and schedule the job to run, click the Schedule button. You'll be returned to the Dashboard, and a message indicating the job has been scheduled will be displayed. When you select "Create Feed Report" again, the job will appear in the list of jobs in Section 1 - Feed jobs, described above.
120
121
122
123 {{id name="End ScreenSteps Content"/}}
124 {{/layout-cell}}
125
126 {{layout-cell}}
127 {{panel title="Search all Documentation:"}}
128
129
130 {{livesearch/}}
131 {{/panel}}
132
133 {{panel title="Search Dashboards Documentation:"}}
134
135
136 {{pagetreesearch rootPage="Analytics Dashboards"/}}
137 {{/panel}}
138
139 {{panel}}
140
141
142 {{toc maxLevel="5"/}}
143 {{/panel}}
144
145 {{panel title="Click here to expand..."}}
146 {{expand title="More Dashboards Documentation"}}
147
148
149 (% style="margin-left: 30.0px;" %)
150
151
152 (% style="margin-left: 30.0px;" %)
153 [[Dashboard Reports – Generate Summary Report>>doc:Dashboard Reports -- Generate Summary Report]]
154
155 (% style="margin-left: 30.0px;" %)
156 [[Dashboard Reports - Combined User Report>>doc:Dashboard Reports - Combined User Report]]
157
158 (% style="margin-left: 30.0px;" %)
159
160
161
162
163
164 {{/expand}}
165 {{/panel}}
166
167
168
169
170
171
172
173
174
175 **
176 **
177
178 **
179 **
180
181
182
183 **
184 **
185
186
187
188
189 {{/layout-cell}}
190 {{/layout-section}}
191 {{/layout}}