Thisismarkantony.com

Cost of Advertising: CPM, CPC, and CPM Demystified The purpose of this post is to clarify the terms CPM and CPC and also show how to convert from one model to the other. CPM CPM stands for Cost per 1000 Impressions (number of times the ad is shown) (M is Roman numeral for 1000). Generally, display advertising (e.g. banners) is sold in CPM. If the ad is shown 1000 times the cost will be equal to 1 CPM price. For example, if a publisher charges $10 CPM, that means your ad will be shown 1000 times for $10. If your budget is say $10,000 then mean your ad will be shown 1,000,000 times ($10,000 *(1000/$10) ). Total Impressions = (Total Cost or Budget) * (1000/CPM) If you are trying to find out how much you will pay for a given number of impressions then you can use the following formula Total Cost = (Total Impressions * CPM)/1000 If you notice in the above calculations, there are no mentions of how many people the ad will be shown to or how many clicks will be generated. CPM adverti...

Below given query will give you details for concurrent program and request group to which CP is attached details. Query : SELECT fcpt.user_concurrent_program_name,        DECODE(frgu.request_unit_type,               'P', 'Program',               'S','Set',               frgu.request_unit_type) Request_Unit_Type,        fcp.concurrent_program_name short_name,        frg.application_id,        frg.request_group_name,        fat.application_name,        fa.application_short_name,        fa.basepath   FROM fnd_request_groups         frg,        fnd_request_group_units    frgu,        fnd_concurrent_programs    fcp,        fnd_co...

Below given query will give you details for short text document attachment details. In this query i passed 2 parameter p_entity_name and p_prim_key_id. One can pass p_entity_name parameter value as "OE_ORDER_HEADERS" then we must pass p_prim_key_id parameter value as header_id from OE_ORDER_HEADERS_ALL table. Similarly you can pass p_entity_name value as 'PO_HEADERS', 'PO_LINES', 'OE_ORDER_HEADERS', 'OE_ORDER_LINES','AP_INVOICES','AP_CHECKS'  etc. to get details for short text attached to this entity. Query : SELECT fad.seq_num,        fdct.user_name,        fdot.title,        fdot.description,        fdst.short_text,        fad.entity_name,        fdct.user_name   FROM fnd_attached_documents     fad,        fnd_documents              fdob,        fnd_documen...

This summary is not available. Please click here to view the post.

Below given query will fetch details for Payable invoice along with its payments details. It will fetch details like invoice number, currency code, date, supplier name, invoice amount, line amount, term name, check number ,PO number, payment details, operating unit and ledger details. Query : select aia.invoice_num,              aia.invoice_currency_code,        aia.invoice_date,        aps.vendor_name,        aila.line_number,        aia.invoice_amount,        aila.amount line_amount,        pha.segment1 po_number,        aila.line_type_lookup_code,        apt.name Term_name,              gcc.concatenated_segments distributed_code_combinations,        aca.check_number,        aipa.amount payment_amount,...

--Example for VArray------------- ========================================== DECLARE   TYPE abc IS VARRAY(20) OF NUMBER;   v1 abc; BEGIN   v1 := abc();   v1.extend();   v1(1) := 1234;   v1.extend();   v1(2) := 5678;   v1.extend();   v1(3) := 7890;   dbms_output.put_line('FIRST VALUE ' || v1(1));   dbms_output.put_line('SECOND VALUE ' || v1(2));   dbms_output.put_line('THIRD VALUE ' || v1(3)); END; -------- Output -------- FIRST VALUE 1234 SECOND VALUE 5678 THIRD VALUE 7890 =========================================== DECLARE   TYPE abc IS VARRAY(20) OF VARCHAR2(100);   v1 abc; BEGIN   v1 := abc();   v1.extend();   v1(1) := 'DEMO FOR';   v1.extend();   v1(2) := 'VARRAY';   v1.extend();   v1(3) := 'EXAMPLE';   dbms_output.put_line('FIRST VALUE: ' || v1(1));   dbms_output.put_line('SECOND VALUE: ' || v1(2));   dbms_output.put_line('...

Query : Select Distinct A.Id,                 A.Form_Name,                 A.Enabled,                 C.User_Form_Name,                 D.Application_Name,                 A.Description,                 Ca.Action_Type,                 Ca.Enabled,                 Ca.Object_Type,                 ca.message_type,                 ca.message_text   from FND_FORM_CUSTOM_RULES   a,        FND_FORM                b,        FND_FORM_TL             c,     ...

To insert notes into AR transaction kindly used ARP_NOTES_PKG.insert_p API. This API will take record variable as input parameter. we need to assigned value to it as shown in below given script. ================================================ DECLARE   l_notes_rec ar_notes%rowtype; begin   --apps initialize   mo_global.init('AR');   mo_global.set_policy_context('S', '204');   --    l_notes_rec.customer_trx_id        := 1545557; -- Customer_trx_id   l_notes_rec.note_type              := 'MAINTAIN';   l_notes_rec.text                   := 'Test for AR note';   l_notes_rec.customer_call_topic_id := NULL;   l_notes_rec.call_action_id         := NULL;   l_notes_rec.customer_call_id       := NULL;  -- call API to insert note    ARP_NOTES_PKG.insert_p(l_notes_rec); ...

SELECT   t.user_concurrent_queue_name AS "Concurrent Manager Name",          b.max_processes AS "Actual Processes",          b.running_processes AS "Target Processes",          b.concurrent_queue_name, b.cache_size,          b.min_processes, b.target_processes, b.target_node, b.sleep_seconds,          b.diagnostic_level, b.manager_type, b.enabled_flag, t.description     FROM fnd_concurrent_queues_tl t, fnd_concurrent_queues b    WHERE b.application_id = t.application_id     AND b.concurrent_queue_id = t.concurrent_queue_id     AND b.enabled_flag = 'Y'     AND t.LANGUAGE = USERENV ('LANG')     --and  t.user_concurrent_queue_name like 'Out%' ORDER BY b.max_processes DESC;

Bing Ad's are similar to Google AdWords but on a different Search Engine, that of course being Bing and Yahoo!. It works in the same way as AdWords on a Pay Per Click basis. If you do use Google AdWords as a form of your online advertising then you will be very familiar with the Pay Per Click model. It uses very similar tools to help and research your keywords. The best thing is that you can import your AdWords campaign over to Bing very easily with a tool inside your Bing account. Bing was slow to start the platform of Pay Per Click and the last of the Three major Search Engines to start Pay Per Click. It was not until 2006 that Bing started its Pay Per Click Ad's. Then at the start of early 2010 Bing announced that it would be setting up a joint venture with Yahoo! to run their Pay Per Click Ad's. Bing Ad's Pay Per Click model works in the same way as AdWords it takes the maximum the advertiser is willing to pay per click along with the CTR (Cli...