Tags not populated in programs table | Community
Skip to main content
A
Anonymous
March 23, 2018
Solved

Tags not populated in programs table

  • March 23, 2018
  • 1 reply
  • 2559 views

Hi,

I am new to Marketo and trying to extract Marketo data using the CDATA Marketo ODBC Driver. I am facing 2 issue with the tables.

1) when I extract Leads table the Columns ProgramId and ListId have Null value. The Column description says "This is a filter column that does not contain data". I need this column to join Leads with Programs and List table.

2) For Programs table TagType and TagValue columns are Null. If I see in actual Program Screen in Marketo I see Tags added for programs.

Can someone help me how can I get values for these Columns?

Regards,

Sampada

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Grégoire_Miche2

To add to the above another issue I have is the time taken to extract Marketo tables using ODBC Connection.

I put the filter of UpdatedAt for a month Dec 2017 and the extract job pulled 51K records in 6hrs 50 mins. And that's too much. The activity tables take even more time (9hrs).

Do I need to make any changes to the filters? How can I reduce the Job runtime?


You will need a solution that can leverage the bulk API, which is probably not the case of an ODBC driver... An anyway, program membership is not covered by the bulk API (yet) Or use a solution that can do incremental export towards a third party database, rather than re-extracting everything every time.

Greg

1 reply

Grégoire_Miche2
Grégoire_Miche2
New Participant
March 23, 2018

The link between programs and leads can either be seenin the acquisition program field or in the Program member table that links leads and programs.

With regards to the program tags, I am afraid you will have to see to it with the support of the driver vendor.

-Greg

A
Anonymous
March 27, 2018

Thanks for the response.

I got in touch with the Driver Vendor and they said both of these restrictions are due to the limitations of Marketo API and there is nothing they can do. Here is the link provided from them for reference:

developers.marketo.com/rest-api/assets/programs/

Notice for the "by id" selection method you can get Tag and Cost data, whereas for the "browse" type of selection you will not receive any Tag or Cost data, which means for a bulk extract of Programs these will not be available.

Is there any method to get the Tags Columns in a bulk extract?

A
Anonymous
April 19, 2018

To add to the above another issue I have is the time taken to extract Marketo tables using ODBC Connection.

I put the filter of UpdatedAt for a month Dec 2017 and the extract job pulled 51K records in 6hrs 50 mins. And that's too much. The activity tables take even more time (9hrs).

Do I need to make any changes to the filters? How can I reduce the Job runtime?

Terms & ConditionsAccessibility statement

Loading footer...